Including Functions.php

Time Before: 0.00045 seconds
Time After: 0.00053 seconds
Time Taken: 0.00008 seconds

Memory Before: 432.023 KB
Memory After: 498.977 KB
Memory Used: 66.953 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00057 seconds
Time After: 0.00173 seconds
Time Taken: 0.00116 seconds

Memory Before: 498.953 KB
Memory After: 499.844 KB
Memory Used: 0.891 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00202 seconds
Time After: 0.00219 seconds
Time Taken: 0.00017 seconds

Memory Before: 499.867 KB
Memory After: 499.922 KB
Memory Used: 0.055 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('iconcache','searchcloud','routes','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY52 18100.00Using index condition

Time Before: 0.00285 seconds
Time After: 0.00369 seconds
Time Taken: 0.00085 seconds

Memory Before: 501.625 KB
Memory After: 740.273 KB
Memory Used: 238.648 KB

Time Before: 0.00221 seconds
Time After: 0.01746 seconds
Time Taken: 0.01525 seconds

Memory Before: 499.688 KB
Memory After: 1,130.641 KB
Memory Used: 630.953 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.196.213.0'
	AND idhash = 'a620bef3bac9ecb97ed637c44b87f2c4'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refguest_lookup,user_activityguest_lookup55const,const,const1100.00 

Time Before: 0.01909 seconds
Time After: 0.02195 seconds
Time Taken: 0.00286 seconds

Memory Before: 1,290.563 KB
Memory After: 1,307.328 KB
Memory Used: 16.766 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroup_socialgroups AS phrasegroup_socialgroups,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroup_user AS phrasegroup_user,
			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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLElanguage systemPRIMARY   1100.00 

Time Before: 0.02503 seconds
Time After: 0.02572 seconds
Time Taken: 0.00069 seconds

Memory Before: 1,298.938 KB
Memory After: 1,431.578 KB
Memory Used: 132.641 KB

Time Before: 0.01800 seconds
Time After: 0.02590 seconds
Time Taken: 0.00790 seconds

Memory Before: 1,288.328 KB
Memory After: 1,421.117 KB
Memory Used: 132.789 KB

SQL Query
SELECT COUNT(*) AS count FROM user WHERE usergroupid = 4
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEuser refusergroupidusergroupid2const2100.00Using index

Time Before: 0.11399 seconds
Time After: 0.11425 seconds
Time Taken: 0.00026 seconds

Memory Before: 1,725.227 KB
Memory After: 1,741.414 KB
Memory Used: 16.188 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 19 AND userselect = 1)
	OR styleid = 19
ORDER BY styleid ASC
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

Time Before: 0.11495 seconds
Time After: 0.11538 seconds
Time Taken: 0.00043 seconds

Memory Before: 1,718.406 KB
Memory After: 1,847.047 KB
Memory Used: 128.641 KB

End call of global.php: 0.12294697761536
SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vb_types.types'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

Time Before: 0.12431 seconds
Time After: 0.12474 seconds
Time Taken: 0.00043 seconds

Memory Before: 2,345.461 KB
Memory After: 2,361.914 KB
Memory Used: 16.453 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (0,24963,24443,24463,24469,24471,24467,24479,24475,24477,24481,24265,24271,24273,24709,24713,24711,24255,24689,24687,24647,24645,24445,24455,24457,24643,23975,16601,25469,25468,24891,14189,14188,14190,14185,14184,14951,14953,14949,14947,14193,14194,14961,24321,21591,16585,24221,24215,24217,16589,24929,0,0,24889,24811,24261,24263,24267,24269,24715,24953,24917,24817,24819,23915,23913,23921,21563,21565)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 67100.00Using index condition

Time Before: 0.12810 seconds
Time After: 0.12905 seconds
Time Taken: 0.00095 seconds

Memory Before: 2,573.719 KB
Memory After: 2,771.680 KB
Memory Used: 197.961 KB

SQL Query
SELECT template
FROM template
WHERE templateid = 16587
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate constPRIMARYPRIMARY4const1100.00 

Time Before: 0.13030 seconds
Time After: 0.13047 seconds
Time Taken: 0.00016 seconds

Memory Before: 2,768.109 KB
Memory After: 2,784.391 KB
Memory Used: 16.281 KB

SQL Query
SELECT contenttype.contenttypeid AS itemid
	
FROM contenttype AS contenttype
	INNER JOIN package AS package
	ON package.packageid = contenttype.packageid LEFT JOIN product AS product
	ON product.productid = package.productid 
WHERE
	1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin')  AND contenttype.cansearch = '1'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEpackage ALLPRIMARY   1100.00 
1SIMPLEproduct eq_refPRIMARYPRIMARY27webdev.package.productid1100.00Using where
1SIMPLEcontenttype ALLpackageclass   1850.00Using where; Using join buffer (Block Nested Loop)

Time Before: 0.13408 seconds
Time After: 0.13490 seconds
Time Taken: 0.00082 seconds

Memory Before: 2,801.516 KB
Memory After: 2,818.328 KB
Memory Used: 16.813 KB

SQL Query
SELECT hvquestion.questionid, COUNT(*) AS answers
FROM hvquestion AS hvquestion
LEFT JOIN hvanswer AS hvanswer
	ON (hvquestion.questionid = hvanswer.questionid)
WHERE hvanswer.answerid IS NOT NULL
	OR hvquestion.regex <> ''
GROUP BY hvquestion.questionid
ORDER BY RAND()
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhvquestion ALLPRIMARY   3100.00Using temporary; Using filesort
1SIMPLEhvanswer ALLquestionid   5100.00Using where; Using join buffer (Block Nested Loop)

Time Before: 0.13637 seconds
Time After: 0.13667 seconds
Time Taken: 0.00030 seconds

Memory Before: 2,950.422 KB
Memory After: 2,966.969 KB
Memory Used: 16.547 KB

SQL Query
INSERT INTO humanverify
	(hash, answer, dateline)
VALUES
	('c9ca5320f5067de3a47b197c5006e835', '13', 1519108281)

Time Before: 0.13677 seconds
Time After: 0.13707 seconds
Time Taken: 0.00030 seconds

Memory Before: 2,949.883 KB
Memory After: 2,949.820 KB
Memory Used: -0.063 KB

SQL Query
SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'hvquestion'
	AND varname = 'question13'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEphrase refname_lang_typename_lang_type252const210.00Using index condition
1SIMPLEphrasetype constPRIMARYPRIMARY22const1100.00 

Time Before: 0.13761 seconds
Time After: 0.13792 seconds
Time Taken: 0.00031 seconds

Memory Before: 2,950.602 KB
Memory After: 2,966.820 KB
Memory Used: 16.219 KB

SQL Query
SELECT contenttype.contenttypeid AS itemid
	
FROM contenttype AS contenttype
	INNER JOIN package AS package
	ON package.packageid = contenttype.packageid LEFT JOIN product AS product
	ON product.productid = package.productid 
WHERE
	1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin')  AND contenttype.cantag = '1'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEpackage ALLPRIMARY   1100.00 
1SIMPLEproduct eq_refPRIMARYPRIMARY27webdev.package.productid1100.00Using where
1SIMPLEcontenttype ALLpackageclass   1850.00Using where; Using join buffer (Block Nested Loop)

Time Before: 0.13863 seconds
Time After: 0.13890 seconds
Time Taken: 0.00026 seconds

Memory Before: 2,957.836 KB
Memory After: 2,974.367 KB
Memory Used: 16.531 KB

SQL Query
SELECT tagsearch.tagid, COUNT(*) AS searchcount
FROM tagsearch AS tagsearch
WHERE tagsearch.dateline > 1516516281
GROUP BY tagsearch.tagid
ORDER BY searchcount DESC
LIMIT 70
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtagsearch ALLtagid,dateline   2436799.16Using where; Using temporary; Using filesort

Time Before: 0.13944 seconds
Time After: 0.16453 seconds
Time Taken: 0.02510 seconds

Memory Before: 2,959.609 KB
Memory After: 2,982.133 KB
Memory Used: 22.523 KB

SQL Query
SELECT tag.tagid, tag.tagtext
						FROM tag AS tag
					   WHERE tag.tagid IN (2162,1286,299,59,2014,163,1279,200,849,1407,10,52,3,929,1287,357,18,173,140,8863,1188,100,139,245,70,12679,123,56,264,15,345,1344,102,192,57,41,597,177,40,342,463,21,476,553,127,635,128,522,643,606,444,55,151,728,450,111,1015,133,5163,533,4171,7657,71,25,88,282,280,42539,414,175)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtag rangePRIMARYPRIMARY4 70100.00Using where

Time Before: 0.16535 seconds
Time After: 0.16617 seconds
Time Taken: 0.00081 seconds

Memory Before: 2,995.000 KB
Memory After: 3,017.742 KB
Memory Used: 22.742 KB

SQL Query
REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('searchcloud', 'a:3:{s:4:\"tags\";a:70:{s:4:\"ajax\";a:5:{s:5:\"tagid\";s:3:\"100\";s:11:\"searchcount\";s:3:\"102\";s:7:\"tagtext\";s:4:\"ajax\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:4:\"ajax\";}s:3:\"api\";a:5:{s:5:\"tagid\";s:3:\"299\";s:11:\"searchcount\";s:3:\"132\";s:7:\"tagtext\";s:3:\"api\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:3:\"api\";}s:5:\"array\";a:5:{s:5:\"tagid\";s:2:\"40\";s:11:\"searchcount\";s:2:\"89\";s:7:\"tagtext\";s:5:\"array\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"array\";}s:7:\"asp.net\";a:5:{s:5:\"tagid\";s:4:\"1279\";s:11:\"searchcount\";s:3:\"126\";s:7:\"tagtext\";s:7:\"asp.net\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:7:\"asp.net\";}s:6:\"button\";a:5:{s:5:\"tagid\";s:3:\"728\";s:11:\"searchcount\";s:2:\"80\";s:7:\"tagtext\";s:6:\"button\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"button\";}s:6:\"chrome\";a:5:{s:5:\"tagid\";s:3:\"553\";s:11:\"searchcount\";s:2:\"86\";s:7:\"tagtext\";s:6:\"chrome\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"chrome\";}s:3:\"cms\";a:5:{s:5:\"tagid\";s:2:\"70\";s:11:\"searchcount\";s:3:\"100\";s:7:\"tagtext\";s:3:\"cms\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:3:\"cms\";}s:4:\"code\";a:5:{s:5:\"tagid\";s:3:\"192\";s:11:\"searchcount\";s:2:\"92\";s:7:\"tagtext\";s:4:\"code\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"code\";}s:7:\"cookies\";a:5:{s:5:\"tagid\";s:4:\"1015\";s:11:\"searchcount\";s:2:\"80\";s:7:\"tagtext\";s:7:\"cookies\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"cookies\";}s:3:\"css\";a:5:{s:5:\"tagid\";s:2:\"18\";s:11:\"searchcount\";s:3:\"113\";s:7:\"tagtext\";s:3:\"css\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:3:\"css\";}s:4:\"css3\";a:5:{s:5:\"tagid\";s:4:\"1407\";s:11:\"searchcount\";s:3:\"125\";s:7:\"tagtext\";s:4:\"css3\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:4:\"css3\";}s:8:\"database\";a:5:{s:5:\"tagid\";s:3:\"139\";s:11:\"searchcount\";s:3:\"102\";s:7:\"tagtext\";s:8:\"database\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:8:\"database\";}s:6:\"design\";a:5:{s:5:\"tagid\";s:2:\"55\";s:11:\"searchcount\";s:2:\"81\";s:7:\"tagtext\";s:6:\"design\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"design\";}s:11:\"development\";a:5:{s:5:\"tagid\";s:3:\"929\";s:11:\"searchcount\";s:3:\"122\";s:7:\"tagtext\";s:11:\"development\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:11:\"development\";}s:3:\"div\";a:5:{s:5:\"tagid\";s:2:\"21\";s:11:\"searchcount\";s:2:\"87\";s:7:\"tagtext\";s:3:\"div\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:3:\"div\";}s:3:\"dom\";a:5:{s:5:\"tagid\";s:3:\"606\";s:11:\"searchcount\";s:2:\"81\";s:7:\"tagtext\";s:3:\"dom\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:3:\"dom\";}s:7:\"dynamic\";a:5:{s:5:\"tagid\";s:3:\"357\";s:11:\"searchcount\";s:3:\"117\";s:7:\"tagtext\";s:7:\"dynamic\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:7:\"dynamic\";}s:5:\"email\";a:5:{s:5:\"tagid\";s:3:\"522\";s:11:\"searchcount\";s:2:\"83\";s:7:\"tagtext\";s:5:\"email\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"email\";}s:5:\"error\";a:5:{s:5:\"tagid\";s:3:\"102\";s:11:\"searchcount\";s:2:\"92\";s:7:\"tagtext\";s:5:\"error\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"error\";}s:7:\"firefox\";a:5:{s:5:\"tagid\";s:2:\"57\";s:11:\"searchcount\";s:2:\"91\";s:7:\"tagtext\";s:7:\"firefox\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"firefox\";}s:5:\"flash\";a:5:{s:5:\"tagid\";s:3:\"282\";s:11:\"searchcount\";s:2:\"74\";s:7:\"tagtext\";s:5:\"flash\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"flash\";}s:4:\"form\";a:5:{s:5:\"tagid\";s:2:\"71\";s:11:\"searchcount\";s:2:\"76\";s:7:\"tagtext\";s:4:\"form\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:4:\"form\";}s:8:\"function\";a:5:{s:5:\"tagid\";s:2:\"25\";s:11:\"searchcount\";s:2:\"76\";s:7:\"tagtext\";s:8:\"function\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"function\";}s:6:\"google\";a:5:{s:5:\"tagid\";s:3:\"597\";s:11:\"searchcount\";s:2:\"90\";s:7:\"tagtext\";s:6:\"google\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"google\";}s:8:\"htaccess\";a:5:{s:5:\"tagid\";s:3:\"163\";s:11:\"searchcount\";s:3:\"126\";s:7:\"tagtext\";s:8:\"htaccess\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:8:\"htaccess\";}s:4:\"html\";a:5:{s:5:\"tagid\";s:3:\"173\";s:11:\"searchcount\";s:3:\"112\";s:7:\"tagtext\";s:4:\"html\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:4:\"html\";}s:5:\"html5\";a:5:{s:5:\"tagid\";s:4:\"1344\";s:11:\"searchcount\";s:2:\"92\";s:7:\"tagtext\";s:5:\"html5\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"html5\";}s:6:\"html 5\";a:5:{s:5:\"tagid\";s:4:\"2162\";s:11:\"searchcount\";s:3:\"136\";s:7:\"tagtext\";s:6:\"html 5\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:6:\"html+5\";}s:6:\"iframe\";a:5:{s:5:\"tagid\";s:3:\"342\";s:11:\"searchcount\";s:2:\"88\";s:7:\"tagtext\";s:6:\"iframe\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"iframe\";}s:5:\"image\";a:5:{s:5:\"tagid\";s:3:\"111\";s:11:\"searchcount\";s:2:\"80\";s:7:\"tagtext\";s:5:\"image\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"image\";}s:6:\"images\";a:5:{s:5:\"tagid\";s:3:\"280\";s:11:\"searchcount\";s:2:\"72\";s:7:\"tagtext\";s:6:\"images\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:6:\"images\";}s:4:\"java\";a:5:{s:5:\"tagid\";s:3:\"245\";s:11:\"searchcount\";s:3:\"100\";s:7:\"tagtext\";s:4:\"java\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:4:\"java\";}s:9:\"javascipt\";a:5:{s:5:\"tagid\";s:4:\"5163\";s:11:\"searchcount\";s:2:\"79\";s:7:\"tagtext\";s:9:\"javascipt\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"javascipt\";}s:10:\"javascript\";a:5:{s:5:\"tagid\";s:1:\"3\";s:11:\"searchcount\";s:3:\"122\";s:7:\"tagtext\";s:10:\"javascript\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:10:\"javascript\";}s:11:\"java script\";a:5:{s:5:\"tagid\";s:3:\"635\";s:11:\"searchcount\";s:2:\"85\";s:7:\"tagtext\";s:11:\"java script\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"java+script\";}s:3:\"job\";a:5:{s:5:\"tagid\";s:4:\"1286\";s:11:\"searchcount\";s:3:\"132\";s:7:\"tagtext\";s:3:\"job\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:3:\"job\";}s:6:\"joomla\";a:5:{s:5:\"tagid\";s:3:\"200\";s:11:\"searchcount\";s:3:\"125\";s:7:\"tagtext\";s:6:\"joomla\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:6:\"joomla\";}s:6:\"jquery\";a:5:{s:5:\"tagid\";s:3:\"140\";s:11:\"searchcount\";s:3:\"110\";s:7:\"tagtext\";s:6:\"jquery\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:6:\"jquery\";}s:4:\"json\";a:5:{s:5:\"tagid\";s:3:\"444\";s:11:\"searchcount\";s:2:\"81\";s:7:\"tagtext\";s:4:\"json\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"json\";}s:4:\"link\";a:5:{s:5:\"tagid\";s:3:\"177\";s:11:\"searchcount\";s:2:\"89\";s:7:\"tagtext\";s:4:\"link\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"link\";}s:5:\"login\";a:5:{s:5:\"tagid\";s:3:\"414\";s:11:\"searchcount\";s:2:\"70\";s:7:\"tagtext\";s:5:\"login\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"login\";}s:4:\"loop\";a:5:{s:5:\"tagid\";s:2:\"52\";s:11:\"searchcount\";s:3:\"123\";s:7:\"tagtext\";s:4:\"loop\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:4:\"loop\";}s:9:\"magento 2\";a:5:{s:5:\"tagid\";s:5:\"42539\";s:11:\"searchcount\";s:2:\"71\";s:7:\"tagtext\";s:9:\"magento 2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"magento+2\";}s:4:\"menu\";a:5:{s:5:\"tagid\";s:3:\"175\";s:11:\"searchcount\";s:2:\"70\";s:7:\"tagtext\";s:4:\"menu\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:4:\"menu\";}s:5:\"mysql\";a:5:{s:5:\"tagid\";s:2:\"15\";s:11:\"searchcount\";s:2:\"94\";s:7:\"tagtext\";s:5:\"mysql\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"mysql\";}s:7:\"onclick\";a:5:{s:5:\"tagid\";s:3:\"450\";s:11:\"searchcount\";s:2:\"80\";s:7:\"tagtext\";s:7:\"onclick\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"onclick\";}s:3:\"php\";a:5:{s:5:\"tagid\";s:2:\"10\";s:11:\"searchcount\";s:3:\"123\";s:7:\"tagtext\";s:3:\"php\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:3:\"php\";}s:18:\"php and javascript\";a:5:{s:5:\"tagid\";s:4:\"4171\";s:11:\"searchcount\";s:2:\"76\";s:7:\"tagtext\";s:18:\"php and javascript\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:18:\"php+and+javascript\";}s:13:\"php and mysql\";a:5:{s:5:\"tagid\";s:4:\"7657\";s:11:\"searchcount\";s:2:\"76\";s:7:\"tagtext\";s:13:\"php and mysql\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"php+and+mysql\";}s:8:\"redirect\";a:5:{s:5:\"tagid\";s:3:\"133\";s:11:\"searchcount\";s:2:\"79\";s:7:\"tagtext\";s:8:\"redirect\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:8:\"redirect\";}s:6:\"review\";a:5:{s:5:\"tagid\";s:2:\"59\";s:11:\"searchcount\";s:3:\"129\";s:7:\"tagtext\";s:6:\"review\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:6:\"review\";}s:6:\"script\";a:5:{s:5:\"tagid\";s:3:\"128\";s:11:\"searchcount\";s:2:\"85\";s:7:\"tagtext\";s:6:\"script\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"script\";}s:6:\"search\";a:5:{s:5:\"tagid\";s:2:\"88\";s:11:\"searchcount\";s:2:\"75\";s:7:\"tagtext\";s:6:\"search\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:6:\"search\";}s:3:\"seo\";a:5:{s:5:\"tagid\";s:3:\"123\";s:11:\"searchcount\";s:2:\"97\";s:7:\"tagtext\";s:3:\"seo\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:3:\"seo\";}s:6:\"slider\";a:5:{s:5:\"tagid\";s:4:\"2014\";s:11:\"searchcount\";s:3:\"129\";s:7:\"tagtext\";s:6:\"slider\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:6:\"slider\";}s:3:\"sql\";a:5:{s:5:\"tagid\";s:3:\"264\";s:11:\"searchcount\";s:2:\"96\";s:7:\"tagtext\";s:3:\"sql\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:3:\"sql\";}s:5:\"table\";a:5:{s:5:\"tagid\";s:3:\"476\";s:11:\"searchcount\";s:2:\"86\";s:7:\"tagtext\";s:5:\"table\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"table\";}s:4:\"text\";a:5:{s:5:\"tagid\";s:3:\"643\";s:11:\"searchcount\";s:2:\"81\";s:7:\"tagtext\";s:4:\"text\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"text\";}s:3:\"url\";a:5:{s:5:\"tagid\";s:3:\"533\";s:11:\"searchcount\";s:2:\"77\";s:7:\"tagtext\";s:3:\"url\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"url\";}s:9:\"variables\";a:5:{s:5:\"tagid\";s:3:\"849\";s:11:\"searchcount\";s:3:\"125\";s:7:\"tagtext\";s:9:\"variables\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:9:\"variables\";}s:5:\"video\";a:5:{s:5:\"tagid\";s:3:\"127\";s:11:\"searchcount\";s:2:\"85\";s:7:\"tagtext\";s:5:\"video\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"video\";}s:3:\"web\";a:5:{s:5:\"tagid\";s:2:\"41\";s:11:\"searchcount\";s:2:\"91\";s:7:\"tagtext\";s:3:\"web\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:3:\"web\";}s:10:\"web design\";a:5:{s:5:\"tagid\";s:4:\"1188\";s:11:\"searchcount\";s:3:\"105\";s:7:\"tagtext\";s:10:\"web design\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:10:\"web+design\";}s:13:\"web developer\";a:5:{s:5:\"tagid\";s:4:\"1287\";s:11:\"searchcount\";s:3:\"120\";s:7:\"tagtext\";s:13:\"web developer\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:13:\"web+developer\";}s:15:\"web development\";a:5:{s:5:\"tagid\";s:2:\"56\";s:11:\"searchcount\";s:2:\"96\";s:7:\"tagtext\";s:15:\"web development\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:15:\"web+development\";}s:7:\"website\";a:5:{s:5:\"tagid\";s:3:\"463\";s:11:\"searchcount\";s:2:\"87\";s:7:\"tagtext\";s:7:\"website\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"website\";}s:21:\"website builder tools\";a:5:{s:5:\"tagid\";s:5:\"12679\";s:11:\"searchcount\";s:2:\"97\";s:7:\"tagtext\";s:21:\"website builder tools\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:21:\"website+builder+tools\";}s:9:\"wordpress\";a:5:{s:5:\"tagid\";s:3:\"345\";s:11:\"searchcount\";s:2:\"94\";s:7:\"tagtext\";s:9:\"wordpress\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"wordpress\";}s:24:\"wordpress plugin support\";a:5:{s:5:\"tagid\";s:4:\"8863\";s:11:\"searchcount\";s:3:\"105\";s:7:\"tagtext\";s:24:\"wordpress plugin support\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:24:\"wordpress+plugin+support\";}s:3:\"xml\";a:5:{s:5:\"tagid\";s:3:\"151\";s:11:\"searchcount\";s:2:\"80\";s:7:\"tagtext\";s:3:\"xml\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:3:\"xml\";}}s:5:\"count\";i:70;s:8:\"dateline\";i:1519108281;}', 1)

Time Before: 0.16692 seconds
Time After: 0.16738 seconds
Time Taken: 0.00046 seconds

Memory Before: 3,061.109 KB
Memory After: 3,049.109 KB
Memory Used: -12.000 KB

SQL Query
UPDATE session
SET lastactivity = 1519108281, location = '/forum/search.php?amp;do=finduser&amp;userid=201897&amp;searchthreadid=284773&amp;contenttype=vBForum_Post&amp;showposts=1&explain=1', inforum = 0, inthread = 0, badlocation = 0
WHERE sessionhash = '45a6e7401e63975334c98ad178bfae35'

Time Before: 0.17335 seconds
Time After: 0.17497 seconds
Time Taken: 0.00162 seconds

Memory Before: 3,098.117 KB
Memory After: 3,097.805 KB
Memory Used: -0.313 KB

Page generated in 0.17278003692627 seconds with 18 queries, spending 0.037935733795166 doing MySQL queries and 0.1348443031311 doing PHP things.
Shutdown Queries:
DISABLED