Including Functions.php

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

Memory Before: 558.500 KB
Memory After: 671.664 KB
Memory Used: 113.164 KB

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

Time Before: 0.00108 seconds
Time After: 0.00479 seconds
Time Taken: 0.00372 seconds

Memory Before: 671.664 KB
Memory After: 672.609 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00515 seconds
Time After: 0.00559 seconds
Time Taken: 0.00044 seconds

Memory Before: 673.305 KB
Memory After: 673.867 KB
Memory Used: 0.563 KB

Datastore Setup
SQL Query
SELECT *
FROM rxdatastore
WHERE title IN ('navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxdatastorerangePRIMARYPRIMARY50 16Using where

Time Before: 0.00624 seconds
Time After: 0.00713 seconds
Time Taken: 0.00089 seconds

Memory Before: 676.844 KB
Memory After: 677.109 KB
Memory Used: 0.266 KB

Time Before: 0.00567 seconds
Time After: 0.01085 seconds
Time Taken: 0.00519 seconds

Memory Before: 673.078 KB
Memory After: 3,151.352 KB
Memory Used: 2,478.273 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.01178 seconds
Time After: 0.01206 seconds
Time Taken: 0.00028 seconds

Memory Before: 3,639.234 KB
Memory After: 3,639.688 KB
Memory Used: 0.453 KB

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

Time Before: 0.01284 seconds
Time After: 0.01317 seconds
Time Taken: 0.00033 seconds

Memory Before: 3,653.625 KB
Memory After: 3,654.000 KB
Memory Used: 0.375 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_messaging AS phrasegroup_messaging,
			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.01406 seconds
Time After: 0.01458 seconds
Time Taken: 0.00051 seconds

Memory Before: 3,664.438 KB
Memory After: 3,664.266 KB
Memory Used: -0.172 KB

Time Before: 0.01222 seconds
Time After: 0.01469 seconds
Time Taken: 0.00247 seconds

Memory Before: 3,646.539 KB
Memory After: 3,718.055 KB
Memory Used: 71.516 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.01778 seconds
Time After: 0.01820 seconds
Time Taken: 0.00042 seconds

Memory Before: 4,190.430 KB
Memory After: 4,190.820 KB
Memory Used: 0.391 KB

End call of global.php: 0.019528865814209
SQL Query
SELECT title, template
FROM rxtemplate
WHERE templateid IN (11357,11419,11374,11403,11081,0,10949,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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplaterangePRIMARYPRIMARY4 45Using where

Time Before: 0.02063 seconds
Time After: 0.02129 seconds
Time Taken: 0.00065 seconds

Memory Before: 4,912.016 KB
Memory After: 4,912.227 KB
Memory Used: 0.211 KB

SQL Query
SELECT hvquestion.questionid, COUNT(*) AS answers
FROM rxhvquestion AS hvquestion
LEFT JOIN rxhvanswer AS hvanswer
	ON (hvquestion.questionid = hvanswer.questionid)
WHERE hvanswer.answerid IS NOT NULL
	OR hvquestion.regex <> ''
GROUP BY hvquestion.questionid
ORDER BY RAND()
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhvquestionindex PRIMARY4 1Using temporary; Using filesort
1SIMPLEhvanswerrefquestionidquestionid403forums.hvquestion.questionid1Using where; Using index

Time Before: 0.02624 seconds
Time After: 0.02662 seconds
Time Taken: 0.00038 seconds

Memory Before: 5,058.867 KB
Memory After: 5,059.078 KB
Memory Used: 0.211 KB

SQL Query
INSERT INTO rxhumanverify
	(hash, answer, dateline)
VALUES
	('cad7e6b59b5f48cdcf21f65afd501bb9', '4', 1669937239)

Time Before: 0.02675 seconds
Time After: 0.02740 seconds
Time Taken: 0.00066 seconds

Memory Before: 5,058.633 KB
Memory After: 5,058.922 KB
Memory Used: 0.289 KB

SQL Query
SELECT text, languageid, special
FROM rxphrase AS phrase
LEFT JOIN rxphrasetype USING (fieldname)
WHERE phrase.fieldname = 'hvquestion'
	AND varname = 'question4'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserefname_lang_typename_lang_type252const1Using index condition
1SIMPLErxphrasetypeconstPRIMARYPRIMARY20const1Using where

Time Before: 0.02814 seconds
Time After: 0.02851 seconds
Time Taken: 0.00037 seconds

Memory Before: 5,067.781 KB
Memory After: 5,068.133 KB
Memory Used: 0.352 KB

SQL Query
UPDATE rxsession
SET lastactivity = 1669937239, location = '/sendmessage.php?explain=1', badlocation = 0
WHERE sessionhash = 'c30e63f1044bb6430a0674cf7de7ad41'

Time Before: 0.03227 seconds
Time After: 0.03259 seconds
Time Taken: 0.00033 seconds

Memory Before: 5,333.000 KB
Memory After: 5,333.227 KB
Memory Used: 0.227 KB

Page generated in 0.031605958938599 seconds with 11 queries, spending 0.0089809894561768 doing MySQL queries and 0.022624969482422 doing PHP things.
Shutdown Queries:
DISABLED