SELECT SQL_NO_CACHE `meta_html`  FROM `cnp_meta_lang`
WHERE  1
AND `url_rewrite` = 'cart?add=1&id_product=14326&token=f545055a46f3de52168e2e5b16a31c49' LIMIT 1

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

SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`value`) AS `value`, c.`id_shop_group`, c.`id_shop`
FROM `cnp_configuration` c
LEFT JOIN `cnp_configuration_lang` `cl` ON c.`id_configuration` = cl.`id_configuration`

SELECT SQL_NO_CACHE h.id_hook, h.name AS h_name, title, description, h.position, live_edit, hm.position AS hm_position, m.id_module, m.name, active
FROM `cnp_hook_module` hm
STRAIGHT_JOIN `cnp_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `cnp_module` AS m ON (m.id_module = hm.id_module)
ORDER BY hm.position

SELECT SQL_NO_CACHE cl.*, c.*, cl.`name` AS `country`, z.`name` AS `zone`
FROM `cnp_country` c
INNER JOIN cnp_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `cnp_country_lang` `cl` ON c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1
LEFT JOIN `cnp_zone` `z` ON z.`id_zone` = c.`id_zone`
ORDER BY cl.`name` ASC

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `cnp_module` m
INNER JOIN cnp_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 `cnp_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `cnp_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `cnp_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `cnp_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 COUNT(DISTINCT `id_cart`) FROM `cnp_specific_price` WHERE `id_cart` != 0 LIMIT 1

SELECT SQL_NO_CACHE cp.`id_product_attribute`,
cp.`id_product`,
cp.`quantity` AS `cart_quantity`,
cp.`id_shop`,
pl.`name`,
p.`is_virtual`,
pl.`description_short`,
pl.`available_now`,
pl.`available_later`,
product_shop.`id_category_default`,
p.`id_supplier`,
p.`id_manufacturer`,
product_shop.`on_sale`,
product_shop.`ecotax`,
product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`,
product_shop.`price`,
product_shop.`active`,
product_shop.`unity`,
product_shop.`unit_price_ratio`,
stock.`quantity` AS `quantity_available`,
p.`width`,
p.`height`,
p.`depth`,
p.`weight`,
stock.`out_of_stock`,
p.`date_add`,
p.`date_upd`,
IFNULL(stock.`quantity`, 0) AS `quantity`,
pl.`link_rewrite`,
cl.`link_rewrite` AS `category`,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id,
cp.`id_address_delivery`,
product_shop.`advanced_stock_management`,
ps.`product_supplier_reference` AS `supplier_reference`,
NULL AS customization_quantity, NULL AS id_customization,
product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr,
IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference,
(p.`weight`+ pa.`weight`) weight_attribute,
IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13,
IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc,
IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity,
IF(product_attribute_shop.wholesale_price > 0,  product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `cnp_cart_product` cp
LEFT JOIN `cnp_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `cnp_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `cnp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop 
LEFT JOIN `cnp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop 
LEFT JOIN `cnp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN cnp_stock_available stock
ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `cnp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute`
LEFT JOIN `cnp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `cnp_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 `cnp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1
WHERE (cp.`id_cart` = 1269414) AND (p.`id_product` IS NOT NULL)
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC

SELECT SQL_NO_CACHE cp.`id_product_attribute`,
cp.`id_product`,
cp.`quantity` AS `cart_quantity`,
cp.`id_shop`,
pl.`name`,
p.`is_virtual`,
pl.`description_short`,
pl.`available_now`,
pl.`available_later`,
product_shop.`id_category_default`,
p.`id_supplier`,
p.`id_manufacturer`,
product_shop.`on_sale`,
product_shop.`ecotax`,
product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`,
product_shop.`price`,
product_shop.`active`,
product_shop.`unity`,
product_shop.`unit_price_ratio`,
stock.`quantity` AS `quantity_available`,
p.`width`,
p.`height`,
p.`depth`,
p.`weight`,
stock.`out_of_stock`,
p.`date_add`,
p.`date_upd`,
IFNULL(stock.`quantity`, 0) AS `quantity`,
pl.`link_rewrite`,
cl.`link_rewrite` AS `category`,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id,
cp.`id_address_delivery`,
product_shop.`advanced_stock_management`,
ps.`product_supplier_reference` AS `supplier_reference`,
NULL AS customization_quantity, NULL AS id_customization,
product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr,
IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference,
(p.`weight`+ pa.`weight`) weight_attribute,
IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13,
IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc,
IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity,
IF(product_attribute_shop.wholesale_price > 0,  product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `cnp_cart_product` cp
LEFT JOIN `cnp_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `cnp_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `cnp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop 
LEFT JOIN `cnp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop 
LEFT JOIN `cnp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN cnp_stock_available stock
ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `cnp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute`
LEFT JOIN `cnp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `cnp_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 `cnp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1
WHERE (cp.`id_cart` = 1269414) AND (p.`id_product` IS NOT NULL)
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC

SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart`
FROM `cnp_cart_cart_rule` cd
LEFT JOIN `cnp_cart_rule` `cr` ON cd.`id_cart_rule` = cr.`id_cart_rule`
LEFT JOIN `cnp_cart_rule_lang` `crl` ON cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1
WHERE (`id_cart` = 1269414) AND (`reduction_percent` != 0 OR `reduction_amount` != 0)
ORDER BY cr.`priority` ASC

SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart`
FROM `cnp_cart_cart_rule` cd
LEFT JOIN `cnp_cart_rule` `cr` ON cd.`id_cart_rule` = cr.`id_cart_rule`
LEFT JOIN `cnp_cart_rule_lang` `crl` ON cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1
WHERE (`id_cart` = 1269414)
ORDER BY cr.`priority` ASC

INSERT INTO `cnp_cart` (`lastsms`, `id_shop_group`, `id_shop`, `id_address_delivery`, `id_address_invoice`, `id_carrier`, `id_currency`, `id_customer`, `id_guest`, `id_lang`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `delivery_option`, `vnotesordercart`, `recovercart`, `secure_key`, `allow_seperated_package`, `date_add`, `date_upd`) VALUES ('0', '1', '1', '0', '0', '0', '1', '0', '0', '1', '0', '0', '', '0', '', '', '0', '', '0', '2026-07-30 22:33:59', '2026-07-30 22:33:59')

SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `cnp_hook`
UNION
SELECT `id_hook`, ha.`alias` AS name
FROM `cnp_hook_alias` ha
INNER JOIN `cnp_hook` h ON ha.name = h.name

SELECT SQL_NO_CACHE *
FROM `cnp_carrier_lang`
WHERE `id_carrier` = 219 AND `id_shop` = 1

SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart`
FROM `cnp_cart_cart_rule` cd
LEFT JOIN `cnp_cart_rule` `cr` ON cd.`id_cart_rule` = cr.`id_cart_rule`
LEFT JOIN `cnp_cart_rule_lang` `crl` ON cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1
WHERE (`id_cart` = 1269414) AND (`gift_product` = 0)
ORDER BY cr.`priority` ASC

SELECT SQL_NO_CACHE *
FROM `cnp_state`
ORDER BY `name` ASC

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

SELECT SQL_NO_CACHE cr.*
FROM cnp_cart_rule cr
LEFT JOIN cnp_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN cnp_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule
LEFT JOIN cnp_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN cnp_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND cr.date_from < "2026-07-30 22:33:59"
AND cr.date_to > "2026-07-30 22:33:59"
AND (
cr.id_customer = 0
)
AND (
cr.`carrier_restriction` = 0
)
AND (
cr.`shop_restriction` = 0
)
AND (
cr.`group_restriction` = 0
OR crg.`id_group` = 1
)
AND (
cr.`reduction_product` <= 0
OR EXISTS (
SELECT 1
FROM `cnp_cart_product`
WHERE `cnp_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 1269414
)
)
AND NOT EXISTS (SELECT 1 FROM cnp_cart_cart_rule WHERE cr.id_cart_rule = cnp_cart_cart_rule.id_cart_rule
AND id_cart = 1269414)
ORDER BY priority

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

SELECT SQL_NO_CACHE d.`price`
FROM `cnp_delivery` d
INNER JOIN `cnp_range_price` r ON d.`id_range_price` = r.`id_range_price`
WHERE (d.`id_zone` = 2) AND (d.`id_carrier` = 219 AND d.id_delivery = (
SELECT d2.id_delivery
FROM cnp_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_price` = `d`.`id_range_price`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
))
ORDER BY r.`delimiter2` DESC LIMIT 1

SELECT SQL_NO_CACHE cr.*
FROM cnp_cart_rule cr
LEFT JOIN cnp_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN cnp_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule
LEFT JOIN cnp_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN cnp_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND cr.date_from < "2026-07-30 22:33:59"
AND cr.date_to > "2026-07-30 22:33:59"
AND (
cr.id_customer = 0
)
AND (
cr.`carrier_restriction` = 0
)
AND (
cr.`shop_restriction` = 0
)
AND (
cr.`group_restriction` = 0
OR crg.`id_group` = 1
)
AND (
cr.`reduction_product` <= 0
OR EXISTS (
SELECT 1
FROM `cnp_cart_product`
WHERE `cnp_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 1269414
)
)
AND NOT EXISTS (SELECT 1 FROM cnp_cart_cart_rule WHERE cr.id_cart_rule = cnp_cart_cart_rule.id_cart_rule
AND id_cart = 1269414)
ORDER BY priority

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

SELECT SQL_NO_CACHE c.*, cl.`delay`
FROM `cnp_carrier` c
LEFT JOIN `cnp_carrier_lang` `cl` ON c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 1 AND cl.id_shop = 1 
LEFT JOIN `cnp_carrier_zone` `cz` ON cz.`id_carrier` = c.`id_carrier`
INNER JOIN cnp_carrier_shop carrier_shop
ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1)
LEFT JOIN `cnp_zone` `z` ON z.`id_zone` = 2
WHERE (c.`deleted` = 0) AND (cz.`id_zone` = 2) AND (z.`active` = 1) AND (c.`active` = 1) AND (EXISTS (SELECT 1 FROM cnp_carrier_group
WHERE cnp_carrier_group.id_carrier = c.id_carrier
AND id_group IN (1))) AND (c.`is_module` = 0 OR c.`need_range` = 1)
GROUP BY c.`id_carrier`
ORDER BY c.`position` ASC

SELECT SQL_NO_CACHE d.`price`
FROM `cnp_delivery` d
LEFT JOIN `cnp_range_price` `r` ON d.`id_range_price` = r.`id_range_price`
WHERE (d.`id_zone` = 2) AND (59.99 >= r.`delimiter1`) AND (59.99 < r.`delimiter2`) AND (d.`id_carrier` = 219 AND d.id_delivery = (
SELECT d2.id_delivery
FROM cnp_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_price` = `d`.`id_range_price`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
))
ORDER BY r.`delimiter1` ASC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `cnp_product` a
LEFT JOIN `cnp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cnp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 14326) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `cnp_module` m
LEFT JOIN `cnp_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 1

SELECT SQL_NO_CACHE s.`id_shop`, CONCAT(su.`physical_uri`, su.`virtual_uri`) AS `uri`, su.`domain`, su.`main`
FROM `cnp_shop_url` su
LEFT JOIN `cnp_shop` `s` ON s.`id_shop` = su.`id_shop`
WHERE (su.domain = 'www.safetyrestore.com' OR su.domain_ssl = 'www.safetyrestore.com') AND (s.`active` = 1) AND (s.`deleted` = 0)

SELECT SQL_NO_CACHE *
FROM `cnp_cart_rule` cr
LEFT JOIN `cnp_cart_rule_lang` `crl` ON cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1
WHERE (cr.`date_from` < '2026-07-30 22:33:59') AND (cr.`date_to` > '2026-07-30 22:33:59') AND (cr.`active` = 1) AND (`free_shipping` = 1) AND (`carrier_restriction` = 1) AND (cr.`id_customer` = 0 OR cr.`group_restriction` = 1)

INSERT INTO `cnp_cart_product` (`id_product`, `id_product_attribute`, `id_cart`, `id_address_delivery`, `id_shop`, `quantity`, `date_add`) VALUES ('14326', '0', '1269414', '0', '1', '1', '2026-07-30 22:33:59')

SELECT SQL_NO_CACHE *
FROM `cnp_cart_rule` cr
LEFT JOIN `cnp_cart_rule_lang` `crl` ON cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1
WHERE (cr.`date_from` < '2026-07-30 22:33:59') AND (cr.`date_to` > '2026-07-30 22:33:59') AND (cr.`active` = 1) AND (cr.`quantity` > 0) AND (`highlight` = 1) AND (`code` NOT LIKE 'BO_ORDER_%') AND (cr.`id_customer` = 0 OR cr.`group_restriction` = 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 `cnp_shop_group` gs
LEFT JOIN `cnp_shop` `s` ON s.`id_shop_group` = gs.`id_shop_group`
LEFT JOIN `cnp_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 *
FROM `cnp_product` a
LEFT JOIN `cnp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 14326) LIMIT 1

SELECT SQL_NO_CACHE COUNT(DISTINCT c.`id_currency`)
FROM `cnp_currency` c
LEFT JOIN `cnp_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 `cnp_product_lang`
WHERE `id_product` = 14326 AND `id_shop` = 1

SELECT SQL_NO_CACHE IFNULL(`left_column`, `default_left_column`) AS `left_column`, IFNULL(`right_column`, `default_right_column`) AS `right_column`
FROM `cnp_theme` t
LEFT JOIN `cnp_theme_meta` `tm` ON t.`id_theme` = tm.`id_theme`
LEFT JOIN `cnp_meta` `m` ON m.`id_meta` = tm.`id_meta`
WHERE (t.`id_theme` = 4) AND (m.`page` = 'cart') LIMIT 1

SELECT SQL_NO_CACHE SUM((p.`weight` + pa.`weight`) * cp.`quantity`) AS `nb`
FROM `cnp_cart_product` cp
LEFT JOIN `cnp_product` `p` ON cp.`id_product` = p.`id_product`
LEFT JOIN `cnp_product_attribute` `pa` ON cp.`id_product_attribute` = pa.`id_product_attribute`
WHERE (cp.`id_product_attribute` IS NOT NULL) AND (cp.`id_product_attribute` != 0) AND (cp.`id_cart` = 1269414) LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `cnp_product` p
INNER JOIN `cnp_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cnp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 14326)

SELECT SQL_NO_CACHE *
FROM `cnp_currency` c
INNER JOIN cnp_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 `cnp_currency` c
INNER JOIN cnp_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 hm.`id_module`
FROM `cnp_hook_module` hm, `cnp_hook` h
WHERE hm.`id_module` = 209 AND h.`id_hook` = 204
AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE SUM(p.`weight` * cp.`quantity`) AS `nb`
FROM `cnp_cart_product` cp
LEFT JOIN `cnp_product` `p` ON cp.`id_product` = p.`id_product`
WHERE (cp.`id_product_attribute` IS NULL OR cp.`id_product_attribute` = 0) AND (cp.`id_cart` = 1269414) LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM `cnp_carrier` a
LEFT JOIN `cnp_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 1
LEFT JOIN `cnp_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 219) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE stock.`out_of_stock`, IFNULL(stock.`quantity`, 0) AS `quantity`
FROM `cnp_product` p
INNER JOIN cnp_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE (p.`id_product` = 14326) LIMIT 1

SELECT SQL_NO_CACHE id_carrier
FROM `cnp_product_carrier` pc
INNER JOIN `cnp_carrier` c ON c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = 0 AND c.`active` = 1
WHERE (pc.`id_product` = 14326) AND (pc.`id_shop` = 1)

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

SELECT SQL_NO_CACHE *
FROM `cnp_module_currency`
WHERE (`id_module` = 65) AND (`id_shop` = 1)

SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM `cnp_shop` s
LEFT JOIN `cnp_shop_url` `su` ON s.`id_shop` = su.`id_shop`
LEFT JOIN `cnp_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 p.id_product
FROM `cnp_product` p
INNER JOIN cnp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 14326
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2026-07-30 00:00:00",
INTERVAL 2000 DAY
)
) > 0

SELECT SQL_NO_CACHE *
FROM `cnp_country` a
LEFT JOIN `cnp_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `cnp_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM cnp_product_attribute pa
INNER JOIN cnp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 14326 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `cnp_currency` a
LEFT JOIN `cnp_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 cnp_mj_filter f
LEFT JOIN cnp_mj_condition c ON c.id_filter = f.id_filter
WHERE f.assignment_auto = 1

SELECT SQL_NO_CACHE cp.`quantity`
FROM `cnp_cart_product` cp
WHERE (cp.`id_product` = 14326) AND (cp.`id_product_attribute` = 0) AND (cp.`id_cart` = 1269414) LIMIT 1

SELECT SQL_NO_CACHE COUNT(DISTINCT l.`id_lang`)
FROM `cnp_lang` l
INNER JOIN `cnp_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 *
FROM `cnp_themeconfigurator`
WHERE (`id_shop` = 1) AND (`id_lang` = 1) AND (`hook` = 'footer') AND (`active` = 1)
ORDER BY `item_order` ASC

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

SELECT SQL_NO_CACHE SUM(`quantity`)
FROM `cnp_cart_product`
WHERE (`id_cart` = 1269414) LIMIT 1

SELECT SQL_NO_CACHE * FROM `cnp_hook_alias`

SELECT SQL_NO_CACHE *
FROM `cnp_country` a
LEFT JOIN `cnp_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1

SELECT SQL_NO_CACHE *
FROM cnp_mj_filter f
LEFT JOIN cnp_mj_condition c ON c.id_filter = f.id_filter
WHERE f.assignment_auto = 1

SELECT SQL_NO_CACHE count(distinct id_address_delivery)
FROM `cnp_cart_product` cp
WHERE (id_cart = 1269414) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `cnp_carrier` a
LEFT JOIN `cnp_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 219) LIMIT 1

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

SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom
FROM `cnp_feature_product` fp
LEFT JOIN `cnp_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value)
WHERE `id_product` = 14326

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `cnp_smarty_lazy_cache`
WHERE `template_hash`='4eda1ec0ee0968d49688dd7d17c99165' AND cache_id="blocksearch-top|1|1|1|1|21" AND compile_id="" LIMIT 1

UPDATE `cnp_cart` SET `id_cart` = '1269414',`lastsms` = '0',`id_shop_group` = '1',`id_shop` = '1',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_carrier` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '0',`id_lang` = '1',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`vnotesordercart` = '',`recovercart` = '0',`secure_key` = '',`allow_seperated_package` = '0',`date_add` = '2026-07-30 22:33:59',`date_upd` = '2026-07-30 22:33:59' WHERE `id_cart` = 1269414

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `cnp_smarty_lazy_cache`
WHERE `template_hash`='7a2a8dea557badbec355083a9701c029' AND cache_id="blockmyaccountfooter|1|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE * FROM `cnp_contentbox_files` where `id_store`=1 and `id_lang`=1 LIMIT 1

SELECT SQL_NO_CACHE `value`
FROM `cnp_configuration`
WHERE (`name` = 'TB_CACHE_SYSTEM') LIMIT 1

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

SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `cnp_lang` l
LEFT JOIN `cnp_lang_shop` `ls` ON l.`id_lang` = ls.`id_lang`

SELECT SQL_NO_CACHE *
FROM `cnp_lang` a
LEFT JOIN `cnp_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 1
FROM `cnp_specific_price`
WHERE (`to` BETWEEN '2026-07-30 00:00:00' AND '2026-07-30 23:59:59') LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `cnp_smarty_lazy_cache`
WHERE `template_hash`='132f0f1772440ba3ad1a30130c38cfea' AND cache_id="blockcms|2|1|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE COUNT(*)
FROM `cnp_hook_module` hm
LEFT JOIN `cnp_hook` `h` ON h.`id_hook` = hm.`id_hook`
WHERE (h.`name` = 'header') AND (hm.`id_module` = 73) LIMIT 1

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM `cnp_tag` t
LEFT JOIN `cnp_product_tag` `pt` ON pt.`id_tag` = t.`id_tag`
WHERE (pt.`id_product` = 14326)

SELECT SQL_NO_CACHE *
FROM `cnp_group` a
LEFT JOIN `cnp_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 out_of_stock
FROM `cnp_stock_available`
WHERE (id_product = 14326) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE COUNT(*)
FROM `cnp_product_attribute` pa
INNER JOIN cnp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE (pa.`id_product` = 14326) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `cnp_currency` a
LEFT JOIN `cnp_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 depends_on_stock
FROM `cnp_stock_available`
WHERE (id_product = 14326) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

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

SELECT SQL_NO_CACHE id_feature, id_product, id_feature_value
FROM `cnp_feature_product`
WHERE `id_product` IN (14326)

SELECT SQL_NO_CACHE *
FROM `cnp_group_lang`
WHERE `id_group` = 1

SELECT SQL_NO_CACHE SUM(`quantity`)
FROM `cnp_cart_product`
WHERE `id_product` = 14326
AND `id_cart` = 1269414 LIMIT 1

SELECT SQL_NO_CACHE 1
FROM `cnp_specific_price`
WHERE (`from` BETWEEN '2026-07-30 00:00:00' AND '2026-07-30 23:59:59') LIMIT 1

SELECT SQL_NO_CACHE hm.`id_module`
FROM `cnp_hook_module` hm, `cnp_hook` h
WHERE hm.`id_module` = 73 AND h.`id_hook` = 9
AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `cnp_smarty_lazy_cache`
WHERE `template_hash`='0bbcfcee42eff89d503127347dff176c' AND cache_id="blockcontactinfos|1|1|1|1|21" AND compile_id="" LIMIT 1

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

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

SELECT SQL_NO_CACHE *
FROM `cnp_country_lang`
WHERE `id_country` = 21

SELECT SQL_NO_CACHE value FROM cnp_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cnp_carrier_tax_rules_group_shop`
WHERE (`id_carrier` = 219) AND (`id_shop` = 1) LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM `cnp_hook_module_exceptions`
WHERE (`id_shop` IN (1))

SELECT SQL_NO_CACHE name
FROM `cnp_manufacturer`
WHERE (`id_manufacturer` = 0) AND (`active` = 1) LIMIT 1

SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM cnp_required_field

SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `cnp_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 6696 LIMIT 1

SELECT SQL_NO_CACHE `id_group`
FROM `cnp_cart_rule_group`
WHERE (id_cart_rule = 79796)

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

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

SELECT SQL_NO_CACHE *
FROM `cnp_cart_cart_rule`
WHERE (`id_cart` = 1269414)

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

SELECT SQL_NO_CACHE id_shop
FROM `cnp_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cnp_product_shop`
WHERE `id_product` = 14326 AND id_shop=1 LIMIT 1

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

SELECT SQL_NO_CACHE a.`id_address`
FROM `cnp_address` a
WHERE (a.`id_address` = 0) LIMIT 1

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

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

SELECT SQL_NO_CACHE `reduction`
FROM `cnp_product_group_reduction_cache`
WHERE (`id_product` = 14326) AND (`id_group` = 1) LIMIT 1

SELECT SQL_NO_CACHE COUNT(*) FROM cnp_shop LIMIT 1

SELECT SQL_NO_CACHE `id_shop`
FROM `cnp_shop`

SELECT SQL_NO_CACHE `name`
FROM `cnp_supplier`
WHERE (`id_supplier` = 0) LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `cnp_group`
WHERE `id_group` = 1 LIMIT 1