Load Time2437 ms - You'd better run your shop on a toaster
Querying Time248 ms
Queries160
Memory Peak Usage21.6 Mb
Included Files386 files - 6.71 Mb
PrestaShop Cache0.01 Mb
Global vars1.04 Mb
PrestaShop Version1.6.1.4
PHP Version5.6.25 (OK)
MySQL Version5.5.52-0ubuntu0.14.04.1-log (Consider upgrading)
Memory Limit512M
Max Execution Time120s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 87 ms 87 ms 6.96 Mb 7.12 Mb
__construct 0 ms 87 ms - Mb 7.12 Mb
init 40 ms 128 ms 3.61 Mb 10.91 Mb
checkAccess 0 ms 128 ms - Mb 10.91 Mb
setMedia 4 ms 132 ms 0.07 Mb 10.91 Mb
postProcess 0 ms 132 ms - Mb 10.91 Mb
initHeader 0 ms 132 ms - Mb 10.91 Mb
initContent 1529 ms 1661 ms 9.44 Mb 20.34 Mb
initFooter 776 ms 2437 ms 0.78 Mb 21.61 Mb
Hook Time Memory Usage
hookfooter 287 ms - Mb
__construct 97 ms 9.25 Mb
hookHeader 37 ms 0.50 Mb
hookdisplayHeader 16 ms - Mb
hookdisplayRightColumnProduct 11 ms - Mb
hookproductfooter 11 ms - Mb
hookdisplayFooterProduct 9 ms 0.25 Mb
hookextraright 9 ms - Mb
hookactionProductOutOfStock 8 ms - Mb
hookdisplayTop 5 ms - Mb
hookdisplayFooter 4 ms - Mb
hookextraleft 4 ms 0.25 Mb
hookproducttabcontent 4 ms - Mb
hookproducttab 3 ms - Mb
hooktop 1 ms - Mb
hookproductactions 1 ms - Mb
hookdisplayBlockNewsletterBottom 0 ms - Mb
hookactionObjectAddAfter 0 ms - Mb
hookmoduleRoutes 0 ms - Mb
19 hooks 508 ms 10.25 Mb
Module Time Memory Usage
statsdata 271 ms 0.50 Mb
blocknewsletter 17 ms 1.25 Mb
productcomments 13 ms - Mb
loyalty 12 ms 0.25 Mb
socialsharing 10 ms - Mb
mailalerts 9 ms - Mb
paypal 8 ms 0.50 Mb
tmmediaparallax 7 ms 0.25 Mb
tmmegamenu 6 ms 0.50 Mb
lgcookieslaw 6 ms - Mb
ns8csp 6 ms - Mb
tmrelatedproducts 6 ms 0.50 Mb
blockwishlist 6 ms 0.25 Mb
cleverreach 6 ms - Mb
productscategory 5 ms - Mb
crossselling 5 ms - Mb
pronesissizechart 5 ms - Mb
blockcms 5 ms - Mb
leosliderlayer 4 ms 0.25 Mb
magiczoomplus 4 ms 0.50 Mb
sendtoafriend 4 ms 0.25 Mb
tmcategoryproducts 4 ms 0.25 Mb
themeconfigurator 4 ms - Mb
sendinblue 4 ms 0.25 Mb
blockcontactinfos 4 ms 0.25 Mb
smartblog 4 ms 0.75 Mb
blockviewed 3 ms - Mb
tmhtmlcontent 3 ms 0.25 Mb
blocksharefb 3 ms 0.50 Mb
blockmyaccountfooter 3 ms - Mb
blocksocial 3 ms - Mb
blockcart 3 ms - Mb
blocklink 3 ms 0.25 Mb
tmnewsletter 3 ms - Mb
tmmegalayout 3 ms 0.25 Mb
tmolarkchat 3 ms 0.50 Mb
tmsearch 2 ms - Mb
googleshopping 2 ms 0.25 Mb
sekeywords 2 ms 0.25 Mb
tmsocialfeeds 2 ms 0.25 Mb
htmlbox 2 ms 0.25 Mb
tmproductvideos 2 ms - Mb
tmsociallogin 2 ms 0.25 Mb
pagesnotfound 2 ms - Mb
paypalstandard 2 ms - Mb
homefeatured 1 ms - Mb
blockuserinfo 1 ms - Mb
homeslider 1 ms - Mb
blockcategories 1 ms - Mb
blockcontact 1 ms - Mb
blockpermanentlinks 1 ms - Mb
blockmanufacturer 1 ms - Mb
blockcurrencies 1 ms 0.25 Mb
blocktags 1 ms - Mb
smartblogtag 1 ms - Mb
blockstore 1 ms - Mb
productpaymentlogos 1 ms - Mb
smartbloghomelatestnews 1 ms - Mb
muinfinitescroll 1 ms - Mb
blocklanguages 1 ms - Mb
blockmyaccount 1 ms - Mb
blocklayered 1 ms 0.25 Mb
blockspecials 1 ms - Mb
blocksupplier 1 ms - Mb
metatagsgenerator 1 ms - Mb
blocknewproducts 1 ms 0.25 Mb
blockpaymentlogo 1 ms - Mb
blockfacebook 1 ms - Mb
blockbestsellers 1 ms - Mb
gadwordsfree 1 ms - Mb
fbtrackingpixel 1 ms - Mb
71 modules 508 ms 10.25 Mb

Stopwatch SQL - 160 queries

Query Time (ms) Rows Filesort Group By Location
INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('1271872', '1146', '2018-12-17 02:11:01')
58.3 1 /classes/classes/Connection.php:106
INSERT INTO `ps_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('2376', '1146', '1', '1', '1')
46.9 1 /classes/classes/Page.php:128
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1889609', '1146', '55620016', '', '1', '1', '2018-12-17 02:11:01')
38.1 1 /classes/classes/ObjectModel.php:487
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')
29.3 1 /classes/classes/ObjectModel.php:487
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.5 1534 /classes/classes/Configuration.php:148
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`
3.4 121 Yes Yes /override/classes/Hook.php:112
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
3 247 Yes /classes/classes/Country.php:131
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
2.9 567 /classes/classes/Hook.php:236
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`,
pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`,
pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default,
DATEDIFF(
p.`date_add`,
DATE_SUB(
NOW(),
INTERVAL 60 DAY
)
) > 0 AS new
FROM `ps_tmrelatedproducts` trp
LEFT JOIN `ps_product` p ON p.`id_product` = `id_slave`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`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 `id_master` = 1817 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
AND trp.`id_shop` = 1
GROUP BY product_shop.id_product
LIMIT 10
2 2 Yes /modules/tmrelatedproducts/tmrelatedproducts.php:262
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
2 609 /classes/classes/SpecificPrice.php:238
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1.9 0 /classes/classes/Hook.php:131
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2018-12-17 00:00:00",
INTERVAL 60 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
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 (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_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 (p.`id_manufacturer`= m.`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 `id_product_1` = 1817 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.8 2 Yes Yes /classes/classes/Product.php:3598
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
1.7 609 /classes/classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
1.6 1083 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE `id_date_range`, `time_end`
FROM `ps_date_range`
WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`) LIMIT 1
1.4 6754801 /classes/classes/DateRange.php:49
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.2 165 Yes /classes/classes/Dispatcher.php:452
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1817
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.9 1 Yes Yes /classes/classes/Product.php:3513
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
0.9 312 Yes /classes/classes/Country.php:137
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` = 461
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.9 1 Yes Yes /classes/classes/Category.php:658
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.8 151 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.7 151 /classes/module/Module.php:277
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 <= 111
AND c.nright >= 112
AND c.nleft >= 2
AND c.nright <= 183
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.6 31 Yes /classes/classes/Tools.php:1301
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 = 1817
ORDER BY f.position ASC
0.6 3 Yes /classes/classes/Product.php:4453
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 152, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 152) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-12-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-12-17 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.6 2 Yes /classes/classes/SpecificPrice.php:418
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1817
0.6 1 /classes/classes/Product.php:5676
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.6 1 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-12-17 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-12-17 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/classes/SpecificPrice.php:361
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` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.5 8 Yes Yes /classes/classes/Category.php:859
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.biyadina.com' OR su.domain_ssl = 'www.biyadina.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.5 1 Yes /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1817
ORDER BY `position`
0.5 3 Yes /classes/classes/Product.php:2723
SELECT SQL_NO_CACHE `name`, `value`, `block` FROM `ps_magiczoomplus_settings` WHERE `enabled`=1
0.5 594 /modules/magiczoomplus/magiczoomplus.php:408
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 1889609
AND `date_add` > '2018-12-17 01:41:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.5 1 Yes /classes/classes/Connection.php:138
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` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.5 1 Yes /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1817) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pc.`id_product_comment`,
(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful,
(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, 
IF(c.id_customer, CONCAT(c.`firstname`, ' ',  LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title
FROM `ps_product_comment` pc
LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer`
WHERE pc.`id_product` = 1817 AND pc.`validate` = 1
ORDER BY pc.`date_add` DESC
0.5 1 Yes /modules/productcomments/ProductComment.php:114
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5bd8fb47f136b58593ed2bf15f8179ab' AND cache_id="blockcms|2|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.5 1 /classes/classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1817
ORDER BY `position`
0.5 3 Yes /classes/classes/Product.php:2723
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `attribute`
FROM `ps_attribute` a
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 1817
0.5 1 /classes/classes/Product.php:5619
SELECT SQL_NO_CACHE pcc.`id_product_comment_criterion`, pccl.`name`
FROM `ps_product_comment_criterion` pcc
LEFT JOIN `ps_product_comment_criterion_lang` pccl
ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion)
LEFT JOIN `ps_product_comment_criterion_product` pccp
ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 1817)
LEFT JOIN `ps_product_comment_criterion_category` pccc
ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`)
LEFT JOIN `ps_product_shop` ps
ON (ps.id_category_default = pccc.id_category AND ps.id_product = 1817)
WHERE pccl.`id_lang` = 1
AND (
pccp.id_product IS NOT NULL
OR ps.id_product IS NOT NULL
OR pcc.id_product_comment_criterion_type = 1
)
AND pcc.active = 1
GROUP BY pcc.id_product_comment_criterion
0.4 1 Yes /modules/productcomments/ProductCommentCriterion.php:184
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` = 1817) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 1817
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.4 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE pa.`id_product_attribute`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1817
ORDER BY product_attribute_shop.`price` DESC LIMIT 1
0.4 1 Yes /classes/classes/Product.php:3201
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.4 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE pl.id_lang = 1
AND pl.id_product = 1817
AND product_shop.active = 1 LIMIT 1
0.4 1 /classes/classes/Meta.php:259
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.4 25 /classes/classes/Language.php:894
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.4 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='55cb217cd888e80c1c2e08aa8a11c2ff' AND cache_id="tmmegamenu|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.4 1 /classes/classes/SmartyCustom.php:215
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.4 1 /classes/shop/Shop.php:203
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 9) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.4 22 Yes /modules/themeconfigurator/themeconfigurator.php:376
SELECT SQL_NO_CACHE *
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 1817
AND pc.`id_customer` = 0
ORDER BY pc.`date_add` DESC LIMIT 1
0.4 1 Yes /modules/productcomments/ProductComment.php:137
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` = 152) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
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.4 5 /classes/classes/Language.php:777
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` = 427) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_tmhtmlcontent`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'top' AND active = 1
ORDER BY item_order ASC
0.4 30 Yes /modules/tmhtmlcontent/tmhtmlcontent.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 451) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(*) n
FROM `ps_module_shop`
WHERE id_module=20 AND id_shop IN (1)
GROUP BY id_module
HAVING n=1 LIMIT 1
0.4 1 /classes/module/Module.php:2210
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.4 9 Yes /classes/classes/Currency.php:231
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` = 2
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 152) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='59ac4725e43cdb279a28a8042bdf7bda' AND cache_id="socialsharing|1817|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.4 1 /classes/classes/SmartyCustom.php:215
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` = 2) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE p.id_product
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)
WHERE p.id_product = 1817
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2018-12-17 00:00:00",
INTERVAL 60 DAY
)
) > 0
0.4 0 /classes/classes/Product.php:1278
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:61
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 1817
AND image_shop.`cover` = 1 LIMIT 1
0.3 3 /classes/classes/Product.php:2743
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='85f511a01d40daa282faf0b7299764cb' AND cache_id="crossselling|productfooter|1817|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.3 1 /classes/classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1817)
0.3 1 /classes/classes/Product.php:2998
SELECT SQL_NO_CACHE pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion`
FROM `ps_product_comment` pc
LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`)
LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
WHERE pc.`id_product` = 1817
AND pccl.`id_lang` = 1 AND pc.`validate` = 1
0.3 1 /modules/productcomments/ProductComment.php:168
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4337a9bfc74581c272d987988bea3b04' AND cache_id="productscategory|1817|461|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.3 1 /classes/classes/SmartyCustom.php:215
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.3 3 /classes/classes/Currency.php:472
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 461 LIMIT 1
0.3 1 /classes/classes/Category.php:1477
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 1817 AND ctg.`id_group` = 1 LIMIT 1
0.3 3 /classes/classes/Product.php:4916
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 1817 AND `id_shop` = 1
0.3 5 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a73f375086b349562fbe9a10fb086c74' AND cache_id="tmmediaparallax|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.3 1 /classes/classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='8599db0b027f323689ef6f7af4679aef' AND cache_id="blockcontactinfos|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.3 1 /classes/classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 461) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.3 18 /classes/classes/ImageType.php:143
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.3 86 /classes/classes/Hook.php:187
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 =3 AND m.page = "product" LIMIT 1
0.3 1 /classes/classes/Theme.php:275
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1817
ORDER BY `position`
0.3 3 Yes /classes/classes/Product.php:2723
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a2f31595767fc04de7144d6664e25fd0' AND cache_id="socialsharing_header|1817|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.3 1 /classes/classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e011fb0cae3e97fb3c0f4fd3f6143e8e' AND cache_id="productFooter_leosliderlayer||20181217|1|1|1|1|2|21|1" AND compile_id="" LIMIT 1
0.3 1 /classes/classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE p.id_product
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)
WHERE p.id_product = 1817
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2018-12-17 00:00:00",
INTERVAL 60 DAY
)
) > 0
0.3 0 /classes/classes/Product.php:1278
SELECT SQL_NO_CACHE name, width, height FROM `ps_image_type` WHERE name in ('large_default', 'small_default')
0.3 2 /modules/magiczoomplus/magiczoomplus.php:1064
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 152
0.3 6 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dae9a572aa957a7701a4b5ab16bb99fb' AND cache_id="blockmyaccountfooter|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.3 1 /classes/classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 1817 LIMIT 1
0.3 1 /classes/classes/Product.php:752
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
0.3 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "paypal" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM ps_leosliderlayer_groups gr
WHERE gr.id_shop = 1
AND gr.hook = "productFooter" AND gr.`active` = 1
ORDER BY gr.id_leosliderlayer_groups LIMIT 1
0.3 1 /modules/leosliderlayer/leosliderlayer.php:1063
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "sendinblue" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.3 1 /classes/shop/ShopUrl.php:169
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.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 145 AND `id_shop` = 1 LIMIT 1
0.3 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=1817
0.3 1 /classes/classes/Tag.php:205
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.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 461 LIMIT 1
0.3 1 /classes/classes/Category.php:1054
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2018-12-17 00:00:00' AND '2018-12-17 23:59:59' LIMIT 1
0.3 1 /classes/classes/SpecificPrice.php:301
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` = 1817
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.3 1 /modules/productcomments/ProductComment.php:184
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 3) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE version FROM `ps_module` WHERE name = 'paypal' LIMIT 1
0.3 1 /modules/paypal/paypal.php:281
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` = 2) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2 LIMIT 1
0.3 1 /classes/classes/Category.php:1477
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1817) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'large_default' LIMIT 1
0.3 1 /classes/classes/Image.php:470
SELECT SQL_NO_CACHE `status`
FROM ps_tmnewsletter_settings
WHERE `id_shop` = 1
AND `is_guest` = 0 LIMIT 1
0.3 2 /modules/tmnewsletter/tmnewsletter.php:496
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=1817
0.2 1 /classes/classes/Tag.php:205
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en' LIMIT 1
0.2 1 /classes/classes/Language.php:680
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='7d8e35c16d98aac5065c1785e7cb3375' AND cache_id="blocksocial|1|1|1|1|2|21" AND compile_id="" LIMIT 1
0.2 1 /classes/classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE * from `ps_pronesissizechartproducts` where id_product=1817 and shop_id=1
0.2 0 /modules/pronesissizechart/classes/pronesissizechartgroups.php:108
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1817) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 6 AND `id_object` = 1817 LIMIT 1
0.2 1 /classes/classes/Page.php:77
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 461
AND id_shop = 1 LIMIT 1
0.2 1 /classes/classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.2 1 /classes/classes/Image.php:470
SELECT SQL_NO_CACHE p.id_product
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)
WHERE p.id_product = 1817
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2018-12-17 00:00:00",
INTERVAL 60 DAY
)
) > 0
0.2 0 /classes/classes/Product.php:1278
SELECT SQL_NO_CACHE `status`
FROM ps_tmnewsletter_settings
WHERE `id_shop` = 1
AND `is_guest` = 1 LIMIT 1
0.2 2 /modules/tmnewsletter/tmnewsletter.php:496
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
0.2 1 /classes/classes/Country.php:174
SELECT SQL_NO_CACHE description,value,image from `ps_pronesissizechartgroups` where active=1 and categories LIKE '%|461|%' and shop_id=1
0.2 0 /modules/pronesissizechart/classes/pronesissizechartgroups.php:124
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1817) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:646
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.2 1 /classes/classes/Page.php:97
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 21
0.2 6 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1817
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 1817
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1817) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:646
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'cart_default' LIMIT 1
0.2 1 /classes/classes/Image.php:470
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.2 1 /classes/classes/Image.php:470
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.2 6 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE id_product FROM `ps_category_product` WHERE `id_product` = 1817 AND `id_category` IN (0) LIMIT 1
0.2 1 /classes/classes/Product.php:4885
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 2
AND id_shop = 1 LIMIT 1
0.2 1 /classes/classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.2 1 /modules/lgcookieslaw/lgcookieslaw.php:174
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1817) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 95 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.2 1 /classes/classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr
FROM `ps_product_comment` pc
WHERE `id_product` = 1817 AND `validate` = 1
AND `grade` > 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:261
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2018-12-17 00:00:00' AND '2018-12-17 23:59:59' LIMIT 1
0.2 1 /classes/classes/SpecificPrice.php:305
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1817 AND id_shop=1 LIMIT 1
0.2 1 /classes/classes/Product.php:5032
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 1817
AND id_shop = 1 LIMIT 1
0.2 1 /classes/classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/classes/ObjectModel.php:1451
UPDATE `ps_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 2376
AND `id_page` = 1146
AND `id_shop` = 1
0.2 1 /classes/classes/Page.php:118
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1817 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1
0.2 0 /classes/classes/Manufacturer.php:248
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 1817 AND `validate` = 1 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.2 1 /classes/classes/SmartyCustom.php:142
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
0.2 1 /classes/classes/Group.php:133
SELECT SQL_NO_CACHE name, width, height FROM `ps_image_type` WHERE name in ('large_default', 'small_default')
0.2 2 /modules/magiczoomplus/magiczoomplus.php:1064
SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw;
0.2 1 /override/classes/Hook.php:44
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=1817
0.2 1 /classes/classes/Tag.php:205
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1817) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.2 1 /modules/lgcookieslaw/lgcookieslaw.php:174
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 461 LIMIT 1
0.2 0 /classes/classes/Category.php:1054
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
0.2 0 /classes/classes/Supplier.php:192
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.2 1 /modules/lgcookieslaw/lgcookieslaw.php:174
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1817) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:646
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
0.1 2 /classes/classes/ObjectModel.php:1368

Doubles

4
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
3
SELECT out_of_stock
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
3
			SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
			FROM `ps_image` i
			 INNER JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
			LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
			WHERE i.`id_product` = XX
			ORDER BY `position`
3
			SELECT p.id_product
			FROM `ps_product` p
			 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX)
			WHERE p.id_product = XX
			AND DATEDIFF(
				product_shop.`date_add`,
				DATE_SUB(
					"XX-XX-XX XX:XX:XX",
					INTERVAL XX DAY
				)
			) > XX
		
3
SELECT depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
3
		SELECT t.`id_lang`, t.`name`
		FROM ps_tag t
		LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
		WHERE pt.`id_product`=XX
3
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
2
SELECT *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX
WHERE (a.`id_country` = XX) LIMIT XX
2
		SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
		FROM `ps_product_comment` pc
		WHERE pc.`id_product` = XX
		AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
2
SELECT `status`
                FROM ps_tmnewsletter_settings
                WHERE `id_shop` = XX
                AND `is_guest` = XX LIMIT XX
2
SELECT *
							FROM `ps_country_lang`
							WHERE `id_country` = XX
2
				SELECT 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` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2
				SELECT m.`id_module`, m.`name`, (
					SELECT id_module
					FROM `ps_module_shop` ms
					WHERE m.`id_module` = ms.`id_module`
					AND ms.`id_shop` = XX
					LIMIT XX
				) as mshop
				FROM `ps_module` m
2
			SELECT nleft, nright, level_depth
			FROM ps_category
			WHERE id_category = XX LIMIT XX
2
SELECT buttonXX FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX
2
SELECT name, width, height FROM `ps_image_type` WHERE name in ('large_default', 'small_default')
2
			SELECT cl.`link_rewrite`
			FROM `ps_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
2
SELECT *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX
WHERE (a.`id_lang` = XX) LIMIT XX

Tables stress

12 product_shop
11 smarty_lazy_cache
10 module
10 category_lang
10 stock_available
9 module_shop
9 product
8 category
8 product_comment
7 product_attribute_shop
7 category_shop
7 image_type
6 image_shop
6 specific_price
5 product_lang
5 image
5 image_lang
5 product_attribute
5 lang
5 lang_shop
5 country
4 country_shop
4 hook
4 shop_url
4 country_lang
4 currency_shop
4 shop
3 product_attribute_combination
3 attribute
3 manufacturer
3 lgcookieslaw_lang
3 currency
3 tag
3 theme
3 product_tag
2 category_product
2 product_comment_criterion_lang
2 configuration
2 date_range
2 product_comment_criterion
2 tmnewsletter_settings
2 shop_group
2 meta
2 smarty_last_flush
2 product_comment_usefulness
2 attribute_shop
2 hook_module
2 hook_alias
2 group_shop
2 group
2 category_group
2 attribute_group_lang
2 tax_rule
2 attribute_lang
2 tax_rules_group
1 feature_shop
1 feature
1 feature_lang
1 feature_value_lang
1 required_field
1 feature_product
1 product_comment_grade
1 page_type
1 themeconfigurator
1 page
1 customer
1 pronesissizechartgroups
1 product_comment_criterion_product
1 product_comment_criterion_category
1 connections
1 pronesissizechartproducts
1 hook_module_exceptions
1 group_lang
1 supplier
1 specific_price_priority
1 product_group_reduction_cache
1 theme_meta
1 meta_lang
1 configuration_lang
1 lgcookieslaw
1 module_group
1 magiczoomplus_settings
1 zone
1 leosliderlayer_groups
1 tmrelatedproducts
1 attribute_group
1 layered_indexable_attribute_lang_value
1 tmhtmlcontent
1 cms_shop
1 state
1 cms
1 cms_lang
1 accessory

ObjectModel instances

NameInstancesSource
Product 9 /classes/classes/Link.php [104]
/controllers/front/ProductController.php [85]
/modules/blockviewed/blockviewed.php [158]
/modules/tmrelatedproducts/tmrelatedproducts.php [227]
/modules/sendtoafriend/sendtoafriend.php [68]
/modules/pronesissizechart/pronesissizechart.php [212]
/modules/loyalty/loyalty.php [266]
/modules/magiczoomplus/magiczoomplus.php [905]
/modules/magiczoomplus/magiczoomplus.php [905]
Country 7 /config/config.inc.php [142]
/override/classes/controller/FrontController.php [46]
/modules/paypal/paypal.php [111]
/modules/paypal/paypal.php [2355]
/modules/tmmegamenu/tmmegamenu.php [2635]
/modules/paypal/paypal.php [1647]
/modules/paypal/paypal.php [1647]
Address 7 /classes/classes/Product.php [492]
/classes/classes/Product.php [5048]
/classes/classes/Product.php [2937]
/controllers/front/ProductController.php [314]
/controllers/front/ProductController.php [349]
/classes/classes/Product.php [492]
/classes/classes/Product.php [492]
Category 4 /controllers/front/ProductController.php [158]
/classes/classes/Link.php [177]
/classes/classes/Link.php [177]
/classes/classes/Link.php [177]
Language 3 /config/config.inc.php [195]
/classes/classes/Tools.php [564]
/classes/classes/Tools.php [498]
Connection 1 /modules/statsdata/statsdata.php [142]
Guest 1 /modules/statsdata/statsdata.php [104]
CMS 1 /classes/classes/Link.php [265]
Manufacturer 1 /controllers/front/ProductController.php [268]
Cart 1 /classes/controller/FrontController.php [348]
ShopGroup 1 /classes/shop/Shop.php [518]
Theme 1 /config/config.inc.php [115]
Customer 1 /config/config.inc.php [217]
Currency 1 /classes/classes/Tools.php [610]
Shop 1 /config/config.inc.php [114]
Group 1 /classes/classes/Cart.php [184]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/settings.inc.php
5/config/autoload.php
6/config/alias.php
7/classes/PrestaShopAutoload.php
8/cache/class_index.php
9/config/bootstrap.php
10/Core/Core/Business/Core_Business_ContainerBuilder.php
11/Core/Foundation/IoC/Core_Foundation_IoC_Container.php
12/Adapter/Adapter_ServiceLocator.php
13/classes/controller/Controller.php
14/classes/classes/ObjectModel.php
15/Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php
16/classes/db/Db.php
17/classes/classes/Tools.php
18/classes/classes/Context.php
19/classes/shop/Shop.php
20/classes/db/DbPDO.php
21/classes/classes/Configuration.php
22/classes/classes/Validate.php
23/classes/classes/cache/Cache.php
24/Adapter/Adapter_EntityMapper.php
25/classes/db/DbQuery.php
26/classes/classes/Theme.php
27/config/defines_uri.inc.php
28/tools/htmlpurifier/HTMLPurifier.standalone.php
29/classes/classes/Language.php
30/classes/classes/Country.php
31/classes/classes/PrestaShopCollection.php
32/classes/shop/ShopGroup.php
33/classes/classes/Cookie.php
34/classes/classes/Blowfish.php
35/classes/classes/Customer.php
36/classes/classes/Group.php
37/classes/classes/Link.php
38/classes/shop/ShopUrl.php
39/config/smarty.config.inc.php
40/tools/smarty/Smarty.class.php
41/tools/smarty/sysplugins/smarty_internal_data.php
42/tools/smarty/sysplugins/smarty_internal_templatebase.php
43/tools/smarty/sysplugins/smarty_internal_template.php
44/tools/smarty/sysplugins/smarty_resource.php
45/tools/smarty/sysplugins/smarty_internal_resource_file.php
46/tools/smarty/sysplugins/smarty_cacheresource.php
47/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
48/classes/classes/SmartyCustom.php
49/config/smartyfront.config.inc.php
50/classes/classes/Dispatcher.php
51/classes/classes/Hook.php
52/override/classes/Hook.php
53/classes/module/Module.php
54/tools/mobile_Detect/Mobile_Detect.php
55/config/db_slave_server.inc.php
56/modules/smartblog/smartblog.php
57/modules/smartblog/classes/BlogCategory.php
58/modules/smartblog/classes/Blogcomment.php
59/modules/smartblog/classes/BlogPostCategory.php
60/modules/smartblog/classes/BlogTag.php
61/modules/smartblog/classes/SmartBlogPost.php
62/modules/smartblog/classes/BlogImageType.php
63/modules/smartblog/controllers/admin/AdminAboutUsController.php
64/classes/controller/ModuleAdminController.php
65/classes/controller/AdminController.php
66/classes/classes/Translate.php
67/modules/smartblog/translations/en.php
68/controllers/front/ProductController.php
69/classes/controller/FrontController.php
70/override/classes/controller/FrontController.php
71/override/controllers/front/ProductController.php
72/classes/classes/Product.php
73/classes/webservice/WebserviceRequest.php
74/themes/theme1307/lang/en.php
75/tools/geoip/geoipcity.inc
76/tools/geoip/geoip.inc
77/tools/geoip/geoipregionvars.php
78/classes/classes/Currency.php
79/classes/classes/Cart.php
80/override/classes/Cart.php
81/classes/classes/CartRule.php
82/override/classes/CartRule.php
83/classes/classes/Meta.php
84/classes/classes/Category.php
85/classes/classes/Manufacturer.php
86/classes/classes/Supplier.php
87/classes/classes/Address.php
88/classes/tax/TaxManagerFactory.php
89/classes/tax/TaxRulesTaxManager.php
90/classes/tax/TaxManagerInterface.php
91/Adapter/Adapter_Configuration.php
92/Core/Core/Business/Core_Business_ConfigurationInterface.php
93/classes/tax/TaxCalculator.php
94/classes/tax/Tax.php
95/classes/classes/Combination.php
96/classes/classes/SpecificPrice.php
97/classes/classes/GroupReduction.php
98/classes/classes/Tag.php
99/classes/stock/StockAvailable.php
100/classes/classes/Media.php
101/modules/socialsharing/socialsharing.php
102/modules/socialsharing/translations/en.php
103/cache/smarty/cache/socialsharing_header/1817/1/1/1/1/2/21/4d/cd/96/4dcd964724abf22b496bc7dba611736649787145.socialsharing_header.tpl.php
104/modules/magiczoomplus/magiczoomplus.php
105/modules/magiczoomplus/magiczoomplus.module.core.class.php
106/modules/magiczoomplus/magictoolbox.params.class.php
107/modules/magiczoomplus/translations/en.php
108/modules/blockbestsellers/blockbestsellers.php
109/themes/theme1307/modules/blockbestsellers/translations/en.php
110/modules/blockbestsellers/translations/en.php
111/modules/blocksocial/blocksocial.php
112/themes/theme1307/modules/blocksocial/translations/en.php
113/modules/blocksocial/translations/en.php
114/modules/blockcategories/blockcategories.php
115/themes/theme1307/modules/blockcategories/translations/en.php
116/modules/blockcategories/translations/en.php
117/modules/blockcurrencies/blockcurrencies.php
118/themes/theme1307/modules/blockcurrencies/translations/en.php
119/modules/blockcurrencies/translations/en.php
120/modules/blocklanguages/blocklanguages.php
121/themes/theme1307/modules/blocklanguages/translations/en.php
122/modules/blocklanguages/translations/en.php
123/modules/blocklayered/blocklayered.php
124/themes/theme1307/modules/blocklayered/translations/en.php
125/modules/blocklayered/translations/en.php
126/modules/blockcms/blockcms.php
127/modules/blockcms/BlockCMSModel.php
128/themes/theme1307/modules/blockcms/translations/en.php
129/modules/blockcms/translations/en.php
130/modules/blockcontact/blockcontact.php
131/themes/theme1307/modules/blockcontact/translations/en.php
132/modules/blockcontact/translations/en.php
133/modules/blockcontactinfos/blockcontactinfos.php
134/themes/theme1307/modules/blockcontactinfos/translations/en.php
135/modules/blockcontactinfos/translations/en.php
136/modules/blockmanufacturer/blockmanufacturer.php
137/themes/theme1307/modules/blockmanufacturer/translations/en.php
138/modules/blockmanufacturer/translations/en.php
139/modules/blockmyaccount/blockmyaccount.php
140/themes/theme1307/modules/blockmyaccount/translations/en.php
141/modules/blockmyaccount/translations/en.php
142/modules/blockmyaccountfooter/blockmyaccountfooter.php
143/themes/theme1307/modules/blockmyaccountfooter/translations/en.php
144/modules/blockmyaccountfooter/translations/en.php
145/modules/blocknewproducts/blocknewproducts.php
146/themes/theme1307/modules/blocknewproducts/translations/en.php
147/modules/blocknewproducts/translations/en.php
148/modules/blockfacebook/blockfacebook.php
149/themes/theme1307/modules/blockfacebook/translations/en.php
150/modules/blockfacebook/translations/en.php
151/modules/blocknewsletter/blocknewsletter.php
152/themes/theme1307/modules/blocknewsletter/translations/en.php
153/modules/blocknewsletter/translations/en.php
154/modules/blockpaymentlogo/blockpaymentlogo.php
155/modules/blockpaymentlogo/translations/en.php
156/modules/blockspecials/blockspecials.php
157/themes/theme1307/modules/blockspecials/translations/en.php
158/modules/blockspecials/translations/en.php
159/modules/blockstore/blockstore.php
160/themes/theme1307/modules/blockstore/translations/en.php
161/modules/blockstore/translations/en.php
162/modules/blocksupplier/blocksupplier.php
163/themes/theme1307/modules/blocksupplier/translations/en.php
164/modules/blocksupplier/translations/en.php
165/modules/blocktags/blocktags.php
166/themes/theme1307/modules/blocktags/translations/en.php
167/modules/blocktags/translations/en.php
168/modules/blockuserinfo/blockuserinfo.php
169/themes/theme1307/modules/blockuserinfo/translations/en.php
170/modules/blockuserinfo/translations/en.php
171/modules/blockviewed/blockviewed.php
172/themes/theme1307/modules/blockviewed/translations/en.php
173/modules/blockviewed/translations/en.php
174/modules/homeslider/homeslider.php
175/modules/homeslider/HomeSlide.php
176/themes/theme1307/modules/homeslider/translations/en.php
177/modules/homeslider/translations/en.php
178/modules/productpaymentlogos/productpaymentlogos.php
179/modules/productpaymentlogos/translations/en.php
180/modules/homefeatured/homefeatured.php
181/themes/theme1307/modules/homefeatured/translations/en.php
182/modules/homefeatured/translations/en.php
183/modules/themeconfigurator/themeconfigurator.php
184/themes/theme1307/modules/themeconfigurator/translations/en.php
185/modules/themeconfigurator/translations/en.php
186/modules/sendtoafriend/sendtoafriend.php
187/themes/theme1307/modules/sendtoafriend/translations/en.php
188/modules/sendtoafriend/translations/en.php
189/modules/blockpermanentlinks/blockpermanentlinks.php
190/themes/theme1307/modules/blockpermanentlinks/translations/en.php
191/modules/blockpermanentlinks/translations/en.php
192/modules/crossselling/crossselling.php
193/themes/theme1307/modules/crossselling/translations/en.php
194/modules/crossselling/translations/en.php
195/modules/productscategory/productscategory.php
196/themes/theme1307/modules/productscategory/translations/en.php
197/modules/productscategory/translations/en.php
198/modules/leosliderlayer/leosliderlayer.php
199/modules/leosliderlayer/grouplayer.php
200/modules/leosliderlayer/sliderlayer.php
201/modules/leosliderlayer/status.php
202/modules/leosliderlayer/translations/en.php
203/modules/smartbloghomelatestnews/smartbloghomelatestnews.php
204/modules/smartblogtag/smartblogtag.php
205/modules/tmmegamenu/tmmegamenu.php
206/modules/tmmegamenu/classes/MegaMenu.php
207/modules/tmmegamenu/classes/MegaMenuHtml.php
208/modules/tmmegamenu/classes/MegaMenuLink.php
209/modules/tmmegamenu/classes/MegaMenuBanner.php
210/modules/tmmegamenu/classes/MegaMenuVideo.php
211/modules/tmmegamenu/classes/MegaMenuMap.php
212/modules/tmmegamenu/translations/en.php
213/modules/tmproductvideos/tmproductvideos.php
214/modules/tmproductvideos/translations/en.php
215/modules/tmsociallogin/tmsociallogin.php
216/modules/tmsociallogin/translations/en.php
217/modules/pronesissizechart/pronesissizechart.php
218/modules/pronesissizechart/classes/pronesissizechartgroups.php
219/modules/pronesissizechart/translations/en.php
220/modules/tmsearch/tmsearch.php
221/modules/tmsearch/translations/en.php
222/modules/tmrelatedproducts/tmrelatedproducts.php
223/modules/tmrelatedproducts/translations/en.php
224/modules/blockcart/blockcart.php
225/themes/theme1307/modules/blockcart/translations/en.php
226/modules/blockcart/translations/en.php
227/modules/mailalerts/mailalerts.php
228/modules/mailalerts/MailAlert.php
229/modules/mailalerts/translations/en.php
230/modules/tmhtmlcontent/tmhtmlcontent.php
231/modules/tmhtmlcontent/translations/en.php
232/modules/tmnewsletter/tmnewsletter.php
233/modules/tmnewsletter/translations/en.php
234/modules/tmmediaparallax/tmmediaparallax.php
235/modules/tmmediaparallax/classes/TMMediaParallaxItems.php
236/modules/tmmediaparallax/classes/TMMediaParallaxLayouts.php
237/modules/tmmediaparallax/translations/en.php
238/cache/smarty/cache/tmmediaparallax/1/1/1/1/2/21/2c/a9/ec/2ca9ece3be6e747fa3c2ae21eab349ffe825033c.layouts.tpl.php
239/modules/tmcategoryproducts/tmcategoryproducts.php
240/modules/tmcategoryproducts/classes/CategoryProducts.php
241/modules/tmcategoryproducts/translations/en.php
242/cache/smarty/compile/36/8f/e8/368fe828d9f7022bf44f299af3d05b9ffd4ab261.file.header.tpl.php
243/tools/smarty/sysplugins/smarty_internal_filter_handler.php
244/modules/lgcookieslaw/lgcookieslaw.php
245/modules/lgcookieslaw/translations/en.php
246/modules/lgcookieslaw/en.php
247/classes/classes/CMS.php
248/cache/smarty/compile/fb/ca/dd/fbcaddf8114575500b8f1dcd8bd0908e77286926.file.cookieslaw_header.tpl.php
249/tools/js_minify/jsmin.php
250/modules/tmsocialfeeds/tmsocialfeeds.php
251/modules/tmsocialfeeds/translations/en.php
252/modules/paypal/paypal.php
253/modules/paypal/api/paypal_lib.php
254/modules/paypal/api/paypal_connect.php
255/modules/paypal/api/CallApiPaypalPlus.php
256/modules/paypal/api/ApiPaypalPlus.php
257/modules/paypal/paypal_logos.php
258/modules/paypal/paypal_orders.php
259/modules/paypal/paypal_tools.php
260/modules/paypal/paypal_login/paypal_login.php
261/modules/paypal/paypal_login/PayPalLoginUser.php
262/modules/paypal/classes/PaypalCapture.php
263/modules/paypal/classes/AuthenticatePaymentMethods.php
264/modules/paypal/classes/PaypalPlusPui.php
265/classes/classes/PaymentModule.php
266/modules/paypal/en.php
267/cache/smarty/compile/9c/de/7c/9cde7c0fc6b0fd6d022374472d74e8e95785958b.file.paypal.js.php
268/modules/tmmegalayout/tmmegalayout.php
269/modules/tmmegalayout/classes/TMMegaLayoutItems.php
270/modules/tmmegalayout/classes/TMMegaLayoutLayouts.php
271/modules/tmmegalayout/classes/TMMegaLayoutExport.php
272/modules/tmmegalayout/classes/TMMegaLayoutImport.php
273/modules/tmmegalayout/translations/en.php
274/modules/blockwishlist/blockwishlist.php
275/modules/blockwishlist/WishList.php
276/themes/theme1307/modules/blockwishlist/translations/en.php
277/modules/blockwishlist/translations/en.php
278/modules/paypalstandard/paypalstandard.php
279/modules/gadwordsfree/gadwordsfree.php
280/modules/sendinblue/sendinblue.php
281/modules/sendinblue/Psmailin.php
282/modules/sendinblue/config.php
283/modules/sendinblue/en.php
284/modules/sendinblue/backward_compatibility/backward.php
285/modules/sendinblue/backward_compatibility/Display.php
286/modules/googleshopping/googleshopping.php
287/modules/googleshopping/lib/phpseclib/Crypt/RSA.php
288/modules/googleshopping/lib/phpseclib/Crypt/Random.php
289/modules/googleshopping/lib/phpseclib/Crypt/Hash.php
290/modules/googleshopping/lib/phpseclib/Math/BigInteger.php
291/modules/googleshopping/translations/en.php
292/modules/productcomments/productcomments.php
293/themes/theme1307/modules/productcomments/translations/en.php
294/modules/productcomments/translations/en.php
295/modules/blocklink/blocklink.php
296/themes/theme1307/modules/blocklink/translations/en.php
297/modules/blocklink/translations/en.php
298/modules/fbtrackingpixel/fbtrackingpixel.php
299/modules/muinfinitescroll/muinfinitescroll.php
300/modules/htmlbox/htmlbox.php
301/modules/htmlbox/translations/en.php
302/modules/ns8csp/ns8csp.php
303/modules/ns8csp/lib/RESTClient.php
304/modules/ns8csp/lib/utils.php
305/cache/smarty/compile/c3/48/a8/c348a8cd83af32bcd8da36a986802c680c14a29f.file.script.tpl.php
306/modules/pagesnotfound/pagesnotfound.php
307/modules/pagesnotfound/translations/en.php
308/modules/sekeywords/sekeywords.php
309/classes/module/ModuleGraph.php
310/modules/sekeywords/translations/en.php
311/cache/smarty/cache/tmmegamenu/1/1/1/1/2/21/63/ee/62/63ee624c3ed79cace4aecf5c3b9e82f8b38c5ac8.menu.tpl.php
312/cache/smarty/compile/ed/47/7d/ed477dabf1ad8837f3cc9c87fba6f2b268b80570.file.top.tpl.php
313/cache/smarty/compile/5f/27/b8/5f27b82a821c9a532347ac186097db2cba23e3f0.file.blockwishlist_top.tpl.php
314/classes/classes/Pack.php
315/classes/classes/ProductDownload.php
316/classes/classes/ImageType.php
317/cache/smarty/cache/crossselling/productfooter/1817/1/1/1/1/2/21/09/66/ec/0966ec6ab3e28193e7bc531f216b0f86343c852f.crossselling.tpl.php
318/cache/smarty/cache/productscategory/1817/461/1/1/1/1/2/21/66/e0/9e/66e09edb79af78b5c37dde6cf27c5056d7dddc24.productscategory.tpl.php
319/cache/smarty/compile/c1/0b/2e/c10b2e9a4d4264a61fffac29eccd8c0bf059ce7e.file.tmrelatedproducts.tpl.php
320/modules/cleverreach/cleverreach.php
321/modules/cleverreach/vendor/autoload.php
322/modules/cleverreach/vendor/composer/autoload_real.php
323/modules/cleverreach/vendor/composer/ClassLoader.php
324/modules/cleverreach/vendor/composer/autoload_static.php
325/modules/cleverreach/classes/HooksHandler.php
326/modules/cleverreach/classes/Initializer.php
327/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/ServiceRegister.php
328/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Interfaces/Required/Configuration.php
329/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Utility/TimeProvider.php
330/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Interfaces/Required/HttpClient.php
331/modules/cleverreach/vendor/cleverreach/integration-core/src/BusinessLogic/Interfaces/Proxy.php
332/modules/cleverreach/vendor/cleverreach/integration-core/src/BusinessLogic/Interfaces/Recipients.php
333/modules/cleverreach/vendor/cleverreach/integration-core/src/BusinessLogic/Interfaces/OrderItems.php
334/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Interfaces/Required/ShopLoggerAdapter.php
335/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Interfaces/LoggerAdapter.php
336/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Interfaces/DefaultLoggerAdapter.php
337/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Interfaces/Required/TaskQueueStorage.php
338/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Interfaces/Exposed/TaskRunnerStatusStorage.php
339/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Interfaces/Required/AsyncProcessStarter.php
340/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Interfaces/Exposed/TaskRunnerWakeup.php
341/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/TaskExecution/TaskRunner.php
342/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/TaskExecution/Queue.php
343/modules/cleverreach/vendor/cleverreach/integration-core/src/Infrastructure/Utility/GuidProvider.php
344/modules/cleverreach/vendor/cleverreach/integration-core/src/BusinessLogic/Interfaces/Attributes.php
345/classes/classes/Image.php
346/classes/classes/Feature.php
347/cache/smarty/compile/8a/05/bc/8a05bc44b72e2715c37a7b8144b4af1c76621cd5.file.sendtoafriend-extra.tpl.php
348/modules/blocksharefb/blocksharefb.php
349/modules/blocksharefb/translations/en.php
350/cache/smarty/compile/c2/8d/4c/c28d4c7f3a2db9f693868b8f3aa546875549b80a.file.blocksharefb.tpl.php
351/cache/smarty/cache/socialsharing/1817/1/1/1/1/2/21/ae/fa/ec/aefaecbcf8cfa8487eb39bf2b17fe8549b91c664.socialsharing.tpl.php
352/cache/smarty/compile/7f/8c/f9/7f8cf96ee079869be8393a932b03d655ede26bbf.file.product_page.tpl.php
353/modules/loyalty/loyalty.php
354/themes/theme1307/modules/loyalty/translations/en.php
355/modules/loyalty/translations/en.php
356/modules/loyalty/LoyaltyModule.php
357/cache/smarty/compile/3d/7a/8a/3d7a8a717eaedac8daff0f404590590150e40268.file.product.tpl.php
358/modules/magiczoomplus/magictoolbox.templatehelper.class.php
359/modules/magiczoomplus/templates/bottom.tpl.php
360/modules/productcomments/ProductComment.php
361/modules/productcomments/ProductCommentCriterion.php
362/cache/smarty/compile/1b/a7/6f/1ba76fa1267551bfc3a60afbc90c4396ba883d05.file.productcomments-extra.tpl.php
363/cache/smarty/compile/07/2d/d8/072dd87f8c3ea9d674c54f168ab8459f1efedc81.file.product.tpl.php
364/cache/smarty/compile/d2/35/fd/d235fdf60e55dc663e27ca05eaa488b970a98776.file.blockwishlist-extra.tpl.php
365/cache/smarty/compile/4b/16/85/4b1685520e81c9dfe87f4a486e678fbf16547c94.file.tab.tpl.php
366/cache/smarty/compile/ac/1a/b2/ac1ab2dec29949a12a5137972533dc6e5761be92.file.productcomments.tpl.php
367/cache/smarty/compile/d4/16/e6/d416e6812ae63e6da428d6fdb68d6593031cdd33.file.hook.tpl.php
368/cache/smarty/compile/df/b8/20/dfb820b7ab67feb3755caa19ce783d16a11790ef.file.blocknewsletter.tpl.php
369/cache/smarty/cache/blockcms/2/1/1/1/1/2/21/3d/44/67/3d4467467d2b75063cbf71cd9ba16cc01299c247.blockcms.tpl.php
370/cache/smarty/cache/blockmyaccountfooter/1/1/1/1/2/21/af/fc/15/affc1556ea73c4e54f4d6a3e2daf9d9593673848.blockmyaccountfooter.tpl.php
371/cache/smarty/cache/blockcontactinfos/1/1/1/1/2/21/b5/7b/ec/b57bec0c5954cb50129cc1a604d0df37ff830b06.blockcontactinfos.tpl.php
372/cache/smarty/cache/blocksocial/1/1/1/1/2/21/71/70/53/717053ed97f34b9ff3a315a3452030339e6fc3ff.blocksocial.tpl.php
373/modules/statsdata/statsdata.php
374/modules/statsdata/translations/en.php
375/classes/classes/Guest.php
376/modules/metatagsgenerator/metatagsgenerator.php
377/classes/classes/Connection.php
378/classes/classes/Page.php
379/classes/classes/ConnectionsSource.php
380/classes/classes/DateRange.php
381/modules/tmolarkchat/tmolarkchat.php
382/modules/tmolarkchat/translations/en.php