Catalog

Your account

MOTO BAGS There are 27 products.

per page
Showing 1 - 24 of 27 items
Showing 1 - 24 of 27 items
Load Time5719 ms - You'd better run your shop on a toaster
Querying Time473 ms
Queries1159
Memory Peak Usage58.3 Mb
Included Files368 files - 7.55 Mb
PrestaShop Cache- Mb
Global vars2.01 Mb
PrestaShop Version1.6.1.4
PHP Version5.5.35 (OK)
MySQL Version5.6.38 (OK)
Memory Limit256M
Max Execution Time259200s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 59 ms 59 ms 5.80 Mb 5.95 Mb
__construct 0 ms 59 ms - Mb 5.95 Mb
init 17 ms 76 ms 1.46 Mb 7.37 Mb
checkAccess 0 ms 76 ms - Mb 7.37 Mb
setMedia 4 ms 81 ms 0.20 Mb 7.56 Mb
postProcess 0 ms 81 ms - Mb 7.56 Mb
initHeader 0 ms 81 ms 0.01 Mb 7.56 Mb
initContent 2168 ms 2249 ms 25.67 Mb 33.41 Mb
initFooter 71 ms 2320 ms 1.83 Mb 36.10 Mb
display 3399 ms 5719 ms 22.46 Mb 58.28 Mb
Hook Time Memory Usage
hookleftcolumn 770 ms 2.25 Mb
hookHeader 540 ms 3.25 Mb
hookdisplayProductPriceBlock 310 ms 13.50 Mb
hookdisplayProductListReviews 300 ms 6.50 Mb
hookproductlistassign 210 ms 5.25 Mb
hookdisplayTop 210 ms 5.25 Mb
__construct 150 ms 10.25 Mb
hookfooter 40 ms 0.50 Mb
hookdisplayNav 20 ms 0.50 Mb
hookdisplayProductListFunctionalButtons 20 ms - Mb
hookdisplayHeader 20 ms 0.50 Mb
hookdisplayBanner 10 ms 0.25 Mb
hooktop 10 ms - Mb
hookdisplayFooter 10 ms - Mb
hookdisplayTopColumn - ms - Mb
hookdisplayLeftColumn - ms - Mb
16 hooks 2620 ms 48.00 Mb
Module Time Memory Usage
blocklayered 680 ms 6.75 Mb
fbloginblock 450 ms 4.25 Mb
livechatpro 400 ms 1.25 Mb
gsnippetsreviews 350 ms 9.75 Mb
advancedeucompliance 320 ms 13.50 Mb
blocktopmenu 170 ms 2.75 Mb
fsopengraph 20 ms - Mb
blockwishlist 20 ms - Mb
statsdata 20 ms 1.00 Mb
blockcurrencies 20 ms - Mb
blockcontactinfos 20 ms - Mb
ganalytics 10 ms - Mb
blocksocial 10 ms 0.25 Mb
easymarketing 10 ms 1.00 Mb
hreflangpro 10 ms - Mb
sendtoafriend 10 ms - Mb
blockbanner 10 ms 0.50 Mb
ec_hover_image_plus 10 ms - Mb
facebookpsshoptab 10 ms 0.25 Mb
blockcontact 10 ms 0.50 Mb
newsletterpro 10 ms 1.00 Mb
blocksearch 10 ms - Mb
blocknewsletter 10 ms 1.75 Mb
homeslider 10 ms - Mb
pagesnotfound 10 ms 0.25 Mb
themeconfigurator 10 ms - Mb
gremarketing - ms 0.25 Mb
lgcanonicalurls - ms 0.50 Mb
sekeywords - ms 0.25 Mb
blockcart - ms 0.50 Mb
paypal - ms 0.50 Mb
blocklanguages - ms - Mb
blockcms - ms 0.25 Mb
blockfacebook - ms 0.25 Mb
blockbestsellers - ms - Mb
socialsharing - ms 0.25 Mb
blockmyaccountfooter - ms - Mb
blockpaymentlogo - ms - Mb
productpaymentlogos - ms - Mb
whatsappcontact - ms 0.25 Mb
homefeatured - ms - Mb
blockviewed - ms - Mb
blockuserinfo - ms 0.25 Mb
editorial - ms - Mb
44 modules 2620 ms 48.00 Mb

Stopwatch SQL - 1159 queries

Query Time (ms) Rows Filesort Group By Location
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 = 1
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 = 1
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 1)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 1) 
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
45.7 27 Yes /modules/blocklayered/blocklayered.php:2376
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 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) LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
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` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (632,385,387,389,603,601,602,384,600,597,381,383,382,372,370,371,379,373,342,378,366,365,343,361) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
10.9 6 Yes /classes/Product.php:3466
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 = 1
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 = 1
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 1)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 1) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 23 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
9.7 27 Yes /modules/blocklayered/blocklayered.php:2376
UPDATE `ps_smarty_lazy_cache`
SET filepath='blocktopmenu/1/1/1/1/2/21/category/226/73/e8/22/73e8228076fb6c7227f15c7ed977866337e5c1ec.blocktopmenu.tpl.php'
WHERE `template_hash`='af9f0cff16a77f54a59d52deff9f4935' AND cache_id="blocktopmenu|1|1|1|1|2|21|category|226" AND compile_id=""
7.9 1 /classes/SmartyCustom.php:183
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|381|1|1%"
6.8 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|371|1|1%"
6.5 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
6.3 1994 /classes/Configuration.php:148
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|602|1|1%"
6.1 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|600|1|1%"
6.1 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|372|1|1%"
6 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|370|1|1%"
6 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|597|1|1%"
5.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|365|1|1%"
5.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|383|1|1%"
5.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|382|1|1%"
5.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|379|1|1%"
5.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "378|1|1|1|1|2|21%"
5.8 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|603|1|1%"
5.8 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|389|1|1%"
5.8 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='9fa00b59bbc051d7185906531f8cb38e' AND cache_id LIKE "productlist_colors|601|1|1%"
5.6 1 /classes/SmartyCustom.php:295
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-24 00:00:00", INTERVAL 0 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 = 1)
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` = 1)
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.price asc , cp.id_product LIMIT 0,24
4.2 27 Yes /modules/blocklayered/blocklayered.php:2048
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
3 244 Yes /classes/Country.php:131
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2.6 88 Yes Yes /classes/Hook.php:355
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 1 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.1 80 Yes Yes /classes/Category.php:585
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
2.1 449 /classes/Hook.php:236
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.8 0 /classes/Hook.php:131
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
1.6 710 /classes/SpecificPrice.php:230
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 = 226
AND sl.id_lang = 1 AND s.active = 1
ORDER BY sl.name ASC
1.4 1 Yes /classes/Scene.php:226
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.3 338 Yes /classes/Country.php:137
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 >= 65
AND c.nright <= 66
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 DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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)
WHERE pa.`id_product` = 342
AND pac.id_product_attribute = 79990
AND a.`id_attribute` NOT IN(298)
1.1 2 /classes/Product.php:5572
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockbanner/1/1/1/1/2/21/0b/f9/25/0bf9252611b2bf14be9335288d1fc8d588ad43cb.blockbanner.tpl.php'
WHERE `template_hash`='3eacb84cd64c5d991141b43ba35ad360' AND cache_id="blockbanner|1|1|1|1|2|21" AND compile_id=""
1 1 /classes/SmartyCustom.php:183
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')
1 1 /classes/ObjectModel.php:487
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 = 1)
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 = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 12
GROUP BY fv.id_feature_value
1 27 Yes /modules/blocklayered/blocklayered.php:2376
SELECT SQL_NO_CACHE `id_date_range`, `time_end`
FROM `ps_date_range`
WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`) LIMIT 1
1 1946025 /classes/DateRange.php:49
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 >= 65
AND c.nright <= 66
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 1 /modules/blocklayered/blocklayered.php:1942
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcms/0/1/1/1/1/2/21/84/dd/e1/84dde1eb0f488543787b8c239c6b13c3575ca164.blockcms.tpl.php'
WHERE `template_hash`='0d02a37f6632b0610fe526f70d1860bb' AND cache_id="blockcms|0|1|1|1|1|2|21" AND compile_id=""
0.9 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockmyaccountfooter/1/1/1/1/2/21/f2/22/40/f22240bcc4981cc3e61592bf41ebfddcadb9fd21.blockmyaccountfooter.tpl.php'
WHERE `template_hash`='e9df9b72f15ee2e8772620f6ed2d3350' AND cache_id="blockmyaccountfooter|1|1|1|1|2|21" AND compile_id=""
0.9 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 ('2682129', '1108', '912043273', '', '1', '1', '2018-05-24 17:40:32')
0.9 1 /classes/ObjectModel.php:487
UPDATE `ps_smarty_lazy_cache`
SET filepath='productlist_colors/342/1/1/3d/2e/13/3d2e13da02fa77848d5c3f6e4ca2ebcc0ea7cc67.product-list-colors.tpl.php'
WHERE `template_hash`='9fa00b59bbc051d7185906531f8cb38e' AND cache_id="productlist_colors|342|1|1" AND compile_id=""
0.9 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.9 709 /classes/SpecificPrice.php:238
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcontact/1/1/1/1/2/21/3f/0f/47/3f0f47f8b60f947dd4d27d0ffb0676729314fa22.nav.tpl.php'
WHERE `template_hash`='c01f60e9031a9daea91a6d6d541dd287' AND cache_id="blockcontact|1|1|1|1|2|21" AND compile_id=""
0.9 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcontactinfos/1/1/1/1/2/21/29/44/10/294410ee453934509e635f2e73b813ad3e291bb1.blockcontactinfos.tpl.php'
WHERE `template_hash`='04ecbfde2116e9932f2b4aead4d5a8c0' AND cache_id="blockcontactinfos|1|1|1|1|2|21" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='blocksearch_top/1/1/1/1/2/21/65/32/1d/65321d791c6b58986b0d81735f9b20d7315a3ead.blocksearch-top.tpl.php'
WHERE `template_hash`='6d68fc1d413b613350335e0d2029a605' AND cache_id="blocksearch-top|1|1|1|1|2|21" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='blocksocial/1/1/1/1/2/21/0f/45/67/0f45675aedeca08bbcc140fcaa5752c49bb44310.blocksocial.tpl.php'
WHERE `template_hash`='53288174ec7492a0866acb3ad0465212' AND cache_id="blocksocial|1|1|1|1|2|21" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcms/2/1/1/1/1/2/21/84/dd/e1/84dde1eb0f488543787b8c239c6b13c3575ca164.blockcms.tpl.php'
WHERE `template_hash`='0d02a37f6632b0610fe526f70d1860bb' AND cache_id="blockcms|2|1|1|1|1|2|21" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productlist_colors/343/1/1/3d/2e/13/3d2e13da02fa77848d5c3f6e4ca2ebcc0ea7cc67.product-list-colors.tpl.php'
WHERE `template_hash`='9fa00b59bbc051d7185906531f8cb38e' AND cache_id="productlist_colors|343|1|1" AND compile_id=""
0.8 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE bc.`id_cms_block`, bc.`id_cms_category`, bc.`display_store`, ccl.`link_rewrite`, ccl.`name` category_name, bcl.`name` block_name
FROM `ps_cms_block` bc
LEFT JOIN `ps_cms_block_shop` bcs
ON (bcs.id_cms_block = bc.id_cms_block)
INNER JOIN `ps_cms_category_lang` ccl
ON (bc.`id_cms_category` = ccl.`id_cms_category`)
INNER JOIN `ps_cms_block_lang` bcl
ON (bc.`id_cms_block` = bcl.`id_cms_block`)
WHERE bc.`location` = 0
AND ccl.`id_lang` = 1
AND bcl.`id_lang` = 1
AND bcs.id_shop = 1 AND ccl.`id_shop` = 1
ORDER BY `position`
0.7 1 Yes /modules/blockcms/BlockCMSModel.php:360
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 = 2 AND psi.id_shop=1)
WHERE 1
0.7 27 /modules/blocklayered/blocklayered.php:2376
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.7 38 Yes /classes/Dispatcher.php:452
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 = 1)
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 = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 14
GROUP BY fv.id_feature_value
0.7 27 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 = 1)
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 = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 15
GROUP BY fv.id_feature_value
0.7 27 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 = 1)
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 = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 16
GROUP BY fv.id_feature_value
0.7 27 Yes /modules/blocklayered/blocklayered.php:2376
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` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 226
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.7 1 Yes Yes /classes/Category.php:658
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 = 1)
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 = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 7
GROUP BY fv.id_feature_value
0.7 27 Yes /modules/blocklayered/blocklayered.php:2376
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
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)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 343
GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.7 1 Yes Yes /classes/Product.php:2092
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 226
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.7 11 Yes Yes /modules/blocklayered/blocklayered.php:2122
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "366|1|1|1|1|2|21%"
0.6 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 378) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.6 102 /classes/module/Module.php:277
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
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)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 342
GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.6 1 Yes Yes /classes/Product.php:2092
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 = 1)
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 = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 13
GROUP BY fv.id_feature_value
0.6 27 Yes /modules/blocklayered/blocklayered.php:2376
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 342) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 632
0.6 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 379) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 2 Yes /classes/SpecificPrice.php:361
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "381|1|1|1|1|2|21%"
0.6 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "372|1|1|1|1|2|21%"
0.6 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
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)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 343
GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.6 1 Yes Yes /classes/Product.php:2092
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "383|1|1|1|1|2|21%"
0.6 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
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)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 342
GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.6 1 Yes Yes /classes/Product.php:2092
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "389|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 366
0.5 1 /Adapter/Adapter_Database.php:37
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "382|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "602|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC
0.5 9 Yes Yes /classes/Supplier.php:127
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "373|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "384|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "361|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "371|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "597|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "370|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "600|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('8f10617a8caf789637e5e1c3564d647c',"343|1|1|1|1|2|21","", FROM_UNIXTIME(1527176436))
0.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 385) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*
FROM `ps_feature` f
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1)
ORDER BY f.`position` ASC
0.5 14 Yes /classes/Feature.php:86
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 632) 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 ('8f10617a8caf789637e5e1c3564d647c',"365|1|1|1|1|2|21","", FROM_UNIXTIME(1527176436))
0.5 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "603|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('8f10617a8caf789637e5e1c3564d647c',"632|1|1|1|1|2|21","", FROM_UNIXTIME(1527176435))
0.5 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='8f10617a8caf789637e5e1c3564d647c' AND cache_id LIKE "601|1|1|1|1|2|21%"
0.5 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('8f10617a8caf789637e5e1c3564d647c',"379|1|1|1|1|2|21","", FROM_UNIXTIME(1527176435))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('8f10617a8caf789637e5e1c3564d647c',"385|1|1|1|1|2|21","", FROM_UNIXTIME(1527176435))
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 = 1) RIGHT JOIN ps_category_group cg ON (cg.id_category = c.id_category AND cg.`id_group` IN (1)) WHERE c.nleft > 65
AND c.nright < 66
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position
0.5 12 Yes /modules/blocklayered/blocklayered.php:2376
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('8f10617a8caf789637e5e1c3564d647c',"342|1|1|1|1|2|21","", FROM_UNIXTIME(1527176435))
0.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.braapmoto.com' OR su.domain_ssl = 'www.braapmoto.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.5 1 Yes /classes/shop/Shop.php:334
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 385
ORDER BY f.position ASC
0.5 4 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `ps_manufacturer` m
INNER JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)
WHERE m.`active` = 1
ORDER BY m.`name` ASC
0.4 23 Yes /classes/Manufacturer.php:181
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 343) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 361
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9fa00b59bbc051d7185906531f8cb38e',"productlist_colors|366|1|1","", FROM_UNIXTIME(1527176432))
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 365) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 366
0.4 1 /Adapter/Adapter_Database.php:37
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('8f10617a8caf789637e5e1c3564d647c',"387|1|1|1|1|2|21","", FROM_UNIXTIME(1527176435))
0.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 384) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9fa00b59bbc051d7185906531f8cb38e',"productlist_colors|387|1|1","", FROM_UNIXTIME(1527176432))
0.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9fa00b59bbc051d7185906531f8cb38e',"productlist_colors|385|1|1","", FROM_UNIXTIME(1527176432))
0.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 601) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 365) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 387) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 371
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 600) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 632) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 597) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 373) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 372) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 371) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 370) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 366) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 602) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 1 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE name
FROM `ps_feature_lang` fl
LEFT JOIN  `ps_layered_indexable_feature` lif
ON lif.id_feature = fl.id_feature
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 1
0.4 70 /modules/blocklayered/blocklayered.php:2725
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 342
AND pac.`id_product_attribute` = 79990
0.4 1 /classes/Product.php:5531
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 381
0.4 1 /Adapter/Adapter_Database.php:37
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 632
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.4 1 Yes /classes/shop/Shop.php:663
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9fa00b59bbc051d7185906531f8cb38e',"productlist_colors|373|1|1","", FROM_UNIXTIME(1527176432))
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 372) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 226 LIMIT 1
0.4 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 381
0.4 1 /Adapter/Adapter_Database.php:37
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 600) AND (b.`id_shop` = 1) LIMIT 1
0.4 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 601
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 343
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 378
0.4 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 361) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 366
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 389) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 378
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 365
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 603) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 384
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 384) AND (b.`id_shop` = 1) LIMIT 1
0.4 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 382
ORDER BY f.position ASC
0.4 3 Yes /classes/Product.php:4453
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9fa00b59bbc051d7185906531f8cb38e',"productlist_colors|378|1|1","", FROM_UNIXTIME(1527176432))
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 389
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 379) AND (b.`id_shop` = 1) LIMIT 1
0.4 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 603
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 597
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 381
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 1 Yes /classes/SpecificPrice.php:361
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 366) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 366
0.4 1 /Adapter/Adapter_Database.php:37
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 387
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 372
0.4 1 /Adapter/Adapter_Database.php:37
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 373) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 385) AND (b.`id_shop` = 1) LIMIT 1
0.4 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 383
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 343) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 381) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-05-24 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:361
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 381) AND (b.`id_shop` = 1) LIMIT 1
0.4 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 602
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 370
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 600
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 361) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 603) 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 ('9fa00b59bbc051d7185906531f8cb38e',"productlist_colors|384|1|1","", FROM_UNIXTIME(1527176432))
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 601) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 383) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.4 3 /classes/Currency.php:472
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 372
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 382) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 342) AND (b.`id_shop` = 1) LIMIT 1
0.4 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 373
ORDER BY f.position ASC
0.4 4 Yes /classes/Product.php:4453
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 379
ORDER BY f.position ASC
0.4 3 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 365
0.4 1 /Adapter/Adapter_Database.php:37
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 387) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 602) 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 ('9fa00b59bbc051d7185906531f8cb38e',"productlist_colors|361|1|1","", FROM_UNIXTIME(1527176432))
0.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 378
0.4 1 /Adapter/Adapter_Database.php:37
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 389) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.4 9 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 2
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.4 1 Yes /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 632
0.4 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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)
WHERE pa.`id_product` = 343
AND pac.id_product_attribute = 79991
AND a.`id_attribute` NOT IN(298)
0.4 2 /classes/Product.php:5572
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 370) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 597) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 378) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 597
0.4 1 /Adapter/Adapter_Database.php:37
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.4 1 /modules/blocklayered/blocklayered.php:2142
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 371) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 371
0.4 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE public_name
FROM `ps_attribute_group_lang` agl
LEFT JOIN `ps_layered_indexable_attribute_group` liag
ON liag.id_attribute_group = agl.id_attribute_group
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 1
0.4 180 /modules/blocklayered/blocklayered.php:2715
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 632 LIMIT 1
0.4 1 /classes/Product.php:2237
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 342
ORDER BY f.position ASC
0.3 4 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 54 AND `id_shop` = 1 LIMIT 1
0.3 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
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 <= 65
AND c.nright >= 66
AND c.nleft >= 2
AND c.nright <= 155
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.3 14 Yes /classes/Tools.php:1301
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 343
AND pac.`id_product_attribute` = 79991
0.3 1 /classes/Product.php:5531
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` = 342)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 381
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 385 LIMIT 1
0.3 1 /classes/Product.php:752
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` = 379)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
0.3 2 /classes/Category.php:1673
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 366
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.3 116 /classes/Tab.php:296
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 600
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 12) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.3 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 61 AND `id_object` = 226 LIMIT 1
0.3 1 /classes/Page.php:77
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 383
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 343 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 370
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 378
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 372
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 365
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 365
0.3 1 /Adapter/Adapter_Database.php:37
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` = 226
AND l.`active` = 1
0.3 25 /classes/Category.php:1460
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.3 25 /classes/Language.php:894
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 383
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 366
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 383 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 365
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 632
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 365
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='8f10617a8caf789637e5e1c3564d647c' AND cache_id="378|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 600
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 381
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 343
0.3 1 /Adapter/Adapter_Database.php:37
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` = 343)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 632
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 343
0.3 1 /Adapter/Adapter_Database.php:37
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 27 Yes /modules/blocklayered/blocklayered.php:2376
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 378
0.3 1 /Adapter/Adapter_Database.php:37
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` = 5
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 226) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 384
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 381
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 632 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 372 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 383
0.3 1 /Adapter/Adapter_Database.php:37
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` = 385)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 365
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 372
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 378
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 603
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 378
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 632
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 381
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 342
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 381 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 383
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 383
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 365 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 382
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 366 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 365
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 382 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 366
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 343
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 373
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 632 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 600
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 602
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 378 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 342
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 381
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 372
0.3 1 /Adapter/Adapter_Database.php:37
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` = 597)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 372
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 381
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 597
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.3 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 383 LIMIT 1
0.3 1 /classes/Product.php:2237
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` = 226) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 372
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "order-opc"
OR m.page = "orderopc"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.3 2 /classes/Meta.php:149
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 384
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 361
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 366 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 378
0.3 1 /Adapter/Adapter_Database.php:37
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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 226) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 381
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 602
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 381 LIMIT 1
0.3 1 /classes/Product.php:2237
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` = 603)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 600
0.3 1 /Adapter/Adapter_Database.php:37
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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 226) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 343
0.3 1 /Adapter/Adapter_Database.php:37
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` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 226) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 384 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 370
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 342
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 365
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 366
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 602
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='0d02a37f6632b0610fe526f70d1860bb' AND cache_id="blockcms|0|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 384
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 342 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 379
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 371
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 382
0.3 1 /Adapter/Adapter_Database.php:37
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` = 370)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.3 1 /classes/shop/Shop.php:203
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 597
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 383
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 597
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 373
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 378
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 597
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 597
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 602
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 602
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 372
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 342
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
0.3 2 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 602 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 382
0.3 1 /Adapter/Adapter_Database.php:37
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` = 601)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 12) LIMIT 1
0.3 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` = 365)
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` = 372)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 378 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 384
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 342
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 597
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 602 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 371
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 379 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 373
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 342
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 600
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 379
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 379
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 371
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 600
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 381
0.3 1 /Adapter/Adapter_Database.php:37
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` = 382)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 382
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 342
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 343 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 366
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 384
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
FROM ps_layered_category
WHERE id_category = 226
AND id_shop = 1 LIMIT 1
0.3 11 /modules/blocklayered/blocklayered.php:637
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` = 383)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 601
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 378
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 379
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 384
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 373 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 597
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 371
0.3 1 /Adapter/Adapter_Database.php:37
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` = 384)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 597
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 383
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 389
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 382
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 378 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 361
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 632
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 372
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 384
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 603
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 389
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 600
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 632
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 366
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 361
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 365 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 387
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 389
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 379
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 379
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 603
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.3 5 /classes/Language.php:777
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 342
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 385
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 373
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 361
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 373
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 603
0.3 1 /Adapter/Adapter_Database.php:37
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` = 600)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 342
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 342
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 373
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 385
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 600
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 379
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 361
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 372
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 601
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 387
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 385
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 382
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 601
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 602
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 601
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 387
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 603
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 382
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 389
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 387
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 600
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 387
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 602
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 371
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 601
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 597
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 385
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 602
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 378
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 597 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 601
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 600
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 373
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 373
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 365
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 373
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 602
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 389
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 373
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 383
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 379
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 387
0.3 1 /Adapter/Adapter_Database.php:37
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` = 373)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 361
0.3 1 /Adapter/Adapter_Database.php:37
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` = 371)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.3 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 601
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 372 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 597 LIMIT 1
0.3 1 /classes/Product.php:2237
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` = 387)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 382
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 379
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 603
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3eacb84cd64c5d991141b43ba35ad360' AND cache_id="blockbanner|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 373 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 387
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 384 LIMIT 1
0.3 1 /classes/Product.php:2237
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` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 603
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 381
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 343
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 384
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 602
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 379
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 385
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 603
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 382 LIMIT 1
0.3 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 343
0.3 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 601
0.3 1 /Adapter/Adapter_Database.php:37
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` = 378)
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` = 632)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 603
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 603
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 389
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 370
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 389
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 389
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 384
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 370
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 601
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 387
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 632
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 343
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 387
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 385
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 600 LIMIT 1
0.2 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 385
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 384
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 632
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 385
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 601
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 389
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 385
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 385
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 389
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 632
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 342 LIMIT 1
0.2 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 343
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 383
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 387
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE *
FROM `ps_feature` a
LEFT JOIN `ps_feature_lang` `b` ON a.`id_feature` = b.`id_feature` AND b.`id_lang` = 1
LEFT JOIN `ps_feature_shop` `c` ON a.`id_feature` = c.`id_feature` AND c.`id_shop` = 1
WHERE (a.`id_feature` = 7) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(*)
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)
WHERE pa.`id_product` = 370 LIMIT 1
0.2 1 /classes/Product.php:2237
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 361
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 361
0.2 1 /Adapter/Adapter_Database.php:37
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =1 AND m.page = "category" LIMIT 1
0.2 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 371
0.2 1 /Adapter/Adapter_Database.php:37