Backoffice very very slow after update to 1.5.5.

Soesoe · September 1, 2013

Hello everyone,

As title, happened to me after update.

If I want to open a order it will take about 10-15 seconds, another 10 seconds to mark it as 'shipped'

Normally it takes 1-2 seconds.

What could be the problem/solution?

Thanks

Soesoe · September 2, 2013

no one that can help me ?

musicmaster · September 2, 2013

For debugging this you could switch profiling on. It is in the file "defines.inc.php" in the config directory.

There you should change "define('_PS_DEBUG_PROFILING_', false);". " and set it to true. You might also consider enabling the development mode (define('_PS_MODE_DEV_', false);". ). The effect should be that you see at the bottom of each page a long list of timings.

I hope this helps you further...

nortom · September 5, 2013

I have the same bug. Solution please????

benjamin utterback · September 5, 2013

I have the same bug. Solution please????

Hi Nortom, please follow the suggestion that musicmaster gave in his post. Turn on the debug profiling mode and and Mode_dev.. Set them to true and save it to your FTP. You will be able to see more information.

I tried to visit your website but it is currently in maintenance mode. You can turn it off maintenance mode and I can check to see what the problem is if I can.

nortom · September 5, 2013

if i do this. I'm getting this error

 Memcache::set(): No servers added to memcache connection

Edited September 6, 2013 by nortom (see edit history)

Soesoe · September 6, 2013

I get the same error as nortom when I set profiling mode

Soesoe · September 6, 2013

nortom

keep the line below on false:

"define('_PS_DEBUG_PROFILING_', false)

edit this line to true

(define('_PS_MODE_DEV_', false);". )

you will now see on every tab in your backoffice a error list, mostly it is one file that keeps reloading

for me the map default_country_modules_list wasn't working properly, so I have to replace it with original map.

I'm first making an back-up and will let you know if the problem will be solved

Soesoe · September 6, 2013

after uploading new xml file of default_country_modules_list

The speed went from 11-12 seconds to 3,5 seconds

still slow but it's a good improvement

hope it can help anybody

purepixels · September 6, 2013

Here same problems with adminpanel very (very) slow.. loading time takes me between 36 and 42 seconds in the back end.

errors I receive when turning on debug mode;

Warning: file_put_contents(/home/mydomain/domains/mydomain.nl/public_html/prestashop/config/xml/default_country_modules_list.xml) [function.file-put-contents]: failed to open stream: Permission denied in/home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1540


Warning: simplexml_load_file() [function.simplexml-load-file]: I/O warning : failed to load external entity "/home/mydomain/domains/mydomain.nl/public_html/prestashop/config/xml/default_country_modules_list.xml" in/home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1542


Notice: Trying to get property of non-object in /home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1544


Warning: Invalid argument supplied for foreach() in /home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1544


Warning: file_put_contents(/home/mydomain/domains/mydomain.nl/public_html/prestashop/config/xml/default_country_modules_list.xml) [function.file-put-contents]: failed to open stream: Permission denied in/home/mydomain/domains/mydomain.nl/public_html/prestashop/controllers/admin/AdminHomeController.php on line 679
 
 
After changing permissions to the xml directory to 755, I get the following list of errors;
Warning: simplexml_load_file() [function.simplexml-load-file]: /home/mydomain/domains/mydomain.nl/public_html/prestashop/config/xml/default_country_modules_list.xml:1: parser error : Document is empty in/home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1542

Warning: simplexml_load_file() [function.simplexml-load-file]: in /home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1542

Warning: simplexml_load_file() [function.simplexml-load-file]: ^ in /home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1542

Warning: simplexml_load_file() [function.simplexml-load-file]: /home/mydomain/domains/mydomain.nl/public_html/prestashop/config/xml/default_country_modules_list.xml:1: parser error : Start tag expected, '<' not found in/home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1542

Warning: simplexml_load_file() [function.simplexml-load-file]: in /home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1542

Warning: simplexml_load_file() [function.simplexml-load-file]: ^ in /home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1542

Notice: Trying to get property of non-object in /home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1544

Warning: Invalid argument supplied for foreach() in /home/mydomain/domains/mydomain.nl/public_html/prestashop/classes/controller/AdminController.php on line 1544

Now I see SoeSoe mentioning a new XML file. In the zip from PS 1.5.5. there is no xml file present and I cannot find the file online elsewhere. Can you tell me where you've found this file?

I'll probably be back after that to fix the rest of the issues. One step at a time.

Thanks in advance for your help!

Edited September 6, 2013 by purepixels (see edit history)

musicmaster · September 6, 2013

Nortom, Soesoe,

As you have a caching error, can you try to switch the external caching (memcache, etc) off? This is under Advanced Parameters -> Performance. See picture.

Soesoe · September 6, 2013

Dear Musicmaster,

Your tip helped alot for the frontoffice

It was on indeed, so I switched it off and when I click a category on my site it takes around 2 seconds instead of 5 seconds, nice improvement

On backoffice I didn't notice anything

Thanks for your help, hope it helps the others too

nortom · September 6, 2013

Yes this improve the back office, but the front site is slower

So it's a caching problem?

benjamin utterback · September 6, 2013

Yes this improve the back office, but the front site is slower

So it's a caching problem?

Hi, yes it is a caching issue. Do you have memcache installed on your server?

nortom · September 6, 2013

Yes i have memcache installed on my server.

Never had problems with it.

benjamin utterback · September 6, 2013

When you go to Advance Parameters>Performance and turn on MemCache, when you Test your server is everything okay?

nortom · September 6, 2013

Yes everything works fine, but in the back-office are somethings very slow.

Like module tab loading slower, edit product and save, changing status order

10x slower.

The previous version of presta don't have this problem.

benjamin utterback · September 6, 2013

Can you try to delete the Smarty cache as well? To manually cache clear delete the content of the following folders:

cache/smarty/compile

cache/smarty/cache

img/tmp

Delete all the files in the folders, except of index.php.

nortom · September 7, 2013

Done this.

It stays slow when i change order status

about 4 sec.

nortom · September 7, 2013

Someone solve the problem?

benjamin utterback · September 9, 2013

Hi nortom, your front office is running fast. Your back-office is the only problem? What kind of hosting are you on?

nortom · September 9, 2013

My own server.

After the update, some things are running slow in the back-office.

Like changing order status is one of the things about 4 a 8 Sec. before 1sec.

benjamin utterback · September 9, 2013

Okay cool, what version of PrestaShop were you using before? The one that you had before the upgrade, was it another version of 1.5 or 1.4 .

nortom · September 9, 2013

1.5.4.1

hatta · September 10, 2013

Hi,

Same for me...i am new bie in prestashop.

Blank for backoffice with error below

WarningC:\Users\ehatagu\Documents\Other Data\xampp\htdocs\prestashop\classes\controller\AdminController.php on line 1542

Warning: simplexml_load_file(): in C:\Users\ehatagu\Documents\Other Data\xampp\htdocs\prestashop\classes\controller\AdminController.php on line 1542

Warning: simplexml_load_file(): ^ in C:\Users\ehatagu\Documents\Other Data\xampp\htdocs\prestashop\classes\controller\AdminController.php on line 1542

WarningC:\Users\ehatagu\Documents\Other Data\xampp\htdocs\prestashop\classes\controller\AdminController.php on line 1542

Warning: simplexml_load_file(): in C:\Users\ehatagu\Documents\Other Data\xampp\htdocs\prestashop\classes\controller\AdminController.php on line 1542

Warning: simplexml_load_file(): ^ in C:\Users\ehatagu\Documents\Other Data\xampp\htdocs\prestashop\classes\controller\AdminController.php on line 1542

Notice: Trying to get property of non-object in C:\Users\ehatagu\Documents\Other Data\xampp\htdocs\prestashop\classes\controller\AdminController.php on line 1544

Warning: Invalid argument supplied for foreach() in C:\Users\ehatagu\Documents\Other Data\xampp\htdocs\prestashop\classes\controller\AdminController.php on line 1544

nortom · September 14, 2013

Any solution?

GordonPim · September 15, 2013

HI, I've the same problem

Any solution?

tnx

nortom · September 15, 2013

I see that module yotpo slow down order tab.

Someone the same issue?

benjamin utterback · September 16, 2013

I see that module yotpo slow down order tab.

Someone the same issue?

Hi nortom, if you could please update the yotpo module. We recently released a new version. http://addons.prestashop.com/en/social-commerce-facebook-prestashop-modules/7366-yotpo-social-reviews.html

Let me know how it goes and make sure to always have a back up

nortom · September 16, 2013

I update the module, but the problem stays

benjamin utterback · September 16, 2013

I update the module, but the problem stays

Have you cleared cache and smarty cache? Is the yotpo module still the issue?

benjamin utterback · September 16, 2013

I update the module, but the problem stays

Hi nortom, I am sorry! The module is not updated on Addons yet. However, it is updated on Github. I went ahead and downloaded it for you and zipped it. Use this version 1.3.1 and let me know if it works for you.

Thank you!

yotpo.zip

bloggus · September 17, 2013

after uploading new xml file of default_country_modules_list

The speed went from 11-12 seconds to 3,5 seconds

still slow but it's a good improvement

hope it can help anybody

Where did you find the file? I too have the slow performance in the BO and all errors seems to be due to empty default_country_modules_list.xml

Edited September 17, 2013 by bloggus (see edit history)

nortom · September 18, 2013

I update the yotpo module.

I must say, the speed is way better.

From 10-13 sec to 3-5sec

Still it's slower than presta (1.5.4.1) 1sec

abellasmith · September 19, 2013

Someone solve the problem?

+100!

nortom · September 21, 2013

This help also improve the speedprestashop1.5.5.0/classes/controller/AdminController.php

if (!$this->isFresh(Module::CACHE_FILE_MUST_HAVE_MODULES_LIST, 86400))

@file_put_contents(_PS_ROOT_DIR_.Module::CACHE_FILE_MUST_HAVE_MODULES_LIST, Tools::addonsRequest('must-have'));

delete or comment this code with //.

Edited September 21, 2013 by nortom (see edit history)

quadfun · September 22, 2013

Same problem here.

Backoffice verry slow after update.

Tomin · December 1, 2013

Hi, i have same problem - very long time for saving product aftersome changes, as well as availbable amount saving isn't too fast. Prestashop was upgraded from 1.4 to 1.5.5

In debug mode I have something like this -

Load time: 108ms
Good boy! That's what I call a webserver!
config: 49ms
constructor: 0ms
init: 9ms
checkAccess: 0ms
setMedia: 2ms
postProcess: 0ms
initHeader: 7ms
initContent: 37ms
initFooter: 0ms
display: 4ms
Hook processing: 11ms / 0.64 Mb
moduleRoutes: 11ms / 0.64 Mb
displayAdminHomeQuickLinks: 0ms / 0 Mb
actionDispatcher: 0ms / 0 Mb
displayAdminHomeInfos: 0ms / 0 Mb
actionAdminControllerSetMedia: 0ms / 0 Mb
displayBackOfficeHeader: 0ms / 0 Mb
displayBackOfficeTop: 0ms / 0 Mb
displayBackOfficeFooter: 0ms / 0 Mb
displayBackOfficeHome: 0ms / 0 Mb
displayAdminHomeStatistics: 0ms / 0 Mb
Memory peak usage: 6.1 Mb
config: 3.69 Mb (3.8 Mb)
constructor: 0 Mb (3.8 Mb)
init: 1.16 Mb (4.9 Mb)
checkAccess: 0 Mb (4.9 Mb)
setMedia: 0.07 Mb (4.9 Mb)
postProcess: 0 Mb (4.9 Mb)
initHeader: 0.46 Mb (5.4 Mb)
initContent: 0.34 Mb (5.9 Mb)
initFooter: 0 Mb (5.9 Mb)
display: 0.16 Mb (6.1 Mb)


Total cache size (in Cache class): 0.33 Mb DB type: DbPDO 
SQL Queries: 54 queries 
Time spent querying: 48ms Included files: 73
Size of included files: 1.6 Mb Globals (> 1 Ko only): 1174 Ko
_LANGADM ≈ 1114.3 Ko
context ≈ 46 Ko
_SERVER ≈ 7.7 Ko
_COOKIE ≈ 2.2 Ko
Go to Stopwatch
Go to Doubles
Go to Tables
Go to ObjectModels
Display queries table
Stopwatch (with SQL_NO_CACHE) (total = 54)
17.723 ms SELECT SQL_NO_CACHE SUM(pv.`counter`) AS total_viewed FROM `ps_page_viewed` pv LEFT JOIN `ps_date_range` dr ON pv.`id_date_range` = dr.`id_date_range` LEFT JOIN `ps_page` p ON pv.`id_page` = p.`id_page` LEFT JOIN `ps_page_type` pt ON pt.`id_page_type` = p.`id_page_type` WHERE pt.`name` = 'product' AND dr.`time_start` BETWEEN '2013-12-01 00:00:00' AND '2013-12-31 23:59:59' AND dr.`time_end` BETWEEN '2013-12-01 00:00:00' AND '2013-12-31 23:59:59' AND id_shop IN (1) LIMIT 1
in /var/www/html/prod_shopfolder/controllers/admin/AdminHomeController.php:332
425 rows browsed
3.553 ms SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)
in /var/www/html/prod_shopfolder/classes/Configuration.php:116
486 rows browsed
2.48 ms SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)
in /var/www/html/prod_shopfolder/classes/Configuration.php:116
486 rows browsed
2.076 ms SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:212
1 row browsed
1.998 ms SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name
in /var/www/html/prod_shopfolder/classes/Hook.php:128
0 rows browsed
1.657 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` WHERE ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) ORDER BY hm.`position`
in /var/www/html/prod_shopfolder/classes/Hook.php:334
USING FILESORT - 88 rows browsed
1.063 ms SELECT SQL_NO_CACHE *, ( SELECT osl.`name` FROM `ps_order_state_lang` osl WHERE osl.`id_order_state` = o.`current_state` AND osl.`id_lang` = 1 LIMIT 1 ) AS `state_name` FROM `ps_orders` o LEFT JOIN `ps_customer` c ON (c.`id_customer` = o.`id_customer`) WHERE 1 AND o.id_shop IN (1) ORDER BY o.`date_add` DESC LIMIT 0, 10
in /var/www/html/prod_shopfolder/classes/order/Order.php:877
10 rows browsed
0.99 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 4 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Currency.php:277
1 row browsed
0.92 ms SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) ORDER BY t.`position` ASC
in /var/www/html/prod_shopfolder/classes/Tab.php:240
USING FILESORT - 108 rows browsed
0.807 ms SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC
in /var/www/html/prod_shopfolder/classes/Dispatcher.php:426
USING FILESORT - 25 rows browsed
0.705 ms SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m
in /var/www/html/prod_shopfolder/classes/module/Module.php:167
88 rows browsed
0.685 ms SELECT SQL_NO_CACHE SUM(total_paid / conversion_rate) as total_converted, left(invoice_date, 10) as invoice_date FROM ps_orders o WHERE valid = 1 AND total_paid > 0 AND invoice_date BETWEEN '2013-11-24 00:00:00' AND '2013-12-01 13:29:38' AND id_shop IN (1) GROUP BY DATE(invoice_date)
in /var/www/html/prod_shopfolder/controllers/admin/AdminHomeController.php:398
USING FILESORT - 111 rows browsed
0.586 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
in /var/www/html/prod_shopfolder/classes/shop/Shop.php:196
1 row browsed
0.505 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
in /var/www/html/prod_shopfolder/classes/Hook.php:180
86 rows browsed
0.499 ms SELECT SQL_NO_CACHE IFNULL(SUM(`total_paid_real` / conversion_rate), "0") as total_sales, COUNT(*) as total_orders FROM `ps_orders` WHERE valid = 1 AND `invoice_date` BETWEEN '2013-12-01 00:00:00' AND '2013-12-31 23:59:59' AND id_shop IN (1) LIMIT 1
in /var/www/html/prod_shopfolder/controllers/admin/AdminHomeController.php:313
111 rows browsed
0.496 ms SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name
in /var/www/html/prod_shopfolder/classes/shop/Shop.php:615
USING FILESORT - 1 row browsed
0.412 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Language.php:775
9 rows browsed
0.393 ms SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'shopfolder' OR su.domain_ssl = 'shopfolder') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
in /var/www/html/prod_shopfolder/classes/shop/Shop.php:315
USING FILESORT - 1 row browsed
0.38 ms SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:212
1 row browsed
0.378 ms SELECT SQL_NO_CACHE COUNT(`id_customer`) AS total_registrations FROM `ps_customer` c WHERE c.`date_add` BETWEEN '2013-12-01 00:00:00' AND '2013-12-31 23:59:59' AND id_shop IN (1) LIMIT 1
in /var/www/html/prod_shopfolder/controllers/admin/AdminHomeController.php:320
77 rows browsed
0.374 ms SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 12 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 125) LIMIT 1
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:212
1 row browsed
0.363 ms SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
in /var/www/html/prod_shopfolder/classes/Language.php:670
3 rows browsed
0.359 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_customer_thread` WHERE `status` = "open" LIMIT 1
in /var/www/html/prod_shopfolder/controllers/admin/AdminHomeController.php:256
92 rows browsed
0.344 ms SELECT SQL_NO_CACHE * FROM `ps_quick_access` qa LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = 1) ORDER BY `name` ASC
in /var/www/html/prod_shopfolder/classes/QuickAccess.php:65
USING FILESORT - 5 rows browsed
0.337 ms SELECT SQL_NO_CACHE * FROM ps_memcached_servers
in /var/www/html/prod_shopfolder/classes/cache/CacheMemcache.php:200
1 row browsed
0.335 ms SELECT SQL_NO_CACHE COUNT(*) FROM ps_customer_thread LIMIT 1
in /var/www/html/prod_shopfolder/controllers/admin/AdminHomeController.php:255
92 rows browsed
0.32 ms SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""
in /var/www/html/prod_shopfolder/classes/Tab.php:216
108 rows browsed
0.316 ms SELECT SQL_NO_CACHE `id_employee` FROM `ps_employee` WHERE `id_employee` = 1 AND `passwd` = '995be9d9caf8c08a76c1aecdcbdcf086' AND active = 1 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Employee.php:208
1 row browsed
0.312 ms SELECT SQL_NO_CACHE date_upd FROM ps_configuration WHERE name = "PS_REWRITING_SETTINGS" LIMIT 1
in /var/www/html/prod_shopfolder/controllers/admin/AdminHomeController.php:45
1 row browsed
0.31 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminhome' LIMIT 1
in /var/www/html/prod_shopfolder/classes/Tab.php:178
108 rows browsed
0.308 ms SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
in /var/www/html/prod_shopfolder/classes/Tab.php:270
108 rows browsed
0.303 ms SELECT SQL_NO_CACHE * FROM `ps_employee` a LEFT JOIN `ps_employee_shop` `c` ON a.id_employee = c.id_employee AND c.id_shop = 1 WHERE (a.id_employee = 1) LIMIT 1
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:212
1 row browsed
0.299 ms SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 4) LIMIT 1
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:212
1 row browsed
0.296 ms SELECT SQL_NO_CACHE module FROM ps_tab_module_preference WHERE `id_tab` = 88 AND `id_employee` = 1
in /var/www/html/prod_shopfolder/classes/Tab.php:528
1 row browsed
0.29 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 4 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Currency.php:277
1 row browsed
0.28 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_customer_thread` WHERE `status` LIKE "%pending%" LIMIT 1
in /var/www/html/prod_shopfolder/controllers/admin/AdminHomeController.php:257
92 rows browsed
0.269 ms SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 1) LIMIT 1
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:212
1 row browsed
0.268 ms SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 4 AND id_shop = 1 LIMIT 1
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:1220
1 row browsed
0.268 ms SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:1265
1 row browsed
0.262 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 4 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Currency.php:277
1 row browsed
0.259 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 4 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Currency.php:277
1 row browsed
0.256 ms SELECT SQL_NO_CACHE * FROM ps_memcached_servers
in /var/www/html/prod_shopfolder/classes/cache/CacheMemcache.php:200
1 row browsed
0.252 ms SELECT SQL_NO_CACHE date_upd FROM ps_configuration WHERE name = "PS_HTACCESS_CACHE_CONTROL" LIMIT 1
in /var/www/html/prod_shopfolder/controllers/admin/AdminHomeController.php:60
1 row browsed
0.242 ms SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1
in /var/www/html/prod_shopfolder/classes/shop/ShopUrl.php:154
1 row browsed
0.241 ms SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) WHERE t.`id_tab` = 88 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Tab.php:200
1 row browsed
0.241 ms SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 4 AND id_shop = 1 LIMIT 1
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:1220
1 row browsed
0.241 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 4 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Currency.php:277
1 row browsed
0.238 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 4 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Currency.php:277
1 row browsed
0.234 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 4 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Currency.php:277
1 row browsed
0.229 ms SELECT SQL_NO_CACHE * FROM `ps_tab` a WHERE (a.id_tab = 88) LIMIT 1
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:212
1 row browsed
0.227 ms SELECT SQL_NO_CACHE * FROM `ps_tab_lang` WHERE `id_tab` = 88
in /var/www/html/prod_shopfolder/classes/ObjectModel.php:219
3 rows browsed
0.227 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 1 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Currency.php:277
1 row browsed
0.222 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 1 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Currency.php:277
1 row browsed
0.202 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 4 LIMIT 1
in /var/www/html/prod_shopfolder/classes/Currency.php:277
1 row browsed
Doubles (IDs replaced by "XX") (total = 42)
10 SELECT * FROM `ps_currency` WHERE `deleted` = XX AND `id_currency` = XX LIMIT XX
2 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)
2 SELECT * FROM ps_memcached_servers
2 SELECT id_shop FROM `ps_currency_shop` WHERE `id_currency` = XX AND id_shop = XX LIMIT XX
1 SELECT * FROM `ps_shop_group` a WHERE (a.id_shop_group = XX) LIMIT XX
1 SELECT module FROM ps_tab_module_preference WHERE `id_tab` = XX AND `id_employee` = XX
1 SELECT `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminhome' LIMIT XX
1 SELECT * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = XX) WHERE t.`id_tab` = XX LIMIT XX
1 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 = XX WHERE s.deleted = XX AND gs.deleted = XX ORDER BY gs.name, s.name
1 SELECT IFNULL(SUM(`total_paid_real` / conversion_rate), "XX") as total_sales, COUNT(*) as total_orders FROM `ps_orders` WHERE valid = XX AND `invoice_date` BETWEEN 'XX-XX-XX XX:XX:XX' AND 'XX-XX-XX XX:XX:XX' AND id_shop IN (XX) LIMIT XX
1 SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = XX WHERE (a.id_currency = XX) LIMIT XX
1 SELECT * FROM `ps_quick_access` qa LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = XX) ORDER BY `name` ASC
1 SELECT SUM(pv.`counter`) AS total_viewed FROM `ps_page_viewed` pv LEFT JOIN `ps_date_range` dr ON pv.`id_date_range` = dr.`id_date_range` LEFT JOIN `ps_page` p ON pv.`id_page` = p.`id_page` LEFT JOIN `ps_page_type` pt ON pt.`id_page_type` = p.`id_page_type` WHERE pt.`name` = 'product' AND dr.`time_start` BETWEEN 'XX-XX-XX XX:XX:XX' AND 'XX-XX-XX XX:XX:XX' AND dr.`time_end` BETWEEN 'XX-XX-XX XX:XX:XX' AND 'XX-XX-XX XX:XX:XX' AND id_shop IN (XX) LIMIT XX
1 SELECT *, ( SELECT osl.`name` FROM `ps_order_state_lang` osl WHERE osl.`id_order_state` = o.`current_state` AND osl.`id_lang` = XX LIMIT XX ) AS `state_name` FROM `ps_orders` o LEFT JOIN `ps_customer` c ON (c.`id_customer` = o.`id_customer`) WHERE XX AND o.id_shop IN (XX) ORDER BY o.`date_add` DESC LIMIT XX, XX
1 SELECT date_upd FROM ps_configuration WHERE name = "PS_REWRITING_SETTINGS" LIMIT XX
1 SELECT date_upd FROM ps_configuration WHERE name = "PS_HTACCESS_CACHE_CONTROL" LIMIT XX
1 SELECT SUM(total_paid / conversion_rate) as total_converted, left(invoice_date, XX) as invoice_date FROM ps_orders o WHERE valid = XX AND total_paid > XX AND invoice_date BETWEEN 'XX-XX-XX XX:XX:XX' AND 'XX-XX-XX XX:XX:XX' AND id_shop IN (XX) GROUP BY DATE(invoice_date)
1 SELECT COUNT(*) FROM `ps_customer_thread` WHERE `status` LIKE "%pending%" LIMIT XX
1 SELECT `id_employee` FROM `ps_employee` WHERE `id_employee` = XX AND `passwd` = 'XXbeXXdXXcafXXcXXaXXcXXaecdcbdcfXX' AND active = XX LIMIT XX
1 SELECT COUNT(*) FROM ps_customer_thread LIMIT XX
1 SELECT COUNT(*) FROM `ps_customer_thread` WHERE `status` = "open" LIMIT XX
1 SELECT COUNT(`id_customer`) AS total_registrations FROM `ps_customer` c WHERE c.`date_add` BETWEEN 'XX-XX-XX XX:XX:XX' AND 'XX-XX-XX XX:XX:XX' AND id_shop IN (XX) LIMIT XX
1 SELECT t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""
1 SELECT * FROM `ps_employee` a LEFT JOIN `ps_employee_shop` `c` ON a.id_employee = c.id_employee AND c.id_shop = XX WHERE (a.id_employee = XX) LIMIT XX
1 SELECT id_shop FROM `ps_employee_shop` WHERE `id_employee` = XX
1 SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = XX WHERE (a.id_lang = XX) LIMIT XX
1 SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = XX LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = XX WHERE (a.id_country = XX) LIMIT XX
1 SELECT l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
1 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 = 'shopfolder' OR su.domain_ssl = 'shopfolder') AND s.active = XX AND s.deleted = XX ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
1 SELECT * FROM `ps_shop` a WHERE (a.id_shop = XX) LIMIT XX
1 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 = XX AND s.active = XX AND s.deleted = XX AND su.main = XX LIMIT XX
1 SELECT domain, domain_ssl FROM ps_shop_url WHERE main = XX AND id_shop = XX LIMIT XX
1 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 = XX) WHERE l.`active` = XX LIMIT XX
1 SELECT id_tab, class_name FROM `ps_tab`
1 SELECT * FROM `ps_tab` a WHERE (a.id_tab = XX) LIMIT XX
1 SELECT * FROM `ps_tab_lang` WHERE `id_tab` = XX
1 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 = XX ) ORDER BY LENGTH(ml.url_rewrite) DESC
1 SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX LIMIT XX ) as mshop FROM `ps_module` m
1 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_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` WHERE ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (XX)) = XX) AND (h.name != "displayPayment") AND (hm.id_shop = XX) ORDER BY hm.`position`
1 SELECT * FROM `ps_hook_alias`
1 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
1 SELECT * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = XX) ORDER BY t.`position` ASC
Tables stress
11 currency
6 tab
4 configuration
4 shop_url
4 shop
3 hook
3 tab_lang
3 currency_shop
3 lang_shop
3 customer_thread
3 orders
3 lang
2 module_shop
2 memcached_servers
2 customer
2 shop_group
2 hook_alias
2 employee_shop
2 module
2 employee
2 configuration_lang
1 page_viewed
1 theme
1 date_range
1 page_type
1 order_state_lang
1 country
1 page
1 quick_access_lang
1 meta_lang
1 meta
1 country_shop
1 country_lang
1 hook_module
1 quick_access
1 tab_module_preference
ObjectModel instances
2 Currency
1 ShopGroup
1 Tab
1 Language
1 Country
1 Employee
1 Shop
Included files
1 manage/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/Autoload.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 classes/db/DbPDO.php
22 classes/cache/Cache.php
23 classes/cache/CacheMemcache.php
24 classes/Configuration.php
25 classes/Validate.php
26 classes/db/DbQuery.php
27 config/defines_uri.inc.php
28 classes/Language.php
29 classes/Country.php
30 classes/Collection.php
31 classes/Cookie.php
32 classes/Rijndael.php
33 classes/Employee.php
34 classes/Link.php
35 classes/shop/ShopUrl.php
36 config/smarty.config.inc.php
37 tools/smarty/Smarty.class.php
38 tools/smarty/sysplugins/smarty_internal_data.php
39 tools/smarty/sysplugins/smarty_internal_templatebase.php
40 tools/smarty/sysplugins/smarty_internal_template.php
41 tools/smarty/sysplugins/smarty_resource.php
42 tools/smarty/sysplugins/smarty_internal_resource_file.php
43 tools/smarty/sysplugins/smarty_cacheresource.php
44 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
45 config/smartyadmin.config.inc.php
46 manage/functions.php
47 ./images.inc.php
48 classes/Dispatcher.php
49 classes/module/Module.php
50 modules/csblog/csblog.php
51 modules/csblog/url/csLink.php
52 modules/csblog/class/CSBLPost.php
53 modules/csblog/class/CSPLCategory.php
54 classes/Translate.php
55 classes/Tab.php
56 controllers/admin/AdminHomeController.php
57 classes/controller/AdminController.php
58 translations/en/admin.php
59 classes/Profile.php
60 classes/Currency.php
61 classes/Media.php
62 classes/QuickAccess.php
63 classes/helper/Helper.php
64 classes/shop/ShopGroup.php
65 classes/Upgrader.php
66 classes/Chart.php
67 classes/order/Order.php
68 cache/smarty/compile/bd/b9/a3/bdb9a3b6304f71f47cd9be5b6cb965123941f9bc.file.optimizationTips.tpl.php
69 cache/smarty/compile/97/3b/81/973b81302f3adb8246c3c6a29246319e219e09e3.file.content.tpl.php
70 cache/smarty/compile/64/96/ef/6496ef0ec7f194db4219d928bbbe09cabd24253b.file.layout.tpl.php
71 cache/smarty/compile/68/56/11/6856115e7970b576b7a79aeda8e822dcf1156ca5.file.header.tpl.php
72 tools/smarty/plugins/modifier.escape.php
73 cache/smarty/compile/7d/91/95/7d91954d9940ca3f4aaea4c023329492c7ec0703.file.

Edited December 1, 2013 by Tomin (see edit history)

tyszek · December 2, 2013

I turned off all the modules but the problem remained.

Sorry for my english

bloggus · December 3, 2013

Maybe this will help you. This was my issue:

http://www.prestashop.com/forums/topic/284219-solved-backoffice-very-slow/?do=findComment&comment=1435602

El Patron · May 23, 2014

For those back offices with the need for speed, this module fixes it.

Please take a look at [Module] BoZoom PrestaShop Back Office Performance for 1.5 | 1.6

this module 'will' significantly speed up your back off pages

Backoffice very very slow after update to 1.5.5.

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