Including Functions.php

Time Before: 0.00107 seconds
Time After: 0.00126 seconds
Time Taken: 0.00020 seconds

Memory Before: 472.375 KB
Memory After: 475.156 KB
Memory Used: 2.781 KB

Connect to Database on Server: localhost

Time Before: 0.00136 seconds
Time After: 0.00287 seconds
Time Taken: 0.00151 seconds

Memory Before: 475.133 KB
Memory After: 476.023 KB
Memory Used: 0.891 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00310 seconds
Time After: 0.00326 seconds
Time Taken: 0.00016 seconds

Memory Before: 476.047 KB
Memory After: 476.102 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
1SIMPLEdatastorerangePRIMARYPRIMARY52 23Using index condition

Time Before: 0.00401 seconds
Time After: 0.01157 seconds
Time Taken: 0.00757 seconds

Memory Before: 478.133 KB
Memory After: 991.688 KB
Memory Used: 513.555 KB

Time Before: 0.00329 seconds
Time After: 0.02778 seconds
Time Taken: 0.02449 seconds

Memory Before: 475.867 KB
Memory After: 1,980.203 KB
Memory Used: 1,504.336 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '34.238.192.150'
	AND idhash = '89ca6f6cacf975f2c412885d1c8c62ea'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrefguest_lookup,user_activityguest_lookup237const,const,const3Using where

Time Before: 0.02894 seconds
Time After: 0.02928 seconds
Time Taken: 0.00034 seconds

Memory Before: 2,140.367 KB
Memory After: 2,157.211 KB
Memory Used: 16.844 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 = 29
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguageconstPRIMARYPRIMARY2const1 

Time Before: 0.03051 seconds
Time After: 0.03100 seconds
Time Taken: 0.00049 seconds

Memory Before: 2,146.703 KB
Memory After: 2,347.313 KB
Memory Used: 200.609 KB

Time Before: 0.02839 seconds
Time After: 0.03113 seconds
Time Taken: 0.00273 seconds

Memory Before: 2,136.836 KB
Memory After: 2,245.102 KB
Memory Used: 108.266 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 43 AND userselect = 1)
	OR styleid = 43
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 

Time Before: 0.03936 seconds
Time After: 0.03972 seconds
Time Taken: 0.00035 seconds

Memory Before: 2,710.008 KB
Memory After: 2,934.656 KB
Memory Used: 224.648 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (16617,14695,26169,26170,26171,26173,26174,26175,26176,26172,21922,26243,26249,21924,21925,21926,21927,21928,26594,22152,22023,24124,21985,14006,14005,14007,14002,14001,22160,16679,22184,22188,14010,14011,22173,26431,21987,22061,26381,26378,26379,26380,26735,0,0,26715,26676,26401,26402,26404,26405,26628,26747,26729,26679,26680,26228,26227,26231,16232,16311,16312,22144,0,22145,22148,0,22146,22147,22072,22077,22073,22064,22079,22063,22071,22066,22074,22084,22070,22076,22087,22085,22086,22078,22082,22081,22067,22083,22068,22069,22075,22065,22080,16537,16534,16538,16535,16536,16539,16990,16989,16991,16992,16549,16550,16939,17701,17702,17699,17700,27007)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 109Using index condition

Time Before: 0.04872 seconds
Time After: 0.05052 seconds
Time Taken: 0.00179 seconds

Memory Before: 3,260.813 KB
Memory After: 3,477.992 KB
Memory Used: 217.180 KB

SQL Query
SELECT id, name, impressions, position, url, image, clicktrack, clicks, text, usergroups
    FROM rbs_banners 
    WHERE enabled=1
        AND startdate<=1573689910
        AND enddate>=1573689910
        AND IF(forumhome, 0=0, IF(forumids='', 1, FIND_IN_SET('0', forumids)))
        AND IF(maximpressions>0, impressions0 AND clicks
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.06094 seconds
Time After: 0.06133 seconds
Time Taken: 0.00039 seconds

Memory Before: 3,574.773 KB
Memory After: 3,591.227 KB
Memory Used: 16.453 KB

SQL Query
UPDATE session
SET lastactivity = 1573689910, location = '/forum/?explain=1'
WHERE sessionhash = '7cbb104f43bf0e941bbafa8613963462'

Time Before: 0.06151 seconds
Time After: 0.06194 seconds
Time Taken: 0.00043 seconds

Memory Before: 3,554.008 KB
Memory After: 3,553.992 KB
Memory Used: -0.016 KB

Page generated in 0.059542179107666 seconds with 8 queries, spending 0.013028860092163 doing MySQL queries and 0.046513319015503 doing PHP things.
Shutdown Queries:
DISABLED