Mens Leather Waistcoats / Vests There are 17 products.

Showing 1 - 12 of 17 items
Load Time8073 ms - You'd better run your shop on a toaster
Querying Time2167 ms
Queries570
Memory Peak Usage60.8 Mb
Included Files381 files - 5.99 Mb
PrestaShop Cache- Mb
Global vars1.03 Mb
PrestaShop Version1.6.1.0
PHP Version5.6.40 (OK)
MySQL Version5.6.51-cll-lve (OK)
Memory Limit128M
Max Execution Time7200s
Smarty Cachedisabled
Smarty Compilationforce compile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 193 ms 193 ms 15.03 Mb 15.11 Mb
__construct 0 ms 193 ms - Mb 15.11 Mb
init 65 ms 258 ms 5.37 Mb 20.51 Mb
checkAccess 0 ms 258 ms - Mb 20.51 Mb
setMedia 5 ms 263 ms 0.34 Mb 20.84 Mb
postProcess 0 ms 263 ms - Mb 20.84 Mb
initHeader 0 ms 263 ms 0.01 Mb 20.84 Mb
initContent 2757 ms 3020 ms 27.39 Mb 48.38 Mb
initFooter 134 ms 3155 ms 0.87 Mb 49.29 Mb
display 4919 ms 8073 ms 11.04 Mb 60.80 Mb
Hook Time Memory Usage
hookproductlistassign 1721 ms 3.50 Mb
hookdisplayProductListReviews 987 ms 0.25 Mb
hookdisplayProductListFunctionalButtons 575 ms 2.25 Mb
hookmegamenu 441 ms 5.50 Mb
hooktop 259 ms 1.25 Mb
hookleftcolumn 258 ms 0.75 Mb
__construct 238 ms 21.50 Mb
hookblockFooter1 187 ms 0.25 Mb
hookdisplayNav 151 ms - Mb
hookheader 100 ms 2.50 Mb
hookfooter 67 ms - Mb
hookdisplayFooter 32 ms 0.25 Mb
hookblockFooter3 11 ms 0.25 Mb
hookbrandSlider 5 ms - Mb
hookdisplayHeader 2 ms - Mb
hookdisplayTop 2 ms - Mb
hookposscroll 1 ms - Mb
hookblockFooter2 1 ms - Mb
hookblockPosition8 1 ms - Mb
hookmoduleRoutes - ms - Mb
20 hooks 5038 ms 38.25 Mb
Module Time Memory Usage
blocklayered 1970 ms 5.50 Mb
productcomments 990 ms 0.50 Mb
blockwishlist 585 ms 2.75 Mb
posmegamenu 445 ms 6.00 Mb
blockcart 245 ms 1.50 Mb
posstaticfooter 204 ms 0.50 Mb
paypal 58 ms 4.25 Mb
posstaticblocks 57 ms 0.25 Mb
blocklanguages 56 ms - Mb
ebay 51 ms 4.25 Mb
blockcurrencies 51 ms - Mb
blockuserinfo 46 ms - Mb
posscroll 43 ms - Mb
mailjet 37 ms 3.75 Mb
trustedshopsintegration 29 ms 0.75 Mb
blocktags 23 ms - Mb
statsdata 22 ms 0.50 Mb
smartblog 22 ms 2.25 Mb
blocknewsletter 17 ms 1.75 Mb
blockcategories 16 ms 0.25 Mb
contentbox 10 ms - Mb
blocksearch 8 ms - Mb
stripe_official 8 ms 0.50 Mb
blockcms 5 ms 0.50 Mb
ganalytics 4 ms 0.25 Mb
sekeywords 3 ms 0.25 Mb
poslogo 3 ms - Mb
pagesnotfound 2 ms 0.25 Mb
posspecialsproducts 2 ms - Mb
productscategory 2 ms 0.25 Mb
carriercompare 2 ms 0.25 Mb
posslideshow 2 ms - Mb
socialsharing 1 ms 0.25 Mb
blocknewproducts 1 ms - Mb
blockbestsellers 1 ms - Mb
homefeatured 1 ms - Mb
blockviewed 1 ms 0.25 Mb
blockmanufacturer 1 ms - Mb
blockspecials 1 ms - Mb
blocksocial 1 ms - Mb
blockcontact 1 ms 0.25 Mb
blockfacebook 1 ms 0.25 Mb
blockstore 1 ms - Mb
productpaymentlogos 1 ms - Mb
blocksupplier 1 ms - Mb
blockmyaccountfooter 1 ms - Mb
blockpaymentlogo 1 ms - Mb
blockmyaccount 1 ms 0.25 Mb
sendtoafriend 1 ms - Mb
posimgproduct 1 ms - Mb
50 modules 5038 ms 38.25 Mb

Stopwatch SQL - 570 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.*,
product_shop.*,
product_shop.id_category_default,
pl.*,
image_shop.`id_image` id_image,
il.legend,
m.name manufacturer_name,
product_attribute_shop.id_product_attribute id_product_attribute,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2021-11-29 00:00:00", INTERVAL 21 DAY)) > 0 AS new,
stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM ps_cat_filter_restriction cp
LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1  AND pl.id_lang = 1)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
ORDER BY cp.position asc , cp.id_product LIMIT 0,12
1301 422926 Yes /modules/blocklayered/blocklayered.php:2054
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (542,544,545,543,563,564,565,609,610,566,567,568) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
49.4 96 Yes Yes /classes/Product.php:3274
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `hook_position` = "footer" 
AND `showhook` = 1 ORDER BY `posorder` ASC
46.5 8 Yes /modules/posstaticblocks/models/Staticblock.php:53
SELECT SQL_NO_CACHE s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC
45.2 1 Yes Yes /classes/Supplier.php:124
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 564
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
24.9 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_log`
WHERE
`message` = 'The function addCSS (Line 37) is deprecated and will be removed in the next major version.'
AND `severity` = '3'
AND `error_code` = '0'
AND `object_type` = ''
AND `object_id` = '' LIMIT 1
20.9 31656 /classes/PrestaShopLogger.php:175
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
20.4 452 /classes/Hook.php:234
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_log`
WHERE
`message` = 'The function addJS (Line 38) is deprecated and will be removed in the next major version.'
AND `severity` = '3'
AND `error_code` = '0'
AND `object_type` = ''
AND `object_id` = '' LIMIT 1
18.4 31656 /classes/PrestaShopLogger.php:175
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` = 6) AND (b.`id_shop` = 1) LIMIT 1
15.9 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 610)
AND `id_product_attribute` IN (0, 5654)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
15.4 4 Yes /classes/SpecificPrice.php:236
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
12.7 452 Yes Yes /classes/Hook.php:353
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` = 542)
10.2 9 /classes/Product.php:2829
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 567
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
9.9 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 545) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
9.8 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 568 AND id_shop=1 LIMIT 1
9.7 1 /classes/Product.php:4759
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 542
ORDER BY `id_specific_price_priority` DESC LIMIT 1
9.3 1 /classes/SpecificPrice.php:189
SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 4
AND c.id_category IN (SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (1))
ORDER BY `level_depth` ASC, cs.`position` ASC
7.8 63 Yes /modules/posmegamenu/posmegamenu.php:994
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
7.6 243 Yes /classes/Country.php:130
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 5
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
7.5 1 Yes /classes/tax/TaxRulesTaxManager.php:105
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 567) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.1 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 543 AND id_shop=1 LIMIT 1
6.7 1 /classes/Product.php:4759
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`)
5.8 1443 /classes/Configuration.php:145
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 563 AND id_shop=1 LIMIT 1
5.7 1 /classes/Product.php:4759
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 542)
AND `id_product_attribute` IN (0, 4920)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
5.4 4 Yes /classes/SpecificPrice.php:236
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 543)
AND `id_product_attribute` IN (0, 4929)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
5.2 4 Yes /classes/SpecificPrice.php:236
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` = 11) AND (b.`id_shop` = 1) LIMIT 1
5.2 1 /Adapter/Adapter_EntityMapper.php:62
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 = 565
ORDER BY f.position ASC
4.9 1 Yes /classes/Product.php:4225
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 609 AND `id_group` = 1 LIMIT 1
4.6 0 /classes/GroupReduction.php:144
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 566)
AND `id_product_attribute` IN (0, 5165)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
4.6 4 Yes /classes/SpecificPrice.php:236
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 = 542
ORDER BY f.position ASC
4.5 1 Yes /classes/Product.php:4225
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 565
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.4 1 /classes/SpecificPrice.php:189
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` = 564) AND (b.`id_shop` = 1) LIMIT 1
4.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 610
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.4 1 /classes/SpecificPrice.php:189
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 = 'brandslock.com' OR su.domain_ssl = 'brandslock.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
4.3 4 Yes /classes/shop/Shop.php:333
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` = 4920 LIMIT 1
4.1 1 /classes/Combination.php:331
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` = 5645 LIMIT 1
4.1 1 /classes/Combination.php:331
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` = 543)
4 9 /classes/Product.php:2829
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 = 563
ORDER BY f.position ASC
4 1 Yes /classes/Product.php:4225
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` = 609)
3.9 9 /classes/Product.php:2829
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 564 AND `id_group` = 1 LIMIT 1
3.8 0 /classes/GroupReduction.php:144
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 609) AND (id_product_attribute = 5645) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.8 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 75) LIMIT 1
3.7 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 564
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3.7 1 /classes/SpecificPrice.php:189
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 565) AND (id_product_attribute = 5156) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.6 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 543) AND (id_product_attribute = 4929) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.5 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 610) AND (id_product_attribute = 5654) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.4 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 545
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
3.2 2 /modules/productcomments/ProductComment.php:197
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` = 563) AND (b.`id_shop` = 1) LIMIT 1
3.1 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 20
AND c.nright >= 21
AND c.nleft >= 6
AND c.nright <= 119
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
3.1 6 Yes /classes/Tools.php:1250
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
3 1 /classes/Category.php:1199
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` = 5120 LIMIT 1
3 1 /classes/Combination.php:331
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 568)
AND `id_product_attribute` IN (0, 5183)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
2.8 4 Yes /classes/SpecificPrice.php:236
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` = 564)
2.8 9 /classes/Product.php:2829
SELECT SQL_NO_CACHE * FROM `ps_image_type`
2.8 9 /classes/ImageType.php:142
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 563)
AND `id_product_attribute` IN (0, 5120)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
2.6 4 Yes /classes/SpecificPrice.php:236
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
2.5 48 /classes/Category.php:1625
CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY
SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 20
AND c.nright <= 21
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
2.5 1 /modules/blocklayered/blocklayered.php:2142
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
2.5 0 /classes/Hook.php:131
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` = 543) AND (b.`id_shop` = 1) LIMIT 1
2.5 1 /Adapter/Adapter_EntityMapper.php:62
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` = 61 LIMIT 1
2.3 1 /classes/Category.php:1041
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 545) AND (id_product_attribute = 4947) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.3 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2.3 0 /classes/tax/TaxRulesTaxManager.php:105
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 = 610
ORDER BY f.position ASC
2.2 1 Yes /classes/Product.php:4225
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 545
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
2.2 2 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
2.2 1 /classes/Category.php:1199
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` = 567) AND (b.`id_shop` = 1) LIMIT 1
2.2 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE * FROM ps_contentbox WHERE `id_lang` = "1" and `id_store`="1" LIMIT 1
2.2 1 /modules/contentbox/contentbox.php:724
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 567)
AND `id_product_attribute` IN (0, 5174)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
2.1 4 Yes /classes/SpecificPrice.php:236
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` = 544)
2.1 9 /classes/Product.php:2829
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 543
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2.1 1 /classes/SpecificPrice.php:189
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 7
AND nleft >= 20 AND nright <= 21
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
2.1 11 Yes /modules/blockcategories/blockcategories.php:231
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` = 568)
2.1 9 /classes/Product.php:2829
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 565)
AND `id_product_attribute` IN (0, 5156)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
2.1 4 Yes /classes/SpecificPrice.php:236
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 = 564
ORDER BY f.position ASC
2 1 Yes /classes/Product.php:4225
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 545
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2 1 /classes/SpecificPrice.php:189
SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 1
INNER JOIN ps_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 1
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 1)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 1) 
WHERE lpa.id_attribute_group = 2 AND lpa.`id_shop` = 1 AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = 61) 
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
2 532 Yes /modules/blocklayered/blocklayered.php:2382
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 61 LIMIT 1
2 1 /classes/Category.php:1438
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 6 AND `id_object` = 61 LIMIT 1
1.9 1 /classes/Page.php:78
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 6
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.9 14 Yes Yes /classes/Category.php:863
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` = 40) AND (b.`id_shop` = 1) LIMIT 1
1.9 1 /Adapter/Adapter_EntityMapper.php:62
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` = 542) AND (b.`id_shop` = 1) LIMIT 1
1.9 1 /Adapter/Adapter_EntityMapper.php:62
CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
SELECT cp.id_product, MIN(cp.position) position FROM ps_category_product cp
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE cp.`id_category` IN (61)  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT id_product FROM ps_category_product cp WHERE cp.`id_category` = 61)
GROUP BY cp.id_product ORDER BY position, id_product
1.9 1 /modules/blocklayered/blocklayered.php:1958
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
1.8 16 Yes /classes/shop/Shop.php:654
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 609 AND id_shop=1 LIMIT 1
1.8 1 /classes/Product.php:4759
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` = 568) AND (b.`id_shop` = 1) LIMIT 1
1.7 1 /Adapter/Adapter_EntityMapper.php:62
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` = 62) AND (b.`id_shop` = 1) LIMIT 1
1.7 1 /Adapter/Adapter_EntityMapper.php:62
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
1.7 107 /classes/module/Module.php:270
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 544 AND id_shop=1 LIMIT 1
1.6 1 /classes/Product.php:4759
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 544) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.6 1 /classes/stock/StockAvailable.php:379
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` = 57) AND (b.`id_shop` = 1) LIMIT 1
1.6 1 /Adapter/Adapter_EntityMapper.php:62
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
1.6 1 /classes/Language.php:841
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` = 44) AND (b.`id_shop` = 1) LIMIT 1
1.6 1 /Adapter/Adapter_EntityMapper.php:62
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` = 21) AND (b.`id_shop` = 1) LIMIT 1
1.6 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_6_right"
1.6 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 545
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1.5 2 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 53 AND `id_shop` = 1
1.5 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 1
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
1.4 1 /modules/blockcms/BlockCMSModel.php:333
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` = 46) AND (b.`id_shop` = 1) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_6_right"
1.4 8 /modules/posmegamenu/posmegamenu.php:555
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 = 566
ORDER BY f.position ASC
1.4 1 Yes /classes/Product.php:4225
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
1.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 568) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.4 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 1263811
AND `date_add` > '2021-11-29 01:55:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
1.4 1 Yes /classes/Connection.php:135
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 564 AND id_shop=1 LIMIT 1
1.4 1 /classes/Product.php:4759
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` = 68) AND (b.`id_shop` = 1) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:62
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` = 565) AND (b.`id_shop` = 1) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 566
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1.3 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE t.name, counter AS times
FROM `ps_tag_count` pt
LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag)
WHERE pt.`id_group` = 1
AND pt.`id_lang` = 1 AND pt.`id_shop` = 1
ORDER BY times DESC
LIMIT 10
1.3 135 /classes/Tag.php:181
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.3 312 Yes /classes/Country.php:136
SELECT SQL_NO_CACHE l.`id_lang`, c.`link_rewrite`
FROM `ps_category_lang` AS c
LEFT JOIN  `ps_lang` AS l ON c.`id_lang` = l.`id_lang`
WHERE c.`id_category` = 61
AND l.`active` = 1
1.3 33 /classes/Category.php:1420
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `hook_position` = "brandSlider" 
AND `showhook` = 1 ORDER BY `posorder` ASC
1.3 8 Yes /modules/posstaticblocks/models/Staticblock.php:53
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` = 4947 LIMIT 1
1.3 1 /classes/Combination.php:331
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 542 AND `validate` = 1 LIMIT 1
1.3 1 /modules/productcomments/ProductComment.php:240
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
1.3 49 Yes /classes/Dispatcher.php:454
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` = 545) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
1.2 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 545)
AND `id_product_attribute` IN (0, 4947)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
1.2 4 Yes /classes/SpecificPrice.php:236
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
1.2 1 /classes/Category.php:1199
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` = 544) AND (b.`id_shop` = 1) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `hook_position` = "displayNav" 
AND `showhook` = 1 ORDER BY `posorder` ASC
1.2 8 Yes /modules/posstaticblocks/models/Staticblock.php:53
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 544) AND (id_product_attribute = 4938) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.1 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 542
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
1.1 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
1.1 1 /classes/Group.php:132
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_57_right"
1.1 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
where id_shop =1 
AND id_lang =1
AND `identify` like "pt_item_menu%"
1.1 8 /modules/posmegamenu/posmegamenu.php:569
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 545
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1.1 2 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 564)
AND `id_product_attribute` IN (0, 5147)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
1.1 4 Yes /classes/SpecificPrice.php:236
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 563) AND (id_product_attribute = 5120) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.1 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 567 AND id_shop=1 LIMIT 1
1.1 1 /classes/Product.php:4759
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 565 AND id_shop=1 LIMIT 1
1.1 1 /classes/Product.php:4759
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
1.1 1 /classes/ObjectModel.php:469
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` = 609) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 543
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =1
AND `hook_position` = "footer" 
AND `showhook` = 1
1.1 11 /modules/posstaticfooter/models/Staticfooter.php:53
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 = 545
ORDER BY f.position ASC
1.1 1 Yes /classes/Product.php:4225
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` = 563)
1.1 9 /classes/Product.php:2829
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 3
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
1.1 1 /modules/blockcms/BlockCMSModel.php:333
SELECT SQL_NO_CACHE s.*
FROM `ps_scene_category` sc
LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene)
INNER JOIN ps_scene_shop scene_shop
ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1)
LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene)
WHERE sc.id_category = 61
AND sl.id_lang = 1 AND s.active = 1
ORDER BY sl.name ASC
1 1 Yes /classes/Scene.php:218
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 609)
AND `id_product_attribute` IN (0, 5645)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
1 4 Yes /classes/SpecificPrice.php:236
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 = 609
ORDER BY f.position ASC
1 1 Yes /classes/Product.php:4225
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 24 AND `id_shop` = 1
1 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 564
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 544)
AND `id_product_attribute` IN (0, 4938)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2021-11-29 02:25:00' <= `to`)
)
AND id_cart IN (0, 0)
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
1 4 Yes /classes/SpecificPrice.php:236
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 = 544
ORDER BY f.position ASC
1 1 Yes /classes/Product.php:4225
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 544
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1 1 /modules/productcomments/ProductComment.php:197
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` = 610)
1 9 /classes/Product.php:2829
SELECT SQL_NO_CACHE * FROM `ps_pos_logo` ps LEFT JOIN `ps_pos_logo_shop`  s ON ps.id_pos_logo = s.id_pos_logo where s.`id_shop` =1  ORDER BY `porder` ASC
1 8 Yes /modules/poslogo/poslogo.php:193
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 7
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1 13 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 544
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1 1 /classes/SpecificPrice.php:189
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
1 1 /classes/shop/ShopUrl.php:163
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
1 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
1 1 /classes/Category.php:1199
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 = 543
ORDER BY f.position ASC
1 1 Yes /classes/Product.php:4225
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 542
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 563
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
1 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 61
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1 1 Yes Yes /classes/Category.php:632
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 11 AND `id_shop` = 1
1 2 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 565
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 609
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 567
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 609
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 542 AND `id_group` = 1 LIMIT 1
0.9 0 /classes/GroupReduction.php:144
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` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 610
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.9 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'category_default' LIMIT 1
0.9 1 /classes/Image.php:441
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =1
AND `hook_position` = "blockFooter1" 
AND `showhook` = 1
0.9 11 /modules/posstaticfooter/models/Staticfooter.php:53
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 543
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.9 1 /modules/productcomments/ProductComment.php:197
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` = 610) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:62
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 = 567
ORDER BY f.position ASC
0.9 1 Yes /classes/Product.php:4225
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 10) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'category' LIMIT 1
0.9 1 /classes/Page.php:97
ALTER TABLE ps_cat_restriction ADD PRIMARY KEY (id_product),
ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE,
ADD KEY `condition` (`condition`,`id_product`) USING BTREE,
ADD KEY `weight` (`weight`,`id_product`) USING BTREE
0.9 1 /modules/blocklayered/blocklayered.php:2148
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 15
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.9 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 5
0.9 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 566
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.9 1 /modules/productcomments/ProductComment.php:197
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` = 566)
0.9 9 /classes/Product.php:2829
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
0.9 1 /classes/ObjectModel.php:1311
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 544
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.9 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.9 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_58_right"
0.9 8 /modules/posmegamenu/posmegamenu.php:555
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` = 71) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 10
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.9 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.9 1 /classes/Category.php:1199
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` = 61) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:62
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1263811', '1014', '56368180', '', '1', '1', '2021-11-29 02:25:02')
0.9 1 /classes/ObjectModel.php:469
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` = 17) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ebay" LIMIT 1
0.9 1 /classes/module/Module.php:2496
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.9 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.9 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.9 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.9 3 /classes/Language.php:736
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 564
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.9 1 /modules/productcomments/ProductComment.php:197
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` = 545)
0.9 9 /classes/Product.php:2829
SELECT SQL_NO_CACHE * FROM ps_trustedshopsintegration WHERE id_shop = '1' AND id_lang = '1' LIMIT 1
0.9 2 /modules/trustedshopsintegration/trustedshopsintegration.php:637
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 76) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 542) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.9 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 610
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.9 1 /modules/productcomments/ProductComment.php:197
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` = 567)
0.8 9 /classes/Product.php:2829
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 = 568
ORDER BY f.position ASC
0.8 1 Yes /classes/Product.php:4225
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` = 565)
0.8 9 /classes/Product.php:2829
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 8
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.8 8 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 565
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.8 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 568
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.8 1 /modules/productcomments/ProductComment.php:197
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` = 566) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_6"
0.8 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 566
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.8 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 563
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.8 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 61) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 545 AND `validate` = 1 LIMIT 1
0.8 2 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.8 383 /classes/module/Module.php:2086
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_58_right"
0.8 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 563) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.8 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 568 AND `id_group` = 1 LIMIT 1
0.8 0 /classes/GroupReduction.php:144
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 5) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:62
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` = 5174 LIMIT 1
0.8 1 /classes/Combination.php:331
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` = 60) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 61
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.8 18 Yes Yes /modules/blocklayered/blocklayered.php:2128
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` = 5147 LIMIT 1
0.7 1 /classes/Combination.php:331
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 566
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.7 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 11
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.7 1 Yes Yes /classes/Category.php:863
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` = 4938 LIMIT 1
0.7 1 /classes/Combination.php:331
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 542 AND id_shop=1 LIMIT 1
0.7 1 /classes/Product.php:4759
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `hook_position` = "top" 
AND `showhook` = 1 ORDER BY `posorder` ASC
0.7 8 Yes /modules/posstaticblocks/models/Staticblock.php:53
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 10 AND `id_shop` = 1
0.7 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 567
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.7 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.7 1 /classes/Category.php:1199
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` = 4929 LIMIT 1
0.7 1 /classes/Combination.php:331
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 568
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.7 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:62
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` = 10) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:62
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` = 5183 LIMIT 1
0.7 1 /classes/Combination.php:331
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 60) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.7 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 57
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.7 2 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max 
FROM ps_cat_restriction p
INNER JOIN `ps_layered_price_index` psi
ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1)
WHERE 1
0.7 17 /modules/blocklayered/blocklayered.php:2382
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` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 71) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 564 AND `validate` = 1 LIMIT 1
0.7 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 74
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.7 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # 
FROM ps_category_product cp
LEFT JOIN ps_product p ON (p.id_product = cp.id_product)  INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE cp.id_category = c.id_category
AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog")
) count_products
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = 1 and cl.id_lang = 1) RIGHT JOIN ps_category_group cg ON (cg.id_category = c.id_category AND cg.`id_group` IN (1)) WHERE c.nleft > 20
AND c.nright < 21
AND c.level_depth <= 4
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position
0.7 64 Yes /modules/blocklayered/blocklayered.php:2382
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 25
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.7 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 62
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.7 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 29
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.7 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = ""
0.7 8 /modules/posmegamenu/posmegamenu.php:555
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` = 24) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.7 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.7 1 /classes/shop/Shop.php:1033
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.7 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.6 10 /classes/Currency.php:455
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 63
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =1
AND `hook_position` = "footer" 
AND `showhook` = 1
0.6 11 /modules/posstaticfooter/models/Staticfooter.php:53
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 542
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.6 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
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.6 1 /classes/shop/Shop.php:202
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` = 77) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:62
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` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_6"
0.6 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.6 1 /classes/Image.php:441
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 76 AND `id_shop` = 1
0.6 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_7"
0.6 8 /modules/posmegamenu/posmegamenu.php:555
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` = 15) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 16
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.6 86 /classes/Hook.php:188
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_7"
0.6 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 564) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 609) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:379
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` = 5156 LIMIT 1
0.6 1 /classes/Combination.php:331
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 19
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 544 AND `id_group` = 1 LIMIT 1
0.6 0 /classes/GroupReduction.php:144
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 =7 AND m.page = "category" LIMIT 1
0.6 1 /classes/Theme.php:274
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 564
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.6 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 609
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.6 1 /modules/productcomments/ProductComment.php:184
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` = 29) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 61
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE public_name
FROM `ps_attribute_group_lang` agl
LEFT JOIN `ps_layered_indexable_attribute_group` liag
ON liag.id_attribute_group = agl.id_attribute_group
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 1
0.6 12 /modules/blocklayered/blocklayered.php:2721
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 64 AND `id_shop` = 1
0.6 2 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
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` = 50) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 565
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.6 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 77
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:863
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` = 5165 LIMIT 1
0.6 1 /classes/Combination.php:331
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_58"
0.6 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 60 AND `id_shop` = 1
0.6 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 71
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:863
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` = 76) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 58
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 2 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =1
AND `hook_position` = "blockFooter2" 
AND `showhook` = 1
0.6 11 /modules/posstaticfooter/models/Staticfooter.php:53
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 71 AND `id_shop` = 1
0.6 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 563
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.6 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 76
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 60
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 563
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.6 1 /classes/SpecificPrice.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 568
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.6 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 544
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.6 1 /modules/productcomments/ProductComment.php:184
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` = 5654 LIMIT 1
0.6 1 /classes/Combination.php:331
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 610
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.6 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 567 AND `validate` = 1 LIMIT 1
0.6 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.6 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 24
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 543) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
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` = 53) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_7_right"
0.5 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE name
FROM `ps_feature_lang` fl
LEFT JOIN  `ps_layered_indexable_feature` lif
ON lif.id_feature = fl.id_feature
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 1
0.5 108 /modules/blocklayered/blocklayered.php:2731
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 542) AND (id_product_attribute = 4920) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:379
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` = 51) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 61) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 22 AND `id_shop` = 1
0.5 2 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_8_right"
0.5 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 544
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 543
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
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` = 3) LIMIT 1
0.5 0 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
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` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:62
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` = 19) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:62
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` = 16) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:62
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.5 3 Yes /classes/Currency.php:222
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 563 AND `id_group` = 1 LIMIT 1
0.5 0 /classes/GroupReduction.php:144
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '23c97ecf26d433b541cdf7ab56d5fd9c' LIMIT 1
0.5 1 /modules/blocklayered/blocklayered.php:1722
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `hook_position` = "blockPosition8" 
AND `showhook` = 1 ORDER BY `posorder` ASC
0.5 8 Yes /modules/posstaticblocks/models/Staticblock.php:53
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `hook_position` = "leftColumn" 
AND `showhook` = 1 ORDER BY `posorder` ASC
0.5 8 Yes /modules/posstaticblocks/models/Staticblock.php:53
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 609
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 542
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 609 AND `validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 567) AND (id_product_attribute = 5174) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 610) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 610
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 609
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 /classes/SpecificPrice.php:189
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 568
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 64
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.5 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 565
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 543
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE ec.`name`, ec.`value`
FROM `ps_ebay_configuration` ec
WHERE ec.`id_ebay_profile`= 1
0.5 28 /modules/ebay/classes/EbayProfile.php:156
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` = 74) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 543 AND `validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.5 1 /classes/ObjectModel.php:1388
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:62
ALTER TABLE ps_cat_filter_restriction ADD PRIMARY KEY (id_product), ADD KEY (position, id_product) USING BTREE
0.5 1 /modules/blocklayered/blocklayered.php:1960
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 4
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
0.5 1 /modules/blockcms/BlockCMSModel.php:333
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "paypal" LIMIT 1
0.5 1 /classes/module/Module.php:2496
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_57_right"
0.5 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_57"
0.5 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 545 AND `id_group` = 1 LIMIT 1
0.5 0 /classes/GroupReduction.php:144
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 563
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 563 AND `validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 566 AND id_shop=1 LIMIT 1
0.5 1 /classes/Product.php:4759
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 565) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_57"
0.5 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 75
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.5 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 568
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 /classes/SpecificPrice.php:189
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 545 AND id_shop=1 LIMIT 1
0.5 1 /classes/Product.php:4759
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.5 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_7_right"
0.5 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 566) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_8"
0.5 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 567 AND `id_group` = 1 LIMIT 1
0.5 0 /classes/GroupReduction.php:144
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 567
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.5 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 564) AND (id_product_attribute = 5147) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 25 AND `id_shop` = 1
0.5 2 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE COUNT(*)
FROM ps_layered_category
WHERE id_category = 61
AND id_shop = 1 LIMIT 1
0.5 18 /modules/blocklayered/blocklayered.php:637
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 77) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
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` = 8) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 16
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
0.4 1 /modules/blockcms/BlockCMSModel.php:333
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 568 AND `validate` = 1 LIMIT 1
0.4 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 568) AND (id_product_attribute = 5183) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.4 1 /classes/SmartyCustom.php:99
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 567
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:189
SELECT SQL_NO_CACHE * FROM `ps_contentbox_files` where `id_store`=1 and `id_lang`=1 LIMIT 1
0.4 1 /modules/contentbox/contentbox.php:744
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 75 AND `id_shop` = 1
0.4 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 543 AND `id_group` = 1 LIMIT 1
0.4 0 /classes/GroupReduction.php:144
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 544 AND `validate` = 1 LIMIT 1
0.4 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 22
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.4 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 565 AND `validate` = 1 LIMIT 1
0.4 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE entity.`id_currency`
FROM `ps_currency_shop`es
LEFT JOIN ps_currency entity
ON (entity.`id_currency` = es.`id_currency`)
WHERE es.`id_shop` = 1 AND entity.`active` = 1 AND entity.deleted = 0
0.4 3 /classes/shop/Shop.php:1195
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 566 AND `validate` = 1 LIMIT 1
0.4 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =1
AND `hook_position` = "blockFooter3" 
AND `showhook` = 1
0.4 11 /modules/posstaticfooter/models/Staticfooter.php:53
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 610 AND `validate` = 1 LIMIT 1
0.4 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 3
AND id_shop = 1 LIMIT 1
0.4 0 /classes/ObjectModel.php:1388
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 565 AND `id_group` = 1 LIMIT 1
0.4 0 /classes/GroupReduction.php:144
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 52
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.4 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 6
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
0.4 1 /modules/blockcms/BlockCMSModel.php:333
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.4 1 /classes/Image.php:441
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 61 AND `id_shop` = 1
0.4 2 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
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` = 75) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 15) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 610 AND id_shop=1 LIMIT 1
0.4 1 /classes/Product.php:4759
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 41) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.4 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 566
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:189
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 53
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.4 1 Yes Yes /classes/Category.php:863
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` = 64) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 62) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'm_scene_default' LIMIT 1
0.4 1 /classes/Image.php:441
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_ebay_profile` a
WHERE (a.`id_ebay_profile` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 61 AND ctg.`id_group` = 1 LIMIT 1
0.4 1 /classes/Category.php:1285
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 74 AND `id_shop` = 1
0.4 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 40
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.4 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 74) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 21
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.4 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 29 AND `id_shop` = 1
0.4 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 41
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.4 1 Yes Yes /classes/Category.php:863
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
0.4 1 /classes/Country.php:170
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` = 58) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 61 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 52) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_8"
0.4 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 610 AND `id_group` = 1 LIMIT 1
0.4 0 /classes/GroupReduction.php:144
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =1
AND `hook_position` = "footer" 
AND `showhook` = 1
0.4 11 /modules/posstaticfooter/models/Staticfooter.php:53
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
0.4 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 40) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 63 AND `id_shop` = 1
0.4 3 /Adapter/Adapter_EntityMapper.php:70
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` = 22) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 41 AND `id_shop` = 1
0.4 3 /Adapter/Adapter_EntityMapper.php:70
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` = 63) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
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:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =1
AND `hook_position` = "footer" 
AND `showhook` = 1
0.4 11 /modules/posstaticfooter/models/Staticfooter.php:53
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 13
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
0.4 1 /modules/blockcms/BlockCMSModel.php:333
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_58"
0.4 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 25) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
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` = 41) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 6 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 566) AND (id_product_attribute = 5165) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:379
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 61
AND id_shop = 1 LIMIT 1
0.4 1 /classes/ObjectModel.php:1388
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` = 25) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 29) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1
0.4 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 63) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:62
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1
0.4 4 /classes/shop/Shop.php:1034
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '23c97ecf26d433b541cdf7ab56d5fd9c' LIMIT 1
0.4 1 /modules/blocklayered/blocklayered.php:1722
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 2 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =1
AND `identify` = "pt_menu_idcat_8_right"
0.4 8 /modules/posmegamenu/posmegamenu.php:555
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 1 AND cs.`id_shop` = 1 LIMIT 1
0.4 1 /classes/Category.php:1199
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 21
0.4 3 /Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 21 AND `id_shop` = 1
0.4 3 /Adapter/Adapter_EntityMapper.php:70