vBulletin

Including Functions.php

Time Before: 0.00012 seconds
Time After: 0.00014 seconds
Time Taken: 0.00002 seconds

Memory Before: 418.578 KB
Memory After: 420.414 KB
Memory Used: 1.836 KB

Connect to Database on Server: localhost

Time Before: 0.00016 seconds
Time After: 0.00036 seconds
Time Taken: 0.00020 seconds

Memory Before: 420.398 KB
Memory After: 421.289 KB
Memory Used: 0.891 KB

SQL Query

SET @@sql_mode = ''

Time Before: 0.00045 seconds
Time After: 0.00050 seconds
Time Taken: 0.00005 seconds

Memory Before: 421.336 KB
Memory After: 421.391 KB
Memory Used: 0.055 KB

Datastore Setup

SQL Query

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','mailqueue','pluginlistadmin')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	range	PRIMARY	PRIMARY	200		16	Using where

Time Before: 0.00073 seconds
Time After: 0.00130 seconds
Time Taken: 0.00057 seconds

Memory Before: 422.867 KB
Memory After: 639.734 KB
Memory Used: 216.867 KB

Time Before: 0.00051 seconds
Time After: 0.00622 seconds
Time Taken: 0.00571 seconds

Memory Before: 421.180 KB
Memory After: 946.977 KB
Memory Used: 525.797 KB

SQL Query

SELECT *
FROM datastore
WHERE title IN ('modstats_coder','modstats_designer','modstats_motm','modtitle_coder','modtitle_designer')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	range	PRIMARY	PRIMARY	200		5	Using where

Time Before: 0.00649 seconds
Time After: 0.00669 seconds
Time Taken: 0.00020 seconds

Memory Before: 948.305 KB
Memory After: 1,332.625 KB
Memory Used: 384.320 KB

Session Handling

SQL Query

SELECT *
FROM session
WHERE userid = 0
	AND host = '18.117.184.236'
	AND idhash = '2d868c4c27d13651295489baf292e97b'
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	session	ALL					986	Using where

Time Before: 0.00695 seconds
Time After: 0.00701 seconds
Time Taken: 0.00006 seconds

Memory Before: 1,138.781 KB
Memory After: 1,155.227 KB
Memory Used: 16.445 KB

SQL Query

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_plugins AS phrasegroup_plugins,
			phrasegroup_cpglobal AS phrasegroup_cpglobal,
			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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	language	system	PRIMARY				1

Time Before: 0.00730 seconds
Time After: 0.00801 seconds
Time Taken: 0.00070 seconds

Memory Before: 1,144.398 KB
Memory After: 1,273.000 KB
Memory Used: 128.602 KB

Time Before: 0.00676 seconds
Time After: 0.00805 seconds
Time Taken: 0.00129 seconds

Memory Before: 1,136.336 KB
Memory After: 1,205.672 KB
Memory Used: 69.336 KB

SQL Query

SELECT title FROM datastore

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	index		PRIMARY	200		33	Using index

Time Before: 0.00949 seconds
Time After: 0.01424 seconds
Time Taken: 0.00475 seconds

Memory Before: 1,289.328 KB
Memory After: 1,306.891 KB
Memory Used: 17.563 KB

SQL Query

SELECT script, action, optionname FROM adminhelp

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	adminhelp	index		phraseunique	706		1663	Using index

Time Before: 0.01545 seconds
Time After: 0.01742 seconds
Time Taken: 0.00197 seconds

Memory Before: 1,296.984 KB
Memory After: 1,469.211 KB
Memory Used: 172.227 KB

SQL Query

UPDATE session
SET location = '/admincp/plugin.php?do=productadd&explain=1', badlocation = 1
WHERE sessionhash = '1181eab85f83d57868e92e3b03d9c5df'

Time Before: 0.01907 seconds
Time After: 0.01923 seconds
Time Taken: 0.00015 seconds

Memory Before: 1,591.641 KB
Memory After: 1,591.594 KB
Memory Used: -0.047 KB