Including Functions.php

Time Before: 0.01096 seconds
Time After: 0.02638 seconds
Time Taken: 0.01542 seconds

Memory Before: 1,439.445 KB
Memory After: 2,484.852 KB
Memory Used: 1,045.406 KB

Connect to Database on Server: localhost

Time Before: 0.02648 seconds
Time After: 0.02906 seconds
Time Taken: 0.00258 seconds

Memory Before: 2,484.805 KB
Memory After: 2,485.375 KB
Memory Used: 0.570 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.02938 seconds
Time After: 0.02952 seconds
Time Taken: 0.00014 seconds

Memory Before: 2,485.398 KB
Memory After: 2,485.453 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.03043 seconds
Time After: 0.03570 seconds
Time Taken: 0.00527 seconds

Memory Before: 2,487.281 KB
Memory After: 2,487.211 KB
Memory Used: -0.070 KB

Time Before: 0.02955 seconds
Time After: 0.04972 seconds
Time Taken: 0.02017 seconds

Memory Before: 2,485.219 KB
Memory After: 3,511.156 KB
Memory Used: 1,025.938 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.05260 seconds
Time After: 0.05312 seconds
Time Taken: 0.00051 seconds

Memory Before: 3,740.063 KB
Memory After: 3,740.055 KB
Memory Used: -0.008 KB

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

Time Before: 0.05635 seconds
Time After: 0.05661 seconds
Time Taken: 0.00026 seconds

Memory Before: 3,881.555 KB
Memory After: 3,881.859 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.05869 seconds
Time After: 0.05997 seconds
Time Taken: 0.00128 seconds

Memory Before: 3,888.422 KB
Memory After: 3,888.602 KB
Memory Used: 0.180 KB

Time Before: 0.05566 seconds
Time After: 0.06032 seconds
Time Taken: 0.00466 seconds

Memory Before: 3,880.891 KB
Memory After: 3,963.891 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.08541 seconds
Time After: 0.08559 seconds
Time Taken: 0.00018 seconds

Memory Before: 4,645.719 KB
Memory After: 4,645.742 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.08827 seconds
Time After: 0.08893 seconds
Time Taken: 0.00066 seconds

Memory Before: 4,738.594 KB
Memory After: 4,738.898 KB
Memory Used: 0.305 KB

End call of global.php: 0.097331047058105
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.10445 seconds
Time After: 0.10577 seconds
Time Taken: 0.00131 seconds

Memory Before: 5,583.883 KB
Memory After: 5,584.063 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.12263 seconds
Time After: 0.13112 seconds
Time Taken: 0.00850 seconds

Memory Before: 6,381.258 KB
Memory After: 6,381.000 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.17929 seconds
Time After: 0.17945 seconds
Time Taken: 0.00017 seconds

Memory Before: 7,013.992 KB
Memory After: 7,014.297 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.18232 seconds
Time After: 0.18267 seconds
Time Taken: 0.00035 seconds

Memory Before: 7,046.445 KB
Memory After: 7,046.750 KB
Memory Used: 0.305 KB

SQL Query
SELECT * FROM glowhostspamomatic_stats
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEglowhostspamomatic_statsALL    1 

Time Before: 0.18900 seconds
Time After: 0.19052 seconds
Time Taken: 0.00152 seconds

Memory Before: 7,193.133 KB
Memory After: 7,193.438 KB
Memory Used: 0.305 KB

SQL Query
SET @@session.wait_timeout = 90

Time Before: 0.19587 seconds
Time After: 0.19601 seconds
Time Taken: 0.00014 seconds

Memory Before: 7,519.367 KB
Memory After: 7,519.477 KB
Memory Used: 0.109 KB

SQL Query
UPDATE session
SET lastactivity = 1568645075, location = '/?explain=1', inforum = 0, badlocation = 0
WHERE sessionhash = 'd85d7639a3f17e540867879fbeebd610'

Time Before: 0.20950 seconds
Time After: 0.21002 seconds
Time Taken: 0.00052 seconds

Memory Before: 7,536.977 KB
Memory After: 7,536.883 KB
Memory Used: -0.094 KB

Page generated in 0.19360208511353 seconds with 14 queries, spending 0.023403167724609 doing MySQL queries and 0.17019891738892 doing PHP things.
Shutdown Queries:
DISABLED