vBulletin

Including Functions.php

Time Before: 0.00021 seconds
Time After: 0.00025 seconds
Time Taken: 0.00004 seconds

Memory Before: 468.961 KB
Memory After: 535.055 KB
Memory Used: 66.094 KB

Connect to Database on Server: localhost

Time Before: 0.00027 seconds
Time After: 0.00040 seconds
Time Taken: 0.00013 seconds

Memory Before: 535.008 KB
Memory After: 535.586 KB
Memory Used: 0.578 KB

SQL Query

SET @@sql_mode = ''

Time Before: 0.00049 seconds
Time After: 0.00062 seconds
Time Taken: 0.00014 seconds

Memory Before: 535.609 KB
Memory After: 535.664 KB
Memory Used: 0.055 KB

Datastore Setup

SQL Query

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	range	PRIMARY	PRIMARY	50		15	Using index condition

Time Before: 0.00089 seconds
Time After: 0.00139 seconds
Time Taken: 0.00050 seconds

Memory Before: 537.695 KB
Memory After: 937.133 KB
Memory Used: 399.438 KB

Time Before: 0.00064 seconds
Time After: 0.00268 seconds
Time Taken: 0.00205 seconds

Memory Before: 535.430 KB
Memory After: 1,557.367 KB
Memory Used: 1,021.938 KB

SQL Query

SELECT *
FROM datastore
WHERE title IN ('dbtech_ajaxthreads_usergroup')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 0.00307 seconds
Time After: 0.00310 seconds
Time Taken: 0.00004 seconds

Memory Before: 1,715.055 KB
Memory After: 1,731.172 KB
Memory Used: 16.117 KB

Session Handling

SQL Query

SELECT *
FROM session
WHERE userid = 0
	AND host = '3.231.212.98'
	AND idhash = 'c2d969c283c17227ed292590b876592a'
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	session	ref	user_activity,guest_lookup	guest_lookup	51	const,const,const	2	Using where

Time Before: 0.00340 seconds
Time After: 0.00357 seconds
Time Taken: 0.00017 seconds

Memory Before: 1,719.250 KB
Memory After: 1,735.602 KB
Memory Used: 16.352 KB

SQL Query

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_user AS phrasegroup_user,
			phrasegroup_forumdisplay AS phrasegroup_forumdisplay,
			phrasegroup_thread AS phrasegroup_thread,
			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 = 2

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

Time Before: 0.00425 seconds
Time After: 0.00432 seconds
Time Taken: 0.00008 seconds

Memory Before: 1,725.055 KB
Memory After: 1,893.867 KB
Memory Used: 168.813 KB

Time Before: 0.00314 seconds
Time After: 0.00437 seconds
Time Taken: 0.00123 seconds

Memory Before: 1,716.398 KB
Memory After: 1,886.133 KB
Memory Used: 169.734 KB

SQL Query

SELECT userip
FROM vsavilxh_guests AS vsavilxh_guests
WHERE userip = '3.231.212.98'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vsavilxh_guests	ALL					2823	Using where

Time Before: 0.00563 seconds
Time After: 0.00614 seconds
Time Taken: 0.00051 seconds

Memory Before: 2,136.852 KB
Memory After: 2,153.047 KB
Memory Used: 16.195 KB

SQL Query

INSERT INTO `vsavilxh_guests`
(userip, dateline)
VALUES ('3.231.212.98', '1576103140')

Time Before: 0.00617 seconds
Time After: 0.02171 seconds
Time Taken: 0.01555 seconds

Memory Before: 2,153.195 KB
Memory After: 2,153.164 KB
Memory Used: -0.031 KB

SQL Query

DELETE FROM vsavilxh_guests WHERE dateline < '1576016740'

Time Before: 0.02175 seconds
Time After: 0.02253 seconds
Time Taken: 0.00079 seconds

Memory Before: 2,136.461 KB
Memory After: 2,136.492 KB
Memory Used: 0.031 KB

SQL Query

SELECT *
FROM style
WHERE (styleid = 12 AND userselect = 1)
	OR styleid = 12
ORDER BY styleid ASC
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	style	const	PRIMARY	PRIMARY	2	const	1

Time Before: 0.02284 seconds
Time After: 0.02290 seconds
Time Taken: 0.00006 seconds

Memory Before: 2,122.086 KB
Memory After: 2,234.711 KB
Memory Used: 112.625 KB

SQL Query

SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
	AND varname = 'nopermission_loggedout' AND languageid IN (-1, 0, 2)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	276		3	Using index condition
1	SIMPLE	phrasetype	const	PRIMARY	PRIMARY	20	const	1	Using where

Time Before: 0.02399 seconds
Time After: 0.02403 seconds
Time Taken: 0.00004 seconds

Memory Before: 2,512.586 KB
Memory After: 2,528.711 KB
Memory Used: 16.125 KB

SQL Query

SELECT title, template
FROM template
WHERE templateid IN (1541,1538,1149,1531,1477,1481,2233,2231,2234,2235,0,0,79,73,72,2344,2347,2101,75,80,81,82,1337,1634,2221,2222,1286,1287,1650,0,0,1613,1615,1307,1308,1310,1311,1534,1577,1576,1626,1578,1137,1136,1140,2249,1931,1932,1129,1132,1130,1295,1131,2226)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		51	Using index condition

Time Before: 0.02484 seconds
Time After: 0.02643 seconds
Time Taken: 0.00159 seconds

Memory Before: 2,719.648 KB
Memory After: 2,876.398 KB
Memory Used: 156.750 KB

SQL Query

SELECT * FROM molding ORDER BY molding.order ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	molding	ALL					11	Using filesort

Time Before: 0.02719 seconds
Time After: 0.02722 seconds
Time Taken: 0.00004 seconds

Memory Before: 2,901.039 KB
Memory After: 2,918.984 KB
Memory Used: 17.945 KB

SQL Query

INSERT IGNORE INTO session
	(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken, topxtab, topxmenu, topxresult)
VALUES
	('e05468ab5df1c6962984c5f31310ba43', 0, '3.231.212.98', 'c2d969c283c17227ed292590b876592a', 1576103140, '/forum/subscription.php?explain=1', 0, 0, 0, 0, 0, 0, 1, 'CCBot/2.0 (https://commoncrawl.org/faq/)', 0, 0, 0, '', '0', '0', 0)

Time Before: 0.03001 seconds
Time After: 0.03022 seconds
Time Taken: 0.00021 seconds

Memory Before: 2,980.117 KB
Memory After: 2,979.492 KB
Memory Used: -0.625 KB