Including Functions.php

Time Before: 0.03215 seconds
Time After: 0.05878 seconds
Time Taken: 0.02662 seconds

Memory Before: 1,439.742 KB
Memory After: 2,485.141 KB
Memory Used: 1,045.398 KB

Connect to Database on Server: localhost

Time Before: 0.05894 seconds
Time After: 0.07560 seconds
Time Taken: 0.01666 seconds

Memory Before: 2,485.094 KB
Memory After: 2,485.664 KB
Memory Used: 0.570 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.07605 seconds
Time After: 0.07623 seconds
Time Taken: 0.00017 seconds

Memory Before: 2,485.688 KB
Memory After: 2,485.742 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.07729 seconds
Time After: 0.08072 seconds
Time Taken: 0.00343 seconds

Memory Before: 2,487.570 KB
Memory After: 2,487.500 KB
Memory Used: -0.070 KB

Time Before: 0.07627 seconds
Time After: 0.12702 seconds
Time Taken: 0.05076 seconds

Memory Before: 2,485.508 KB
Memory After: 3,514.672 KB
Memory Used: 1,029.164 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.13422 seconds
Time After: 0.13504 seconds
Time Taken: 0.00081 seconds

Memory Before: 3,743.578 KB
Memory After: 3,743.570 KB
Memory Used: -0.008 KB

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

Time Before: 0.14021 seconds
Time After: 0.14049 seconds
Time Taken: 0.00028 seconds

Memory Before: 3,885.695 KB
Memory After: 3,886.000 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.14440 seconds
Time After: 0.14527 seconds
Time Taken: 0.00086 seconds

Memory Before: 3,892.563 KB
Memory After: 3,892.742 KB
Memory Used: 0.180 KB

Time Before: 0.13926 seconds
Time After: 0.14561 seconds
Time Taken: 0.00635 seconds

Memory Before: 3,885.031 KB
Memory After: 3,968.031 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.17121 seconds
Time After: 0.17143 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,654.109 KB
Memory After: 4,654.133 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.17656 seconds
Time After: 0.17725 seconds
Time Taken: 0.00068 seconds

Memory Before: 4,746.984 KB
Memory After: 4,747.289 KB
Memory Used: 0.305 KB

End call of global.php: 0.18689393997192
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.19411 seconds
Time After: 0.19550 seconds
Time Taken: 0.00139 seconds

Memory Before: 5,592.273 KB
Memory After: 5,592.453 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.20849 seconds
Time After: 0.20976 seconds
Time Taken: 0.00127 seconds

Memory Before: 6,390.703 KB
Memory After: 6,390.445 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.29660 seconds
Time After: 0.29683 seconds
Time Taken: 0.00023 seconds

Memory Before: 7,031.438 KB
Memory After: 7,031.742 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.29841 seconds
Time After: 0.29906 seconds
Time Taken: 0.00065 seconds

Memory Before: 7,063.891 KB
Memory After: 7,064.195 KB
Memory Used: 0.305 KB

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

Time Before: 0.30225 seconds
Time After: 0.30247 seconds
Time Taken: 0.00022 seconds

Memory Before: 7,216.383 KB
Memory After: 7,216.688 KB
Memory Used: 0.305 KB

SQL Query
SELECT * FROM glowhostspamomatic_stats
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEglowhostspamomatic_statsALL    1 

Time Before: 0.30457 seconds
Time After: 0.30482 seconds
Time Taken: 0.00025 seconds

Memory Before: 7,276.695 KB
Memory After: 7,277.000 KB
Memory Used: 0.305 KB

SQL Query
UPDATE session
SET lastactivity = 1579282441, location = '/?explain=1', inforum = 0, badlocation = 0
WHERE sessionhash = '35b68381cce6f9802feb357b80ae07e1'

Time Before: 0.31043 seconds
Time After: 0.31087 seconds
Time Taken: 0.00044 seconds

Memory Before: 7,500.367 KB
Memory After: 7,500.273 KB
Memory Used: -0.094 KB

Page generated in 0.30945611000061 seconds with 14 queries, spending 0.02754545211792 doing MySQL queries and 0.28191065788269 doing PHP things.
Shutdown Queries:
DISABLED