SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5983 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5983 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE * FROM tp_lappstarsynchronizationpro_categories
WHERE id_ps= 536
AND type_erp=3 LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `tp_stock_available`
WHERE (id_product = 5983) AND (id_product_attribute = 3008) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `tp_product_group_reduction_cache`
WHERE `id_product` = 5973 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc
WHERE id_product=5972
AND id_customer=0 LIMIT 1

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

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

SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=611 AND c.nright<=612 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.erp_tri ASC, p.id_product DESC

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `tp_module` m
INNER JOIN tp_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1)
INNER JOIN `tp_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `tp_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `tp_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") 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 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 `tp_hook_module` hm
STRAIGHT_JOIN `tp_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `tp_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc
WHERE id_product=5988
AND id_customer=0 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute_lang`
WHERE `id_product_attribute` = 3001

SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-10-29 00:00:00',
INTERVAL 3 DAY
)
) > 0) as new
FROM tp_product p
LEFT JOIN tp_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN tp_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN tp_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (5972,5973,5974,5975,5976,5979,5980,5982,5983,5984,5986,5987,5988,5989,5990,5991,5992,5993,5994,5995,5996,5997)

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

SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `tp_feature` f  INNER JOIN tp_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `tp_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `tp_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC

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

SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_description`
FROM `tp_category` c
INNER JOIN tp_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `tp_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `tp_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 536
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC

SELECT SQL_NO_CACHE id, value, state, is_confirmed, is_deleted FROM tp_lappstar_options
WHERE id_customer=0
AND id_option="secret_codeeg" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5990) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE `id_hook`, `name` FROM `tp_hook`

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc_niveau_categoriesfam
WHERE id_customer=0
AND code_sfam="LW"
AND deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3004) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5974) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `tp_attribute_group` ag  INNER JOIN tp_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `tp_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `tp_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5972 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5972 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `tp_category` c
LEFT JOIN `tp_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN tp_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 534
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM `tp_category` a0
LEFT JOIN `tp_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 611) AND (a0.`nright` > 612) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5972
AND pac.`id_product_attribute` = 3000
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5989 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5989 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5974 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5974 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5993 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5993 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3002) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5986 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5986 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3006) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5987 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5987 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3013
AND cp.`id_cart` = 0 AND cp.`id_product` = 5989 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3013
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5989 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5992 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5992 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5990 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5990 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5996 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM tp_layered_category
WHERE controller = 'category'
AND id_category = 536
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3012
AND cp.`id_cart` = 0 AND cp.`id_product` = 5988 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3012
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5988 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5991 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5991 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5984 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5984 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q 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 tp_shop_group gs
LEFT JOIN tp_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN tp_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 `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5984) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5982 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5982 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5980 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5980 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5989) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5988 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5988 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5984
ORDER BY `position`

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5991
AND pac.`id_product_attribute` = 3015
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3001
AND cp.`id_cart` = 0 AND cp.`id_product` = 5973 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3001
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5973 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5975 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5975 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5979 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5979 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5992
AND pac.`id_product_attribute` = 3016
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `tp_meta` m
LEFT JOIN `tp_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 COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5976 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5976 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5992) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3000
AND cp.`id_cart` = 0 AND cp.`id_product` = 5972 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3000
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5972 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5993
AND pac.`id_product_attribute` = 3017
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3010
AND cp.`id_cart` = 0 AND cp.`id_product` = 5986 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3010
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5986 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5996 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5996 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5995) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5986
AND pac.`id_product_attribute` = 3010
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5973 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5973 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5973
AND pac.`id_product_attribute` = 3001
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5975) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3015
AND cp.`id_cart` = 0 AND cp.`id_product` = 5991 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3015
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5991 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5972) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5990
AND pac.`id_product_attribute` = 3014
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5994) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5997 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5997 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5986) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5986
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3004
AND cp.`id_cart` = 0 AND cp.`id_product` = 5976 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3004
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5976 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3009
AND cp.`id_cart` = 0 AND cp.`id_product` = 5984 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3009
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5984 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5995 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5995 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5982) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3008
AND cp.`id_cart` = 0 AND cp.`id_product` = 5983 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3008
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5983 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5996) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5980) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5989
AND pac.`id_product_attribute` = 3013
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5976) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5983) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5994
AND pac.`id_product_attribute` = 3018
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5982
AND pac.`id_product_attribute` = 3007
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3014
AND cp.`id_cart` = 0 AND cp.`id_product` = 5990 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3014
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5990 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

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

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5975
AND pac.`id_product_attribute` = 3003
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5974
AND pac.`id_product_attribute` = 3002
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5991) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3016
AND cp.`id_cart` = 0 AND cp.`id_product` = 5992 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3016
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5992 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5994 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5994 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3019
AND cp.`id_cart` = 0 AND cp.`id_product` = 5995 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3019
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5995 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3002
AND cp.`id_cart` = 0 AND cp.`id_product` = 5974 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3002
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5974 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3011
AND cp.`id_cart` = 0 AND cp.`id_product` = 5987 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3011
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5987 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5987
AND pac.`id_product_attribute` = 3011
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5993) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5995
AND pac.`id_product_attribute` = 3019
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5983
AND pac.`id_product_attribute` = 3008
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5976
AND pac.`id_product_attribute` = 3004
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3005
AND cp.`id_cart` = 0 AND cp.`id_product` = 5979 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3005
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5979 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3018
AND cp.`id_cart` = 0 AND cp.`id_product` = 5994 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3018
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5994 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5996
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3003
AND cp.`id_cart` = 0 AND cp.`id_product` = 5975 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3003
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5975 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc_niveau_categorieeg
WHERE id_customer=0
AND code_sfam="LW"
AND deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5980
AND pac.`id_product_attribute` = 3006
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5984
AND pac.`id_product_attribute` = 3009
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3020
AND cp.`id_cart` = 0 AND cp.`id_product` = 5996 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3020
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5996 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5973) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5979
AND pac.`id_product_attribute` = 3005
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5988) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3012) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3017
AND cp.`id_cart` = 0 AND cp.`id_product` = 5993 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3017
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5993 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5979) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3021
AND cp.`id_cart` = 0 AND cp.`id_product` = 5997 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3021
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5997 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3005) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5997
AND pac.`id_product_attribute` = 3021
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5988
AND pac.`id_product_attribute` = 3012
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5972
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3007
AND cp.`id_cart` = 0 AND cp.`id_product` = 5982 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3007
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5982 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM tp_shop_url su
LEFT JOIN tp_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'evo.tabacpresse.net' OR su.domain_ssl = 'evo.tabacpresse.net')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3006
AND cp.`id_cart` = 0 AND cp.`id_product` = 5980 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3006
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5980 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5987) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5997
ORDER BY `position`

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5996
AND pac.`id_product_attribute` = 3020
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5973
ORDER BY `position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5991
ORDER BY `position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5995
ORDER BY `position`

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5997) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5976
ORDER BY `position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5983
ORDER BY `position`

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

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5987
ORDER BY `position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5975
ORDER BY `position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5979
ORDER BY `position`

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

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5980
ORDER BY `position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5982
ORDER BY `position`

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3000) LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5990
ORDER BY `position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5994
ORDER BY `position`

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5984 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5993
ORDER BY `position`

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3016) LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5983 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5995 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3017) LIMIT 1

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

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5974
ORDER BY `position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5989
ORDER BY `position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5988
ORDER BY `position`

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3018) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5987)

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3003) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5975)

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3017) LIMIT 1

SELECT SQL_NO_CACHE tr.*
FROM `tp_tax_rule` tr
JOIN `tp_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5992
ORDER BY `position`

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3003) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3005) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3008) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3011) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3010) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_category` a
LEFT JOIN `tp_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tp_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 536) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5973)

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3007) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5982)

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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5989)

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5987 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3013) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3020) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5988)

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3015) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5974)

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3019) LIMIT 1

SELECT SQL_NO_CACHE * FROM `tp_image_type` WHERE 1 AND `categories` = 1  AND `theme_name` = 'child_hummingbird' OR `theme_name` IS NULL ORDER BY `width` DESC, `height` DESC, `name`ASC

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3013) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3001) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3014) LIMIT 1

SELECT SQL_NO_CACHE data FROM tp_layered_filter_block WHERE hash="4b8bfa46fd7af41fadc92b3c815757b1" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3006) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3009) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5972)

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5986 AND il.`id_lang` = 1 ORDER by i.`position`

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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5984)

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5979 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3001) LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5984 AND pa.`id_product` = 5984 AND pa.`id_product_attribute` = 3009 LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5986 AND pa.`id_product` = 5986 AND pa.`id_product_attribute` = 3010 LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5980 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3004) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5991)

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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5980)

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5991 AND pa.`id_product` = 5991 AND pa.`id_product_attribute` = 3015 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3012) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5976)

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3021) LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5982 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5975 AND pa.`id_product` = 5975 AND pa.`id_product_attribute` = 3003 LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5983 AND pa.`id_product` = 5983 AND pa.`id_product_attribute` = 3008 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3009) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5992)

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3021) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5983)

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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5990)

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3014) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3015) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5996)

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5973 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5974 AND pa.`id_product` = 5974 AND pa.`id_product_attribute` = 3002 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3011) LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5974 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE *
FROM `tp_country` a
LEFT JOIN `tp_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `tp_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3008) 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5994)

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5972 AND il.`id_lang` = 1 ORDER by i.`position`

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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5986)

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3020) LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5991 AND il.`id_lang` = 1 ORDER by i.`position`

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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5993)

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5997 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5994 AND il.`id_lang` = 1 ORDER by i.`position`

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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5979)

SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `tp_lang` l
JOIN tp_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 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5997)

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5975 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3016) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3019) LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5989 AND pa.`id_product` = 5989 AND pa.`id_product_attribute` = 3013 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3007) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3010) LIMIT 1

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

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5973 AND pa.`id_product` = 5973 AND pa.`id_product_attribute` = 3001 LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5980 AND pa.`id_product` = 5980 AND pa.`id_product_attribute` = 3006 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3000) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3002) LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5976 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE s.id_shop, s.id_shop_group FROM tp_shop s

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5979 AND pa.`id_product` = 5979 AND pa.`id_product_attribute` = 3005 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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `tp_product` p
INNER JOIN `tp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tp_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` = 5995)

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc
WHERE id_product=5975
AND id_customer=0 LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5987 AND pa.`id_product` = 5987 AND pa.`id_product_attribute` = 3011 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 3018) LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5990 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5982 AND pa.`id_product` = 5982 AND pa.`id_product_attribute` = 3007 LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5990 AND pa.`id_product` = 5990 AND pa.`id_product_attribute` = 3014 LIMIT 1

SELECT SQL_NO_CACHE * FROM `tp_image_type` WHERE 1 AND `manufacturers` = 1  AND `theme_name` = 'child_hummingbird' OR `theme_name` IS NULL ORDER BY `width` DESC, `height` DESC, `name`ASC

SELECT SQL_NO_CACHE * FROM `tp_image_type` WHERE 1 AND `stores` = 1  AND `theme_name` = 'child_hummingbird' OR `theme_name` IS NULL ORDER BY `width` DESC, `height` DESC, `name`ASC

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5996 AND pa.`id_product` = 5996 AND pa.`id_product_attribute` = 3020 LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5988 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5989 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE *
FROM `tp_currency` a
LEFT JOIN `tp_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `tp_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 pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5993 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 5992 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE *
FROM `tp_category` a
LEFT JOIN `tp_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 536) LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5992 AND pa.`id_product` = 5992 AND pa.`id_product_attribute` = 3016 LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5993 AND pa.`id_product` = 5993 AND pa.`id_product_attribute` = 3017 LIMIT 1

SELECT SQL_NO_CACHE id 
FROM tp_lappstarsynchronizationpro_categories
WHERE id_ps= 536
AND id_parent_erp IN ("11", "12")
AND deleted!=1 LIMIT 1

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

SELECT SQL_NO_CACHE * FROM `tp_image_type` WHERE 1 AND `products` = 1  AND `theme_name` = 'child_hummingbird' OR `theme_name` IS NULL ORDER BY `width` DESC, `height` DESC, `name`ASC

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5972 AND pa.`id_product` = 5972 AND pa.`id_product_attribute` = 3000 LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5994 AND pa.`id_product` = 5994 AND pa.`id_product_attribute` = 3018 LIMIT 1

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc
WHERE id_product=5986
AND id_customer=0 LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5976 AND pa.`id_product` = 5976 AND pa.`id_product_attribute` = 3004 LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5988 AND pa.`id_product` = 5988 AND pa.`id_product_attribute` = 3012 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_lang` a
LEFT JOIN `tp_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 id_ps FROM tp_lappstarsynchronizationpro_categories
WHERE type_erp = 1
AND id_ps IN(14,498,534,536)
AND deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE `id_category`
FROM `tp_category_shop`
WHERE `id_category` = 536
AND `id_shop` = 1 LIMIT 1

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

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5995 AND pa.`id_product` = 5995 AND pa.`id_product_attribute` = 3019 LIMIT 1

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

SELECT SQL_NO_CACHE tr.*
FROM `tp_tax_rule` tr
JOIN `tp_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM tp_shop s
LEFT JOIN tp_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 l.*, ls.`id_shop`
FROM `tp_lang` l
LEFT JOIN `tp_lang_shop` ls ON (l.id_lang = ls.id_lang)

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc
WHERE id_product=5976
AND id_customer=0 LIMIT 1

SELECT SQL_NO_CACHE pa.`available_date` FROM `tp_product` p LEFT JOIN `tp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN tp_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN tp_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 p.`id_product` = 5997 AND pa.`id_product` = 5997 AND pa.`id_product_attribute` = 3021 LIMIT 1

SELECT SQL_NO_CACHE `name`
FROM `tp_manufacturer`
WHERE `id_manufacturer` = 122
AND `active` = 1 LIMIT 1

SELECT SQL_NO_CACHE name, alias FROM `tp_hook_alias`

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc
WHERE id_product=5992
AND id_customer=0 LIMIT 1

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc
WHERE id_product=5996
AND id_customer=0 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_currency` a
LEFT JOIN `tp_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 `tp_image_type` WHERE 1 AND `suppliers` = 1  AND `theme_name` = 'child_hummingbird' OR `theme_name` IS NULL ORDER BY `width` DESC, `height` DESC, `name`ASC

SELECT SQL_NO_CACHE * FROM `tp_image_type`

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc_condcli
WHERE id_customer=0
AND ps_categorie_1=14
AND ps_categorie_2 IN(498,534,536)
AND ps_categorie_3 IN(498,534,536)
AND deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute_lang`
WHERE `id_product_attribute` = 3007

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

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc
WHERE id_product=5982
AND id_customer=0 LIMIT 1

SELECT SQL_NO_CACHE * FROM tp_lappstar_cpc
WHERE id_product=5989
AND id_customer=0 LIMIT 1

SELECT SQL_NO_CACHE * FROM tp_lappstarsynchronizationpro_categories
WHERE id_ps= 498
AND type_erp=3 LIMIT 1