Website very slow! Back and front office in the same time.

JODY44 · May 28, 2014

Hi, I use PS V1.6

My website normally is loading in about 3 -4 seconds, but sometimes it takes 55 seconds to load 1 page, and when that happens it is going on for all day, and even so slow that it comes up with gateway errors, and then it goes back to normal

Now it has happened again, I try to contact the Hosts but they just said that they cannot see anything wrong with it. Frist time it happened after I switched on web service by mistake. It does not happen straight away, I think after about 24 hours, I switched off that option clear cache, then It's back to normal again

But since that, it has happened on and off, sometimes after I installed a module and uninstall it. And sometimes without making any changes to it.

I have no idea on how to fix this problem. We did not get any orders at all when this happens so is costing a lot of money.

Can anyone please advise.....HELP

JPresta.com · May 28, 2014

When it happens you should do a profiling: www.webbax.ch/2013/06/21/prestashop-1-5-et-le-profilling/. This will tell you if it's a Prestashop problem.

Also, analyse where the request is long with Chrome > inspect element > network (or firefox) or use GTMetrix. This will tell you if it's a network problem.

JODY44 · May 29, 2014

Thank you joemartin ! finally, my host has offered to move the DB to another sever for me, if this problem has been caused from the current sever hopefully, It will soon be resolved.

PrestaHeroes USA · May 29, 2014

make sure to set apache optimization to 'yes' (see your screen shot)

this won't fix all your issues but it's best setting..

also for slow pages, config/defines.inc.php set to true

define('_PS_DEBUG_PROFILING_', true);

then visit your slow page, and scroll to bottom to see profiling...this can help you isolate exactly what the hang up is

(make sure to set to false when done.

PrestaHeroes USA · May 29, 2014

for back office, I found this post very useful, and I think many are having the same issue.

http://www.prestashop.com/forums/topic/333695-solved-1606-back-office-slow/?p=1687307

JODY44 · May 29, 2014

Thank you el-patron, will do that.

JODY44 · May 30, 2014

Hi, EI Patron it happened again !!!

I'm opened config/settings.inc.php but cannot see this (define('_PS_DEBUG_PROFILING) line at all.

--removed--

PrestaHeroes USA · May 30, 2014

Hi, EI Patron it happened again !!!

I'm opened config/settings.inc.php but cannot see this (define('_PS_DEBUG_PROFILING) line at all.

I apologize for that I get them mixed up, the file is config/defines.inc.php

JODY44 · May 30, 2014

ok they are in this /config/defines.inc.php so could anyone suggest if this is problem from prestashop on server

Sorry I'm not a technical person and need help.

Load time: 47.132s
You'd better run your shop on a toaster

config: 11.003s
constructor: 0ms
init: 34.936s
checkAccess: 0ms
setMedia: 4ms
postProcess: 0ms
initHeader: 0ms
initContent: 764ms
initFooter: 146ms
display: 279ms
Hook processing: 35.862s / 10.67 Mb
57 methods called in 35 modules
- actionCartSave: 34.762s / 1.23 Mb
- displayHeader: 670ms / 7.04 Mb
- displayTopColumn: 173ms / 0.06 Mb
- displayFooter: 146ms / 0.56 Mb
- displayHome: 68ms / 0.3 Mb
- displayTop: 26ms / 1.34 Mb
- displayNav: 15ms / 0.1 Mb
- displayBanner: 3ms / 0.03 Mb
- displayHomeTabContent: 0ms / 0 Mb
- moduleRoutes: 0ms / 0 Mb
- actionDispatcher: 0ms / 0 Mb
- actionObjectUpdateAfter: 0ms / 0 Mb
- actionObjectUpdateBefore: 0ms / 0 Mb
- displayHomeTab: 0ms / 0 Mb
- actionFrontControllerSetMedia: 0ms / 0 Mb
- actionObjectCartUpdateAfter: 0ms / 0 Mb
- DisplayOverrideTemplate: 0ms / 0 Mb
- actionObjectCartUpdateBefore: 0ms / 0 Mb
Memory peak usage: 42.3 Mb
- config: 10.99 Mb (11.1 Mb)
- constructor: 0 Mb (11.1 Mb)
- init: 13.92 Mb (29.2 Mb)
- checkAccess: 0 Mb (29.2 Mb)
- setMedia: 0.21 Mb (29.2 Mb)
- postProcess: 0 Mb (29.2 Mb)
- initHeader: 0.01 Mb (29.2 Mb)
- initContent: 8.71 Mb (34.2 Mb)
- initFooter: 0.57 Mb (42.3 Mb)
- display: 0.5 Mb (42.3 Mb)
Total cache size (in Cache class): 0.75 Mb
DB type: DbPDO
SQL Queries: 7 queries
Time spent querying: 45.503s

PrestaHeroes USA · May 30, 2014

"SQL Queries: 7 queries
Time spent querying: 45.503s

in config/settings.inc.php

define('_PS_MODE_DEV_', true);

turn on errors, this will also allow _PS_DEBUG_SQL to run

re-create and lets see if any interesting info comes of this

JODY44 · May 30, 2014

HI Ei Patron

Here is the result, you think this is from SQL or PS also

My host will move sql server for me tonight but I’m not sure if is from SQL alone that cause problem

Load time: 46.878s
You'd better run your shop on a toaster

config: 10.881s
constructor: 0ms
init: 35.205s
checkAccess: 0ms
setMedia: 6ms
postProcess: 0ms
initHeader: 0ms
initContent: 513ms
initFooter: 94ms
display: 179ms

Hook processing: 35.753s / 10.72 Mb
57 methods called in 35 modules

actionCartSave: 35.053s / 1.23 Mb
displayHome: 332ms / 0.31 Mb
displayHeader: 140ms / 7.05 Mb
displayFooter: 94ms / 0.57 Mb
displayTopColumn: 88ms / 0.08 Mb
displayTop: 40ms / 1.34 Mb
displayNav: 4ms / 0.1 Mb
displayBanner: 2ms / 0.03 Mb
moduleRoutes: 0ms / 0 Mb
actionFrontControllerSetMedia: 0ms / 0 Mb
displayHomeTab: 0ms / 0 Mb
actionDispatcher: 0ms / 0 Mb
displayHomeTabContent: 0ms / 0 Mb
DisplayOverrideTemplate: 0ms / 0 Mb
actionObjectUpdateBefore: 0ms / 0 Mb
actionObjectUpdateAfter: 0ms / 0 Mb
actionObjectCartUpdateBefore: 0ms / 0 Mb
actionObjectCartUpdateAfter: 0ms / 0 Mb

Memory peak usage: 22.4 Mb

config: 6.77 Mb (6.9 Mb)
constructor: 0 Mb (6.9 Mb)
init: 5.14 Mb (12.1 Mb)
checkAccess: 0 Mb (12.1 Mb)
setMedia: 0.21 Mb (12.3 Mb)
postProcess: 0 Mb (12.3 Mb)
initHeader: 0.01 Mb (12.3 Mb)
initContent: 8.72 Mb (21.2 Mb)
initFooter: 0.59 Mb (22 Mb)
display: 0.52 Mb (22.4 Mb)

Total cache size (in Cache class): 0.75 Mb

DB type: DbPDO
SQL Queries: 13 queries
Time spent querying: 46.396s

Included files: 207
Size of included files: 2.6 Mb

Globals (> 1 Ko only): 591 Ko

_MODULES ≈ 304.6 Ko
_LANG ≈ 184.1 Ko
context ≈ 71.5 Ko
_SERVER ≈ 10.3 Ko
_ENV ≈ 10 Ko
_MODULE ≈ 3.7 Ko
_REQUEST ≈ 1.4 Ko
_COOKIE ≈ 1.4 Ko

Go to Stopwatch
Go to Doubles
Go to Tables
Go to ObjectModels
Display queries table
Go to files

Time (ms) Rows Query Location Filesort Group By 35016.712 1702 SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) /classes/module/Module.php:1717 10765.613 585 SELECT 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`) /classes/Configuration.php:118 313.094 21 SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'home' AND active = 1 ORDER BY item_order ASC /modules/themeconfigurator/themeconfigurator.php:330 Yes 80.435 21 SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'top' AND active = 1 ORDER BY item_order ASC /modules/themeconfigurator/themeconfigurator.php:330 Yes 36.915 1 SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "index" OR m.page = "index" ) AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1 /classes/Meta.php:142 29.449 1 INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('12255', '1', '2014-05-30 13:50:46') /classes/Connection.php:101 26.644 1 SELECT value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1 /classes/cache/CacheFs.php:36 22.479 0 SELECT * FROM `ps_cart` a WHERE (a.id_cart = 169) LIMIT 1 /classes/ObjectModel.php:212 22.333 0 SELECT `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 /classes/Hook.php:131 22.015 1 SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =1 AND m.page = "index" LIMIT 1 /classes/Theme.php:177 21.876 1 SELECT `id_page` FROM `ps_page` WHERE `id_page_type` = 1 LIMIT 1 /classes/Page.php:78 19.664 1 UPDATE `ps_cart` SET `id_shop_group` = '0',`id_shop` = '0',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_carrier` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '0',`id_lang` = '1',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`secure_key` = '',`allow_seperated_package` = '0',`date_add` = '0000-00-00',`date_upd` = '2014-05-30 13:50:10' WHERE `id_cart` = 0 /classes/ObjectModel.php:596 18.487 1 SELECT id_page_type FROM ps_page_type WHERE name = 'index' LIMIT 1 /classes/Page.php:96

Stopwatch (with SQL_NO_CACHE) (total = 13)

35016.712 ms SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)
in /classes/module/Module.php:1717

from /classes/Hook.php:469
from /tools/profiling/Hook.php:60
from /classes/Cart.php:200
from /classes/controller/FrontController.php:215
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28

1702 rows browsed

10765.613 ms SELECT 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`)
in /classes/Configuration.php:118

from /config/config.inc.php:113
from /index.php:27

585 rows browsed

313.094 ms SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'home' AND active = 1 ORDER BY item_order ASC
in /modules/themeconfigurator/themeconfigurator.php:330

from /modules/themeconfigurator/themeconfigurator.php:252
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /controllers/front/IndexController.php:40
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28

USING FILESORT - 21 rows browsed

80.435 ms SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'top' AND active = 1 ORDER BY item_order ASC
in /modules/themeconfigurator/themeconfigurator.php:330

from /modules/themeconfigurator/themeconfigurator.php:242
from /modules/themeconfigurator/themeconfigurator.php:234
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/c1/03/58/c103587743800001c5bb6488d2abbb37927b68b5.file.header.tpl.php:169
from /cache/smarty/compile/c1/03/58/c103587743800001c5bb6488d2abbb37927b68b5.file.header.tpl.php:169
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/97/4f/a0/974fa04aa59f01f524e1f81e6c4fd97b63cfaa98.file.layout.tpl.php:38
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/Controller.php:402
from /classes/controller/FrontController.php:562
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:28

USING FILESORT - 21 rows browsed

36.915 ms SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "index" OR m.page = "index" ) AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1
in /classes/Meta.php:142

from /classes/Meta.php:225
from /classes/Meta.php:212
from /classes/controller/FrontController.php:286
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28

1 row browsed

29.449 ms INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('12255', '1', '2014-05-30 13:50:46')
in /classes/Connection.php:101

from /modules/statsdata/statsdata.php:104
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:808
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28

26.644 ms SELECT value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1
in /classes/cache/CacheFs.php:36

from /classes/cache/Cache.php:131
from /classes/db/Db.php:495
from /classes/shop/Shop.php:329
from /config/config.inc.php:94
from /index.php:27

1 row browsed

22.479 ms SELECT * FROM `ps_cart` a WHERE (a.id_cart = 169) LIMIT 1
in /classes/ObjectModel.php:212

from /tools/profiling/ObjectModel.php:37
from /classes/Cart.php:155
from /classes/controller/FrontController.php:195
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28

0 rows browsed

22.333 ms SELECT `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
in /classes/Hook.php:131

from /classes/Hook.php:417
from /tools/profiling/Hook.php:60
from /classes/Cart.php:200
from /classes/controller/FrontController.php:215
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28

0 rows browsed

22.015 ms SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =1 AND m.page = "index" LIMIT 1
in /classes/Theme.php:177

from /classes/controller/FrontController.php:78
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:366
from /index.php:28

1 row browsed

21.876 ms SELECT `id_page` FROM `ps_page` WHERE `id_page_type` = 1 LIMIT 1
in /classes/Page.php:78

from /classes/Connection.php:90
from /modules/statsdata/statsdata.php:104
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:808
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28

1 row browsed

19.664 ms UPDATE `ps_cart` SET `id_shop_group` = '0',`id_shop` = '0',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_carrier` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '0',`id_lang` = '1',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`secure_key` = '',`allow_seperated_package` = '0',`date_add` = '0000-00-00',`date_upd` = '2014-05-30 13:50:10' WHERE `id_cart` = 0
in /classes/ObjectModel.php:596

from /classes/Cart.php:199
from /classes/controller/FrontController.php:215
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28

19.664 ms UPDATE `ps_cart` SET `id_shop_group` = '0',`id_shop` = '0',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_carrier` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '0',`id_lang` = '1',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`secure_key` = '',`allow_seperated_package` = '0',`date_add` = '0000-00-00',`date_upd` = '2014-05-30 13:50:10' WHERE `id_cart` = 0
in /classes/ObjectModel.php:596

Edited May 30, 2014 by JODY44 (see edit history)

Dh42 · May 30, 2014

It is because your sql server is slow. If you notice most of the loading time is spent querying with 13 queries, it is like they are running mysql on a raspberry pi or something.

PrestaHeroes USA · May 30, 2014

jajaja @dh42...(note dh42 could probably get a raspberry pi to run faster)

35016.712 ms SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)
in /classes/module/Module.php:1717

from /classes/Hook.php:469
from /tools/profiling/Hook.php:60
from /classes/Cart.php:200
from /classes/controller/FrontController.php:215
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28

try this, (possible you have bad module(s))

what we are going to do is see if any different if you temporarily disable 'non PrestaShop' modules.

back office-->advanced parms-->performance

here you can disabled non-prestashop modules and/or overrides.

http://screencast.com/t/J3V4EuuCiJg

you can disable one or both and rerun test.

bannerclick · June 1, 2014

Hi, do you have layered navigation enabled? I have a problem with layered in just one of my 2 multistore shops. When enabled, the mysql query takes more than 25 seconds, when disabled all is normal again. In mysql logging, this should be the problem in blocklayered.php (starting form rule 1983)

$this->products = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('

SELECT

p.*,

'.($alias_where == 'p' ? '' : 'product_shop.*,' ).'

'.$alias_where.'.id_category_default,

pl.*,

MAX(image_shop.`id_image`) id_image,

il.legend,

m.name manufacturer_name,

MAX(product_attribute_shop.id_product_attribute) id_product_attribute,

DATEDIFF('.$alias_where.'.`date_add`, DATE_SUB(NOW(), INTERVAL '.(int)$nb_day_new_product.' DAY)) > 0 AS new,

stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity

FROM `'._DB_PREFIX_.'category_product` cp

LEFT JOIN '._DB_PREFIX_.'category c ON (c.id_category = cp.id_category)

LEFT JOIN `'._DB_PREFIX_.'product` p ON p.`id_product` = cp.`id_product`

'.Shop::addSqlAssociation('product', 'p').'

'.Product::sqlStock('p', null, false, Context::getContext()->shop).'

LEFT JOIN '._DB_PREFIX_.'product_lang pl ON (pl.id_product = p.id_product'.Shop::addSqlRestrictionOnLang('pl').' AND pl.id_lang = '.(int)$cookie->id_lang.')

LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product`)'.

Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').'

LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$cookie->id_lang.')

LEFT JOIN '._DB_PREFIX_.'manufacturer m ON (m.id_manufacturer = p.id_manufacturer)

LEFT JOIN '._DB_PREFIX_.'product_attribute pa ON (p.id_product = pa.id_product)'.

Shop::addSqlAssociation('product_attribute', 'pa', false, 'product_attribute_shop.`default_on` = 1').'

WHERE '.$alias_where.'.`active` = 1 AND '.$alias_where.'.`visibility` IN ("both", "catalog")

AND '.(Configuration::get('PS_LAYERED_FULL_TREE') ? 'c.nleft >= '.(int)$parent->nleft.' AND c.nright <= '.(int)$parent->nright : 'c.id_category = '.(int)$id_parent).'

AND c.active = 1

AND p.id_product IN ('.implode(',', $product_id_list).')

GROUP BY product_shop.id_product

ORDER BY '.Tools::getProductsOrder('by', Tools::getValue('orderby'), true).' '.Tools::getProductsOrder('way', Tools::getValue('orderway')).

' LIMIT '.(((int)$this->page - 1) * $n.','.$n));

}

JODY44 · June 3, 2014

Hi, EL Patron and everyone, heres an update for my problem.

On debug mode I cannot change setting, every time I tried to change it went back to the same setting.

disable non-prestashop modules (no) and disable all overrides (yes) what this indicate to the problem ?

After getting the ISP to change SQL servers, my website seems to work fine now and has not suffered from the awful slowness, and hopefully it will stay that way.

For layered navigation enabled I have some enabled and some disabled but I think that my main problem is sql server and it happened sometime without me making any changes to the settings.

However, I still feel that something is not quite right I recently purchased a popup module from an external developer and have problem where the Popup opens on every page, even if I been and visited that page once, if I go back to that page the popup opens again. I thought their module had a problem.

However, I have just bought another popup Box Notification (Popup) developed by PrestaShop and it has the same problem.

I contacted prestashop, but did not hear from them yet.

Did anyone have the same problem ?

PrestaHeroes USA · June 4, 2014

Hi, EL Patron and everyone, heres an update for my problem.

On debug mode I cannot change setting, every time I tried to change it went back to the same setting.

disable non-prestashop modules (no) and disable all overrides (yes) what this indicate to the problem ?

After getting the ISP to change SQL servers, my website seems to work fine now and has not suffered from the awful slowness, and hopefully it will stay that way.

For layered navigation enabled I have some enabled and some disabled but I think that my main problem is sql server and it happened sometime without me making any changes to the settings.

However, I still feel that something is not quite right I recently purchased a popup module from an external developer and have problem where the Popup opens on every page, even if I been and visited that page once, if I go back to that page the popup opens again. I thought their module had a problem.

However, I have just bought another popup Box Notification (Popup) developed by PrestaShop and it has the same problem.

I contacted prestashop, but did not hear from them yet.

Did anyone have the same problem ?

hi, for new issue, it is best to open new topic, i.e. pop up.

note to enable debug, this is done in config/settings.inc.php (not sure what you were changing)

homefoodfinder · June 15, 2014

Hello El Patron,

Am having a similar problem. With the layered navigation, my site is taking 32 seconds and without it 3 seconds. Not sure what I should be doing.

I have turned on the debug profiling and given the results below. Being a non-techie, am clueless as to what to do with it.

Load time: 31.069s
You'd better run your shop on a toaster

config: 270ms
constructor: 0ms
init: 193ms
checkAccess: 0ms
setMedia: 27ms
postProcess: 0ms
initHeader: 0ms
initContent: 29.816s
initFooter: 18ms
display: 745ms

Hook processing: 29.832s / 21.17 Mb
88 methods called in 34 modules

actionProductListOverride: 28.103s / 1.89 Mb
displayHeader: 1.252s / 10.84 Mb
displayTop: 332ms / 6.09 Mb
displayLeftColumn: 97ms / 1.18 Mb
displayFooter: 17ms / 0.75 Mb
displayProductListReviews: 16ms / 0.07 Mb
displayNav: 11ms / 0.26 Mb
displayBanner: 2ms / 0.06 Mb
displayProductListFunctionalButtons: 1ms / 0.02 Mb
displayTopColumn: 0ms / 0 Mb
moduleRoutes: 0ms / 0 Mb
actionFrontControllerSetMedia: 0ms / 0 Mb
actionProductListModifier: 0ms / 0 Mb
DisplayOverrideTemplate: 0ms / 0 Mb
actionDispatcher: 0ms / 0 Mb

Memory peak usage: 44.2 Mb

config: 11.84 Mb (11.9 Mb)
constructor: 0 Mb (11.9 Mb)
init: 6.42 Mb (18.5 Mb)
checkAccess: 0 Mb (18.5 Mb)
setMedia: 0.48 Mb (18.8 Mb)
postProcess: 0 Mb (18.8 Mb)
initHeader: 0.01 Mb (18.8 Mb)
initContent: 20.69 Mb (39.7 Mb)
initFooter: 0.77 Mb (40.5 Mb)
display: 3.48 Mb (44.2 Mb)

Total cache size (in Cache class): 0 Mb

DB type: DbPDO
SQL Queries: 274 queries
Time spent querying: 28.881s

Included files: 269
Size of included files: 3.34 Mb

Globals (> 1 Ko only): 858 Ko

_MODULES ≈ 581.5 Ko
_LANG ≈ 191.9 Ko
HTTP_SERVER_VARS ≈ 9.3 Ko
_SERVER ≈ 9.3 Ko
HTTP_ENV_VARS ≈ 8.5 Ko
_ENV ≈ 8.5 Ko
_MODULE ≈ 3.7 Ko
_REQUEST ≈ 2.6 Ko
HTTP_COOKIE_VARS ≈ 2.6 Ko
_COOKIE ≈ 2.6 Ko

Stopwatch (with SQL_NO_CACHE) (total = 274)

27866.265 ms SELECT p.*, product_shop.*, product_shop.id_category_default, pl.*, MAX(image_shop.`id_image`) id_image, il.legend, m.name manufacturer_name, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 0 DAY)) > 0 AS new, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity FROM `ps_category_product` cp LEFT JOIN ps_category c ON (c.id_category = cp.id_category) 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_stock_available stock ON (stock.id_product = p.id_product AND stock.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` 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 (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT 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 AND product_attribute_shop.`default_on` = 1) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND c.nleft >= 3 AND c.nright <= 26 AND c.active = 1 AND p.id_product IN (2,3,4,5,6,7,8,9,10,11,14,15,16,17,18,19,20,21,22,23,24,25,26,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,122,123,124,125,126,127,130,133,134,146,147,148,150,151,152,155,156,157,158,159,160,162,163,164,166,167,173,174,176,177,178,179,181) GROUP BY product_shop.id_product ORDER BY pl.name asc LIMIT 0,12
in /modules/blocklayered/blocklayered.php:2012
USING FILESORT - 8568 rows browsed

608.297 ms SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , psi.price_min, psi.price_max 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) INNER JOIN ps_category_product cp ON (cp.id_product = p.id_product) INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 3 AND c.nright <= 26 AND c.active = 1) LEFT JOIN `ps_stock_available` sa ON (sa.id_product = p.id_product AND sa.id_shop = 1) 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 product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY p.id_product
in /modules/blocklayered/blocklayered.php:2304
USING FILESORT - 504 rows browsed
Useless GROUP BY need to be removed

74.956 ms SELECT ctg.`id_group` FROM ps_category_group ctg INNER JOIN ps_customer_group cg on (cg.`id_group` = ctg.`id_group` AND cg.`id_customer` = 13) WHERE ctg.`id_category` = 12 LIMIT 1
in /classes/Category.php:1140
1 row browsed

70.079 ms SELECT COUNT(DISTINCT p.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, psi.price_min, psi.price_max 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_product as 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) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) 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 a.id_attribute_group = 1 AND lpa.`id_shop` = 1 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 INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 3 AND c.nright <= 26 AND c.active = 1) ) GROUP BY lpa.id_attribute ORDER BY ag.`position` ASC, a.`position` ASC
in /modules/blocklayered/blocklayered.php:2304
USING FILESORT - 18144 rows browsed

50.071 ms SELECT * 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 = 21) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

19.839 ms SELECT 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 = 12 AND sl.id_lang = 1 AND s.active = 1 ORDER BY sl.name ASC
in /classes/Scene.php:217
USING FILESORT - 1 row browsed

19.303 ms SELECT p.`id_product` id_product FROM `ps_product` p INNER JOIN ps_category_product cp ON p.id_product = cp.id_product INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 3 AND c.nright <= 26 AND c.active = 1) RIGHT JOIN ps_layered_category lc ON (lc.id_category = 12 AND lc.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 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY id_product
in /modules/blocklayered/blocklayered.php:2023
USING FILESORT - 84 rows browsed
Useless GROUP BY need to be removed

16.432 ms SELECT COUNT(DISTINCT p.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, psi.price_min, psi.price_max 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_product as 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) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) 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 a.id_attribute_group = 2 AND lpa.`id_shop` = 1 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 INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 3 AND c.nright <= 26 AND c.active = 1) ) GROUP BY lpa.id_attribute ORDER BY ag.`position` ASC, a.`position` ASC
in /modules/blocklayered/blocklayered.php:2304
USING FILESORT - 5292 rows browsed

15.264 ms SELECT p.`id_product` id_product FROM `ps_product` p INNER JOIN ps_category_product cp ON p.id_product = cp.id_product INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 3 AND c.nright <= 26 AND c.active = 1) RIGHT JOIN ps_layered_category lc ON (lc.id_category = 12 AND lc.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 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY id_product
in /modules/blocklayered/blocklayered.php:2023
USING FILESORT - 84 rows browsed
Useless GROUP BY need to be removed

15.091 ms SELECT 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
in /classes/shop/Shop.php:629
USING FILESORT - 1 row browsed

14.489 ms SELECT c.*, cl.delay FROM `ps_carrier` c LEFT JOIN `ps_carrier_lang` cl ON (c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_carrier_zone` cz ON (cz.`id_carrier` = c.`id_carrier`)LEFT JOIN `ps_zone` z ON (z.`id_zone` = 3) INNER JOIN ps_carrier_shop carrier_shop ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1) WHERE c.`deleted` = 0 AND c.`active` = 1 AND cz.`id_zone` = 3 AND z.`active` = 1 AND c.id_carrier IN (SELECT id_carrier FROM ps_carrier_group WHERE id_group IN (3)) AND (c.is_module = 0 OR c.need_range = 1) GROUP BY c.`id_carrier` ORDER BY c.`position` ASC
in /classes/Carrier.php:453
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

10.416 ms SELECT 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
in /modules/blocklayered/blocklayered.php:2649
3 rows browsed

9.932 ms SELECT pac.`id_product_attribute`, agl.`public_name` AS public_group_name, al.`name` AS attribute_name FROM `ps_product_attribute_combination` pac LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) LEFT JOIN `ps_attribute_group_lang` agl ON ( ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1 ) WHERE pac.`id_product_attribute` IN (11827) ORDER BY agl.`public_name` ASC
in /classes/Cart.php:717
USING FILESORT - 3 rows browsed

9.306 ms SELECT image_shop.`id_image` id_image, il.`legend` FROM `ps_image` i JOIN `ps_image_shop` image_shop ON (i.id_image = image_shop.id_image 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) WHERE i.`id_product` = 152 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Cart.php:653
1 row browsed

7.612 ms SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.id_address_delivery, product_shop.`wholesale_price`, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, pai.`id_image` as pai_id_image, il.`legend` as pai_legend, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity FROM `ps_cart_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_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 ) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_product_attribute_image` `pai` ON pai.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = pai.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 14) AND (p.`id_product` IS NOT NULL) GROUP BY unique_id ORDER BY p.`id_product`, cp.`id_product_attribute`, cp.`date_add` ASC
in /classes/Cart.php:508
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

5.708 ms SELECT id_carrier FROM `ps_product_carrier` pc INNER JOIN `ps_carrier` c ON c.id_reference = pc.id_carrier_reference AND c.deleted = 0 WHERE (pc.id_product = 152) AND (pc.id_shop = 1)
in /classes/Carrier.php:1202
1 row browsed

5.159 ms SELECT distinct p.id_product FROM ps_product p LEFT JOIN `ps_product_owner` a_po ON p.id_product=a_po.id_product LEFT JOIN `ps_sellerinfo` a_s ON a_po.id_owner=a_s.id_seller LEFT JOIN `ps_sellerinfo_lang` a_sl ON (a_sl.id_sellerinfo=a_s.id_sellerinfo AND a_sl.id_lang=1) WHERE p.id_product IN (2,6,16,17,28,29,41,58,84,138,144,151,152,176,180,181) AND (IFNULL(a_po.approved,0) = 1 OR IFNULL(a_po.id_owner,0)=0)
in /modules/agilemultipleseller/AgileMultipleSellerBase.php:2193
4224 rows browsed

2.449 ms SELECT 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` h INNER JOIN `ps_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) INNER JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position
in /classes/Hook.php:228
USING FILESORT - 67 rows browsed

1.97 ms SELECT 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`)
in /classes/Configuration.php:118
399 rows browsed

1.788 ms SELECT 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` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
in /classes/Hook.php:346
USING FILESORT - 32 rows browsed
Useless GROUP BY need to be removed

1.284 ms SELECT `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
in /classes/Hook.php:131
0 rows browsed

1.048 ms SELECT MAX(image_shop.id_image) id_image, p.id_product, il.legend, product_shop.active, pl.name, pl.description_short, pl.link_rewrite, cl.link_rewrite AS category_rewrite FROM ps_product p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.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 (il.id_image = image_shop.id_image) LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 ) WHERE p.id_product IN (181,180) AND pl.id_lang = 1 AND cl.id_lang = 1 GROUP BY product_shop.id_product
in /modules/blockviewed/blockviewed.php:109
USING FILESORT - 2 rows browsed

0.786 ms SELECT d.`price` FROM `ps_delivery` d INNER JOIN `ps_range_price` r ON d.`id_range_price` = r.`id_range_price` WHERE d.`id_zone` = 3 AND d.`id_carrier` = 8 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_price` = `d`.`id_range_price` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 ) ORDER BY r.`delimiter2` DESC LIMIT 1
in /classes/Carrier.php:373
USING FILESORT - 1 row browsed

0.773 ms SELECT 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 ) WHERE `id_parent` = 12 AND `active` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
in /classes/Category.php:585
USING FILESORT - 3 rows browsed
Useless GROUP BY need to be removed

0.696 ms SELECT t.name, COUNT(pt.id_tag) AS times FROM `ps_product_tag` pt LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE t.`id_lang` = 1 AND product_shop.`active` = 1 GROUP BY t.id_tag ORDER BY times DESC LIMIT 10
in /classes/Tag.php:157
USING FILESORT - 1 row browsed

0.577 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium' LIMIT 1
in /classes/Image.php:377
1 row browsed

0.573 ms SELECT 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
in /classes/Dispatcher.php:461
USING FILESORT - 34 rows browsed

0.569 ms SELECT pa.id_product, a.color, pac.id_product_attribute, 0 qty 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_group ag ON (ag.id_attribute_group = ag.id_attribute_group) WHERE pa.id_product IN (41,84,151,58,99,81,23,22,61,32,80,21) AND ag.is_color_group = 1 GROUP BY pa.id_product, color
in /classes/Product.php:3121
USING FILESORT - 1389 rows browsed
Useless GROUP BY need to be removed

0.568 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 23)
in /classes/Product.php:2701
119 rows browsed

0.568 ms SELECT * 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 = 152) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.539 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 22)
in /classes/Product.php:2701
119 rows browsed

0.534 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 21)
in /classes/Product.php:2701
119 rows browsed

0.47 ms SELECT 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 = 'homefood-finder.com' OR su.domain_ssl = 'homefood-finder.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
in /classes/shop/Shop.php:329
USING FILESORT - 1 row browsed

0.446 ms SELECT 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 = 41 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.442 ms SELECT * 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 = 181) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.433 ms SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =1 AND m.page = "category" LIMIT 1
in /classes/Theme.php:177
1 row browsed

0.425 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 99)
in /classes/Product.php:2701
77 rows browsed

0.416 ms SELECT d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_price` r ON d.`id_range_price` = r.`id_range_price` WHERE d.`id_zone` = 3 AND 70 >= r.`delimiter1` AND 70 < r.`delimiter2` AND d.`id_carrier` = 8 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_price` = `d`.`id_range_price` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 ) ORDER BY r.`delimiter1` ASC LIMIT 1
in /classes/Carrier.php:320
USING FILESORT - 1 row browsed

0.406 ms SELECT * FROM `ps_tax_rule` WHERE `id_country` = 110 AND `id_tax_rules_group` = 0 AND `id_state` IN (0, 336) AND ('600041' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '600041'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /classes/tax/TaxRulesTaxManager.php:90
USING FILESORT - 1 row browsed

0.398 ms 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` = 1 LIMIT 1 ) as mshop FROM `ps_module` m
in /classes/module/Module.php:205
67 rows browsed

0.384 ms SELECT 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
in /classes/Currency.php:443
2 rows browsed

0.375 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "agilesellerproducts" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.372 ms SELECT * 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 = 41) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.37 ms SELECT 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` = 12 AND l.`active` = 1
in /classes/Category.php:1261
1 row browsed

0.368 ms SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `ps_address` WHERE `id_address` = 3 LIMIT 1
in /classes/Address.php:303
1 row browsed

0.357 ms SELECT 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 = 99 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.353 ms SELECT * 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 = 180) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.352 ms SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'left' AND active = 1 ORDER BY item_order ASC
in /modules/themeconfigurator/themeconfigurator.php:330
USING FILESORT - 21 rows browsed

0.347 ms SELECT * 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 = 12) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.347 ms SELECT * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.322 ms SELECT 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 = 32 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.315 ms SELECT SUM((p.`weight` + pa.`weight`) * cp.`quantity`) as nb FROM `ps_cart_product` cp LEFT JOIN `ps_product` p ON (cp.`id_product` = p.`id_product`) LEFT JOIN `ps_product_attribute` pa ON (cp.`id_product_attribute` = pa.`id_product_attribute`) WHERE (cp.`id_product_attribute` IS NOT NULL AND cp.`id_product_attribute` != 0) AND cp.`id_cart` = 14 LIMIT 1
in /classes/Cart.php:2837
1 row browsed

0.315 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "agileshowcasemanager" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.312 ms SELECT 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 = 23 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.31 ms SELECT 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 = 21 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.31 ms SELECT * 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 = 81) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.304 ms SELECT 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 = 84 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.302 ms SELECT * 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 = 99) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.3 ms SELECT al.`name`, agl.`name` as `group` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`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_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 152 AND pac.`id_product_attribute` = 11827 AND agl.`id_lang` = 1
in /classes/Product.php:5077
9 rows browsed

0.297 ms SELECT 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 = 58 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.295 ms SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '3d45e91e50290b5fd872e23cfe6bac3c' LIMIT 1
in /modules/blocklayered/blocklayered.php:1726
1 row browsed

0.294 ms SELECT DISTINCT la.`id_attribute`, la.`url_name` as `name` FROM `ps_attribute` a LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = 152 AND pac.`id_product_attribute` = 11827
in /classes/Product.php:5012
1 row browsed

0.289 ms SELECT * 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 = 22) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.289 ms SELECT 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) ORDER BY s.`name` ASC
in /classes/Supplier.php:123
USING FILESORT - 1 row browsed

0.288 ms SELECT 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 = 22 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.287 ms SELECT 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 = 151 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.286 ms SELECT * 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 = 84) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.286 ms SELECT * 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 = 58) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.284 ms SELECT 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 = 81 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.283 ms SELECT * 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 = 151) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.282 ms SELECT * 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 = 23) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.282 ms SELECT * 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 = 61) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.281 ms SELECT 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 = 61 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.281 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 41 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.278 ms SELECT * FROM ps_layered_category WHERE id_category = 12 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
in /modules/blocklayered/blocklayered.php:2052
USING FILESORT - 3 rows browsed
Useless GROUP BY need to be removed

0.277 ms SELECT * 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 = 32) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.275 ms SELECT * 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 = 80) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.275 ms SELECT w.`id_wishlist`, w.`name`, w.`token`, w.`date_add`, w.`date_upd`, w.`counter` FROM `ps_wishlist` w WHERE `id_customer` = 13 AND id_shop = 1 ORDER BY w.`name` ASC
in /modules/blockwishlist/WishList.php:192
USING FILESORT - 1 row browsed

0.275 ms SELECT 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 = 80 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed

0.274 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 99 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.273 ms SELECT * FROM `ps_cart` a WHERE (a.id_cart = 14) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.269 ms SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'footer' AND active = 1 ORDER BY item_order ASC
in /modules/themeconfigurator/themeconfigurator.php:330
USING FILESORT - 21 rows browsed

0.269 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 58 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.263 ms SELECT * 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 = 152) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.261 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'category_default-bootstrap' LIMIT 1
in /classes/ImageType.php:141
1 row browsed

0.259 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 61 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.256 ms SELECT 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
in /classes/Language.php:818
1 row browsed

0.255 ms SELECT * 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
in /classes/Currency.php:219
USING FILESORT - 1 row browsed

0.253 ms SELECT * FROM `ps_carrier` a LEFT JOIN `ps_carrier_lang` `b` ON a.id_carrier = b.id_carrier AND b.id_lang = 1 LEFT JOIN `ps_carrier_shop` `c` ON a.id_carrier = c.id_carrier AND c.id_shop = 1 WHERE (a.id_carrier = 8) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.245 ms SELECT * 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
in /classes/ObjectModel.php:212
1 row browsed

0.243 ms SELECT * 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
in /classes/ObjectModel.php:212
1 row browsed

0.243 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 41)
in /classes/Product.php:2701
7 rows browsed

0.24 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 81)
in /classes/Product.php:2701
5 rows browsed

0.24 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 32 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.238 ms SELECT c.id_carrier FROM `ps_warehouse_carrier` wc INNER JOIN `ps_carrier` c ON c.id_reference = wc.id_carrier WHERE (id_warehouse = 0) AND (c.deleted = 0)
in /classes/stock/Warehouse.php:147
1 row browsed

0.235 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 81 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.234 ms SELECT IFNULL(is_default,0) AS is_default FROM ps_carrier_owner WHERE id_carrier=8 LIMIT 1
in /override/classes/Carrier.php:21
8 rows browsed

0.234 ms SELECT * 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 = 12) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.233 ms SELECT domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1
in /classes/shop/ShopUrl.php:154
1 row browsed

0.233 ms SELECT 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
in /modules/blocklayered/blocklayered.php:2659
5 rows browsed

0.232 ms SELECT DISTINCT la.`id_attribute`, la.`url_name` as `name` FROM `ps_attribute` a LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = 152 AND pac.`id_product_attribute` = 11827
in /classes/Product.php:5012
1 row browsed

0.231 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 152)
in /classes/Product.php:2701
2 rows browsed

0.23 ms SELECT 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 ) WHERE c.nleft <= 3 AND c.nright >= 26 AND c.nleft >= 2 AND c.nright <= 115 AND cl.id_lang = 1 AND c.active = 1 AND c.level_depth > 1 ORDER BY c.level_depth ASC
in /classes/Tools.php:1052
USING FILESORT - 2 rows browsed

0.229 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 32)
in /classes/Product.php:2701
7 rows browsed

0.225 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 23 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.224 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 80)
in /classes/Product.php:2701
2 rows browsed

0.223 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 84 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.223 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 99) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.222 ms SELECT SUM(p.`weight` * cp.`quantity`) as nb FROM `ps_cart_product` cp LEFT JOIN `ps_product` p ON (cp.`id_product` = p.`id_product`) WHERE (cp.`id_product_attribute` IS NULL OR cp.`id_product_attribute` = 0) AND cp.`id_cart` = 14 LIMIT 1
in /classes/Cart.php:2846
1 row browsed

0.222 ms SELECT * FROM `ps_hook_alias`
in /classes/Hook.php:183
86 rows browsed

0.219 ms SELECT * 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 = 3) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.218 ms SELECT 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
in /classes/shop/Shop.php:199
1 row browsed

0.218 ms SELECT * FROM `ps_tax_rule` WHERE `id_country` = 110 AND `id_tax_rules_group` = 0 AND `id_state` IN (0, 0) AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /classes/tax/TaxRulesTaxManager.php:90
USING FILESORT - 1 row browsed

0.217 ms SELECT * 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 = 110) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.215 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 151)
in /classes/Product.php:2701
4 rows browsed

0.214 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 99 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.213 ms SELECT * FROM `ps_carrier` a LEFT JOIN `ps_carrier_shop` `c` ON a.id_carrier = c.id_carrier AND c.id_shop = 1 WHERE (a.id_carrier = 8) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.213 ms SELECT `id_tax_rules_group` FROM `ps_carrier_tax_rules_group_shop` WHERE `id_carrier` = 8 AND id_shop=1 LIMIT 1
in /classes/Carrier.php:983
1 row browsed

0.213 ms SELECT count(distinct id_address_delivery) FROM `ps_cart_product` cp WHERE (id_cart = 14) LIMIT 1
in /classes/Cart.php:2307
1 row browsed

0.211 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 22 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.211 ms SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)
in /classes/module/Module.php:1717
3 rows browsed

0.209 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 84)
in /classes/Product.php:2701
2 rows browsed

0.205 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 58)
in /classes/Product.php:2701
1 row browsed

0.204 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 (p.`id_product` = 61)
in /classes/Product.php:2701
1 row browsed

0.202 ms SELECT (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` = 81 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.199 ms SELECT (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` = 61 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.198 ms SELECT id_feature, id_product, id_feature_value FROM `ps_feature_product` WHERE `id_product` IN (152)
in /classes/Product.php:3353
5 rows browsed

0.196 ms SELECT (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` = 23 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.196 ms SELECT SUM(`quantity`) FROM `ps_cart_product` WHERE `id_cart` = 14 LIMIT 1
in /classes/Cart.php:762
1 row browsed

0.193 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 32) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.192 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 152) AND (id_product_attribute = 11827) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.192 ms SELECT * FROM `ps_group_lang` WHERE `id_group` = 3
in /classes/ObjectModel.php:219
3 rows browsed

0.19 ms SELECT (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` = 99 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.189 ms SELECT * 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 = 110) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.189 ms SELECT * FROM `ps_carrier_lang` WHERE `id_carrier` = 8 AND `id_shop` = 1
in /classes/ObjectModel.php:219
12 rows browsed

0.188 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "agilesellerratings" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.187 ms SELECT * 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 = 23) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.185 ms SELECT * 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
in /classes/ObjectModel.php:212
1 row browsed

0.185 ms SELECT l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
in /classes/Language.php:711
1 row browsed

0.185 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 12 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.185 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 41) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.184 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'medium_default-bootstrap' LIMIT 1
in /classes/ImageType.php:141
1 row browsed

0.183 ms SELECT (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` = 58 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.183 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 22) AND (id_product_attribute = 3256) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.181 ms SELECT * FROM `ps_customer` a WHERE (a.id_customer = 13) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.181 ms SELECT s.`id_zone` AS id_zone_state, c.`id_zone` FROM `ps_address` a LEFT JOIN `ps_country` c ON c.`id_country` = a.`id_country` LEFT JOIN `ps_state` s ON s.`id_state` = a.`id_state` WHERE a.`id_address` = 3 LIMIT 1
in /classes/Address.php:250
1 row browsed

0.18 ms SELECT * 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
in /classes/ObjectModel.php:212
1 row browsed

0.179 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 99 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.178 ms SELECT * FROM `ps_category_lang` WHERE `id_category` = 12 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed

0.178 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 23) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.178 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.177 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21) AND (id_product_attribute = 3137) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.175 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 58) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.175 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 99) AND (id_product_attribute = 5307) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.175 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 41) AND (id_product_attribute = 4173) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.174 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 22) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.172 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 151) AND (id_product_attribute = 11823) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.172 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 151) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.171 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 81) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.17 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 84) AND (id_product_attribute = 4337) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.169 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 23) AND (id_product_attribute = 3375) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.168 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 21 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.167 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 32) AND (id_product_attribute = 4110) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.167 ms SELECT COUNT(*) FROM ps_layered_category WHERE id_category = 12 AND id_shop = 1 LIMIT 1
in /modules/blocklayered/blocklayered.php:646
3 rows browsed

0.166 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 84) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.165 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 61) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.165 ms SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '3d45e91e50290b5fd872e23cfe6bac3c' LIMIT 1
in /modules/blocklayered/blocklayered.php:1726
1 row browsed

0.165 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 80) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.164 ms SELECT `id_address` FROM `ps_address` WHERE `id_customer` = 13 AND `id_address` = 3 AND `deleted` = 0 LIMIT 1
in /classes/Customer.php:426
1 row browsed

0.164 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 61 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.163 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 81 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.162 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'm_scene_default-bootstrap' LIMIT 1
in /classes/ImageType.php:141
2 rows browsed

0.161 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 61) AND (id_product_attribute = 4218) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.161 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 23 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.161 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 81) AND (id_product_attribute = 4324) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.16 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 58) AND (id_product_attribute = 4215) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.16 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "agilesellershipping" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.159 ms SELECT * FROM `ps_country_lang` WHERE `id_country` = 110
in /classes/ObjectModel.php:219
2 rows browsed

0.159 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 80) AND (id_product_attribute = 4322) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.159 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 152 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed

0.158 ms SELECT c.`active` FROM `ps_address` a LEFT JOIN `ps_country` c ON c.`id_country` = a.`id_country` WHERE a.`id_address` = 3 LIMIT 1
in /classes/Address.php:274
1 row browsed

0.157 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 80 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.155 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 58 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.154 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.152 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "agilemembership" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.152 ms SELECT IFNULL(is_default,0) AS is_default FROM ps_carrier_owner WHERE id_carrier=8 LIMIT 1
in /override/classes/Carrier.php:21
8 rows browsed

0.152 ms SELECT (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` = 32 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.151 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "agilesellerlistoptions" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.151 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "agileprepaidcredit" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.149 ms SELECT (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` = 41 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.149 ms SELECT 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` = 3137 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.148 ms SELECT (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` = 22 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.148 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "agilemultipleseller" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.148 ms SELECT * FROM `ps_address` a WHERE (a.id_address = 3) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.148 ms SELECT (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` = 151 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.147 ms SELECT IFNULL(is_default,0) AS is_default FROM ps_carrier_owner WHERE id_carrier=8 LIMIT 1
in /override/classes/Carrier.php:21
8 rows browsed

0.147 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 151 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.146 ms SELECT (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` = 84 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.146 ms SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description` FROM `ps_category_lang` cl WHERE cl.`id_lang` = 1 AND cl.`id_category` = 12 AND cl.id_shop = 1 LIMIT 1
in /classes/Meta.php:282
1 row browsed

0.145 ms SELECT (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` = 80 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.144 ms SELECT (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` = 21 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed

0.143 ms SELECT `id_customer` FROM `ps_customer` WHERE `id_customer` = '13' AND active = 1 AND `deleted` = 0 LIMIT 1
in /classes/Customer.php:373
1 row browsed

0.143 ms SELECT 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` = 4324 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.141 ms SELECT 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` = 5307 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.141 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 152 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.141 ms SELECT * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.14 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 151 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed

0.14 ms SELECT 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` = 3256 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.14 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT 1
in /classes/Image.php:377
1 row browsed

0.14 ms SELECT IFNULL(is_default,0) AS is_default FROM ps_carrier_owner WHERE id_carrier=8 LIMIT 1
in /override/classes/Carrier.php:21
8 rows browsed

0.14 ms SELECT SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = 152 AND `id_cart` = 14 LIMIT 1
in /classes/Product.php:2552
1 row browsed

0.139 ms SELECT 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` = 4173 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.138 ms SELECT IFNULL(is_default,0) AS is_default FROM ps_carrier_owner WHERE id_carrier=8 LIMIT 1
in /override/classes/Carrier.php:21
8 rows browsed

0.138 ms SELECT 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` = 4322 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.138 ms SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '9670c086f6722d215f86f1f85e32c8d6' LIMIT 1
in /modules/blocklayered/blocklayered.php:1726
1 row browsed

0.138 ms SELECT IFNULL(is_default,0) AS is_default FROM ps_carrier_owner WHERE id_carrier=8 LIMIT 1
in /override/classes/Carrier.php:21
8 rows browsed

0.138 ms SELECT `id_customer` FROM `ps_customer` WHERE `id_customer` = 13 AND `passwd` = 'd423007615e9a680b6c2bcd768c9712d' LIMIT 1
in /classes/Customer.php:496
1 row browsed

0.137 ms SELECT IFNULL(is_default,0) AS is_default FROM ps_carrier_owner WHERE id_carrier=8 LIMIT 1
in /override/classes/Carrier.php:21
8 rows browsed

0.137 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 21 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.137 ms SELECT 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` = 4215 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.137 ms SELECT count(*) FROM `ps_orders` WHERE `id_cart` = 14 LIMIT 1
in /classes/Cart.php:1114
1 row browsed

0.137 ms SELECT IFNULL(is_default,0) AS is_default FROM ps_carrier_owner WHERE id_carrier=8 LIMIT 1
in /override/classes/Carrier.php:21
8 rows browsed

0.136 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'home_default-bootstrap' LIMIT 1
in /classes/ImageType.php:141
1 row browsed

0.135 ms SELECT 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` = 3375 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.135 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'default-bootstrap_category' LIMIT 1
in /classes/ImageType.php:141
1 row browsed

0.135 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'default-bootstrap_medium' LIMIT 1
in /classes/ImageType.php:141
1 row browsed

0.134 ms SELECT `id_address` FROM ps_address a WHERE a.`id_address` = 0 LIMIT 1
in /classes/Address.php:321
0 rows browsed

0.134 ms SELECT 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` = 4337 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.134 ms SELECT 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` = 11823 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.133 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 84 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.133 ms SELECT 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` = 4110 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.133 ms SELECT 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` = 4218 LIMIT 1
in /classes/Combination.php:320
1 row browsed

0.133 ms SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '3d45e91e50290b5fd872e23cfe6bac3c' LIMIT 1
in /modules/blocklayered/blocklayered.php:1726
1 row browsed

0.132 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'default-bootstrap_m_scene' LIMIT 1
in /classes/ImageType.php:141
1 row browsed

0.131 ms SELECT id_shop FROM `ps_group_shop` WHERE `id_group` = 3 AND id_shop = 1 LIMIT 1
in /classes/ObjectModel.php:1250
1 row browsed

0.131 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'default-bootstrap_home' LIMIT 1
in /classes/ImageType.php:141
1 row browsed

0.13 ms SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '3d45e91e50290b5fd872e23cfe6bac3c' LIMIT 1
in /modules/blocklayered/blocklayered.php:1726
1 row browsed

0.13 ms SELECT `name` FROM `ps_country_lang` WHERE `id_lang` = 1 AND `id_country` = 110 LIMIT 1
in /classes/Country.php:205
1 row browsed

0.13 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 55 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.129 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 13 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.127 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 32 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.126 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 41 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.126 ms SELECT * FROM `ps_theme` a WHERE (a.id_theme = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.126 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 22 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.125 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1
in /classes/Image.php:377
1 row browsed

0.125 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 80 AND `validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:240
1 row browsed

0.124 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'm_scene_default' LIMIT 1
in /classes/Image.php:377
1 row browsed

0.123 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT 1
in /classes/Image.php:377
1 row browsed

0.123 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "agilemultipleshop" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.123 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 14 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.121 ms SELECT `id_address` FROM ps_address a WHERE a.`id_address` = 3 LIMIT 1
in /classes/Address.php:321
1 row browsed

0.12 ms SELECT id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1
in /classes/ObjectModel.php:1250
1 row browsed

0.119 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 12 LIMIT 1
in /classes/Category.php:904
0 rows browsed

0.119 ms SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = 12 LIMIT 1
in /classes/Category.php:1279
1 row browsed

0.118 ms SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 72 AND `id_shop` = 1 LIMIT 1
in /classes/module/Module.php:1780
1 row browsed

0.118 ms SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1
in /classes/ObjectModel.php:1250
1 row browsed

0.118 ms SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '9670c086f6722d215f86f1f85e32c8d6' LIMIT 1
in /modules/blocklayered/blocklayered.php:1726
1 row browsed

0.117 ms SELECT id_feature FROM ps_layered_indexable_feature WHERE indexable = 0
in /modules/blocklayered/blocklayered.php:750
5 rows browsed

0.117 ms SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '9670c086f6722d215f86f1f85e32c8d6' LIMIT 1
in /modules/blocklayered/blocklayered.php:1726
1 row browsed

0.116 ms SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = 2 LIMIT 1
in /classes/Category.php:1279
1 row browsed

0.116 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 22 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.116 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 23 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.116 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 84 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.115 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.115 ms SELECT id_shop FROM `ps_category_shop` WHERE `id_category` = 12 AND id_shop = 1 LIMIT 1
in /classes/ObjectModel.php:1250
1 row browsed

0.114 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 41 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.113 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 81 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.113 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 80 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.112 ms SELECT id_attribute_group FROM ps_layered_indexable_attribute_group WHERE indexable = 0
in /modules/blocklayered/blocklayered.php:748
3 rows browsed

0.112 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 58 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.112 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 32 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.111 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 151 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

Doubles (IDs replaced by "XX") (total = 20)25 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) LIMIT XX15 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = XX LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = XXWHERE (a.id_product = XX) AND (b.id_shop = XX) LIMIT XX13 SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.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 = XX) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 = XX) WHERE (p.`id_product` = XX)13 SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX12 SELECT 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 = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX12 SELECT 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 = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC12 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 XX12 SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX12 SELECT (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` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX8 SELECT IFNULL(is_default,XX) AS is_default FROM ps_carrier_owner WHERE id_carrier=XX LIMIT XX5 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX4 SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = 'XXcXXfXXdXXfXXfXXfXXeXXcXXdXX' LIMIT XX4 SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = 'XXdXXeXXeXXbXXfdXXeXXcfeXXbacXXc' LIMIT XX4 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 XX2 SELECT `id_address` FROM ps_address a WHERE a.`id_address` = XX LIMIT XX2 SELECT COUNT(DISTINCT p.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, psi.price_min, psi.price_max 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 = XX INNER JOIN ps_product as 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 = XX LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = XX) LEFT JOIN ps_layered_indexable_attribute_lang_value lial ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = XX) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN `ps_layered_price_index` psi ON (psi.id_product = p.id_product AND psi.id_currency = XX AND psi.id_shop=XX) WHERE a.id_attribute_group = XX AND lpa.`id_shop` = XX AND product_shop.active = XX AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN ( SELECT id_product FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= XX AND c.nright <= XX AND c.active = XX) ) GROUP BY lpa.id_attribute ORDER BY ag.`position` ASC, a.`position` ASC2 SELECT p.`id_product` id_product FROM `ps_product` p INNER JOIN ps_category_product cp ON p.id_product = cp.id_product INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= XXAND c.nright <= XX AND c.active = XX) RIGHT JOIN ps_layered_category lc ON (lc.id_category = XX AND lc.id_shop = XX) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE XX AND product_shop.`active` = XX AND product_shop.`visibility` IN ("both", "catalog") GROUP BY id_product2 SELECT DISTINCT la.`id_attribute`, la.`url_name` as `name` FROM `ps_attribute` a LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = XX) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = XX AND pac.`id_product_attribute` = XX2 SELECT * FROM `ps_tax_rule` WHERE `id_country` = XX AND `id_tax_rules_group` = XX AND `id_state` IN (XX, XX) AND ('XX' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = XX AND `zipcode_from` IN(XX, 'XX'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC2 SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX

Tables stress51 product_shop41 product36 product_comment32 product_attribute31 product_attribute_shop28 stock_available19 product_lang16 category_lang15 category13 module13 feature_lang13 feature_product13 image_type12 feature_shop12 feature12 feature_value_lang8 carrier_owner8 layered_friendly_url7 address7 category_shop7 attribute6 category_product6 cart_product5 attribute_group_lang5 product_attribute_combination5 carrier4 lang4 shop_url4 shop4 layered_category4 module_shop4 layered_indexable_attribute_lang_value4 delivery4 country4 lang_shop4 currency_shop4 image_lang4 hook4 attribute_group4 attribute_lang3 theme3 layered_price_index3 image3 carrier_shop3 customer3 carrier_lang3 image_shop3 currency3 country_lang2 themeconfigurator2 country_shop2 hook_module2 tax_rule2 layered_indexable_attribute_group2 shop_group2 range_price2 layered_indexable_feature2 meta2 group_shop2 layered_indexable_attribute_group_lang_value2 hook_alias2 layered_product_attribute1 product_tag1 tag1 carrier_tax_rules_group_shop1 wishlist1 category_group1 customer_group1 orders1 manufacturer1 supplier_lang1 supplier_shop1 meta_lang1 supplier1 cart1 carrier_group1 group1 group_lang1 zone1 sellerinfo_lang1 sellerinfo1 product_owner1 product_attribute_image1 configuration1 theme_meta1 product_supplier1 configuration_lang1 hook_module_exceptions1 product_carrier1 scene1 carrier_zone1 state1 scene_shop1 scene_lang1 warehouse_carrier1 scene_category

ObjectModel instances18 Product13 Category8 Carrier6 Address3 Customer3 Country2 Language1 Warehouse1 ConnectionsSource1 Currency1 Theme1 ShopGroup1 Shop1 Cart1 Group

Included files1 ./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 tools/profiling/Controller.php
10 classes/controller/Controller.php
11 tools/profiling/ObjectModel.php
12 classes/ObjectModel.php
13 tools/profiling/Hook.php
14 classes/Hook.php
15 tools/profiling/Db.php
16 classes/db/Db.php
17 tools/profiling/Tools.php
18 classes/Tools.php
19 classes/Context.php
20 classes/shop/Shop.php
21 override/classes/shop/Shop.php
22 config/db_slave_server.inc.php
23 classes/db/DbPDO.php
24 classes/cache/Cache.php
25 classes/Validate.php
26 classes/db/DbQuery.php
27 classes/module/Module.php
28 override/classes/module/Module.php
29 classes/Theme.php
30 config/defines_uri.inc.php
31 classes/Configuration.php
32 classes/Language.php
33 override/classes/Language.php
34 classes/Country.php
35 classes/PrestaShopCollection.php
36 classes/shop/ShopGroup.php
37 classes/Cookie.php
38 override/classes/Cookie.php
39 classes/Rijndael.php
40 classes/Customer.php
41 override/classes/Customer.php
42 classes/Link.php
43 override/classes/Link.php
44 classes/shop/ShopUrl.php
45 config/smarty.config.inc.php
46 tools/smarty/Smarty.class.php
47 tools/smarty/sysplugins/smarty_internal_data.php
48 tools/smarty/sysplugins/smarty_internal_templatebase.php
49 tools/smarty/sysplugins/smarty_internal_template.php
50 tools/smarty/sysplugins/smarty_resource.php
51 tools/smarty/sysplugins/smarty_internal_resource_file.php
52 tools/smarty/sysplugins/smarty_cacheresource.php
53 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
54 config/smartyfront.config.inc.php
55 classes/Dispatcher.php
56 override/classes/Dispatcher.php
57 classes/Group.php
58 tools/mobile_Detect/Mobile_Detect.php
59 controllers/front/CategoryController.php
60 classes/controller/FrontController.php
61 override/classes/controller/FrontController.php
62 override/controllers/front/CategoryController.php
63 classes/Category.php
64 override/classes/Category.php
65 themes/default-bootstrap/lang/en.php
66 classes/Currency.php
67 classes/Cart.php
68 override/classes/Cart.php
69 classes/Meta.php
70 classes/Product.php
71 override/classes/Product.php
72 classes/webservice/WebserviceRequest.php
73 classes/Address.php
74 classes/AgileHelper.php
75 classes/Media.php
76 classes/Scene.php
77 modules/socialsharing/socialsharing.php
78 classes/Translate.php
79 themes/default-bootstrap/modules/socialsharing/translations/en.php
80 modules/socialsharing/translations/en.php
81 modules/blockbanner/blockbanner.php
82 themes/default-bootstrap/modules/blockbanner/translations/en.php
83 modules/blockbanner/translations/en.php
84 modules/blockbestsellers/blockbestsellers.php
85 themes/default-bootstrap/modules/blockbestsellers/translations/en.php
86 modules/blockbestsellers/translations/en.php
87 modules/blockcart/blockcart.php
88 themes/default-bootstrap/modules/blockcart/translations/en.php
89 modules/blockcart/translations/en.php
90 modules/blocksocial/blocksocial.php
91 themes/default-bootstrap/modules/blocksocial/translations/en.php
92 modules/blocksocial/translations/en.php
93 modules/blockcategories/blockcategories.php
94 themes/default-bootstrap/modules/blockcategories/translations/en.php
95 modules/blockcategories/translations/en.php
96 modules/blockcurrencies/blockcurrencies.php
97 themes/default-bootstrap/modules/blockcurrencies/translations/en.php
98 modules/blockcurrencies/translations/en.php
99 modules/blockfacebook/blockfacebook.php
100 themes/default-bootstrap/modules/blockfacebook/translations/en.php
101 modules/blockfacebook/translations/en.php
102 modules/blocklanguages/blocklanguages.php
103 themes/default-bootstrap/modules/blocklanguages/translations/en.php
104 modules/blocklanguages/translations/en.php
105 modules/blockcms/blockcms.php
106 modules/blockcms/BlockCMSModel.php
107 themes/default-bootstrap/modules/blockcms/translations/en.php
108 modules/blockcms/translations/en.php
109 modules/blockcontact/blockcontact.php
110 themes/default-bootstrap/modules/blockcontact/translations/en.php
111 modules/blockcontact/translations/en.php
112 modules/blockcontactinfos/blockcontactinfos.php
113 themes/default-bootstrap/modules/blockcontactinfos/translations/en.php
114 modules/blockcontactinfos/translations/en.php
115 modules/blockmyaccount/blockmyaccount.php
116 themes/default-bootstrap/modules/blockmyaccount/translations/en.php
117 modules/blockmyaccount/translations/en.php
118 modules/blockmyaccountfooter/blockmyaccountfooter.php
119 themes/default-bootstrap/modules/blockmyaccountfooter/translations/en.php
120 modules/blockmyaccountfooter/translations/en.php
121 modules/blocknewsletter/blocknewsletter.php
122 themes/default-bootstrap/modules/blocknewsletter/translations/en.php
123 modules/blocknewsletter/translations/en.php
124 modules/blockpaymentlogo/blockpaymentlogo.php
125 themes/default-bootstrap/modules/blockpaymentlogo/translations/en.php
126 modules/blockpaymentlogo/translations/en.php
127 modules/blocksearch/blocksearch.php
128 themes/default-bootstrap/modules/blocksearch/translations/en.php
129 modules/blocksearch/translations/en.php
130 modules/blockspecials/blockspecials.php
131 themes/default-bootstrap/modules/blockspecials/translations/en.php
132 modules/blockspecials/translations/en.php
133 modules/blocktags/blocktags.php
134 themes/default-bootstrap/modules/blocktags/translations/en.php
135 modules/blocktags/translations/en.php
136 modules/blockuserinfo/blockuserinfo.php
137 themes/default-bootstrap/modules/blockuserinfo/translations/en.php
138 modules/blockuserinfo/translations/en.php
139 modules/blockviewed/blockviewed.php
140 themes/default-bootstrap/modules/blockviewed/translations/en.php
141 modules/blockviewed/translations/en.php
142 modules/homeslider/homeslider.php
143 modules/homeslider/HomeSlide.php
144 themes/default-bootstrap/modules/homeslider/translations/en.php
145 modules/homeslider/translations/en.php
146 modules/homefeatured/homefeatured.php
147 themes/default-bootstrap/modules/homefeatured/translations/en.php
148 modules/homefeatured/translations/en.php
149 modules/themeconfigurator/themeconfigurator.php
150 themes/default-bootstrap/modules/themeconfigurator/translations/en.php
151 modules/themeconfigurator/translations/en.php
152 modules/blockwishlist/blockwishlist.php
153 themes/default-bootstrap/modules/blockwishlist/translations/en.php
154 modules/blockwishlist/translations/en.php
155 modules/productcomments/productcomments.php
156 themes/default-bootstrap/modules/productcomments/translations/en.php
157 modules/productcomments/translations/en.php
158 modules/sendtoafriend/sendtoafriend.php
159 themes/default-bootstrap/modules/sendtoafriend/translations/en.php
160 modules/sendtoafriend/translations/en.php
161 modules/agilemultipleseller/agilemultipleseller.php
162 modules/agilemultipleseller/AgileMultipleSellerBase.php
163 classes/AgileInstaller.php
164 themes/default-bootstrap/modules/agilemultipleseller/translations/en.php
165 modules/agilemultipleseller/translations/en.php
166 classes/AgileSellerManager.php
167 modules/blocklayered/blocklayered.php
168 themes/default-bootstrap/modules/blocklayered/translations/en.php
169 modules/blocklayered/translations/en.php
170 modules/ebspayment/ebspayment.php
171 classes/PaymentModule.php
172 override/classes/PaymentModule.php
173 modules/ebspayment/backmain.php
174 cache/smarty/cache/blocksearch_top/1/110/dd/bb/82/ddbb82da0e3803a219a327e90c30ce0afcd23076.blocksearch-top.tpl.php
175 classes/Combination.php
176 classes/stock/StockAvailable.php
177 classes/Customization.php
178 classes/Feature.php
179 classes/tax/Tax.php
180 classes/SpecificPrice.php
181 classes/tax/TaxManagerFactory.php
182 classes/tax/TaxRulesTaxManager.php
183 classes/tax/TaxManagerInterface.php
184 classes/tax/TaxCalculator.php
185 classes/GroupReduction.php
186 classes/CartRule.php
187 classes/ProductDownload.php
188 override/classes/ProductDownload.php
189 classes/stock/Warehouse.php
190 classes/Carrier.php
191 override/classes/Carrier.php
192 cache/smarty/compile/f6/43/6e/f6436e8bdddccda6b5a5910fdaae3390c82865c3.file.blockcart.tpl.php
193 tools/smarty/plugins/modifier.replace.php
194 tools/smarty/plugins/function.counter.php
195 tools/smarty/sysplugins/smarty_internal_filter_handler.php
196 tools/minify_html/minify_html.class.php
197 modules/blocktopmenu/blocktopmenu.php
198 modules/blocktopmenu/menutoplinks.class.php
199 themes/default-bootstrap/modules/blocktopmenu/translations/en.php
200 modules/blocktopmenu/translations/en.php
201 cache/smarty/cache/blocktopmenu/0/category/1/3/1/12/0/0/0/0/8c/07/4f/8c074f800d068f5933c80e1aac125efdb092546c.blocktopmenu.tpl.php
202 cache/smarty/compile/dc/40/9c/dc409c7be32dcbaa7ed940b88904ac24667b834a.file.blockuserinfo.tpl.php
203 modules/pagesnotfound/pagesnotfound.php
204 themes/default-bootstrap/modules/pagesnotfound/translations/en.php
205 modules/pagesnotfound/translations/en.php
206 modules/sekeywords/sekeywords.php
207 classes/module/ModuleGraph.php
208 themes/default-bootstrap/modules/sekeywords/translations/en.php
209 modules/sekeywords/translations/en.php
210 modules/blockwishlist/WishList.php
211 cache/smarty/compile/d3/0c/c0/d30cc023dbbfecad71ab6e3a8aab2ce9fdc71660.file.blockwishlist_top.tpl.php
212 cache/smarty/cache/blockcategories/1/110/12/12/3/aa/c1/45/aac145405b9204be03a9ddbfa2652dc4db53f0de.blockcategories.tpl.php
213 cache/smarty/cache/blockcms/0/1/110/8d/46/48/8d46485da4230ce99ea8491f31723d471b9a3a44.blockcms.tpl.php
214 classes/Tag.php
215 classes/Image.php
216 cache/smarty/compile/e6/87/a6/e687a6803298a40533ee53eb2e9ff5a145a5f94a.file.blockviewed.tpl.php
217 cache/smarty/compile/72/a8/cb/72a8cbd13e78b24ccda73c17fd2fb03072bc9c7a.file.hook.tpl.php
218 cache/smarty/compile/56/53/ef/5653ef23f717038d8a5f3ad40364390ad26e9674.file.blocklayered.tpl.php
219 classes/ImageType.php
220 classes/Supplier.php
221 override/classes/Supplier.php
222 cache/smarty/compile/91/bd/af/91bdaf4534c11ee4133ee750b425a3a31a41a995.file.blocknewsletter.tpl.php
223 cache/smarty/cache/blocksocial/1/110/d8/e0/0c/d8e00cee90bf15c9f0d9457656c613b6d148cfc2.blocksocial.tpl.php
224 cache/smarty/cache/blockcategories/1/110/12/3/f6/92/e4/f692e421323e922deedbbe29ae91e55cad581e49.blockcategories_footer.tpl.php
225 cache/smarty/cache/blockcms/2/1/110/8d/46/48/8d46485da4230ce99ea8491f31723d471b9a3a44.blockcms.tpl.php
226 cache/smarty/cache/blockmyaccountfooter/1/110/a1/19/1c/a1191cdfd60b8e36d87aa3a86782d1d80d5100f3.blockmyaccountfooter.tpl.php
227 cache/smarty/cache/blockcontactinfos/1/110/a6/98/ed/a698eded4a4450c1b76a19163adba45b15de8bc3.blockcontactinfos.tpl.php
228 modules/statsdata/statsdata.php
229 themes/default-bootstrap/modules/statsdata/translations/en.php
230 modules/statsdata/translations/en.php
231 classes/Connection.php
232 classes/ConnectionsSource.php
233 cache/smarty/compile/d0/95/d1/d095d1714a47b6ec9f272c30ffeae72d395853d3.file.category.tpl.php
234 cache/smarty/compile/ec/9a/16/ec9a1638274f238c32e441216fdfe68190255292.file.errors.tpl.php
235 cache/smarty/compile/ff/25/23/ff2523d0481303bb11229d02efcce36a94f3bfc4.file.category-count.tpl.php
236 cache/smarty/compile/cb/9c/e5/cb9ce59f8ef2e44fefc6f613979a580b724b8ffc.file.product-sort.tpl.php
237 cache/smarty/compile/81/e4/e8/81e4e84174ace81ae2f82990afef5894f1b6ed61.file.nbr-product-page.tpl.php
238 cache/smarty/compile/a0/49/d9/a049d9328e4481ed7f2f468ea64d35220658b645.file.product-compare.tpl.php
239 cache/smarty/compile/34/92/53/349253976112618178b365a5d984fd607cbc3b7c.file.pagination.tpl.php
240 cache/smarty/compile/2a/cb/62/2acb62d9994cea37b9321f2b319673fc8afe4797.file.product-list.tpl.php
241 tools/smarty/plugins/function.math.php
242 modules/productcomments/ProductComment.php
243 cache/smarty/cache/41/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
244 cache/smarty/compile/e3/88/77/e388778a1f800d5cdb4947d1a1084d6b8dcb0921.file.blockwishlist_button.tpl.php
245 cache/smarty/cache/84/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
246 cache/smarty/cache/151/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
247 cache/smarty/cache/58/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
248 cache/smarty/cache/99/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
249 cache/smarty/cache/81/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
250 cache/smarty/cache/23/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
251 cache/smarty/cache/22/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
252 cache/smarty/cache/61/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
253 cache/smarty/cache/32/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
254 cache/smarty/cache/80/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
255 cache/smarty/cache/21/1/110/08/6b/f7/086bf74a31c1b2207c028d193f9929f26c151e19.productcomments_reviews.tpl.php
256 cache/smarty/compile/0d/bf/ae/0dbfaec81ca39ac62ed9b14ee9bd097dfefb9e70.file.layout.tpl.php
257 cache/smarty/compile/88/61/4a/88614a11ffa051846743031fad240ede014f9545.file.header.tpl.php
258 tools/smarty/plugins/function.implode.php
259 cache/smarty/cache/blockbanner/1/110/af/8b/77/af8b77b70d5ec60514d52044bf10ccbdf28ac11b.blockbanner.tpl.php
260 cache/smarty/compile/c5/aa/18/c5aa18ac2f73c48576bec8fc1842eb366975deaf.file.nav.tpl.php
261 cache/smarty/compile/fa/a0/6d/faa06de0964abbefdf29f4ed1d1e59daa20c7e2b.file.blockcurrencies.tpl.php
262 cache/smarty/compile/02/97/26/0297261be4930097b6609a90e2ea4d17698c07b0.file.blocklanguages.tpl.php
263 tools/smarty/plugins/modifier.regex_replace.php
264 cache/smarty/cache/blockcontact/1/110/8b/b3/41/8bb341776139d0e389e019d77bcb5a05c85e065c.nav.tpl.php
265 cache/smarty/compile/9a/38/fc/9a38fc1a78a389c0772ff2a98aaf8936eb275062.file.breadcrumb.tpl.php
266 cache/smarty/compile/17/d2/5e/17d25e30440440cb2e9b71dfa31d3622523e4e9d.file.footer.tpl.php
267 cache/smarty/compile/58/29/df/5829df0d47b8854c8651184a645c190c7f6dcd4b.file.global.tpl.php
268 cache/smarty/compile/84/50/00/8450005ad0a6b8ca591fa54cc298a8d3602138c6.file.javascript.tpl.php
269 tools/js_minify/jsmin.php

PrestaHeroes USA · June 15, 2014

HI,

Hello El Patron,

Am having a similar problem. With the layered navigation, my site is taking 32 seconds and without it 3 seconds. Not sure what I should be doing.

I have turned on the debug profiling and given the results below. Being a non-techie, am clueless as to what to do with it.

Load time: 31.069s
You'd better run your shop on a toaster
config: 270ms

constructor: 0ms

init: 193ms

checkAccess: 0ms

setMedia: 27ms

postProcess: 0ms

initHeader: 0ms

initContent: 29.816s

initFooter: 18ms

display: 745ms

Hook processing: 29.832s / 21.17 Mb
88 methods called in 34 modules
actionProductListOverride: 28.103s / 1.89 Mb

displayHeader: 1.252s / 10.84 Mb

displayTop: 332ms / 6.09 Mb

displayLeftColumn: 97ms / 1.18 Mb

displayFooter: 17ms / 0.75 Mb

displayProductListReviews: 16ms / 0.07 Mb

displayNav: 11ms / 0.26 Mb

displayBanner: 2ms / 0.06 Mb

displayProductListFunctionalButtons: 1ms / 0.02 Mb

displayTopColumn: 0ms / 0 Mb

moduleRoutes: 0ms / 0 Mb

actionFrontControllerSetMedia: 0ms / 0 Mb

actionProductListModifier: 0ms / 0 Mb

DisplayOverrideTemplate: 0ms / 0 Mb

actionDispatcher: 0ms / 0 Mb

Memory peak usage: 44.2 Mb
config: 11.84 Mb (11.9 Mb)

constructor: 0 Mb (11.9 Mb)

init: 6.42 Mb (18.5 Mb)

checkAccess: 0 Mb (18.5 Mb)

setMedia: 0.48 Mb (18.8 Mb)

postProcess: 0 Mb (18.8 Mb)

initHeader: 0.01 Mb (18.8 Mb)

initContent: 20.69 Mb (39.7 Mb)

initFooter: 0.77 Mb (40.5 Mb)

display: 3.48 Mb (44.2 Mb)

Total cache size (in Cache class): 0 Mb

DB type: DbPDO
SQL Queries: 274 queries
Time spent querying: 28.881s

Included files: 269
Size of included files: 3.34 Mb

Globals (> 1 Ko only): 858 Ko
_MODULES ≈ 581.5 Ko

_LANG ≈ 191.9 Ko

HTTP_SERVER_VARS ≈ 9.3 Ko

_SERVER ≈ 9.3 Ko

HTTP_ENV_VARS ≈ 8.5 Ko

_ENV ≈ 8.5 Ko

_MODULE ≈ 3.7 Ko

_REQUEST ≈ 2.6 Ko

HTTP_COOKIE_VARS ≈ 2.6 Ko

_COOKIE ≈ 2.6 Ko

back office-->modules-->positions-->(make sure to display non-positionalble hooks as well)

what is hooked to actionProductListOverride?

that would be the problem (layered navigation hooks here, hopefully you have something besides this)

homefoodfinder · June 16, 2014

HI,

back office-->modules-->positions-->(make sure to display non-positionalble hooks as well)

what is hooked to actionProductListOverride?

that would be the problem (layered navigation hooks here, hopefully you have something besides this)

Nope. Unfortunately, only layered navigation is hooked here. (I made sure the non-positionable hook is checked on). I checked the permissions for the layered navigation module. Its 755 for all folders and 644 for all files.

PrestaHeroes USA · June 16, 2014

Nope. Unfortunately, only layered navigation is hooked here. (I made sure the non-positionable hook is checked on). I checked the permissions for the layered navigation module. Its 755 for all folders and 644 for all files.

how many products/categories and guesstimate of attributes do you have?

homefoodfinder · June 16, 2014

how many products/categories and guesstimate of attributes do you have?

I have 61 categories and 181 products (each product is assigned to 7-8 categories average). Most products have 20 combinations each, but some might have upto 300 combinations.

PrestaHeroes USA · June 16, 2014

I tried with the values 150, 1200, and 15000. When I had it as 15000, it marginal reduce the load time by 1-2 seconds but it was still around 30 seconds.

Thank you El Patron for working with me on this, but I really hope we can find a solution.

We had the same issue earlier and thought maybe it was the theme we were using or it was because of prestashop 1.5. Hence we did a fresh install of prestashop 1.6 and added all the products again. But its happening again. We have delayed the go-live of my business by 1 month now already.

back office-->advanced perf-->performance

scroll to bottom, are you using any apc/flle/memcache? if so disable and retest

homefoodfinder · June 16, 2014

back office-->advanced perf-->performance

scroll to bottom, are you using any apc/flle/memcache? if so disable and retest

Nope. In my live site, we were using APC. Thinking that it might be problem, we never enabled the cache in the bottom section of advanced perf-performance for the test site www.homefood-finder.com.

PrestaHeroes USA · June 16, 2014

Nope. In my live site, we were using APC. Thinking that it might be problem, we never enabled the cache in the bottom section of advanced perf-performance for the test site www.homefood-finder.com.

this is beyond my pay scale. It may be a good idea to post in paid section, to get someone to look 'very' closely at your issue. There are some bright folks who work for 'very' reasonable fee. I will post back if I can come up with any other idea you could try. Good luck!

also you can also open a forge report here: http://forge.prestashop.com/secure/Dashboard.jspa

possible one of the ps developers knows/fixed and/or can help more. They are very good.

homefoodfinder · June 16, 2014

this is beyond my pay scale. It may be a good idea to post in paid section, to get someone to look 'very' closely at your issue. There are some bright folks who work for 'very' reasonable fee. I will post back if I can come up with any other idea you could try. Good luck!

also you can also open a forge report here: http://forge.prestashop.com/secure/Dashboard.jspa

possible one of the ps developers knows/fixed and/or can help more. They are very good.

Thanks. I posted it in forge last week and am waiting for a response.

I have also posted it in the paid jobs section. I am also trying to work with my hosting provider to see if I can do anything on the server side.

Thank you very much for your time and effort. Keeping my fingers crossed that someone can figure this out. Will update you when it happens.

homefoodfinder · June 16, 2014

Have posted this issue on Forge (link given below). Hope to find a solution soon.

http://forge.prestashop.com/browse/PSCSX-2393

PrestaHeroes USA · June 16, 2014

Have posted this issue on Forge (link given below). Hope to find a solution soon.

http://forge.prestashop.com/browse/PSCSX-2393

using the product url you supplied in forge report, and using firebug/yslow, it's possinle that the following file is possibly being blocked,

https://themes.googleusercontent.com/static/fonts/opensans/v8/k3k702ZOKiLJc3WVjuplzHhCUOGz7vYGh680lGh-uXM.woff

http://screencast.com/t/W8zYfHofPZf

troyrob · June 16, 2014

I had the same problem one. What i found solved my problem was to disable filesystem caching. Found under: Advanced Parameters -> Performance

Disabling cache completely took my website from 50s page loads to 4s (very counter intuitive i know)

homefoodfinder · June 16, 2014

using the product url you supplied in forge report, and using firebug/yslow, it's possinle that the following file is possibly being blocked,

https://themes.googleusercontent.com/static/fonts/opensans/v8/k3k702ZOKiLJc3WVjuplzHhCUOGz7vYGh680lGh-uXM.woff

http://screencast.com/t/W8zYfHofPZf

How do I correct it? (am sorry - might be a dumb question)

PrestaHeroes USA · June 16, 2014

How do I correct it? (am sorry - might be a dumb question)

note sure this is you issue, if you are in same country as server, try clicking on it, should download without delay..

it might be a good time to review your error log for time out errors, make sure to set error reporting to true in config/defines.inc.php because the time out of 30 seconds is pretty typical php timeout value.

homefoodfinder · June 16, 2014

I had the same problem one. What i found solved my problem was to disable filesystem caching. Found under: Advanced Parameters -> Performance

Disabling cache completely took my website from 50s page loads to 4s (very counter intuitive i know)

Hello troyrob - thanks for pitching in.

Unfortunately, it did not work for me. the advance cache (filesystem/memcache/apc) was never checked on. I tried disabling the smarty cache (and after that cleared all the cache and browser cache), it still did not work. Actually it further slowed my website - load time was 45 seconds.

Any other ideas?

homefoodfinder · June 16, 2014

note sure this is you issue, if you are in same country as server, try clicking on it, should download without delay..

it might be a good time to review your error log for time out errors, make sure to set error reporting to true in config/defines.inc.php because the time out of 30 seconds is pretty typical php timeout value.

No errors reported in the error log on the server.

Have set both '_PS_MODE_DEV_', true and '_PS_DEBUG_PROFILING_', true. No errors are reported on the website when I open the page.

Was checking the error log in the public_html folder and saw the following line:

PHP Warning: Module 'memcache' already loaded in Unknown on line 0

Does it ring any bell?? Because memcache was never enabled.

homefoodfinder · June 16, 2014

2 more errors that I have in the public_html -> error log files are as follows (but I have not been getting both after 12th June when I installed the layered navigation module)

Error 1:

[06-Jun-2014 12:42:32 Asia/Kolkata] PHP Warning: Invalid argument supplied for foreach() in /home/homef/public_html/controllers/front/CategoryController.php on line 212

Line 212 is :

foreach ($this->cat_products as &$product)

if ($product['id_product_attribute'] && isset($product['product_attribute_minimal_quantity']))

$product['minimal_quantity'] = $product['product_attribute_minimal_quantity'];

[12-Jun-2014 19:34:32 Asia/Kolkata] PHP Fatal error: Uncaught exception 'SmartyCompilerException' with message 'Syntax Error in template "/home/homef/public_html/modules/agilemultipleseller/views/templates/hook/hookproducttabcontent.tpl" on line 80 "" unclosed {if} tag' in /home/homef/public_html/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php:667

Stack trace:

#0 /home/homef/public_html/tools/smarty/sysplugins/smarty_internal_smartytemplatecompiler.php(118): Smarty_Internal_TemplateCompilerBase->trigger_template_error('unclosed {if} t...')

#1 /home/homef/public_html/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php(206): Smarty_Internal_SmartyTemplateCompiler->doCompile('<script type="t...')

#2 /home/homef/public_html/tools/smarty/sysplugins/smarty_internal_template.php(187): Smarty_Internal_TemplateCompilerBase->compileTemplate(Object(Smarty_Internal_Template))

#3 /home/homef/public_html/tools/smarty/sysplugins/smarty_internal_templatebase.php(164): Smarty_Internal_Template->compileTemplateSource()

#4 /home/ in /home/homef/public_html/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php on line 667

PrestaHeroes USA · June 16, 2014

if you disable blocklayered there is no issue, correct?

homefoodfinder · June 16, 2014

correct. If I disable blocklayered, the website loads in 3-4 seconds.

homefoodfinder · June 18, 2014

So finally figured out that the issue was a conflict between the layered navigation module and the agile multi-sellar module which I had installed. If I uninstall either of the modules (keeping only my site and block layered OR keeping only my site and multi-sellar module), the load time reduces to 4 seconds.

I reached out to the creator of agile multi-sellar module and he gave me an add-on block layered module. So now with both the multi-sellar functionality and block layered functionality, the load time is 11 seconds. This is much better than the 35 seconds I had but hoping to reduce it further.

ringerce · June 23, 2014

So finally figured out that the issue was a conflict between the layered navigation module and the agile multi-sellar module which I had installed. If I uninstall either of the modules (keeping only my site and block layered OR keeping only my site and multi-sellar module), the load time reduces to 4 seconds.

I reached out to the creator of agile multi-sellar module and he gave me an add-on block layered module. So now with both the multi-sellar functionality and block layered functionality, the load time is 11 seconds. This is much better than the 35 seconds I had but hoping to reduce it further.

If you unook the BlockLayered module from actionProductListOverride you'll notice that the everything works just fine. The problem is poorly written SQL code from Prestashop in the latest version of the BlockLayered module. In 1.6 when they added color attributes on the category/product listing pages they didn't optimize the code so now lots of people with heavy combination based catalogs are all complaining about performance with the block layered module.

Edited June 23, 2014 by ringerce (see edit history)

giuliopowa · November 7, 2014

hello,

my site now is very slow.
can you help me?

i saw that i have many sql queries (1598)
and many rows browsed

giuliopowa · November 7, 2014

i solved , clean the tables

PrestaHeroes USA · November 8, 2014

Have posted this issue on Forge (link given below). Hope to find a solution soon.

http://forge.prestashop.com/browse/PSCSX-2393

this bug report has been marked as 'fixed'...so worth looking at and applying.

Website very slow! Back and front office in the same time.

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment