Including Functions.php

Time Before: 0.01021 seconds
Time After: 0.02484 seconds
Time Taken: 0.01463 seconds

Memory Before: 1,439.750 KB
Memory After: 2,485.156 KB
Memory Used: 1,045.406 KB

Connect to Database on Server: localhost

Time Before: 0.02499 seconds
Time After: 0.02764 seconds
Time Taken: 0.00265 seconds

Memory Before: 2,485.109 KB
Memory After: 2,485.680 KB
Memory Used: 0.570 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.02801 seconds
Time After: 0.02812 seconds
Time Taken: 0.00012 seconds

Memory Before: 2,485.703 KB
Memory After: 2,485.758 KB
Memory Used: 0.055 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
1SIMPLEdatastorerangePRIMARYPRIMARY150 23Using where

Time Before: 0.02902 seconds
Time After: 0.03191 seconds
Time Taken: 0.00289 seconds

Memory Before: 2,487.586 KB
Memory After: 2,487.516 KB
Memory Used: -0.070 KB

Time Before: 0.02816 seconds
Time After: 0.05594 seconds
Time Taken: 0.02778 seconds

Memory Before: 2,485.523 KB
Memory After: 3,510.992 KB
Memory Used: 1,025.469 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('blogcategorycache','blogstats','dbtech_vbshop_category','dbtech_vbshop_currency','dbtech_vbshop_currency2','dbtech_vbshop_item','dbtech_vbshop_itemtype','dbtech_vbshop_lottery','dbtech_vbshop_lotteryprize','dbtech_vbshop_shop')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY150 10Using where

Time Before: 0.06027 seconds
Time After: 0.06087 seconds
Time Taken: 0.00060 seconds

Memory Before: 3,739.898 KB
Memory After: 3,739.891 KB
Memory Used: -0.008 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '35.172.150.239'
	AND idhash = '7be345a701280ccd989960ee3aa06b4b'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrefuser_activity,guest_lookupguest_lookup237const,const,const2Using where

Time Before: 0.06483 seconds
Time After: 0.06510 seconds
Time Taken: 0.00028 seconds

Memory Before: 3,881.766 KB
Memory After: 3,882.070 KB
Memory Used: 0.305 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.06659 seconds
Time After: 0.06811 seconds
Time Taken: 0.00151 seconds

Memory Before: 3,888.633 KB
Memory After: 3,888.813 KB
Memory Used: 0.180 KB

Time Before: 0.06421 seconds
Time After: 0.06836 seconds
Time Taken: 0.00415 seconds

Memory Before: 3,881.102 KB
Memory After: 3,964.102 KB
Memory Used: 83.000 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.08659 seconds
Time After: 0.08675 seconds
Time Taken: 0.00016 seconds

Memory Before: 4,647.781 KB
Memory After: 4,647.805 KB
Memory Used: 0.023 KB

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

Time Before: 0.08999 seconds
Time After: 0.09146 seconds
Time Taken: 0.00147 seconds

Memory Before: 4,740.656 KB
Memory After: 4,740.961 KB
Memory Used: 0.305 KB

End call of global.php: 0.10070514678955
SQL Query
SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
	user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
	
FROM forum AS forum

LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumALL    123 
1SIMPLEusereq_refPRIMARYPRIMARY4driftrpc_forum.forum.lastposterid1 
1SIMPLEuserlisteq_refPRIMARY,relationid,useridPRIMARY9const,driftrpc_forum.user.userid,const1Using where

Time Before: 0.10898 seconds
Time After: 0.10985 seconds
Time Taken: 0.00087 seconds

Memory Before: 5,585.945 KB
Memory After: 5,586.125 KB
Memory Used: 0.180 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (417,418,473,474,475,477,478,479,480,476,1737,547,1748,1746,1744,1742,1743,552,898,1731,1544,1736,1020,0,0,426,420,419,424,425,423,422,427,428,429,735,1009,1734,685,682,683,684,1039,0,0,1019,980,705,706,708,709,932,1051,1033,983,984,532,531,535,1326,61,85,1314,1312,1313,1315,1383,1382,0,1600,1588,1717,1716,1708,1718)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 71Using where

Time Before: 0.11625 seconds
Time After: 0.11995 seconds
Time Taken: 0.00370 seconds

Memory Before: 6,383.820 KB
Memory After: 6,383.563 KB
Memory Used: -0.258 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'forumblock.628f615cecbd2c4161d5c2930c9f64de'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.20700 seconds
Time After: 0.20720 seconds
Time Taken: 0.00020 seconds

Memory Before: 7,020.555 KB
Memory After: 7,020.859 KB
Memory Used: 0.305 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'forumblock.fb17ab23d7f634bb3f1a444d60671b0e'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.22778 seconds
Time After: 0.22833 seconds
Time Taken: 0.00055 seconds

Memory Before: 7,053.008 KB
Memory After: 7,053.313 KB
Memory Used: 0.305 KB

SQL Query
SELECT * FROM glowhostspamomatic_stats
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEglowhostspamomatic_statsALL    1 

Time Before: 0.23571 seconds
Time After: 0.23609 seconds
Time Taken: 0.00039 seconds

Memory Before: 7,264.266 KB
Memory After: 7,264.570 KB
Memory Used: 0.305 KB

SQL Query
UPDATE session
SET lastactivity = 1573578819, location = '/?explain=1', inforum = 0, inthread = 0, badlocation = 0
WHERE sessionhash = '7014c01de5c846744c080e5962405325'

Time Before: 0.24022 seconds
Time After: 0.24042 seconds
Time Taken: 0.00021 seconds

Memory Before: 7,479.984 KB
Memory After: 7,479.859 KB
Memory Used: -0.125 KB

Page generated in 0.23945808410645 seconds with 13 queries, spending 0.015599727630615 doing MySQL queries and 0.22385835647583 doing PHP things.
Shutdown Queries:
DISABLED