rgwhitaker Posted January 12, 2015 Share Posted January 12, 2015 I'm running PS 1.5.6.2 and it the frontend and backend are both running very slow. I turned define('_PS_DEBUG_PROFILING_', false) to define('_PS_DEBUG_PROFILING_', true). I then went into the backoffice and copied the following below. Also, should I be getting a report at the bottom of each page in the frontend as well? Because if I go to my site (primzie.com), there's nothing at the bottom of the pages. Thanks. Ron ___________________________________________________________________ Load time: 1.12sYou'd better run your shop on a toasterconfig: 178ms constructor: 0ms init: 14ms checkAccess: 0ms setMedia: 0ms postProcess: 0ms initHeader: 0ms initContent: 920ms initFooter: 0ms display: 8ms Hook processing: 12ms / 0.25 MbmoduleRoutes: 12ms / 0.25 Mb actionDispatcher: 0ms / 0 Mb displayBackOfficeTop: 0ms / 0 Mb Memory peak usage: 14.7 Mbconfig: 11.85 Mb (14.1 Mb) constructor: 0 Mb (14.1 Mb) init: 0.33 Mb (14.1 Mb) checkAccess: 0 Mb (14.1 Mb) setMedia: 0 Mb (14.1 Mb) postProcess: 0 Mb (14.1 Mb) initHeader: 0 Mb (14.1 Mb) initContent: 1.29 Mb (14.1 Mb) initFooter: 0 Mb (14.1 Mb) display: 0.47 Mb (14.7 Mb) Total cache size (in Cache class): 0.28 Mb DB type: DbPDO SQL Queries: 24 queries Time spent querying: 19ms Included files: 66Size of included files: 1.41 Mb Globals (> 1 Ko only): 1167 Ko_LANGADM ≈ 1122.2 Ko HTTP_SERVER_VARS ≈ 8.8 Ko _SERVER ≈ 8.8 Ko _ENV ≈ 7.5 Ko HTTP_ENV_VARS ≈ 7.5 Ko _REQUEST ≈ 2.9 Ko HTTP_COOKIE_VARS ≈ 2.6 Ko _COOKIE ≈ 2.3 Ko Go to Stopwatch Go to Doubles Go to Tables Go to ObjectModels Display queries table Stopwatch (with SQL_NO_CACHE) (total = 24)3.779 ms SELECT SQL_NO_CACHE module FROM ps_tab_module_preference WHERE `id_tab` = 6 AND `id_employee` = 0in /home/dellas5/public_html/classes/Tab.php:5341 row browsed3.457 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 /home/dellas5/public_html/classes/Configuration.php:116538 rows browsed1.874 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 /home/dellas5/public_html/classes/Hook.php:339USING FILESORT - 87 rows browsed1.782 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` ASCin /home/dellas5/public_html/classes/QuickAccess.php:65USING FILESORT - 25 rows browsed0.747 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` ASCin /home/dellas5/public_html/classes/Tab.php:246USING FILESORT - 106 rows browsed0.735 ms SELECT SQL_NO_CACHE * FROM `ps_access` a LEFT JOIN `ps_tab` t ON t.id_tab = a.id_tab WHERE `id_profile` = 0in /home/dellas5/public_html/classes/Profile.php:1431 row browsed0.67 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) DESCin /home/dellas5/public_html/classes/Dispatcher.php:426USING FILESORT - 26 rows browsed0.567 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.namein /home/dellas5/public_html/classes/shop/Shop.php:622USING FILESORT - 1 row browsed0.474 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminlogin' LIMIT 1in /home/dellas5/public_html/classes/Tab.php:178106 rows browsed0.45 ms SELECT SQL_NO_CACHE * FROM `ps_tab_lang` WHERE `id_tab` = 6in /home/dellas5/public_html/classes/ObjectModel.php:2191 row browsed0.436 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 1in /home/dellas5/public_html/classes/Language.php:8051 row browsed0.424 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 1in /home/dellas5/public_html/classes/ObjectModel.php:2121 row browsed0.401 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 = 1) LIMIT 1in /home/dellas5/public_html/classes/ObjectModel.php:2121 row browsed0.37 ms SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""in /home/dellas5/public_html/classes/Tab.php:222106 rows browsed0.352 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 /home/dellas5/public_html/classes/Language.php:6981 row browsed0.33 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 = 'www.primzie.com' OR su.domain_ssl = 'www.primzie.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESCin /home/dellas5/public_html/classes/shop/Shop.php:320USING FILESORT - 1 row browsed0.326 ms SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`in /home/dellas5/public_html/classes/Tab.php:276106 rows browsed0.296 ms SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1in /home/dellas5/public_html/classes/cache/CacheFs.php:361 row browsed0.27 ms SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1in /home/dellas5/public_html/classes/shop/ShopUrl.php:1541 row browsed0.258 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 = 1 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 21) LIMIT 1in /home/dellas5/public_html/classes/ObjectModel.php:2121 row browsed0.253 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 1in /home/dellas5/public_html/classes/shop/Shop.php:1991 row browsed0.245 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`in /home/dellas5/public_html/classes/Hook.php:18286 rows browsed0.189 ms SELECT SQL_NO_CACHE * FROM `ps_tab` a WHERE (a.id_tab = 6) LIMIT 1in /home/dellas5/public_html/classes/ObjectModel.php:2121 row browsed0.187 ms SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1in /home/dellas5/public_html/classes/ObjectModel.php:2121 row browsed Tables stress6 tab4 shop_url4 shop3 lang3 lang_shop2 tab_lang2 configuration1 access1 meta_lang1 quick_access1 tab_module_preference1 quick_access_lang1 meta1 currency_shop1 currency1 hook_module1 country_lang1 country1 configuration_lang1 theme1 country_shop1 shop_group1 module_shop1 hook1 module1 hook_alias ObjectModel instances2 Tab1 Currency1 Language1 Employee1 Country1 Shop Included files1 adminx0109a/index.php2 adminx0109a/../config/config.inc.php3 config/config.inc.php4 config/defines.inc.php5 config/settings.inc.php6 config/autoload.php7 config/alias.php8 classes/Autoload.php9 cache/class_index.php10 tools/profiling/Controller.php11 classes/controller/Controller.php12 tools/profiling/ObjectModel.php13 classes/ObjectModel.php14 tools/profiling/Hook.php15 classes/Hook.php16 tools/profiling/Db.php17 classes/db/Db.php18 tools/profiling/Tools.php19 classes/Tools.php20 classes/Context.php21 classes/shop/Shop.php22 classes/db/DbPDO.php23 classes/cache/Cache.php24 classes/cache/CacheFs.php25 classes/Validate.php26 classes/db/DbQuery.php27 config/defines_uri.inc.php28 classes/Configuration.php29 classes/Language.php30 classes/Country.php31 classes/Collection.php32 classes/Cookie.php33 classes/Rijndael.php34 classes/Employee.php35 classes/Link.php36 classes/shop/ShopUrl.php37 config/smarty.config.inc.php38 tools/smarty/Smarty.class.php39 tools/smarty/sysplugins/smarty_internal_data.php40 tools/smarty/sysplugins/smarty_internal_templatebase.php41 tools/smarty/sysplugins/smarty_internal_template.php42 tools/smarty/sysplugins/smarty_resource.php43 tools/smarty/sysplugins/smarty_internal_resource_file.php44 tools/smarty/sysplugins/smarty_cacheresource.php45 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php46 config/smartyadmin.config.inc.php47 adminx0109a/functions.php48 ./images.inc.php49 classes/Dispatcher.php50 classes/Tab.php51 controllers/admin/AdminLoginController.php52 classes/controller/AdminController.php53 classes/Translate.php54 translations/en/admin.php55 classes/Profile.php56 classes/Currency.php57 classes/Media.php58 classes/QuickAccess.php59 classes/module/Module.php60 cache/smarty/compile/ab/14/75/ab1475920163a6deacc3167978595c4f5191956e.file.content.tpl.php61 tools/smarty/plugins/modifier.escape.php62 tools/smarty/plugins/modifier.date_format.php63 tools/smarty/plugins/shared.make_timestamp.php64 cache/smarty/compile/ed/f6/a7/edf6a73267dec527214ca90474017f648d79392f.file.layout.tpl.php65 cache/smarty/compile/de/ac/e7/deace7a9465a4ac913a81b6197a900e6e4b5eea4.file.header.tpl.php66 cache/smarty/compile/55/fb/78/55fb78bc523eff1937408c8ffed4bbdc81e33359.file.footer.tpl.php Link to comment Share on other sites More sharing options...
Recommended Posts