Including Functions.php

Time Before: 0.00073 seconds
Time After: 0.00103 seconds
Time Taken: 0.00029 seconds

Memory Before: 558.953 KB
Memory After: 672.117 KB
Memory Used: 113.164 KB

Connect to Database on Server: www03.rxmuscle.ml.zerolag.com

Time Before: 0.00108 seconds
Time After: 0.00526 seconds
Time Taken: 0.00418 seconds

Memory Before: 672.117 KB
Memory After: 673.063 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00574 seconds
Time After: 0.00623 seconds
Time Taken: 0.00049 seconds

Memory Before: 673.758 KB
Memory After: 674.320 KB
Memory Used: 0.563 KB

Datastore Setup
SQL Query
SELECT *
FROM rxdatastore
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
1SIMPLErxdatastorerangePRIMARYPRIMARY50 23Using where

Time Before: 0.00701 seconds
Time After: 0.00807 seconds
Time Taken: 0.00106 seconds

Memory Before: 677.703 KB
Memory After: 677.883 KB
Memory Used: 0.180 KB

Time Before: 0.00631 seconds
Time After: 0.01193 seconds
Time Taken: 0.00562 seconds

Memory Before: 673.531 KB
Memory After: 3,192.656 KB
Memory Used: 2,519.125 KB

SQL Query
SELECT *
FROM rxdatastore
WHERE title IN ('profilefield')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.01298 seconds
Time After: 0.01329 seconds
Time Taken: 0.00031 seconds

Memory Before: 3,680.469 KB
Memory After: 3,680.922 KB
Memory Used: 0.453 KB

Session Handling
SQL Query
SELECT *
FROM rxsession
WHERE userid = 0
	AND host = '172.70.135.10'
	AND idhash = 'de4868e2481bf0cdb092d9019cf8bce1'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxsessionrefguest_lookup,user_activityguest_lookup51const,const,const2Using where

Time Before: 0.01402 seconds
Time After: 0.01435 seconds
Time Taken: 0.00033 seconds

Memory Before: 3,694.859 KB
Memory After: 3,695.227 KB
Memory Used: 0.367 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 rxlanguage
WHERE languageid = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxlanguagesystemPRIMARY   1 

Time Before: 0.01507 seconds
Time After: 0.01553 seconds
Time Taken: 0.00046 seconds

Memory Before: 3,705.938 KB
Memory After: 3,705.711 KB
Memory Used: -0.227 KB

Time Before: 0.01347 seconds
Time After: 0.01565 seconds
Time Taken: 0.00218 seconds

Memory Before: 3,687.773 KB
Memory After: 3,761.227 KB
Memory Used: 73.453 KB

SQL Query
SELECT *
FROM rxstyle
WHERE (styleid = 21 AND userselect = 1)
	OR styleid = 21
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxstyleconstPRIMARYPRIMARY2const1 

Time Before: 0.01929 seconds
Time After: 0.01973 seconds
Time Taken: 0.00044 seconds

Memory Before: 4,238.617 KB
Memory After: 4,239.008 KB
Memory Used: 0.391 KB

End call of global.php: 0.021077871322632
SQL Query
SELECT
	user.username, (user.options & 512) AS invisible, user.usergroupid, user.lastvisit,
	session.userid, session.inforum, session.lastactivity, session.badlocation,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
	
FROM rxsession AS session
LEFT JOIN rxuser AS user ON(user.userid = session.userid)

WHERE session.lastactivity > 1638127671
	
ORDER BY username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrangelast_activitylast_activity4 2401Using where; Using temporary; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY403forums.session.userid1 

Time Before: 0.02266 seconds
Time After: 0.03356 seconds
Time Taken: 0.01090 seconds

Memory Before: 4,919.914 KB
Memory After: 4,920.016 KB
Memory Used: 0.102 KB

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 rxforum AS forum

LEFT JOIN rxuser AS user ON (user.userid = forum.lastposterid)
LEFT JOIN rxuserlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumALL    216 
1SIMPLEusereq_refPRIMARYPRIMARY403forums.forum.lastposterid1 
1SIMPLEuserlisteq_refPRIMARY,relationid,useridPRIMARY9const,03forums.user.userid,const1Using where

Time Before: 0.04468 seconds
Time After: 0.04732 seconds
Time Taken: 0.00264 seconds

Memory Before: 5,044.758 KB
Memory After: 5,044.656 KB
Memory Used: -0.102 KB

SQL Query
SELECT title, template
FROM rxtemplate
WHERE templateid IN (4945,1589,10860,10861,10862,10864,10865,10866,10867,10863,10684,10934,10686,10935,10936,10937,10938,10939,11285,10728,10723,11387,11407,977,976,978,973,972,1595,4948,10720,10699,981,982,1600,11122,11396,11068,11072,11069,11070,11071,11426,0,0,11406,11367,11092,11093,11095,11096,11319,11438,11420,11370,11371,10919,10918,10922,8758,8761,8762,8760,8759,8763,8764)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplaterangePRIMARYPRIMARY4 65Using where

Time Before: 0.05372 seconds
Time After: 0.05468 seconds
Time Taken: 0.00096 seconds

Memory Before: 6,119.313 KB
Memory After: 6,119.414 KB
Memory Used: 0.102 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.12592402d84cc6dde758698e9fcfe758'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.14234 seconds
Time After: 0.14257 seconds
Time Taken: 0.00022 seconds

Memory Before: 6,618.227 KB
Memory After: 6,618.625 KB
Memory Used: 0.398 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.16eb2811d33801b3ae5553873490f923'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.14338 seconds
Time After: 0.14362 seconds
Time Taken: 0.00024 seconds

Memory Before: 6,625.922 KB
Memory After: 6,626.320 KB
Memory Used: 0.398 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.36d87b9400db58b6e71ee260dfb994d8'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.14444 seconds
Time After: 0.14471 seconds
Time Taken: 0.00027 seconds

Memory Before: 6,633.563 KB
Memory After: 6,633.961 KB
Memory Used: 0.398 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.21c934b5fbb17d55eb070b01cfb7c778'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.14556 seconds
Time After: 0.14586 seconds
Time Taken: 0.00031 seconds

Memory Before: 6,640.461 KB
Memory After: 6,640.859 KB
Memory Used: 0.398 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.274ac0544d6276ebcbe986ae7473af97'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.14659 seconds
Time After: 0.14693 seconds
Time Taken: 0.00034 seconds

Memory Before: 6,663.430 KB
Memory After: 6,663.828 KB
Memory Used: 0.398 KB

SQL Query
SELECT template
FROM rxtemplate
WHERE templateid = 2265
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplateconstPRIMARYPRIMARY4const1 

Time Before: 0.15052 seconds
Time After: 0.15081 seconds
Time Taken: 0.00028 seconds

Memory Before: 6,852.242 KB
Memory After: 6,852.688 KB
Memory Used: 0.445 KB

SQL Query
SELECT * FROM rxglowhostspamomatic_stats
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxglowhostspamomatic_statsALL    1 

Time Before: 0.15177 seconds
Time After: 0.15208 seconds
Time Taken: 0.00031 seconds

Memory Before: 6,891.844 KB
Memory After: 6,892.320 KB
Memory Used: 0.477 KB

SQL Query
UPDATE rxsession
SET lastactivity = 1638134905, location = '/index.php?explain=1', inforum = 0, inthread = 0, badlocation = 0, bypass = 0
WHERE sessionhash = '224e7c7f9304b8a395776c6ba0f96a90'

Time Before: 0.16051 seconds
Time After: 0.16079 seconds
Time Taken: 0.00028 seconds

Memory Before: 7,975.375 KB
Memory After: 7,975.578 KB
Memory Used: 0.203 KB

Page generated in 0.15772199630737 seconds with 17 queries, spending 0.024016618728638 doing MySQL queries and 0.13370537757874 doing PHP things.
Shutdown Queries:
DISABLED