Categories

Specials

Información

Last reviews

By Jaap K. (Groningen, Netherlands) on 28 Nov. 2016 :

(5/5) 

Product rated : Rims dhz motard These are one of the...

By Jaap K. (Groningen, Netherlands) on 28 Nov. 2016 :

(5/5) 

Product rated : Pmt rain 12" couple The compound of the tires...

By Jaap K. (Groningen, Netherlands) on 03 Oct. 2016 :

(5/5) 

Product rated : Turbo kit exhaust gp min25 klx Really a nice exhaust, good...

New products

Top sellers

No products

To be determined Shipping
0,00 € Total

Check out

Load Time3129 ms - You'd better run your shop on a toaster
Querying Time253 ms
Queries853
Memory Peak Usage42.7 Mb
Included Files328 files - 6.48 Mb
PrestaShop Cache- Mb
Global vars0.72 Mb
PrestaShop Version1.6.1.5
PHP Version5.6.39 (OK)
MySQL Version10.3.11-MariaDB-log (OK)
Memory Limit512M
Max Execution Time18000s
Smarty Cacheenabled
Smarty Compilationforce compile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 49 ms 49 ms 5.64 Mb 5.77 Mb
__construct 0 ms 49 ms - Mb 5.78 Mb
init 7 ms 56 ms 1.05 Mb 6.82 Mb
checkAccess 0 ms 56 ms - Mb 6.82 Mb
setMedia 3 ms 59 ms 0.07 Mb 6.88 Mb
postProcess 0 ms 59 ms - Mb 6.88 Mb
initHeader 0 ms 59 ms - Mb 6.89 Mb
initContent 1806 ms 1865 ms 30.85 Mb 37.78 Mb
initFooter 159 ms 2025 ms 1.48 Mb 39.60 Mb
display 1104 ms 3129 ms 2.16 Mb 42.67 Mb
Hook Time Memory Usage
hookdisplayHome 1070 ms 16.00 Mb
hookdisplayProductListReviews 239 ms 4.50 Mb
hooktop 135 ms 1.00 Mb
hookdisplaySideBar 103 ms 0.75 Mb
hookdisplayHeader 102 ms 0.75 Mb
hookdisplayFooter 102 ms 1.50 Mb
hookheader 83 ms 2.00 Mb
__construct 77 ms 9.00 Mb
hookdisplayLeftColumn 69 ms 1.00 Mb
hookdisplayTop 58 ms 0.50 Mb
hookfooter 49 ms 0.50 Mb
hookdisplayNav 41 ms 0.25 Mb
hookdisplayProductLabelBlock 31 ms 0.25 Mb
hookdisplayHomeTop 11 ms - Mb
hookdisplayHomeBottom 10 ms - Mb
hookdisplayMobileBar 7 ms - Mb
hookleftcolumn 7 ms - Mb
hookdisplayHomeSecondaryLeft 6 ms - Mb
hookdisplayHomeSecondaryRight 6 ms - Mb
hookdisplayTopSecondary 5 ms - Mb
hookdisplayHomeVeryBottom 4 ms - Mb
hookdisplayAnywhere 4 ms - Mb
hookdisplayMobileMenu 4 ms - Mb
hookdisplayFooterTop 3 ms - Mb
hookdisplayFooterBottomLeft 3 ms 0.25 Mb
hookdisplayHomeTertiaryRight 3 ms - Mb
hookdisplayHomeTertiaryLeft 2 ms - Mb
hookmoduleRoutes 2 ms - Mb
hookdisplayFooterBottomRight 2 ms - Mb
hookdisplayRightColumn 2 ms - Mb
hookdisplayBanner 2 ms - Mb
hookdisplayFooterSecondary 1 ms - Mb
hookdisplayBottomColumn 1 ms - Mb
hookhome 1 ms - Mb
hookdisplayTopColumn 1 ms - Mb
hookdisplayFullWidthTop 1 ms - Mb
hookdisplayFullWidthTop2 0 ms - Mb
hookrightcolumn 0 ms - Mb
hookdisplayHomeTabContent - ms - Mb
39 hooks 2248 ms 38.25 Mb
Module Time Memory Usage
sthomenew 512 ms 5.50 Mb
stbestsellers 337 ms 8.00 Mb
gsnippetsreviews 331 ms 6.25 Mb
blockcart_mod 233 ms 2.00 Mb
homefeaturedslider 226 ms 3.00 Mb
deluxelopd 78 ms 1.25 Mb
homesliderpro 68 ms 0.75 Mb
productenquiryform 46 ms 0.25 Mb
stbanner 38 ms 0.25 Mb
productlabel 33 ms 0.25 Mb
stthemeeditor 30 ms 1.50 Mb
stcameraslideshow 29 ms 0.25 Mb
contentprotection 25 ms - Mb
stiosslider 20 ms 1.25 Mb
blockuserinfo_mod 18 ms - Mb
stmultilink 16 ms 0.75 Mb
stmegamenu 16 ms 0.25 Mb
blocksearch_mod 15 ms - Mb
staddthisbutton 15 ms 0.25 Mb
blocklanguages_mod 14 ms 0.25 Mb
notarobot 13 ms - Mb
stspecialslider 10 ms - Mb
miniccookie 9 ms 0.25 Mb
blockcurrencies_mod 9 ms - Mb
statsdata 8 ms 0.50 Mb
faktiva_seotk 7 ms - Mb
stsocial 7 ms - Mb
blockcategories 6 ms 0.25 Mb
stquickview 6 ms - Mb
homefeatured_mod 6 ms 0.25 Mb
bongooglereviews 5 ms - Mb
feeder 5 ms 1.75 Mb
paylater 5 ms 0.25 Mb
stfeaturedcategories 5 ms 0.25 Mb
tkraceradmin 5 ms - Mb
bestkit_infinitescroll 5 ms - Mb
paypalwithfee 4 ms - Mb
powerfulformgenerator 4 ms 0.25 Mb
blockcms 4 ms - Mb
hsmultiaccessoriespro 3 ms 1.00 Mb
popupnotification 3 ms - Mb
cron 2 ms - Mb
ganalytics 2 ms 0.25 Mb
productwithoutimages 2 ms 0.25 Mb
sthoverimage 1 ms - Mb
codfee 1 ms - Mb
strightbarcart 1 ms - Mb
steasytabs 1 ms - Mb
lgcanonicalurls 1 ms - Mb
blockviewed 1 ms - Mb
stnewsletter 1 ms - Mb
stcompare 1 ms - Mb
customersexport 1 ms 0.25 Mb
stproductlinknav 1 ms - Mb
scpdfcatalog 1 ms 0.25 Mb
mailalerts 1 ms 0.25 Mb
socialsharing 1 ms 0.25 Mb
pagesnotfound 0 ms - Mb
productscategory 0 ms - Mb
59 modules 2248 ms 38.25 Mb

Stopwatch SQL - 853 queries

<
Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2019-01-17 00:00:00",
INTERVAL 120 DAY)) > 0 AS new, product_shop.price AS orderprice
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_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_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  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 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`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 10
9.5 52 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute,
pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer,
image_shop.`id_image` id_image, il.`legend`,
ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`,
DATEDIFF(p.`date_add`, DATE_SUB("2019-01-17 00:00:00",
INTERVAL 120 DAY)) > 0 AS new FROM `ps_product_sale` ps
LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product`
LEFT 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 p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 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_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`)
AND tr.`id_country` = 6
AND tr.`id_state` = 0
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
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 p.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp
JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
WHERE cp.`id_product` = p.`id_product`)
ORDER BY `product_shop`.`date_add` DESC
LIMIT 0, 30
8.6 1560 /classes/ProductSale.php:140
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`)
7 3760 /classes/Configuration.php:148
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"109|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
5.9 1 /classes/SmartyCustom.php:263
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 (9))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
3.9 238 Yes Yes /classes/Hook.php:355
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2800|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
3.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2267)
3.6 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 269 AND `id_group` = 1 LIMIT 1
3.6 0 /classes/GroupReduction.php:149
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 = 2270
ORDER BY f.position ASC
3.1 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 109
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
2.8 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
product_shop.`date_add` > "2018-09-19" as new,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
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_lang` `pl` ON 
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 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_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_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")) AND (product_shop.`date_add` > "2018-09-19") AND (EXISTS(SELECT 1 FROM `ps_category_product` cp
JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
WHERE cp.`id_product` = p.`id_product`))
ORDER BY product_shop.`date_add` DESC
LIMIT 10
2.5 525 /classes/Product.php:2343
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2805 AND RTG_LANG_ID = 1
2.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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 538 /classes/Hook.php:236
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2800 AND RTG_LANG_ID = 1
1.9 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2778 AND RTG_LANG_ID = 1
1.6 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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 = 2799 LIMIT 1
1.6 1 /classes/Product.php:752
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('df879f1d3abf02fc2677e50fd8489d0d',"stcameraslideshow|1|1|9|1|1|6_17_location","", FROM_UNIXTIME(1547730016))
1.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5fa960c59cdcfb6987f2004867774675' AND cache_id="1281|1|1|9|1|1|6" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5fa960c59cdcfb6987f2004867774675' AND cache_id="2787|1|1|9|1|1|6" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE RVW_ID as id,RTG_ID as ratingId,RVW_SHOP_ID as shopId,RVW_PROD_ID as productId,RVW_LANG_ID as langId,UNIX_TIMESTAMP(RVW_DATE_ADD) as dateAdd,UNIX_TIMESTAMP(RVW_DATE_UPD) as dateUpd,RVW_STATUS as status,RVW_CUST_ID as custId,RVW_FB_PAGE_ID as fbPageId,RVW_DATA as data, pl.name as name, c.firstname as firstname, c.lastname as lastname, c.email as email, RPT_RVW_ID as reportId FROM ps_gsr_review as rvw LEFT JOIN ps_product_lang as pl ON (pl.id_product = rvw.RVW_PROD_ID AND pl.id_lang = 1 AND pl.id_shop = 1 ) LEFT JOIN ps_customer as c ON c.id_customer = rvw.RVW_CUST_ID LEFT JOIN ps_gsr_review_report ON RPT_RVW_ID = rvw.RVW_ID WHERE rvw.RVW_STATUS = "1"  AND rvw.RVW_SHOP_ID  = 1  AND rvw.RVW_LANG_ID  = 1  ORDER BY dateAdd DESC  LIMIT 3
1 241 Yes /modules/gsnippetsreviews/lib/reviews/review-dao_class.php:415
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('df879f1d3abf02fc2677e50fd8489d0d',"stcameraslideshow|1|1|9|1|1|6_17_location","", FROM_UNIXTIME(1547730016))
1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE DISTINCT a.*, cl.`name` AS country, s.name AS state, s.iso_code AS state_iso
FROM `ps_address` a
LEFT JOIN `ps_country` c ON (a.`id_country` = c.`id_country`)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country`)
LEFT JOIN `ps_state` s ON (s.`id_state` = a.`id_state`)
INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
WHERE `id_lang` = 1 AND `id_customer` = 10282 AND a.`deleted` = 0
0.9 1 /classes/Customer.php:459
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2787 AND RTG_LANG_ID = 1
0.9 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (3)
ORDER BY smsg.`position`
0.8 2 Yes /modules/stbanner/StBannerGroup.php:175
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.8 1 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='8ff9f71e8ac0ce664df5c6f3a1dead4f' AND cache_id="stmultilink|1|1|9|1|1|6_3_location" AND compile_id="" LIMIT 1
0.8 1 /classes/SmartyCustom.php:215
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.7 109 /classes/module/Module.php:277
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 269 AND RTG_LANG_ID = 1
0.7 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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 = 269
ORDER BY f.position ASC
0.7 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.7 1 Yes /classes/SpecificPrice.php:361
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 42 Yes /classes/Dispatcher.php:452
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.7 109 /classes/module/Module.php:277
SELECT SQL_NO_CACHE id_product, 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)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE `id_product` IN (2812,2808,2807,2806,2811,2810,2809,2805,2804,2803)
ORDER BY f.position ASC
0.7 1 Yes /classes/Product.php:3740
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 1 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 1691728
AND `date_add` > '2019-01-17 13:30:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.6 1 /classes/Connection.php:138
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` = 2796) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
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 109 /classes/module/Module.php:277
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1278) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 6 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 1 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 = 2801
ORDER BY f.position ASC
0.6 1 Yes /classes/Product.php:4453
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
0.6 0 /classes/Hook.php:131
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 = 175
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:4453
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"1281|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2787) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 6 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 1 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2812) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 5 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` = 2777) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2804) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 4 Yes /classes/SpecificPrice.php:361
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` = 6
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.5 1 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.5 222 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 293) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:378
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"269|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 2807
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.5 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 293 AND id_shop=1 LIMIT 1
0.5 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 1 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_iosslider_group` smsg
INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (4)
ORDER BY smsg.`position`
0.5 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
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` = 559) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 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` = 1281) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE hs.`id_homeslider_slides` as id_slide,
hs.`id_hook`,
hssl.`image`,
hss.`position`,
hss.`active`,
hss.`new_window`,
hss.`has_area`,
hssl.`title`,
hssl.`url`,
hssl.`legend`,
hssl.`description`,
hssl.`areas`
FROM ps_homesliderpro hs
LEFT JOIN ps_homesliderpro_slides hss ON (hs.id_homeslider_slides = hss.id_homeslider_slides)
LEFT JOIN ps_homesliderpro_slides_lang hssl ON (hss.id_homeslider_slides = hssl.id_homeslider_slides)
WHERE (hs.id_shop = 1)
AND (hs.id_hook = "comentarios_google")
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position
0.4 1 Yes /modules/homesliderpro/homesliderpro.php:1095
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (6)
ORDER BY smsg.`position`
0.4 2 Yes /modules/stbanner/StBannerGroup.php:175
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` = 175) 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` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 smsg.*
FROM `ps_st_iosslider_group` smsg
INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (3)
ORDER BY smsg.`position`
0.4 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
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` = 2270) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d76516104874df65ea4a5647c71d4a70' AND cache_id="stbestsellers|1|1|9|1|1|6_99e2c99214" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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, 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 = 293
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_camera_slideshow_group` smsg
INNER JOIN ps_st_camera_slideshow_group_shop st_camera_slideshow_group_shop
ON (st_camera_slideshow_group_shop.id_st_camera_slideshow_group = smsg.id_st_camera_slideshow_group AND st_camera_slideshow_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (1,4,13,14)
ORDER BY smsg.`position`
0.4 2 Yes /modules/stcameraslideshow/StCameraSlideshowGroup.php:233
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.4 166 /classes/Tab.php:296
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "index"
OR m.page = "index"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.4 1 /classes/Meta.php:149
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 = 559
ORDER BY f.position ASC
0.4 1 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` = 1244) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_camera_slideshow_group` smsg
INNER JOIN ps_st_camera_slideshow_group_shop st_camera_slideshow_group_shop
ON (st_camera_slideshow_group_shop.id_st_camera_slideshow_group = smsg.id_st_camera_slideshow_group AND st_camera_slideshow_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (15)
ORDER BY smsg.`position`
0.4 2 Yes /modules/stcameraslideshow/StCameraSlideshowGroup.php:233
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 919
0.4 1 /classes/Product.php:4470
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.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` = 109) 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` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 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 = 2801 LIMIT 1
0.4 1 /classes/Product.php:752
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` = 2799) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
show tables like 'ps_pmt_cart_process'
0.4 1 /modules/paylater/paylater.php:58
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 smsg.*
FROM `ps_st_camera_slideshow_group` smsg
INNER JOIN ps_st_camera_slideshow_group_shop st_camera_slideshow_group_shop
ON (st_camera_slideshow_group_shop.id_st_camera_slideshow_group = smsg.id_st_camera_slideshow_group AND st_camera_slideshow_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (3)
ORDER BY smsg.`position`
0.4 2 Yes /modules/stcameraslideshow/StCameraSlideshowGroup.php:233
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` = 2769) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (1)
ORDER BY smsg.`position`
0.4 2 Yes /modules/stbanner/StBannerGroup.php:175
UPDATE `ps_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 2315
AND `id_page` = 1065
AND `id_shop` = 1
0.4 1 /classes/Page.php:118
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 product_attribute_shop.`price`
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_attribute` = 686 LIMIT 1
0.4 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE sms.*, smsl.*
FROM `ps_st_camera_slideshow` sms
LEFT JOIN `ps_st_camera_slideshow_lang` smsl ON (sms.`id_st_camera_slideshow` = smsl.`id_st_camera_slideshow`)
WHERE smsl.`id_lang` = 1 AND sms.`id_st_camera_slideshow_group`=1 AND sms.`isbanner`=0 AND sms.`active`=1 
ORDER BY sms.`position`
0.4 7 Yes /modules/stcameraslideshow/StCameraSlideshowClass.php:139
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 DISTINCT(fc.`id_st_featured_category`), fc.*, cl.`name`, cl.`link_rewrite`
FROM `ps_st_featured_category` fc
LEFT JOIN `ps_category` c ON (fc.`id_category` = c.`id_category`)
LEFT JOIN `ps_category_lang` cl ON (fc.`id_category` = cl.`id_category` AND cl.`id_lang`=1 AND cl.id_shop = 1 )
WHERE fc.`id_parent`=0 AND fc.`id_shop`=1 AND fc.`active`=1 
ORDER BY fc.`position`
0.4 6 Yes /modules/stfeaturedcategories/StFeaturedCategoriesClass.php:102
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
0.4 1 /classes/ObjectModel.php:487
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 269
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 smsg.*
FROM `ps_st_camera_slideshow_group` smsg
INNER JOIN ps_st_camera_slideshow_group_shop st_camera_slideshow_group_shop
ON (st_camera_slideshow_group_shop.id_st_camera_slideshow_group = smsg.id_st_camera_slideshow_group AND st_camera_slideshow_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (2)
ORDER BY smsg.`position`
0.4 2 Yes /modules/stcameraslideshow/StCameraSlideshowGroup.php:233
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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
show tables like "ps_sesliders_slideconf"
0.4 1 /modules/homesliderpro/homesliderpro.php:1218
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_iosslider_group` smsg
INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
0.4 1 /modules/stiosslider/StIosSliderGroup.php:156
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2770 AND RTG_LANG_ID = 1
0.4 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (19)
ORDER BY smsg.`position`
0.4 2 Yes /modules/stbanner/StBannerGroup.php:175
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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_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 6 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_iosslider_group` smsg
INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (1,14,15,16)
ORDER BY smsg.`position`
0.4 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
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` = 2770) 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` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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 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
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (4)
ORDER BY smsg.`position`
0.4 2 Yes /modules/stbanner/StBannerGroup.php:175
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2794 AND RTG_LANG_ID = 1
0.4 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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 = 1278
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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, 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 = 1281
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 175
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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, 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 = 109
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 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` = 77 LIMIT 1
0.4 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.3 1 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.3 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` = 334) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 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 = 1851
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.3 1 Yes /classes/SpecificPrice.php:361
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 =19 AND m.page = "index" LIMIT 1
0.3 1 /classes/Theme.php:275
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` = 1851) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"269|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 175) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378
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` = 2782) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.3 1 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.3 1 Yes /classes/SpecificPrice.php:361
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2805|1|1|9|1|1|6","", FROM_UNIXTIME(1547730015))
0.3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('1581533', '1065', '2019-01-17 14:00:16')
0.3 1 /classes/Connection.php:106
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2270
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198
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` = 109)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.3 1 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.3 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` = 661) AND (b.`id_shop` = 1) 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` = 2803)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.3 1 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 = 2796
ORDER BY f.position ASC
0.3 1 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` = 2776) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2267) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 52 LIMIT 1
0.3 1 /classes/Page.php:77
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 2809
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.3 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='b419a302fc1389f454b34f4ac58113ab' AND cache_id="homefeatured_mod|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 2803
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.3 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
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` = 1278)
0.3 1 /classes/Product.php:2998
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` = 41 LIMIT 1
0.3 1 /classes/Category.php:1054
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` = 0)
0.3 0 /classes/Product.php:2998
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 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 = 2773
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
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` = 1281)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 445) AND (b.`id_shop` = 1) 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` = 175)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2788) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 4 /classes/Language.php:894
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 = 0 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (5)
ORDER BY smsg.`position`
0.3 2 Yes /modules/stbanner/StBannerGroup.php:175
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` = 2778) AND (b.`id_shop` = 1) 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` = 559)
0.3 3 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1278) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2803) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2773) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2799 AND RTG_LANG_ID = 1
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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` = 2795) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2804 AND RTG_LANG_ID = 1
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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` = 2771) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a2c687d2e0f6cb399227ab89278eadf5' AND cache_id="stmegamenu|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
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` = 2801) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url`
FROM `ps_st_multi_link_group` smlg
INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop
ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1)
LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`)
WHERE smlg.`active`=1  AND smlg.`location` IN (23) AND smlgl.`id_lang` = 1
ORDER BY smlg.`position`
0.3 9 Yes /modules/stmultilink/StMultiLinkGroup.php:141
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2782
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198
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` = 2792) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2789) AND (b.`id_shop` = 1) 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` = 2771)
0.3 1 /classes/Product.php:2998
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 *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country` IN (0, 6) 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 '2019-01-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-01-17 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.3 1 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
0.3 151 /classes/SpecificPrice.php:230
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` = 2811) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 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 = 2770
ORDER BY f.position ASC
0.3 1 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 = 445
ORDER BY f.position ASC
0.3 1 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 = 2787
ORDER BY f.position ASC
0.3 1 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 = 2267
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 2812
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.3 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('acaaf9108aa596e4a978f143c1f4f87a',"stbanner|1|1|9|1|1|6_3_location","", FROM_UNIXTIME(1547730016))
0.3 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` = 2809) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2782|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.3 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` = 2793) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2812) AND (b.`id_shop` = 1) 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` = 334)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2794) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2777 AND RTG_LANG_ID = 1
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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
0.3 0 /classes/DateRange.php:49
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 = 2803
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2770) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378
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.sevimotor.com' OR su.domain_ssl = 'www.sevimotor.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.3 1 Yes /classes/shop/Shop.php:334
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` = 293) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (9)
ORDER BY smsg.`position`
0.3 2 Yes /modules/stbanner/StBannerGroup.php:175
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 269
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.3 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2796) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 2804
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.3 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
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` = 2770)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 919) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE a.id_product, b.name, b.description_short, c.id_image FROM ps_product a
join ps_product_lang b on a.id_product=b.id_product join ps_image c 
on c.id_product = a.id_product where c.cover = 1 and a.id_product=0 and b.id_lang = 1
0.3 0 /modules/productenquiryform/productenquiryform.php:773
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 = 2771
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2803 AND RTG_LANG_ID = 1
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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` = 2800) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url`
FROM `ps_st_multi_link_group` smlg
INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop
ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1)
LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`)
WHERE smlg.`active`=1  AND smlg.`location` IN (5,18,19,20,21,28) AND smlgl.`id_lang` = 1
ORDER BY smlg.`position`
0.3 9 Yes /modules/stmultilink/StMultiLinkGroup.php:141
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` = 1007) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2775) AND (b.`id_shop` = 1) 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` = 0)
0.3 0 /classes/Product.php:2998
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 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 = 2769
ORDER BY f.position ASC
0.3 1 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 = 2775
ORDER BY f.position ASC
0.3 1 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` = 2787) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 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 = 2776
ORDER BY f.position ASC
0.3 1 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 = 2793
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2812 AND RTG_LANG_ID = 1
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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 = 2777
ORDER BY f.position ASC
0.3 1 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` = 2807) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url`
FROM `ps_st_multi_link_group` smlg
INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop
ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1)
LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`)
WHERE smlg.`active`=1  AND smlg.`location` IN (2) AND smlgl.`id_lang` = 1
ORDER BY smlg.`position`
0.3 9 Yes /modules/stmultilink/StMultiLinkGroup.php:141
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` = 2806) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 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 = 2799
ORDER BY f.position ASC
0.3 1 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 = 2778
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
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` = 293)
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` = 2800)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 269) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2812
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_iosslider_group` smsg
INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (17)
ORDER BY smsg.`position`
0.3 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
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 = 2811
ORDER BY f.position ASC
0.3 1 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 = 2804
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 293 AND RTG_LANG_ID = 1
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 109 AND RTG_LANG_ID = 1
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 1281
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.3 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1281
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198
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 = 2800
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 1278 AND RTG_LANG_ID = 1
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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 = 919
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
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` = 919)
0.3 4 /classes/Product.php:2998
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 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 = 2794
ORDER BY f.position ASC
0.3 1 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` = 2804) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2787|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.3 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 = 2808
ORDER BY f.position ASC
0.3 1 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 = 2795
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='858cfa80fda0e99d5001e6c650e397b9' AND cache_id="homefeaturedslider|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
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 = 2788
ORDER BY f.position ASC
0.3 1 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` = 2810) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (2)
ORDER BY smsg.`position`
0.3 2 Yes /modules/stbanner/StBannerGroup.php:175
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2019-01-17 00:00:00' AND '2019-01-17 23:59:59' LIMIT 1
0.3 1 /classes/SpecificPrice.php:301
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 = 2789
ORDER BY f.position ASC
0.3 1 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 = 2792
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 269) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2801
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198
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 = 2782
ORDER BY f.position ASC
0.3 1 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 = 2806
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
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` = 54 LIMIT 1
0.3 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 919
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.3 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 559
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.3 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2805 AND RTG_LANG_ID = 1
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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 = 2808 LIMIT 1
0.3 3 /classes/Product.php:752
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2808 AND RTG_LANG_ID = 1
0.3 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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 = 2805
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.3 86 /classes/Hook.php:187
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` = 2792)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.2 21 /classes/ImageType.php:143
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` = 145 LIMIT 1
0.2 1 /classes/Category.php:1054
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` = 2812)
0.2 6 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 1
0.2 4 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'small_default' LIMIT 1
0.2 1 /classes/Image.php:470
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 293
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.2 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE id_hook, conf FROM `ps_sesliders_slideconf`
WHERE `id_shop` = 1
0.2 2 /modules/homesliderpro/homesliderpro.php:402
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'index' LIMIT 1
0.2 1 /classes/Page.php:97
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` = 269)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='acaaf9108aa596e4a978f143c1f4f87a' AND cache_id="stbanner|1|1|9|1|1|6_19_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 1278
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.2 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
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` = 2270)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2808) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1851)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url`
FROM `ps_st_multi_link_group` smlg
INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop
ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1)
LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`)
WHERE smlg.`active`=1  AND smlg.`location` IN (22) AND smlgl.`id_lang` = 1
ORDER BY smlg.`position`
0.2 9 Yes /modules/stmultilink/StMultiLinkGroup.php:141
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2803 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2270 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 334
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.2 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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_attribute` = 1224 LIMIT 1
0.2 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 2810
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.2 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
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` = 2787)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2788)
0.2 2 /classes/Product.php:2998
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 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 = 334
ORDER BY f.position ASC
0.2 1 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 = 2807
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.2 150 /classes/SpecificPrice.php:238
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5fa960c59cdcfb6987f2004867774675' AND cache_id="2770|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
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` = 2805) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5fa960c59cdcfb6987f2004867774675' AND cache_id="2799|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_iosslider_group` smsg
INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (18)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='b19dc95e0ceb16183d2a1465440cb73f' AND cache_id="stbanner|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 334 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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` = 2805)
0.2 2 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 2811
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.2 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (20)
ORDER BY smsg.`position`
0.2 2 Yes /modules/stbanner/StBannerGroup.php:175
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_camera_slideshow_group` smsg
INNER JOIN ps_st_camera_slideshow_group_shop st_camera_slideshow_group_shop
ON (st_camera_slideshow_group_shop.id_st_camera_slideshow_group = smsg.id_st_camera_slideshow_group AND st_camera_slideshow_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (18)
ORDER BY smsg.`position`
0.2 2 Yes /modules/stcameraslideshow/StCameraSlideshowGroup.php:233
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 2806
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.2 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='03911c558bf79ea286c1256050a4a25b' AND cache_id="stmegamenu|1|1|9|1|1|6_stmegamenu_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url`
FROM `ps_st_multi_link_group` smlg
INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop
ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1)
LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`)
WHERE smlg.`active`=1  AND smlg.`location` IN (22) AND smlgl.`id_lang` = 1
ORDER BY smlg.`position`
0.2 9 Yes /modules/stmultilink/StMultiLinkGroup.php:141
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2804 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 9
AND id_shop = 1 LIMIT 1
0.2 0 /classes/ObjectModel.php:1451
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('f5a69cdf1ecb251632953d292d48343d',"stiosslider|1|1|9|1|1|6_17_location","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_camera_slideshow_group` smsg
INNER JOIN ps_st_camera_slideshow_group_shop st_camera_slideshow_group_shop
ON (st_camera_slideshow_group_shop.id_st_camera_slideshow_group = smsg.id_st_camera_slideshow_group AND st_camera_slideshow_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (17)
ORDER BY smsg.`position`
0.2 2 Yes /modules/stcameraslideshow/StCameraSlideshowGroup.php:233
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.2 1 /classes/shop/Shop.php:203
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 919 AND RTG_LANG_ID = 1
0.2 2 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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` = 2801)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1851) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (21)
ORDER BY smsg.`position`
0.2 2 Yes /modules/stbanner/StBannerGroup.php:175
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 = 2809
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1851
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='acaaf9108aa596e4a978f143c1f4f87a' AND cache_id="stbanner|1|1|9|1|1|6_6_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
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` = 136 LIMIT 1
0.2 1 /classes/Category.php:1054
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` = 2769)
0.2 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"445|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 445)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5fa960c59cdcfb6987f2004867774675' AND cache_id="2804|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_camera_slideshow_group` smsg
INNER JOIN ps_st_camera_slideshow_group_shop st_camera_slideshow_group_shop
ON (st_camera_slideshow_group_shop.id_st_camera_slideshow_group = smsg.id_st_camera_slideshow_group AND st_camera_slideshow_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (19,20)
ORDER BY smsg.`position`
0.2 2 Yes /modules/stcameraslideshow/StCameraSlideshowGroup.php:233
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2796 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2789 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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` = 2773)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url`
FROM `ps_st_multi_link_group` smlg
INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop
ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1)
LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`)
WHERE smlg.`active`=1  AND smlg.`location` IN (6,10,11,12,13,26) AND smlgl.`id_lang` = 1
ORDER BY smlg.`position`
0.2 9 Yes /modules/stmultilink/StMultiLinkGroup.php:141
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 2805
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.2 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url`
FROM `ps_st_multi_link_group` smlg
INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop
ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1)
LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`)
WHERE smlg.`active`=1  AND smlg.`location` IN (23) AND smlgl.`id_lang` = 1
ORDER BY smlg.`position`
0.2 9 Yes /modules/stmultilink/StMultiLinkGroup.php:141
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5fa960c59cdcfb6987f2004867774675' AND cache_id="2267|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2808)
0.2 3 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 175
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.2 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
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` = 2782)
0.2 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('f5a69cdf1ecb251632953d292d48343d',"stiosslider|1|1|9|1|1|6_4_location","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1278) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2806 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2801 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1281) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
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` = 164 LIMIT 1
0.2 1 /classes/Category.php:1054
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` = 2775)
0.2 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2804|1|1|9|1|1|6","", FROM_UNIXTIME(1547730015))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2809 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (10)
ORDER BY smsg.`position`
0.2 2 Yes /modules/stbanner/StBannerGroup.php:175
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2788 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_iosslider_group` smsg
INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (22,23)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 1851
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.2 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
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 = 2810
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='2118aa071ee911dfa97443d31288d51b' AND cache_id="stsocial|1|1|9|1|1|6_stsocial" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (18)
ORDER BY smsg.`position`
0.2 2 Yes /modules/stbanner/StBannerGroup.php:175
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1278
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:198
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` = 2806)
0.2 3 /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` = 2799)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.2 1 /classes/SmartyCustom.php:95
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('df879f1d3abf02fc2677e50fd8489d0d',"stcameraslideshow|1|1|9|1|1|6_18_location","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 4) LIMIT 1
0.2 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` = 127 LIMIT 1
0.2 1 /classes/Category.php:1054
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` = 2777)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2795)
0.2 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2777|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='bce12d3df0078914e248a2b367bce2cd' AND cache_id="stmultilink|1|1|9|1|1|6_23_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
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` = 60 LIMIT 1
0.2 1 /classes/Category.php:1054
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` = 2804)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2796)
0.2 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2803|1|1|9|1|1|6","", FROM_UNIXTIME(1547730015))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5fa960c59cdcfb6987f2004867774675' AND cache_id="1278|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2789)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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_attribute` = 2217 LIMIT 1
0.2 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.2 1 /classes/Image.php:470
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 1281 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2267 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5032
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2799|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2809)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 559) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
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` = 2794)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5fa960c59cdcfb6987f2004867774675' AND cache_id="269|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1691728', '1065', '921324432', '', '1', '1', '2019-01-17 14:00:16')
0.2 1 /classes/ObjectModel.php:487
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` = 2776)
0.2 1 /classes/Product.php:2998
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` = 34 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5fa960c59cdcfb6987f2004867774675' AND cache_id="2769|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='f80dcbd44a085aae73669df8fec0bf89' AND cache_id="stsocial|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2770|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 1 AND ctg.`id_group` = 1 LIMIT 1
0.2 1 /classes/Category.php:1309
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` = 2778)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 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 = 2812
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_iosslider_group` smsg
INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (21)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2811 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='b1c36410862ea3c59b72cf75e5f32987' AND cache_id="sthomenew|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en' LIMIT 1
0.2 1 /classes/Language.php:680
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='cae881936473e7451be341cc49c4c600' AND cache_id="stmegamenu|1|1|9|1|1|6__location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2804|1|1|9|1|1|6","", FROM_UNIXTIME(1547730015))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_iosslider_group` smsg
INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (20)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
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` = 167 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2775 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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 = 2800 LIMIT 1
0.2 1 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2788) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='f5a69cdf1ecb251632953d292d48343d' AND cache_id="stiosslider|1|1|9|1|1|6_17_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 175 AND RTG_LANG_ID = 1
0.2 3 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2793 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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` = 6) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5fa960c59cdcfb6987f2004867774675' AND cache_id="2803|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2770|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1451
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` = 2793)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2806 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2782 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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_attribute` = 2235 LIMIT 1
0.2 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM ps_productlabel pl
JOIN ps_productlabel_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_product` = 2808
AND pll.id_lang = 1
AND pl.`data_end` >= '2019-01-17 14:00:00'
AND pl.`data_start` <= '2019-01-17 14:00:00'
AND pl.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
0.2 7 Yes /modules/productlabel/classes/ClassProductLabel.php:170
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 559) AND (id_product_attribute = 686) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2270) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2267 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 109
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 0 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"919|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2807 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2810 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 334
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='acaaf9108aa596e4a978f143c1f4f87a' AND cache_id="stbanner|1|1|9|1|1|6_3_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2769 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 109) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='37ccaa98ec120784820b48e26eef1ced' AND cache_id="blockcategories|1|1|9|1|1|6|1|9" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2218
UPDATE `ps_smarty_lazy_cache`
SET filepath='stcameraslideshow/1/1/9/1/1/6_3_location/c2/11/80/c21180b29de13d61f3c4484bff745b3cf0896da6.stcameraslideshow.tpl.php'
WHERE `template_hash`='df879f1d3abf02fc2677e50fd8489d0d' AND cache_id="stcameraslideshow|1|1|9|1|1|6_3_location" AND compile_id=""
0.2 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2792|1|1|9|1|1|6","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2771 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 0
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 559 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
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 = 2788 LIMIT 1
0.2 2 /classes/Product.php:752
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('f5a69cdf1ecb251632953d292d48343d',"stiosslider|1|1|9|1|1|6_4_location","", FROM_UNIXTIME(1547730016))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='acaaf9108aa596e4a978f143c1f4f87a' AND cache_id="stbanner|1|1|9|1|1|6_1_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2776 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ab5e96d60a0a9bc3eb5587893eaebbb4' AND cache_id="stcameraslideshow|1|1|9|1|1|6_2_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2792 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 293 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 445
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE count(*) as count FROM ps_gsr_rating WHERE RTG_SHOP_ID = 1 AND RTG_STATUS = "1" AND RTG_PROD_ID = 2808 AND RTG_LANG_ID = 1
0.2 1 /modules/gsnippetsreviews/lib/reviews/rating-dao_class.php:367
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5fa960c59cdcfb6987f2004867774675',"2803|1|1|9|1|1|6","", FROM_UNIXTIME(1547730015))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='52c3c2e0dee84cb96e99d8d387bef07d' AND cache_id="blockcms|0|1|1|9|1|1|6" AND compile_id="" LIMIT 1
0.2 1