Strops and compounds

Strops and compounds fo convex grind and polished edge

There are 39 products.
Showing 1 - 39 of 39 items
Showing 1 - 39 of 39 items
Load Time2352 ms - You'd better run your shop on a toaster
Querying Time249 ms
Queries706
Memory Peak Usage17.8 Mb
Included Files270 files - 5.07 Mb
PrestaShop Cache- Mb
Global vars0.47 Mb
PrestaShop Version1.6.1.18
PHP Version7.0.30 (OK)
MySQL Version5.6.38-log (OK)
Memory Limit1024m
Max Execution Time600s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 33 ms 33 ms 4.93 Mb 5.08 Mb
__construct 0 ms 33 ms - Mb 5.08 Mb
init 23 ms 56 ms 0.37 Mb 5.69 Mb
checkAccess 0 ms 56 ms - Mb 5.69 Mb
setMedia 5 ms 61 ms 0.03 Mb 5.72 Mb
postProcess 0 ms 61 ms - Mb 5.72 Mb
initHeader 0 ms 61 ms - Mb 5.72 Mb
initContent 1501 ms 1562 ms 7.26 Mb 12.99 Mb
initFooter 50 ms 1613 ms 0.28 Mb 13.28 Mb
display 739 ms 2352 ms 4.37 Mb 17.85 Mb
Hook Time Memory Usage
hookproductlistassign 719 ms - Mb
hookdisplayProductListReviews 464 ms - Mb
__construct 51 ms - Mb
hookHeader 50 ms - Mb
hookleftcolumn 18 ms - Mb
hookfooter 15 ms - Mb
hookdisplayHeader 11 ms - Mb
hookdisplayProductListFunctionalButtons 10 ms - Mb
hookdisplayNav 8 ms - Mb
hooktop 6 ms - Mb
hookdisplayTop 6 ms - Mb
hookdisplayFooter 5 ms - Mb
hookdisplayBanner 0 ms - Mb
hookdisplayLeftColumn 0 ms - Mb
hookmoduleRoutes 0 ms - Mb
hookactionModuleRegisterHookAfter - ms - Mb
hookdisplayTopColumn - ms - Mb
17 hooks 1362 ms - Mb
Module Time Memory Usage
blocklayered 760 ms - Mb
productcomments 465 ms - Mb
blockcategories 17 ms - Mb
trustpilot 16 ms - Mb
blockwishlist 12 ms - Mb
homesliderpro 12 ms - Mb
paypal 10 ms - Mb
statsdata 8 ms - Mb
blocklanguages 7 ms - Mb
smartblocktopmenu 5 ms - Mb
blockcart 4 ms - Mb
smartprestashopthemeadmin 4 ms - Mb
smartajaxsearch 3 ms - Mb
blocknewsletter 3 ms - Mb
smartshortcode 3 ms - Mb
blockcontactinfos 2 ms - Mb
blockmanufacturer 2 ms - Mb
smartblocksocial 2 ms - Mb
smartblockfacebook 2 ms - Mb
smartcustomfooter 2 ms - Mb
blockcms 2 ms - Mb
blockuserinfo 2 ms - Mb
uecookie 1 ms - Mb
smartblog 1 ms - Mb
blockcurrencies 1 ms - Mb
smarttopnav 1 ms - Mb
ganalytics 1 ms - Mb
blocktags 1 ms - Mb
smartblockspecials 1 ms - Mb
homeblockadvertiser 1 ms - Mb
blockmyaccount 1 ms - Mb
sekeywords 1 ms - Mb
blocksupplier 1 ms - Mb
smartnewproducts 1 ms - Mb
blockviewed 1 ms - Mb
mailalerts 1 ms - Mb
blockpaymentlogo 1 ms - Mb
productscategory 1 ms - Mb
pagesnotfound 1 ms - Mb
homeadvertiser 0 ms - Mb
massprice 0 ms - Mb
blockstore 0 ms - Mb
cronjobs 0 ms - Mb
smartmanufacturer 0 ms - Mb
44 modules 1362 ms - Mb

Stopwatch SQL - 706 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
5.6 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
4.6 122 /classes/Tab.php:296
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
3.9 74 Yes /modules/blocklayered/blocklayered.php:2048
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5723|1|21","", FROM_UNIXTIME(1526836805))
3.7 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|2201|1|21","", FROM_UNIXTIME(1526836805))
3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|2996|1|21","", FROM_UNIXTIME(1526836805))
2.9 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|2029|1|21","", FROM_UNIXTIME(1526836805))
2.7 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5747|1|21","", FROM_UNIXTIME(1526836805))
2.7 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|317|1|21","", FROM_UNIXTIME(1526836805))
2.6 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|4003|1|21","", FROM_UNIXTIME(1526836805))
2.6 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|2028|1|21","", FROM_UNIXTIME(1526836805))
2.1 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/2201/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2201" AND compile_id=""
1.9 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5745/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5745" AND compile_id=""
1.8 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9599383e61260d8ac64dca4681201254',"blockcategories|1|21|1|10|178|178|3","", FROM_UNIXTIME(1526836804))
1.8 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/3018/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|3018" AND compile_id=""
1.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/3017/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|3017" AND compile_id=""
1.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5704/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5704" AND compile_id=""
1.7 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|311|1|21","", FROM_UNIXTIME(1526836805))
1.6 1 /classes/SmartyCustom.php:263
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 >= 98
AND c.nright <= 99
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
1.5 1 /modules/blocklayered/blocklayered.php:1942
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 317
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.5 1 /classes/SpecificPrice.php:196
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` = 178) AND (b.`id_shop` = 1) LIMIT 1
1.5 1 /Adapter/Adapter_EntityMapper.php:61
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 = 315
ORDER BY f.position ASC
1.5 1 Yes /classes/Product.php:4452
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5705|1|21","", FROM_UNIXTIME(1526836805))
1.5 1 /classes/SmartyCustom.php:263
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
1.4 0 /classes/Hook.php:131
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
1.4 512 Yes /modules/blocklayered/blocklayered.php:2376
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 315 AND id_shop=1 LIMIT 1
1.3 1 /classes/Product.php:5033
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|4003","", FROM_UNIXTIME(1526836806))
1.3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|3017|1|21","", FROM_UNIXTIME(1526836805))
1.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|3017" AND compile_id="" LIMIT 1
1.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|5740|1|21" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcategories/1/21/1/10/178/178/3/62/2e/6d/622e6ddf74f15a737648b2385f86818ab1d7daf5.blockcategories.tpl.php'
WHERE `template_hash`='9599383e61260d8ac64dca4681201254' AND cache_id="blockcategories|1|21|1|10|178|178|3" AND compile_id=""
1.2 1 /classes/SmartyCustom.php:183
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 >= 98
AND c.nright <= 99
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")
1.2 1 /modules/blocklayered/blocklayered.php:2136
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 >= 98 AND nright <= 99
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
1.1 80 Yes /modules/blockcategories/blockcategories.php:231
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|317","", FROM_UNIXTIME(1526836806))
1.1 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5740/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5740" AND compile_id=""
1.1 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5720/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5720" AND compile_id=""
1.1 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|2993|1|21","", FROM_UNIXTIME(1526836805))
1.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
1 1 /classes/SmartyCustom.php:142
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/2997/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2997" AND compile_id=""
1 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5751/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5751" AND compile_id=""
1 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='0c89fc9af202bd86e070e905a9a58f8a' AND cache_id="smartblocktopmenu|1|21|1|10" AND compile_id="" LIMIT 1
0.9 1 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/316/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|316" AND compile_id=""
0.9 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/4003/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4003" AND compile_id=""
0.9 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 21
AND cl.id_shop = 1 
AND cl.`id_category` = 178 LIMIT 1
0.9 1 /classes/Category.php:1054
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|316","", FROM_UNIXTIME(1526836806))
0.9 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5743/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5743" AND compile_id=""
0.9 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/2029/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2029" AND compile_id=""
0.9 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/315/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|315" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5739/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5739" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|312|1|21","", FROM_UNIXTIME(1526836805))
0.8 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5705/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5705" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5747/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5747" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5723/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5723" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5749/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5749" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5744/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5744" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|314","", FROM_UNIXTIME(1526836806))
0.8 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|2826|1|21","", FROM_UNIXTIME(1526836805))
0.8 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/311/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|311" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5749 AND id_shop=1 LIMIT 1
0.8 1 /classes/Product.php:5033
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5748/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5748" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5703/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5703" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/313/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|313" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/2993/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2993" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5722/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5722" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/2826/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2826" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5703|1|21","", FROM_UNIXTIME(1526836805))
0.7 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5721/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5721" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5737/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5737" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1
0.7 1 /classes/cache/CacheFs.php:36
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5741/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5741" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.7 426 /classes/module/Module.php:2141
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/317/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|317" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|2997","", FROM_UNIXTIME(1526836806))
0.7 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5738/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5738" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
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` = 178
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.7 1 Yes Yes /classes/Category.php:656
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/312/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|312" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/2028/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2028" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5746/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5746" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5750","", FROM_UNIXTIME(1526836805))
0.7 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|2997|1|21","", FROM_UNIXTIME(1526836805))
0.7 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5736/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5736" AND compile_id=""
0.6 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/5750/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5750" AND compile_id=""
0.6 1 /classes/SmartyCustom.php:183
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('6493403', '1676', '920688408', '', '1', '1', '2018-05-20 19:20:05')
0.6 1 /classes/ObjectModel.php:487
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
0.6 3 Yes /modules/blocklayered/blocklayered.php:2376
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5751","", FROM_UNIXTIME(1526836805))
0.6 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|3018","", FROM_UNIXTIME(1526836806))
0.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 178
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.6 35 Yes Yes /modules/blocklayered/blocklayered.php:2120
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5750|1|21","", FROM_UNIXTIME(1526836805))
0.6 1 /classes/SmartyCustom.php:263
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` = 5749) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5705","", FROM_UNIXTIME(1526836806))
0.6 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/314/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|314" AND compile_id=""
0.6 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productcomments/1/21/1/10/2996/ec/99/53/ec9953771816c404698c86f1501f17b5b32004bd.productcomments_reviews.tpl.php'
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2996" AND compile_id=""
0.6 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5704","", FROM_UNIXTIME(1526836806))
0.6 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5740","", FROM_UNIXTIME(1526836805))
0.6 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5737|1|21","", FROM_UNIXTIME(1526836805))
0.6 1 /classes/SmartyCustom.php:263
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` = 5748) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|3017","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description`
FROM `ps_category_lang` cl
WHERE cl.`id_lang` = 21
AND cl.`id_category` = 178 AND cl.id_shop = 1 LIMIT 1
0.5 1 /classes/Meta.php:291
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|2826","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5721","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
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` = 5751) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
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')
0.5 1 /classes/ObjectModel.php:487
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5739","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5748","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5737","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5723","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|315","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|316|1|21","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
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 = 5751
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:4452
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` = 315) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
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 = 5737
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:4452
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5747","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5749|1|21","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
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
0.5 14 Yes /modules/blocklayered/blocklayered.php:2376
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5744","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
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
0.5 69 Yes /modules/blocklayered/blocklayered.php:2376
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 (5751,5750,5749,5748,5747,5746,5745,5744,5743,5741,5740,5739,5738,5737,5736,5723,5722,5721,5720,5705,5704,5703,4003,3018,3017,2997,2996,2993,2826,2028,2029,2201,311,312,313,314,315,316,317) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 117 Yes Yes /classes/Product.php:3464
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5746","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5749","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5736","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5741","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
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 > 98
AND c.nright < 99
AND c.level_depth <= 4
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position
0.5 3000 Yes /modules/blocklayered/blocklayered.php:2376
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|312","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|313","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|2029","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
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
0.5 69 Yes /modules/blocklayered/blocklayered.php:2376
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5744|1|21","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|2201","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|311","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|2993","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5738","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5736|1|21","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
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
0.5 1 /modules/blocklayered/blocklayered.php:2142
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|2028","", FROM_UNIXTIME(1526836806))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5748|1|21","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
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 = 5750
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:4452
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` = 312) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5722|1|21","", FROM_UNIXTIME(1526836805))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|2996","", FROM_UNIXTIME(1526836806))
0.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|314|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5745|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
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` = 5747) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
ALTER TABLE ps_cat_filter_restriction ADD PRIMARY KEY (id_product), ADD KEY (position, id_product) USING BTREE
0.4 1 /modules/blocklayered/blocklayered.php:1954
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
0.4 48 Yes /modules/blocklayered/blocklayered.php:2376
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5745","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
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 = 314
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4452
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5720","", FROM_UNIXTIME(1526836806))
0.4 1 /classes/SmartyCustom.php:263
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
0.4 67 Yes /modules/blocklayered/blocklayered.php:2376
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5743","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5721|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5746" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5751|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
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` = 313) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5738|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5722","", FROM_UNIXTIME(1526836806))
0.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5746|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
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
0.4 27 Yes /modules/blocklayered/blocklayered.php:2376
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` = 4003) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|315|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
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` = 5745) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5704|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
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 = 5748
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4452
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|317|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|313|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5720|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
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` = 5744) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5703","", FROM_UNIXTIME(1526836806))
0.4 1 /classes/SmartyCustom.php:263
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
0.4 5 Yes /modules/blocklayered/blocklayered.php:2376
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
0.4 4 Yes /modules/blocklayered/blocklayered.php:2376
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 = 15
GROUP BY fv.id_feature_value
0.4 20 Yes /modules/blocklayered/blocklayered.php:2376
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 <= 98
AND c.nright >= 99
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
0.4 40 Yes /classes/Tools.php:1306
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 = 5747
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4452
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 = 5703
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4452
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
0.4 74 Yes /modules/blocklayered/blocklayered.php:2376
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|3018|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
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 = 16
GROUP BY fv.id_feature_value
0.4 20 Yes /modules/blocklayered/blocklayered.php:2376
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
0.4 74 Yes /modules/blocklayered/blocklayered.php:2376
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5751)
0.4 1 /classes/Product.php:2998
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
0.4 34 Yes /modules/blocklayered/blocklayered.php:2376
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
0.4 567 /modules/blocklayered/blocklayered.php:2376
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
0.4 74 Yes /modules/blocklayered/blocklayered.php:2376
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
0.4 74 Yes /modules/blocklayered/blocklayered.php:2376
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` = 5750) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5739|1|21","", FROM_UNIXTIME(1526836805))
0.4 1 /classes/SmartyCustom.php:263
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` = 5704) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
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
0.4 74 Yes /modules/blocklayered/blocklayered.php:2376
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 = 30
GROUP BY fv.id_feature_value
0.4 1 Yes /modules/blocklayered/blocklayered.php:2376
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
0.4 74 Yes /modules/blocklayered/blocklayered.php:2376
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 = 5741
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4452
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5750)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5749)
0.4 1 /classes/Product.php:2998
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` = 5736) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 5703) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 5743) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 5721) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.*
FROM `ps_scene_category` sc
LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene)
INNER JOIN ps_scene_shop scene_shop
ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1)
LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene)
WHERE sc.id_category = 178
AND sl.id_lang = 21 AND s.active = 1
ORDER BY sl.name ASC
0.4 1 Yes /classes/Scene.php:226
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
0.4 34 Yes /modules/blocklayered/blocklayered.php:2376
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 = 5740
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 316) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 2201
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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
0.3 32 Yes /modules/blocklayered/blocklayered.php:2376
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
0.3 74 Yes /modules/blocklayered/blocklayered.php:2376
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` = 311) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 5749
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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 = 316
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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 = 5721
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 317) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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` = 5705) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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
0.3 74 Yes /modules/blocklayered/blocklayered.php:2376
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 = 5744
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 314) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 5736
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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
0.3 62 Yes /modules/blocklayered/blocklayered.php:2376
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` = 2826) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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
0.3 34 Yes /modules/blocklayered/blocklayered.php:2376
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` = 5720) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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
0.3 34 Yes /modules/blocklayered/blocklayered.php:2376
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` = 5737) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 5743
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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 = 5738
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 5739) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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` = 3017) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 312
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 5723) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 5746
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 2201) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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
0.3 36 Yes /modules/blocklayered/blocklayered.php:2376
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` = 2997) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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` = 3018) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 29
GROUP BY fv.id_feature_value
0.3 34 Yes /modules/blocklayered/blocklayered.php:2376
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 = 2993
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 2993) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 5705
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5748)
0.3 1 /classes/Product.php:2998
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 = 5722
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 5738) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 311
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 5741) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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` = 2996) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 317
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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 = 5745
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5749
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
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` = 2028) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 2028
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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 = 5704
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 5746) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 4003
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction
0.3 1 /modules/blocklayered/blocklayered.php:2126
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 = 2029
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 317 LIMIT 1
0.3 1 /modules/productcomments/ProductComment.php:240
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` = 5722) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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` = 2029) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 5723
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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 = 2996
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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` = 5740) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 5739
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
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 = 3018
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5750
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5751) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5737)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5746)
0.3 1 /classes/Product.php:2998
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 = 5720
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5751" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
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 = 22
GROUP BY fv.id_feature_value
0.3 1 Yes /modules/blocklayered/blocklayered.php:2376
SELECT SQL_NO_CACHE COUNT(*)
FROM ps_layered_category
WHERE id_category = 178
AND id_shop = 1 LIMIT 1
0.3 35 /modules/blocklayered/blocklayered.php:636
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 = 3017
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5722)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5745)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) nbr, m.id_manufacturer, m.name 
FROM ps_cat_restriction p
INNER JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1
GROUP BY p.id_manufacturer ORDER BY m.name
0.3 567 Yes /modules/blocklayered/blocklayered.php:2376
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 = 313
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5721)
0.3 1 /classes/Product.php:2998
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 = 2826
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
SELECT SQL_NO_CACHE l.`id_lang`, c.`link_rewrite`
FROM `ps_category_lang` AS c
LEFT JOIN  `ps_lang` AS l ON c.`id_lang` = l.`id_lang`
WHERE c.`id_category` = 178
AND l.`active` = 1
0.3 4 /classes/Category.php:1458
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5743)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|2029|1|21" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 312)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5736)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 4003)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5740 LIMIT 1
0.3 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max 
FROM ps_cat_restriction p
INNER JOIN `ps_layered_price_index` psi
ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1)
WHERE 1
0.3 567 /modules/blocklayered/blocklayered.php:2376
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5703)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5721 LIMIT 1
0.3 1 /modules/productcomments/ProductComment.php:240
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 = 2997
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4452
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5705)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5747)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5750) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5744)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 317)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE COUNT(*) FROM ps_cat_filter_restriction LIMIT 1
0.3 0 /modules/blocklayered/blocklayered.php:2003
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 312) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5749) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5704)
0.2 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5743|1|21","", FROM_UNIXTIME(1526836805))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5740)
0.2 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5741|1|21","", FROM_UNIXTIME(1526836805))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 314)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 2201)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5741 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 316)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5741)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 313)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5741
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 2028)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 315)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 2996)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 311)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9599383e61260d8ac64dca4681201254' AND cache_id="blockcategories|1|21|1|10|178|178|3" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 178) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 2826)
0.2 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|5740|1|21","", FROM_UNIXTIME(1526836805))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='7571706aeaee908b61573620efd0b590' AND cache_id="blockcontactinfos|1|21|1|10" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5720)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5723)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5747) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5705
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 178 AND `id_shop` = 1
0.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5720
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 2029)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 178) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 3018)
0.2 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5749","", FROM_UNIXTIME(1526836805))
0.2 1 /classes/SmartyCustom.php:263
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` = 34) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5738)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 2993)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 6493403
AND `date_add` > '2018-05-20 18:50:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.2 1 Yes /classes/Connection.php:138
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5739)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 3017)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5740
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5743
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 178
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5705" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5748) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5751
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5720 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5704
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 2997)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5741
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|5703|1|21" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5705
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5748
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|3017|1|21","", FROM_UNIXTIME(1526836805))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5748
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5704
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 313
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5736" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 314
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2993
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5721
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5745" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|5750|1|21" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5750
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5748 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5739
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5704) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 6 AND `id_object` = 178 LIMIT 1
0.2 1 /classes/Page.php:77
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4003
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5720 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 317 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5740
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5745 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5746) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5737
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5745
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5751 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5747
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 311) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 314 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5744" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5751
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 311
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5723" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 3018 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5749
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5745) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 313
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2997
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5722) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 315
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 3018
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2201
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 311 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 317
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 2029 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5743) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2996) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5748
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5703
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='7304852ad4a236ee6adef16bbf65564c' AND cache_id="smartblocksocial|1|21|1|10" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5737
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5743
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5737) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5736
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 317
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5721
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 316) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 315) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5745 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2201
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5737 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 315
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 3017
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5741" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5739" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9599383e61260d8ac64dca4681201254',"blockcategories|1|21|1|10|178|178|3","", FROM_UNIXTIME(1526836804))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5720) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 2826 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4003) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2201) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4003 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5740) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2028
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2028 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='34732c243ff8fb869cd2b57aec0a66f1' AND cache_id="blockcategories|1|21|1|10|178|3" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 311
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5751
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|317" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5720
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 4003
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 316 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5721" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5720" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|5737|1|21" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 316
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 311 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5705) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5704" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|315" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 4003
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|313" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5739
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 2028 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='712c55aed77b861efdca0367bbb0cdca' AND cache_id="blockcms|2|1|21|1|10" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 3017
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5723
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 314
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5736
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2996" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5744
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5745
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|312|1|21" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2029) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 3018
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5736) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5737 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5749
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5704
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5750 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5743" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5722
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2029
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2826
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5744) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 313
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5740" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 313) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5721 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5738" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5722
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5744
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 312 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5745
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5740 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2997
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5705 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2028" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5748" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 311
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5749 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 3017 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2993) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5722" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5751 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2996
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 314 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 315 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 314
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5738 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|2028|1|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5736 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5737
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5738
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5722 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 312 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 317) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2993" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5721) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|311|1|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 316
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5749" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5743 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5750
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2996
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5703
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5704 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5703
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2993 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5739
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3018) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5741
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 313 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5738
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2993
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5750" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5744
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 3018 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2993
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5746
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 4003 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5705
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9418447f432ee58652b78d687b63c457' AND cache_id="smartblockfacebook|1|21|1|10" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|3018|1|21","", FROM_UNIXTIME(1526836805))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5744 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5723) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2997" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5747
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 178 AND ctg.`id_group` = 1 LIMIT 1
0.1 1 /classes/Category.php:1309
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5723
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5747 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5703 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 312
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 312
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 316
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2028
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5746
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 5747
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2826
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5738 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|312" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE proslider FROM ps_category WHERE id_category= 178 LIMIT 1
0.1 1 /modules/homesliderpro/homesliderpro.php:962
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5737" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|4003" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2826" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5748 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 2029
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|5751|1|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2201
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|2993","", FROM_UNIXTIME(1526836806))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|2201|1|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5741) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5743
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2201 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2029" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2028) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5736
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a0d92fca8d21bcd0011ca5056a731efb',"productcomments|1|21|1|10|5743","", FROM_UNIXTIME(1526836805))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5739) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5723
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2826 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|316" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 2993 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 2201 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5705 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|2201" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5704 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5720
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 314) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|314" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|3018" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('16c96b5027e69a9d66214bbe24b6d9b9',"productlist_colors|2997|1|21","", FROM_UNIXTIME(1526836805))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|311" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a0d92fca8d21bcd0011ca5056a731efb' AND cache_id="productcomments|1|21|1|10|5703" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2826) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3017) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5738) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5721
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|316|1|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5722
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|5745|1|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='16c96b5027e69a9d66214bbe24b6d9b9' AND cache_id="productlist_colors|5721|1|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 5703 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240