Including Functions.php

Time Before: 0.00111 seconds
Time After: 0.00153 seconds
Time Taken: 0.00042 seconds

Memory Before: 558.648 KB
Memory After: 671.813 KB
Memory Used: 113.164 KB

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

Time Before: 0.00161 seconds
Time After: 0.00404 seconds
Time Taken: 0.00243 seconds

Memory Before: 671.813 KB
Memory After: 672.758 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00438 seconds
Time After: 0.00467 seconds
Time Taken: 0.00029 seconds

Memory Before: 673.422 KB
Memory After: 673.984 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.00539 seconds
Time After: 0.00654 seconds
Time Taken: 0.00115 seconds

Memory Before: 677.367 KB
Memory After: 677.547 KB
Memory Used: 0.180 KB

Time Before: 0.00474 seconds
Time After: 0.01189 seconds
Time Taken: 0.00715 seconds

Memory Before: 673.227 KB
Memory After: 3,193.906 KB
Memory Used: 2,520.680 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.01303 seconds
Time After: 0.01322 seconds
Time Taken: 0.00018 seconds

Memory Before: 3,655.359 KB
Memory After: 3,655.813 KB
Memory Used: 0.453 KB

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

Time Before: 0.01393 seconds
Time After: 0.01421 seconds
Time Taken: 0.00028 seconds

Memory Before: 3,669.750 KB
Memory After: 3,670.125 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 rxlanguage
WHERE languageid = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxlanguagesystemPRIMARY   1 

Time Before: 0.01503 seconds
Time After: 0.01558 seconds
Time Taken: 0.00056 seconds

Memory Before: 3,682.609 KB
Memory After: 3,682.383 KB
Memory Used: -0.227 KB

Time Before: 0.01336 seconds
Time After: 0.01575 seconds
Time Taken: 0.00239 seconds

Memory Before: 3,662.695 KB
Memory After: 3,737.500 KB
Memory Used: 74.805 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.02006 seconds
Time After: 0.02051 seconds
Time Taken: 0.00045 seconds

Memory Before: 4,209.859 KB
Memory After: 4,210.250 KB
Memory Used: 0.391 KB

End call of global.php: 0.022342920303345
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 > 1713218838
	
ORDER BY username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrangelast_activitylast_activity4 16477Using where; Using temporary; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY403forums.session.userid1 

Time Before: 0.02443 seconds
Time After: 0.08424 seconds
Time Taken: 0.05981 seconds

Memory Before: 4,891.633 KB
Memory After: 4,891.734 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    224 
1SIMPLEusereq_refPRIMARYPRIMARY403forums.forum.lastposterid1 
1SIMPLEuserlisteq_refPRIMARY,relationid,useridPRIMARY9const,03forums.user.userid,const1Using where

Time Before: 0.14196 seconds
Time After: 0.14373 seconds
Time Taken: 0.00177 seconds

Memory Before: 4,935.859 KB
Memory After: 4,935.758 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.14873 seconds
Time After: 0.14934 seconds
Time Taken: 0.00061 seconds

Memory Before: 6,004.945 KB
Memory After: 6,005.047 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.20710 seconds
Time After: 0.20724 seconds
Time Taken: 0.00014 seconds

Memory Before: 6,495.063 KB
Memory After: 6,495.461 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.20766 seconds
Time After: 0.20779 seconds
Time Taken: 0.00013 seconds

Memory Before: 6,502.750 KB
Memory After: 6,503.148 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.20819 seconds
Time After: 0.20832 seconds
Time Taken: 0.00013 seconds

Memory Before: 6,510.383 KB
Memory After: 6,510.781 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.20871 seconds
Time After: 0.20884 seconds
Time Taken: 0.00012 seconds

Memory Before: 6,517.266 KB
Memory After: 6,517.664 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.20930 seconds
Time After: 0.20943 seconds
Time Taken: 0.00014 seconds

Memory Before: 6,539.500 KB
Memory After: 6,539.898 KB
Memory Used: 0.398 KB

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

Time Before: 0.21087 seconds
Time After: 0.21100 seconds
Time Taken: 0.00013 seconds

Memory Before: 6,634.625 KB
Memory After: 6,635.070 KB
Memory Used: 0.445 KB

SQL Query
SELECT * FROM rxglowhostspamomatic_stats
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxglowhostspamomatic_statsALL    1 

Time Before: 0.21153 seconds
Time After: 0.21163 seconds
Time Taken: 0.00010 seconds

Memory Before: 6,670.711 KB
Memory After: 6,671.188 KB
Memory Used: 0.477 KB

SQL Query
INSERT IGNORE INTO rxsession
	(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
	('2ea2c05f1f89861fe7ef1d509fe05d9b', 0, '172.71.222.114', '6e1ae31a5f0db3c1e37acfe9407fdc76', 1713226072, '/?explain=1', 0, 0, 0, 0, 0, 0, 0, 'CCBot/2.0 (https://commoncrawl.org/faq/)', 0, 0, 0, '')

Time Before: 0.21685 seconds
Time After: 0.21699 seconds
Time Taken: 0.00014 seconds

Memory Before: 7,715.500 KB
Memory After: 7,715.469 KB
Memory Used: -0.031 KB

Page generated in 0.21469712257385 seconds with 17 queries, spending 0.068558216094971 doing MySQL queries and 0.14613890647888 doing PHP things.
Shutdown Queries:
DISABLED