Including Functions.php

Time Before: 0.00076 seconds
Time After: 0.00100 seconds
Time Taken: 0.00024 seconds

Memory Before: 1,182.234 KB
Memory After: 1,190.508 KB
Memory Used: 8.273 KB

Connect to Database on Server: localhost

Time Before: 0.00107 seconds
Time After: 0.00140 seconds
Time Taken: 0.00033 seconds

Memory Before: 1,190.391 KB
Memory After: 1,191.172 KB
Memory Used: 0.781 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','iconcache','mailqueue','prefixcache')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY50 17Using where

Time Before: 0.00213 seconds
Time After: 0.00343 seconds
Time Taken: 0.00130 seconds

Memory Before: 1,194.258 KB
Memory After: 1,194.594 KB
Memory Used: 0.336 KB

Time Before: 0.00167 seconds
Time After: 0.00463 seconds
Time Taken: 0.00296 seconds

Memory Before: 1,190.672 KB
Memory After: 1,865.445 KB
Memory Used: 674.773 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.161.98.96'
	AND idhash = '31510ec60f95c1bf9a71c9e1aee169e4'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    84Using where

Time Before: 0.00526 seconds
Time After: 0.00582 seconds
Time Taken: 0.00056 seconds

Memory Before: 1,882.281 KB
Memory After: 1,882.695 KB
Memory Used: 0.414 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_forumdisplay AS phrasegroup_forumdisplay,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroup_autopm_title AS phrasegroup_autopm_title,
			phrasegroup_autopm_text AS phrasegroup_autopm_text,
			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 = 2
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguageconstPRIMARYPRIMARY2const1 

Time Before: 0.00666 seconds
Time After: 0.00679 seconds
Time Taken: 0.00014 seconds

Memory Before: 1,893.117 KB
Memory After: 1,892.813 KB
Memory Used: -0.305 KB

Time Before: 0.00492 seconds
Time After: 0.00695 seconds
Time Taken: 0.00203 seconds

Memory Before: 1,877.906 KB
Memory After: 1,959.250 KB
Memory Used: 81.344 KB

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

Time Before: 0.00971 seconds
Time After: 0.00987 seconds
Time Taken: 0.00015 seconds

Memory Before: 2,149.891 KB
Memory After: 2,150.328 KB
Memory Used: 0.438 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (1931,1074,2376,2378,2377,1077,2028,1683,1076,2029,2035,2037,2021,2034,2022,2023,2036,2038,2033,2427,2437,2366,2495,1778,2541,1934,1933,1935,1930,1929,2206,1078,2158,2159,2160,2426,2429,2438,2179,2180,2181,2182,2380,2443,2442,2444,2447,1710,1711,2542,1702,1708,1707,1713,1712,1703,1709,1601,1740,1610,1754,1661,1720,1630,1627,1628,1654,1629,1673,1675,1674,1856,1860,1863,1855,1862,1861,1858,1857,1865,1864,1866,1867,2450,2451,2473,2519)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 87Using where

Time Before: 0.01117 seconds
Time After: 0.01138 seconds
Time Taken: 0.00021 seconds

Memory Before: 2,366.031 KB
Memory After: 2,366.086 KB
Memory Used: 0.055 KB

SQL Query
SELECT krmessage.message, krmessage.krmessageid, krmessage.active,
     user.userid, user.username, user.usergroupid, user.membergroupids, user.profilepicrevision, user.lastpost,
     (user.options & 512) AS invisible, user.usertitle,
     customprofilepic.dateline, customprofilepic.height, customprofilepic.width,
     session.inforum, session.lastactivity
FROM krmessage AS krmessage
INNER JOIN user AS user ON(user.userid = krmessage.userid)
INNER JOIN customprofilepic AS customprofilepic ON(user.userid = customprofilepic.userid)
LEFT JOIN session AS session ON(session.userid = user.userid)
WHERE krmessage.active = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEkrmessagesystem    1 
1SIMPLEcustomprofilepicsystemPRIMARY   1 
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEsessionALL    84 

Time Before: 0.01320 seconds
Time After: 0.01349 seconds
Time Taken: 0.00030 seconds

Memory Before: 2,586.180 KB
Memory After: 2,585.992 KB
Memory Used: -0.188 KB

End call of global.php: 0.014555931091309
SQL Query
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid
	
FROM forum AS forum
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumALL    11 

Time Before: 0.01598 seconds
Time After: 0.01608 seconds
Time Taken: 0.00009 seconds

Memory Before: 2,749.898 KB
Memory After: 2,750.281 KB
Memory Used: 0.383 KB

SQL Query
SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmoderatorsystemuserid_forumid   1 
1SIMPLEuserconstPRIMARYPRIMARY4const1 

Time Before: 0.01684 seconds
Time After: 0.01693 seconds
Time Taken: 0.00009 seconds

Memory Before: 2,770.609 KB
Memory After: 2,770.953 KB
Memory Used: 0.344 KB

SQL Query
SELECT phrasegroup_cthreadfield AS cthreadfield
FROM language
WHERE languageid = 2
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguageconstPRIMARYPRIMARY2const1 

Time Before: 0.02196 seconds
Time After: 0.02204 seconds
Time Taken: 0.00009 seconds

Memory Before: 2,830.938 KB
Memory After: 2,831.406 KB
Memory Used: 0.469 KB

SQL Query
SELECT * FROM threadfield AS threadfield
LEFT JOIN threadfieldcategory AS threadfieldcategory ON (threadfieldcategory.threadfieldcategoryid = threadfield.threadfieldcategoryid)
WHERE ((forumids = "") OR (forumids = '7' OR forumids LIKE '7,%' OR forumids LIKE '%,7,%' OR forumids LIKE '%,7') OR (forumids = '-1' OR forumids LIKE '-1,%' OR forumids LIKE '%,-1,%' OR forumids LIKE '%,-1')) AND sortable = 1
ORDER BY threadfieldcategory.displayorder, threadfield.displayorder
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadfieldALLforumids   3Using where; Using temporary; Using filesort
1SIMPLEthreadfieldcategoryeq_refPRIMARYPRIMARY2vkinoku.threadfield.threadfieldcategoryid1 

Time Before: 0.02279 seconds
Time After: 0.02564 seconds
Time Taken: 0.00285 seconds

Memory Before: 2,835.359 KB
Memory After: 2,835.438 KB
Memory Used: 0.078 KB

SQL Query
SELECT *
    FROM rbs_banners 
    WHERE enabled=1
        AND startdate<=1642848543
        AND enddate>=1642848543
        AND IF(forumhome, 7=0, IF(forumids='', 1, FIND_IN_SET('7', forumids)))
        AND IF(maximpressions>0, impressions0 AND clicks
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErbs_bannersALL    6Using where

Time Before: 0.02782 seconds
Time After: 0.02818 seconds
Time Taken: 0.00037 seconds

Memory Before: 3,275.617 KB
Memory After: 3,275.828 KB
Memory Used: 0.211 KB

SQL Query
UPDATE session
SET lastactivity = 1642848543, location = '/forumdisplay.php?f=7&explain=1', inforum = 7, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'b265d1c28ec1faa4f08eb7660767eb0a'

Time Before: 0.02870 seconds
Time After: 0.02900 seconds
Time Taken: 0.00030 seconds

Memory Before: 3,202.078 KB
Memory After: 3,202.297 KB
Memory Used: 0.219 KB

Page generated in 0.026602983474731 seconds with 12 queries, spending 0.0067739486694336 doing MySQL queries and 0.019829034805298 doing PHP things.
Shutdown Queries:
DISABLED