Including Functions.php

Time Before: 0.00694 seconds
Time After: 0.01763 seconds
Time Taken: 0.01069 seconds

Memory Before: 1,741.070 KB
Memory After: 2,985.281 KB
Memory Used: 1,244.211 KB

Connect to Database on Server: localhost

Time Before: 0.01768 seconds
Time After: 0.01797 seconds
Time Taken: 0.00029 seconds

Memory Before: 2,985.258 KB
Memory After: 2,986.188 KB
Memory Used: 0.930 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01812 seconds
Time After: 0.01822 seconds
Time Taken: 0.00010 seconds

Memory Before: 2,986.930 KB
Memory After: 2,987.492 KB
Memory Used: 0.563 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue','activeblocks','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY50 23Using where

Time Before: 0.01866 seconds
Time After: 0.01923 seconds
Time Taken: 0.00057 seconds

Memory Before: 2,990.875 KB
Memory After: 2,991.047 KB
Memory Used: 0.172 KB

Time Before: 0.01825 seconds
Time After: 0.02078 seconds
Time Taken: 0.00253 seconds

Memory Before: 2,986.734 KB
Memory After: 3,824.891 KB
Memory Used: 838.156 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('blogcategorycache','blogstats','profilefield')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY50 3Using where

Time Before: 0.02355 seconds
Time After: 0.02369 seconds
Time Taken: 0.00013 seconds

Memory Before: 4,429.805 KB
Memory After: 4,430.234 KB
Memory Used: 0.430 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '107.22.63.172'
	AND idhash = '814a2b1763bc3f53d3c062db8a3308b2'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrefguest_lookup,user_activityguest_lookup51const,const,const2Using where

Time Before: 0.02417 seconds
Time After: 0.02432 seconds
Time Taken: 0.00015 seconds

Memory Before: 4,463.406 KB
Memory After: 4,463.781 KB
Memory Used: 0.375 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_activitystream AS phrasegroup_activitystream,
			phrasegroup_holiday AS phrasegroup_holiday,
			phrasegroupinfo AS lang_phrasegroupinfo,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguagesystemPRIMARY   1 

Time Before: 0.02517 seconds
Time After: 0.02567 seconds
Time Taken: 0.00049 seconds

Memory Before: 4,475.266 KB
Memory After: 4,475.031 KB
Memory Used: -0.234 KB

Time Before: 0.02385 seconds
Time After: 0.02578 seconds
Time Taken: 0.00194 seconds

Memory Before: 4,456.656 KB
Memory After: 4,540.234 KB
Memory Used: 83.578 KB

SQL Query
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,
	calendar.calendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON
	(calendarpermission.calendarid = calendar.calendarid AND
		usergroupid IN (1))
ORDER BY displayorder ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcalendarpermissionsystem    0const row not found
1SIMPLEcalendarALL    2Using filesort

Time Before: 0.02846 seconds
Time After: 0.02860 seconds
Time Taken: 0.00014 seconds

Memory Before: 4,803.000 KB
Memory After: 4,803.203 KB
Memory Used: 0.203 KB

SQL Query
SELECT MAX(permissions & 1) AS perm
FROM cms_permissions
WHERE nodeid = 1 AND usergroupid IN (1)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcms_permissionsconstusergroupid,nodeidusergroupid8const,const1 

Time Before: 0.02908 seconds
Time After: 0.02920 seconds
Time Taken: 0.00012 seconds

Memory Before: 4,836.484 KB
Memory After: 4,836.898 KB
Memory Used: 0.414 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 8 AND userselect = 1)
	OR styleid = 8
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 

Time Before: 0.03122 seconds
Time After: 0.03153 seconds
Time Taken: 0.00031 seconds

Memory Before: 5,009.719 KB
Memory After: 5,010.109 KB
Memory Used: 0.391 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (327,328,6412,6413,6414,6416,6417,6418,6419,6415,6484,6486,6492,4577,6488,6489,6490,6491,6837,7369,4621,6929,6930,0,0,335,329,3690,1213,334,1216,331,336,337,338,6674,6959,6620,6624,6621,6622,6623,6967,0,0,6981,6922,6644,6645,6647,6648,6871,6951,6990,6943,6952,6471,6470,6474,1222,5991,6015)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 59Using where

Time Before: 0.03344 seconds
Time After: 0.03395 seconds
Time Taken: 0.00051 seconds

Memory Before: 5,890.891 KB
Memory After: 5,891.063 KB
Memory Used: 0.172 KB

SQL Query
UPDATE session
SET lastactivity = 1498275467, location = '/content/?explain=1'
WHERE sessionhash = 'f997103b42a83dc99296623b1aa698b7'

Time Before: 0.04227 seconds
Time After: 0.04239 seconds
Time Taken: 0.00012 seconds

Memory Before: 6,463.023 KB
Memory After: 6,463.273 KB
Memory Used: 0.250 KB

Page generated in 0.041741847991943 seconds with 10 queries, spending 0.0029399394989014 doing MySQL queries and 0.038801908493042 doing PHP things.
Shutdown Queries:
DISABLED