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 `configuration` c
LEFT JOIN `configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

SELECT SQL_NO_CACHE MIN(`price`) as min, MAX(`price`) as max FROM `product` p
INNER JOIN `product_lang` pl ON (p.`id_product` = pl.`id_product`) 
WHERE p.`active` = 1 AND p.`id_shop_default` = 1 AND 
pl.`id_lang` = 3

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `module` m
INNER JOIN module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1)
INNER JOIN `hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `hook` `h` ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`

SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `hook_alias` ha
INNER JOIN `hook` h ON ha.name = h.name

SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `hook_module` hm
STRAIGHT_JOIN `hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position

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

SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*
FROM `feature` f
INNER JOIN feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
LEFT JOIN `feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 3)
ORDER BY f.`position` ASC

SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `meta` m
LEFT JOIN `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 `hook`

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

SELECT SQL_NO_CACHE * FROM carrier_shop AS cs 
LEFT JOIN carrier USING (id_carrier) 
LEFT JOIN ed_carriers edc USING (id_reference, id_shop)  
LEFT JOIN carrier_lang AS cl USING (id_carrier, id_shop) 
LEFT JOIN carrier_zone AS cz USING (id_carrier) 
WHERE id_zone IN (9) 
AND active = 1 AND deleted = 0 
AND cl.id_lang = 3 
AND cs.id_shop = 1 
GROUP BY id_reference 
ORDER BY position ASC, id_carrier DESC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 1220 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` 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` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 1222 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` 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` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 1134 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` 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` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 1130 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` 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` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 1171 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` 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` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 1207 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` 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` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 1132 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` 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` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 1247 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` 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` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 1212 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` 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` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 1234 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = ""
OR m.page = ""
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1249) AND (b.`id_shop` = 1) LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1175) AND (b.`id_shop` = 1) LIMIT 1

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

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

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

SELECT SQL_NO_CACHE f.*, f.id_wksearchplus_filters as id
FROM wksearchplus_filters f JOIN `wksearchplus_filters_shop` fs ON (
f.`id_wksearchplus_filters` = fs.`id_wksearchplus_filters` AND
fs.`id_shop` = 1
)  WHERE 1  AND f.`active` = 1  ORDER BY f.`position`

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

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

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1207) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1222) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1241) AND (b.`id_shop` = 1) LIMIT 1

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

SELECT SQL_NO_CACHE * FROM `cart_rule` cr
LEFT JOIN `cart_rule_lang` crl
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 3) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1130) AND (b.`id_shop` = 1) LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1121) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1134) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-prestablog-blog"
OR m.page = "moduleprestablogblog"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1234) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `prestablog_correspondancecategorie` as cc
LEFT JOIN `prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 70
AND cl.`id_lang` = 3
AND c.`actif` = 1
ORDER BY cl.`title`

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1220) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1171) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `country` a
LEFT JOIN `country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 3
LEFT JOIN `country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 10) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1132) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1212) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1210) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1126) 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 shop_group gs
LEFT JOIN shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN 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 cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `prestablog_correspondancecategorie` as cc
LEFT JOIN `prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 70
AND cl.`id_lang` = 3
AND c.`actif` = 1
ORDER BY cl.`title`

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

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1231) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-sitemap"
OR m.page = "moduleets_awesomeurlsitemap"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1

DELETE FROM `pewantinvoice` WHERE id_cart = 0

SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `lang` l
JOIN 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 su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM shop s
LEFT JOIN shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1223) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE tr.*
FROM `tax_rule` tr
JOIN `tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 10
AND tr.`id_tax_rules_group` = 46
AND tr.`id_state` IN (0, 161)
AND ('71045' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '71045')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

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

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

SELECT SQL_NO_CACHE ac.id_ets_abancart_campaign
FROM `ets_abancart_campaign` ac
LEFT JOIN `ets_abancart_campaign_country` `cc` ON cc.id_ets_abancart_campaign = ac.id_ets_abancart_campaign
LEFT JOIN `ets_abancart_campaign_with_lang` `cl` ON cl.id_ets_abancart_campaign = ac.id_ets_abancart_campaign AND cl.id_lang=3
LEFT JOIN `ets_abancart_campaign_group` `acg` ON ac.id_ets_abancart_campaign = acg.id_ets_abancart_campaign
LEFT JOIN `group_shop` `gs` ON gs.id_group = acg.id_group AND gs.id_shop = 1
WHERE (ac.id_shop = 1) AND (ac.enabled = 1 AND ac.deleted = 0) AND (IF(ac.is_all_lang != 1, cl.id_ets_abancart_campaign is NOT NULL AND cl.id_lang=3, 1)) AND (ac.campaign_type != 'email') AND (ac.campaign_type != 'customer') AND (IF(ac.min_total_cart is NOT NULL AND ac.has_product_in_cart = 1, ac.min_total_cart <= 0, 1) AND IF(ac.max_total_cart is NOT NULL AND ac.has_product_in_cart = 1, ac.max_total_cart >= 0, 1)) AND (IF(ac.available_from is NOT NULL, ac.available_from <= '2026-06-16', 1) AND IF(ac.available_to is NOT NULL, ac.available_to >= '2026-06-16', 1)) AND (IF(ac.has_applied_voucher = 'both' OR (ac.has_applied_voucher = 'yes' AND 0 > 0) OR (ac.has_applied_voucher = 'no' AND 0 = 0), 1, 0)) AND (IF(ac.has_product_in_cart = 1, 0, 1)) AND (acg.id_group = 1) AND (ac.is_all_country = 1 OR cc.id_country = -1 OR cc.id_country=10)
GROUP BY ac.id_ets_abancart_campaign

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1247) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `country` a
LEFT JOIN `country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 10) LIMIT 1

SELECT SQL_NO_CACHE tr.*
FROM `tax_rule` tr
JOIN `tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 10
AND tr.`id_tax_rules_group` = 45
AND tr.`id_state` IN (0, 161)
AND ('71045' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '71045')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

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

SELECT SQL_NO_CACHE tr.*
FROM `tax_rule` tr
JOIN `tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 10
AND tr.`id_tax_rules_group` = 47
AND tr.`id_state` IN (0, 161)
AND ('71045' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '71045')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE value FROM `configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1

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

UPDATE `prestablog_news_lang` SET `read` = (`read` + 1)
WHERE `id_prestablog_news`= 70
AND `id_lang` = 3

SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `lang` l
LEFT JOIN `lang_shop` ls ON (l.id_lang = ls.id_lang)

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

SELECT SQL_NO_CACHE id_zone FROM `country` WHERE iso_code = 'IT' AND active = 1 AND id_zone > 0 GROUP BY id_zone

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-prestablog-blog"
OR m.page = "moduleprestablogblog"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM shop_url su
LEFT JOIN shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'dev.pratoerboso.com' OR su.domain_ssl = 'dev.pratoerboso.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1175)

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

SELECT SQL_NO_CACHE pnp.`id_product`
FROM `prestablog_news_product` pnp
JOIN `product` p ON (pnp.`id_product` = p.`id_product`)
WHERE pnp.`id_prestablog_news` = 70 
AND p.`active` = 1

SELECT SQL_NO_CACHE MAX(GREATEST(COALESCE(date_upd, date_add), date_add)) as last_update
FROM `amb_search_suggestion`
WHERE (id_lang = 3) AND (id_shop = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1237) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1175
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE * FROM `whatsappchatblock` LEFT JOIN `whatsappchatblock_lang` ON (`whatsappchatblock`.`id_whatsappchatblock` = `whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 3) WHERE `id_hook` = "hookDisplayHeader" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;

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

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-rss"
OR m.page = "moduleets_awesomeurlrss"
)
AND ml.id_lang = 4
AND ml.id_shop = 1 LIMIT 1

INSERT INTO `pewantinvoice` (`id_cart`, `chosen`) VALUES ('0', '0')

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1222)

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1249
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `whatsappchatblock_agent` LEFT JOIN `whatsappchatblock_agent_lang` ON (`whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 3) WHERE 1 = 1 AND `active` = 1 ORDER BY position

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1171)

SELECT SQL_NO_CACHE `name`, `alias` FROM `hook_alias`

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1220)

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lang` a
LEFT JOIN `lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 4) LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "jmsajaxsearch" LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1234)

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1249 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM cart_product cp INNER JOIN product p
ON (p.id_product = cp.id_product) INNER JOIN 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 product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1247)

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1220
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1175 LIMIT 1

SELECT SQL_NO_CACHE name, alias FROM `hook_alias`

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1130)

SELECT SQL_NO_CACHE id_tab, class_name FROM `tab`

SELECT SQL_NO_CACHE domain, domain_ssl
FROM shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1222
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-rss"
OR m.page = "moduleets_awesomeurlrss"
)
AND ml.id_lang = 5
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1241)

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1210
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1207 LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1207)

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "payplug" LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1207
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-sitemap"
OR m.page = "moduleets_awesomeurlsitemap"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

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

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1130
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `prestablog_news_lang`
WHERE `id_prestablog_news` = 68

SELECT SQL_NO_CACHE `scm`.`id`
FROM `pestoreclosingmanager_schedule` scm
WHERE  ((scm.`id_shop_group` is null and scm.`id_shop` is null)  OR (scm.`id_shop_group` = 1
and scm.`id_shop` is null)  OR (scm.`id_shop` = 1) )  AND `is_active` = 1 
AND `begin_date` <= NOW() AND `end_date` >= NOW()

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1212
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1134)

SELECT SQL_NO_CACHE *
FROM `currency` a
LEFT JOIN `currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 3
LEFT JOIN `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 *
FROM `fbpsc_connector_position` fcp

SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `category_lang` cl
WHERE `id_lang` = 3
AND cl.id_shop = 1 
AND cl.`id_category` = 103 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE `id_product` != 0 LIMIT 1

SELECT SQL_NO_CACHE n.`id_prestablog_news` AS id, nl.`title`, n.`date`, nl.`link_rewrite`, n.`actif`
FROM `prestablog_news` n
LEFT JOIN `prestablog_news_lang` nl
ON (n.`id_prestablog_news` = nl.`id_prestablog_news` AND nl.`id_lang` = 3)
WHERE n.`id_prestablog_news` IN (66,68,69)

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1121)

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1212)

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1220 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1222 LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1134
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lang` a
LEFT JOIN `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 m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1234
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE `id_lang` FROM `lang` WHERE `iso_code` = 'en' LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `specific_price_priority`
WHERE `id_product` = 1249
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE `id_product`, `id_product_attribute`, id_shop
FROM `cart_product`
WHERE `id_cart` = 0
ORDER BY `date_add` DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-rss"
OR m.page = "moduleets_awesomeurlrss"
)
AND ml.id_lang = 7
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkstripepayment"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `prestablog_news_lang`
WHERE `id_prestablog_news` = 66

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1132)

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-rss"
OR m.page = "moduleets_awesomeurlrss"
)
AND ml.id_lang = 6
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1210)

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `specific_price_priority`
WHERE `id_product` = 1175
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `currency` a
LEFT JOIN `currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 3
LEFT JOIN `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 m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1241
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE domain
FROM `shop_url`
WHERE (main = 1) AND (active = 1)
AND id_shop IN (1)

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-sitemap"
OR m.page = "moduleets_awesomeurlsitemap"
)
AND ml.id_lang = 7
AND ml.id_shop = 1 LIMIT 1

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

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1237)

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1171
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1249)

SELECT SQL_NO_CACHE *
FROM `group` a
LEFT JOIN `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 m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "retrieveproducts"
OR m.page = "retrieveproducts"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-sitemap"
OR m.page = "moduleets_awesomeurlsitemap"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `category_lang` cl
WHERE `id_lang` = 3
AND cl.id_shop = 1 
AND cl.`id_category` = 102 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1171 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `product_shop`
WHERE `id_product` = 1175 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `prestablog_news_lang`
WHERE `id_prestablog_news` = 69

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1121
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE `chosen` FROM `pewantinvoice`
WHERE id_cart = 0 LIMIT 1

SELECT SQL_NO_CACHE `menu_color`,`read_color`,`hover_color`,`title_color`,`text_color`,`menu_hover`,`menu_link`,`link_read`,`article_title`,`article_text`,`block_categories`,`block_categories_link`,`block_title`,`block_btn`,`categorie_block_background`,`article_background`,`categorie_block_background_hover`,`block_btn_hover`,`ariane_color`,`ariane_color_text`,`ariane_border`,`block_categories_link_btn`, `sharing_icon_color`,`nav_card_background`,`nav_card_text`,`nav_card_hover`,`nav_card_gradient`
FROM `prestablog_color`
WHERE `id_shop` =1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `product_shop`
WHERE `id_product` = 1212 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1132
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1126
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-sitemap"
OR m.page = "moduleets_awesomeurlsitemap"
)
AND ml.id_lang = 4
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ets_payment_with_fee" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 483 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE `scm`.`id`
FROM `pestoreclosingmanager_schedule` scm
WHERE  ((scm.`id_shop_group` is null and scm.`id_shop` is null)  OR (scm.`id_shop_group` = 1
and scm.`id_shop` is null)  OR (scm.`id_shop` = 1) )  AND `is_active` = 1 
AND `begin_date` <= NOW() AND `end_date` >= NOW()

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ets_awesomeurl" LIMIT 1

SELECT SQL_NO_CACHE tr.*
FROM `tax_rule` tr
JOIN `tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 10
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 161)
AND ('71045' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '71045')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE `from` BETWEEN '2026-06-16 00:00:00' AND '2026-06-16 23:59:59' LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1231)

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE n.`id_author`, n.`firstname`, n.`lastname`, n.`pseudo`, n.`email`, l.`bio` 
FROM `prestablog_author` n 
LEFT JOIN `prestablog_author_lang` l ON n.`id_author` = l.`id_author` 
WHERE n.`id_author` = 2 AND l.`id_lang` = 3 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `prestablog_news_lang`
WHERE `id_prestablog_news` = 70

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-rss"
OR m.page = "moduleets_awesomeurlrss"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 566 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE n.*, nl.*
FROM prestablog_news n
LEFT JOIN prestablog_news_lang nl ON n.id_prestablog_news = nl.id_prestablog_news
WHERE n.id_prestablog_news = 70
AND nl.id_lang = 3
AND n.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "psadyenpayment"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_type` WHERE 1 AND `categories` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `specific_price_priority`
WHERE `id_product` = 1222
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `smarty_last_flush` WHERE type='compile' LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `specific_price_priority`
WHERE `id_product` = 1220
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1130 LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-sitemap"
OR m.page = "moduleets_awesomeurlsitemap"
)
AND ml.id_lang = 5
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1234 LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM `prestablog_news` a
LEFT JOIN `prestablog_news_lang` `b` ON a.`id_prestablog_news` = b.`id_prestablog_news` AND b.`id_lang` = 3
WHERE (a.`id_prestablog_news` = 70) LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `product_shop`
WHERE `id_product` = 1220 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1126 LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-rss"
OR m.page = "moduleets_awesomeurlrss"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `specific_price_priority`
WHERE `id_product` = 1212
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1134 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1212 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-sitemap"
OR m.page = "moduleets_awesomeurlsitemap"
)
AND ml.id_lang = 6
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1241 LIMIT 1

SELECT SQL_NO_CACHE *
FROM meta m
LEFT JOIN meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-ets_awesomeurl-rss"
OR m.page = "moduleets_awesomeurlrss"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1247
AND image_shop.`cover`= 1 LIMIT 1

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

SELECT SQL_NO_CACHE `id_lang` FROM `lang`
WHERE `locale` = 'de-de'
OR `language_code` = 'de-de' LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

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

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `specific_price_priority`
WHERE `id_product` = 1234
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `smarty_lazy_cache`
WHERE `template_hash`='fea6d7237555b455116b5030844c1f66' AND cache_id="zonethememanager|header|1|3|1|10" AND compile_id="ZOneTheme" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `specific_price_priority`
WHERE `id_product` = 1247
ORDER BY `id_specific_price_priority` DESC LIMIT 1

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

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1210 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_edition_basic" LIMIT 1

SELECT SQL_NO_CACHE `id_lang` FROM `lang` WHERE `iso_code` = 'es' LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1231
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `product_shop`
WHERE `id_product` = 1222 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkerrorreporting" LIMIT 1

SELECT SQL_NO_CACHE * FROM `image_shop` image_shop
WHERE image_shop.`id_product` = 1223
AND image_shop.`cover`= 1 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `wksearchplus_filters` a
WHERE (a.`id_wksearchplus_filters` = 5) LIMIT 1

SELECT SQL_NO_CACHE `id_category`
FROM `prestablog_news_category_link`
WHERE `id_prestablog_news` = 70
AND `type` = "article"

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `specific_price_priority`
WHERE `id_product` = 1207
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkwepay"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE `news`, `categorie`
FROM `prestablog_correspondancecategorie`
WHERE `news` IN (66,68,69)

SELECT SQL_NO_CACHE *
FROM `prestablog_categorie` a
LEFT JOIN `prestablog_categorie_lang` `b` ON a.`id_prestablog_categorie` = b.`id_prestablog_categorie` AND b.`id_lang` = 3
WHERE (a.`id_prestablog_categorie` = 2) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "nrtsearchbar" LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1121 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1132 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `specific_price_priority`
WHERE `id_product` = 1241
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1126)

SELECT SQL_NO_CACHE `id_prestablog_newslink`
FROM `prestablog_news_newslink`
WHERE `id_prestablog_news` = 70

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_legalcompliance"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `product_shop`
WHERE `id_product` = 1171 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE `id_lang` FROM `lang` WHERE `iso_code` = 'de' LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `lang_shop`
WHERE `id_lang` = 4
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE c.id_currency
FROM `currency` c
WHERE (iso_code = 'EUR') LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 510 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tax_lang`
WHERE `id_tax` = 2

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `product_shop`
WHERE `id_product` = 1130 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `module` m
LEFT JOIN `module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "wkpaypalsubscription"
AND ms.`id_shop` IN (1) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `currency` a
LEFT JOIN `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 * FROM `image_type`

SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_lang` FROM `lang` WHERE `iso_code` = 'it' LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE `to` BETWEEN '2026-06-16 00:00:00' AND '2026-06-16 23:59:59' LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `product_shop`
WHERE `id_product` = 1207 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "wkpaypalsubscription" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "leoproductsearch" LIMIT 1

SELECT SQL_NO_CACHE `id_category`
FROM `prestablog_news_category_link`
WHERE `id_prestablog_news` = 70
AND `type` = "product"

SELECT SQL_NO_CACHE *
FROM `prestablog_news` a
WHERE (a.`id_prestablog_news` = 68) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `zthememanager_lang`
WHERE `id_zthememanager` = 1

SELECT SQL_NO_CACHE n.`id_author`, n.`firstname`, n.`lastname`, n.`pseudo`, n.`email`, l.`bio` 
FROM `prestablog_author` n 
LEFT JOIN `prestablog_author_lang` l ON n.`id_author` = l.`id_author` 
WHERE n.`id_author` = 2 AND l.`id_lang` = 3 LIMIT 1