Steel

SELECT SQL_NO_CACHE p.*,
product_shop.*,
product_shop.id_category_default,
pl.*,
image_shop.`id_image` id_image,
il.legend,
m.name manufacturer_name,
product_attribute_shop.id_product_attribute id_product_attribute,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2018-05-20 00:00:00", INTERVAL 20 DAY)) > 0 AS new,
stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM ps_cat_filter_restriction cp
LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1  AND pl.id_lang = 21)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 21)
LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
ORDER BY p.date_add desc , cp.id_product LIMIT 0,100

SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 21
INNER JOIN ps_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 21
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 21)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 7 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5867|1|21","", FROM_UNIXTIME(1526836347))

SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 21 AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE (c.`active` = 1 OR c.`id_category` = 1)
AND `level_depth` <= 4
AND cg.`id_group` IN (3)
ORDER BY `level_depth` ASC, category_shop.`position` ASC

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5873/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5873" AND compile_id=""

CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY
SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 70
AND c.nright <= 71
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")

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

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5860|1|21","", FROM_UNIXTIME(1526836347))

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5852/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5852" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4636/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4636" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5872/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5872" AND compile_id=""

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 8
GROUP BY fv.id_feature_value

UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcategories/1/21/1/10/27/27/3/62/2e/6d/622e6ddf74f15a737648b2385f86818ab1d7daf5.blockcategories.tpl.php'
WHERE `template_hash`='9599383e61260d8ac64dca4681201254' AND cache_id="blockcategories|1|21|1|10|27|27|3" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5860/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5860" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5858/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5858" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5868","", FROM_UNIXTIME(1526836348))

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5874/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5874" AND compile_id=""

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4637) AND (b.`id_shop` = 1) LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4629/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4629" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5904/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5904" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcategories/1/21/1/10/27/3/69/2a/f9/692af94f5c63c83b71bc8ee6384646b11edcea40.blockcategories_footer.tpl.php'
WHERE `template_hash`='34732c243ff8fb869cd2b57aec0a66f1' AND cache_id="blockcategories|1|21|1|10|27|3" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4627/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4627" AND compile_id=""

CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 70
AND c.nright <= 71
AND c.active = 1)
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY cp.id_product ORDER BY position, id_product

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5871/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5871" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5855","", FROM_UNIXTIME(1526836348))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5713|1|21","", FROM_UNIXTIME(1526836347))

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4633/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4633" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4623/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4623" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5855/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5855" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4635/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4635" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5856/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5856" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5866/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5866" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4635","", FROM_UNIXTIME(1526836349))

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5844/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5844" AND compile_id=""

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 17
GROUP BY fv.id_feature_value

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

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/6009/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|6009" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5711/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5711" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5709/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5709" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5845/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5845" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5854/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5854" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4638/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4638" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4631/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4631" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4632/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4632" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5861/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5861" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5862/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5862" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5867/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5867" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5869/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5869" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5859/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5859" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5713/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5713" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5863/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5863" AND compile_id=""

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 9
GROUP BY fv.id_feature_value

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5868/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5868" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5867|1|21","", FROM_UNIXTIME(1526836347))

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5848/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5848" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5870/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5870" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4630/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4630" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5847/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5847" AND compile_id=""

INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('6493348', '64', '920688408', '', '1', '1', '2018-05-20 19:12:28')

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5857/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5857" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5865/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5865" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/2057/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2057" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5850/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5850" AND compile_id=""

SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 21
INNER JOIN ps_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 21
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 21)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 8 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC

SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 21
INNER JOIN ps_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 21
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 21)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 5 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4639/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4639" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4634/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4634" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4628/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4628" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5873","", FROM_UNIXTIME(1526836348))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5871","", FROM_UNIXTIME(1526836348))

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4638
ORDER BY f.position ASC

SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 21
INNER JOIN ps_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 21
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 21)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 12 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC

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

SELECT SQL_NO_CACHE p.`id_product`, sa.`quantity`, sa.`out_of_stock` 
FROM ps_cat_restriction p
LEFT JOIN `ps_stock_available` sa
ON (sa.id_product = p.id_product AND sa.id_product_attribute=0  AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5864/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5864" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5851/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5851" AND compile_id=""

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 18
GROUP BY fv.id_feature_value

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4637/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4637" AND compile_id=""

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5863
ORDER BY f.position ASC

SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 21  AND cl.id_shop = 1 )
WHERE `id_parent` = 27
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5853/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5853" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5845","", FROM_UNIXTIME(1526836349))

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5712/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5712" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5871|1|21","", FROM_UNIXTIME(1526836347))

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5870) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4633
ORDER BY f.position ASC

SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 21
INNER JOIN ps_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 21
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 21)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 11 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC

UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5849/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5849" AND compile_id=""

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 21
GROUP BY fv.id_feature_value

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2057
ORDER BY f.position ASC

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 10
GROUP BY fv.id_feature_value

SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 70
AND c.nright >= 71
AND c.nleft >= 2
AND c.nright <= 159
AND cl.id_lang = 21
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5865","", FROM_UNIXTIME(1526836348))

SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 21
INNER JOIN ps_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 21
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 21)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 10 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 20
GROUP BY fv.id_feature_value

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

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 23
GROUP BY fv.id_feature_value

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|6009","", FROM_UNIXTIME(1526836348))

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5856
ORDER BY f.position ASC

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5865) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4634
ORDER BY f.position ASC

SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 21
INNER JOIN ps_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 21
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 21)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 9 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5712","", FROM_UNIXTIME(1526836349))

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 24
GROUP BY fv.id_feature_value

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4630","", FROM_UNIXTIME(1526836349))

SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 21)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (6009,5904,5874,5873,5872,5871,5870,5869,5868,5867,5866,5865,5864,5863,5862,5861,5860,5859,5858,5857,5856,5855,5854,5853,5852,5851,5850,5849,5848,5847,5845,5844,5713,5712,5711,5709,4639,4638,4637,4636,4635,4634,4633,4632,4631,4630,4629,4628,4627,4623,2057) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 12
GROUP BY fv.id_feature_value

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 14
GROUP BY fv.id_feature_value

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5709","", FROM_UNIXTIME(1526836349))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5858|1|21","", FROM_UNIXTIME(1526836347))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5712|1|21","", FROM_UNIXTIME(1526836347))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5859|1|21","", FROM_UNIXTIME(1526836347))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5848","", FROM_UNIXTIME(1526836349))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4629","", FROM_UNIXTIME(1526836349))

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5855
ORDER BY f.position ASC

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5848) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # 
FROM ps_category_product cp
LEFT JOIN ps_product p ON (p.id_product = cp.id_product)  INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE cp.id_category = c.id_category
AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog")
) count_products
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = 1 and cl.id_lang = 21) WHERE c.nleft > 70
AND c.nright < 71
AND c.level_depth <= 4
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5867
ORDER BY f.position ASC

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5868
ORDER BY f.position ASC

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4623
ORDER BY f.position ASC

ALTER TABLE ps_cat_restriction ADD PRIMARY KEY (id_product),
ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE,
ADD KEY `condition` (`condition`,`id_product`) USING BTREE,
ADD KEY `weight` (`weight`,`id_product`) USING BTREE

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5858","", FROM_UNIXTIME(1526836348))

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5855) AND (b.`id_shop` = 1) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5869","", FROM_UNIXTIME(1526836348))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5874|1|21","", FROM_UNIXTIME(1526836347))

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4638) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 28
GROUP BY fv.id_feature_value

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4634","", FROM_UNIXTIME(1526836349))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4623","", FROM_UNIXTIME(1526836349))

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4632) AND (b.`id_shop` = 1) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5874","", FROM_UNIXTIME(1526836348))

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 27
GROUP BY fv.id_feature_value

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5856","", FROM_UNIXTIME(1526836348))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5864","", FROM_UNIXTIME(1526836348))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5863","", FROM_UNIXTIME(1526836348))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|4631|1|21","", FROM_UNIXTIME(1526836347))

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4635) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 19
GROUP BY fv.id_feature_value

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5904","", FROM_UNIXTIME(1526836348))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4628","", FROM_UNIXTIME(1526836349))

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 26
GROUP BY fv.id_feature_value

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4631","", FROM_UNIXTIME(1526836349))

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4633) AND (b.`id_shop` = 1) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|2057","", FROM_UNIXTIME(1526836349))

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5845
ORDER BY f.position ASC

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4633","", FROM_UNIXTIME(1526836349))

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 25
GROUP BY fv.id_feature_value

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 11
GROUP BY fv.id_feature_value

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5860","", FROM_UNIXTIME(1526836348))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4632","", FROM_UNIXTIME(1526836349))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4627","", FROM_UNIXTIME(1526836349))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5869|1|21","", FROM_UNIXTIME(1526836347))

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 21
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5854) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 21
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 191) AND (b.`id_shop` = 1) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5854","", FROM_UNIXTIME(1526836348))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5863|1|21","", FROM_UNIXTIME(1526836347))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5904|1|21","", FROM_UNIXTIME(1526836347))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5713","", FROM_UNIXTIME(1526836349))

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4639
ORDER BY f.position ASC

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 21)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4632
ORDER BY f.position ASC

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4637","", FROM_UNIXTIME(1526836349))

SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 21)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 21)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 21) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 13
GROUP BY fv.id_feature_value