Including Functions.php

Time Before: 0.00052 seconds
Time After: 0.00070 seconds
Time Taken: 0.00018 seconds

Memory Before: 515.211 KB
Memory After: 540.141 KB
Memory Used: 24.930 KB

Connect to Database on Server: localhost

Time Before: 0.00073 seconds
Time After: 0.00097 seconds
Time Taken: 0.00024 seconds

Memory Before: 540.078 KB
Memory After: 540.992 KB
Memory Used: 0.914 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00112 seconds
Time After: 0.00119 seconds
Time Taken: 0.00007 seconds

Memory Before: 541.547 KB
Memory After: 542.070 KB
Memory Used: 0.523 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('maxloggedin','wol_spiders','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 18Using index condition

Time Before: 0.00154 seconds
Time After: 0.00179 seconds
Time Taken: 0.00025 seconds

Memory Before: 545.031 KB
Memory After: 545.906 KB
Memory Used: 0.875 KB

Time Before: 0.00122 seconds
Time After: 0.00282 seconds
Time Taken: 0.00160 seconds

Memory Before: 541.320 KB
Memory After: 1,262.492 KB
Memory Used: 721.172 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('dbtech_downloads_category','dbtech_downloads_domain','dbtech_downloads_extension','dbtech_downloads_extensiongroup')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 4Using index condition

Time Before: 0.00411 seconds
Time After: 0.00425 seconds
Time Taken: 0.00014 seconds

Memory Before: 1,828.320 KB
Memory After: 1,828.820 KB
Memory Used: 0.500 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '216.73.216.48'
	AND idhash = 'ea5a359a73a8141a16de516480d33c34'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrefguest_lookup,user_activityguest_lookup55const,const,const2Using where

Time Before: 0.00467 seconds
Time After: 0.00481 seconds
Time Taken: 0.00014 seconds

Memory Before: 1,850.477 KB
Memory After: 1,851.086 KB
Memory Used: 0.609 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_wol AS phrasegroup_wol,
			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 = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguagesystemPRIMARY   1 

Time Before: 0.00519 seconds
Time After: 0.00539 seconds
Time Taken: 0.00020 seconds

Memory Before: 1,862.063 KB
Memory After: 1,862.125 KB
Memory Used: 0.063 KB

Time Before: 0.00435 seconds
Time After: 0.00547 seconds
Time Taken: 0.00111 seconds

Memory Before: 1,843.492 KB
Memory After: 1,918.500 KB
Memory Used: 75.008 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('dbtech_downloads_domain','dbtech_downloads_extension')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 2Using index condition

Time Before: 0.00599 seconds
Time After: 0.00611 seconds
Time Taken: 0.00012 seconds

Memory Before: 1,967.617 KB
Memory After: 1,968.109 KB
Memory Used: 0.492 KB

SQL Query
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,
	calendar.calendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON
	(calendarpermission.calendarid = calendar.calendarid AND
		usergroupid IN (1))
ORDER BY displayorder ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcalendarsystem    1 
1SIMPLEcalendarpermissionsystem    0Const row not found

Time Before: 0.00645 seconds
Time After: 0.00652 seconds
Time Taken: 0.00007 seconds

Memory Before: 1,977.586 KB
Memory After: 1,977.906 KB
Memory Used: 0.320 KB

SQL Query
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,
	calendar.calendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON
	(calendarpermission.calendarid = calendar.calendarid AND
		usergroupid IN (1))
ORDER BY displayorder ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcalendarsystem    1 
1SIMPLEcalendarpermissionsystem    0Const row not found

Time Before: 0.00763 seconds
Time After: 0.00777 seconds
Time Taken: 0.00014 seconds

Memory Before: 2,254.805 KB
Memory After: 2,255.125 KB
Memory Used: 0.320 KB

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

Time Before: 0.04145 seconds
Time After: 0.04160 seconds
Time Taken: 0.00015 seconds

Memory Before: 2,276.023 KB
Memory After: 2,276.617 KB
Memory Used: 0.594 KB

End call of global.php: 0.042176961898804
SQL Query
SELECT title, template
FROM template
WHERE templateid IN (15277,15297,15298,15300,15306,15305,15695,0,15073,15072,15723,15724,12126,12125,12127,12122,12121,12713,12714,12712,12711,12130,12131,12718,15468,15753,15070,15418,15415,15416,15417,15761,0,0,15775,15716,15438,15439,15441,15442,15665,15745,15784,15737,15746,15265,15264,15268)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 46Using index condition

Time Before: 0.04299 seconds
Time After: 0.04330 seconds
Time Taken: 0.00031 seconds

Memory Before: 2,976.281 KB
Memory After: 2,977.594 KB
Memory Used: 1.313 KB

SQL Query
SELECT user.username, session.useragent, session.location, session.lastactivity, 
user.userid, user.options, session.host, session.badlocation, session.incalendar, 
session.inthread, user.aim, user.icq, user.msn, user.yahoo, user.skype

,IF(ISNULL(user.username), 1, 0) as isguest
,IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, user.infractiongroupid, user.usergroupid
FROM session As session 
LEFT JOIN user AS user USING (userid)


WHERE session.lastactivity > 1765699178
AND 
(
	
	(
		session.userid = 0
	)
 OR 
	(
		session.userid > 0
		AND session.sessionhash = 
		(
			SELECT sessionhash
			FROM session AS latest 
			WHERE latest.userid = session.userid
			ORDER BY latest.lastactivity DESC
			LIMIT 1
		)
	)

)

AND (NOT IF(session.userid > 0, (user.options & 512), 0) OR session.userid = -1)


ORDER BY isguest, user.username asc
LIMIT 0, 20
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYsessionrangelast_activity,user_activitylast_activity4 279Using where; Using temporary; Using filesort
1PRIMARYusereq_refPRIMARYPRIMARY4underdog_vbulletin.session.userid1Using where
2DEPENDENT SUBQUERYlatestrefuser_activityuser_activity4underdog_vbulletin.session.userid38Using where

Time Before: 0.04638 seconds
Time After: 0.04707 seconds
Time Taken: 0.00069 seconds

Memory Before: 3,082.719 KB
Memory After: 3,085.531 KB
Memory Used: 2.813 KB

SQL Query
SELECT session.userid
, IF(user.options & 512, 1, 0) AS invisible


FROM session AS session
LEFT JOIN user AS user USING (userid)


WHERE session.lastactivity > 1765699178
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrangelast_activitylast_activity4 279Using where
1SIMPLEusereq_refPRIMARYPRIMARY4underdog_vbulletin.session.userid1 

Time Before: 0.04739 seconds
Time After: 0.04791 seconds
Time Taken: 0.00052 seconds

Memory Before: 3,085.281 KB
Memory After: 3,092.383 KB
Memory Used: 7.102 KB

SQL Query
SELECT DISTINCT userid 
FROM moderator 
WHERE forumid <> -1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmoderatorindex userid_forumid6 6Using where; Using index

Time Before: 0.04865 seconds
Time After: 0.04872 seconds
Time Taken: 0.00007 seconds

Memory Before: 3,161.367 KB
Memory After: 3,161.891 KB
Memory Used: 0.523 KB

SQL Query
SELECT threadid, postid
FROM post
WHERE postid IN (0,211)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrangePRIMARYPRIMARY4 2Using index condition

Time Before: 0.04992 seconds
Time After: 0.05005 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,291.813 KB
Memory After: 3,292.367 KB
Memory Used: 0.555 KB

SQL Query
SELECT thread.title, thread.prefixid, thread.threadid, thread.forumid, thread.postuserid, thread.visible
,post.pagetext AS preview

FROM thread AS thread
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

WHERE thread.threadid IN (0,230,136)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrangePRIMARYPRIMARY4 3Using index condition
1SIMPLEposteq_refPRIMARYPRIMARY4underdog_vbulletin.thread.firstpostid1 

Time Before: 0.05033 seconds
Time After: 0.05050 seconds
Time Taken: 0.00017 seconds

Memory Before: 3,293.148 KB
Memory After: 3,293.609 KB
Memory Used: 0.461 KB

SQL Query
UPDATE session
SET lastactivity = 1765700078, location = '/online.php?explain=1&page=1&pp=20', inforum = 0, inthread = 0, badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', bypass = 0
WHERE sessionhash = 'e63c39bfb2010d6003760138de30957d'

Time Before: 0.05713 seconds
Time After: 0.05728 seconds
Time Taken: 0.00016 seconds

Memory Before: 3,888.617 KB
Memory After: 3,888.680 KB
Memory Used: 0.063 KB

Page generated in 0.05649995803833 seconds with 16 queries, spending 0.0035626888275146 doing MySQL queries and 0.052937269210815 doing PHP things.
Shutdown Queries:
DISABLED