Including Functions.php

Time Before: 0.00028 seconds
Time After: 0.00029 seconds
Time Taken: 0.00001 seconds

Memory Before: 433.711 KB
Memory After: 435.547 KB
Memory Used: 1.836 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00031 seconds
Time After: 0.01381 seconds
Time Taken: 0.01349 seconds

Memory Before: 435.531 KB
Memory After: 436.266 KB
Memory Used: 0.734 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01402 seconds
Time After: 0.01421 seconds
Time Taken: 0.00019 seconds

Memory Before: 436.313 KB
Memory After: 436.367 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','smiliecache','bbcodecache','mailqueue','bookmarksitecache')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 18Using where

Time Before: 0.01468 seconds
Time After: 0.01570 seconds
Time Taken: 0.00102 seconds

Memory Before: 437.703 KB
Memory After: 1,174.008 KB
Memory Used: 736.305 KB

Time Before: 0.01424 seconds
Time After: 0.02676 seconds
Time Taken: 0.01252 seconds

Memory Before: 436.156 KB
Memory After: 1,805.445 KB
Memory Used: 1,369.289 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('modstats_coder','modstats_designer','modstats_motm','modtitle_coder','modtitle_designer','wol_spiders','nex_crawlers_list_wgo_stats')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 7Using where

Time Before: 0.02706 seconds
Time After: 0.02739 seconds
Time Taken: 0.00033 seconds

Memory Before: 1,807.148 KB
Memory After: 2,063.359 KB
Memory Used: 256.211 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '216.73.217.115'
	AND idhash = '746d2c2e12532723401903d41921bd01'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    351Using where

Time Before: 0.02783 seconds
Time After: 0.02799 seconds
Time Taken: 0.00016 seconds

Memory Before: 1,992.328 KB
Memory After: 2,008.523 KB
Memory Used: 16.195 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_postbit AS phrasegroup_postbit,
			phrasegroup_showthread AS phrasegroup_showthread,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
			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
1SIMPLElanguageconstPRIMARYPRIMARY2const1 

Time Before: 0.02824 seconds
Time After: 0.02845 seconds
Time Taken: 0.00022 seconds

Memory Before: 1,998.242 KB
Memory After: 2,190.930 KB
Memory Used: 192.688 KB

Time Before: 0.02749 seconds
Time After: 0.02849 seconds
Time Taken: 0.00100 seconds

Memory Before: 1,990.086 KB
Memory After: 2,092.625 KB
Memory Used: 102.539 KB

SQL Query
SELECT post.*,
IF(post.visible = 2, 1, 0) AS isdeleted,


editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory

FROM post AS post

LEFT JOIN editlog AS editlog ON (editlog.postid = post.postid)

WHERE post.postid = 299124
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostconstPRIMARYPRIMARY4const1 
1SIMPLEeditlogconstPRIMARYPRIMARY4const1Unique row not found

Time Before: 0.03026 seconds
Time After: 0.03044 seconds
Time Taken: 0.00017 seconds

Memory Before: 2,250.563 KB
Memory After: 2,266.578 KB
Memory Used: 16.016 KB

SQL Query
SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*


FROM thread AS thread






WHERE thread.threadid = 173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadconstPRIMARYPRIMARY4const1 

Time Before: 0.03064 seconds
Time After: 0.03084 seconds
Time Taken: 0.00020 seconds

Memory Before: 2,253.773 KB
Memory After: 2,270.063 KB
Memory Used: 16.289 KB

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

Time Before: 0.03124 seconds
Time After: 0.03144 seconds
Time Taken: 0.00020 seconds

Memory Before: 2,260.609 KB
Memory After: 2,412.977 KB
Memory Used: 152.367 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (10,11,13,12,225,246,267,268,270,277,276,880,570,555,556,558,557,560,562,563,564,566,569,106,108,110,112,882,609,612,613,610,608,707,708,539,537,538,543,541,727,198,196,199,200,57,59,871,868,872,8,7,9,4,3,529,877,407,408,409,245,248,445,446,447,448,449,742,664,663,665,668,878,429,434,433,431,432,550,544,545,546,547,551,553,439,194,867,244,115,178,179,174,151,410,197,397,398,400,874,396,196,198,199,200,216,309,321,322,324,323,875,401,402,744,751,753,754,752,755,566,605,606,603,403)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 120Using where

Time Before: 0.03282 seconds
Time After: 0.03359 seconds
Time Taken: 0.00077 seconds

Memory Before: 2,447.570 KB
Memory After: 2,865.375 KB
Memory Used: 417.805 KB

End call of global.php: 0.035526037216187
SQL Query
SELECT COUNT(*) AS posts
FROM post AS post
WHERE threadid = 173425 AND visible = 1

AND dateline <= 1224525808
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrangethreadid,dateline,idx_dateline,idx_ksoursidx_ksours10 50Using where; Using index

Time Before: 0.03597 seconds
Time After: 0.03613 seconds
Time Taken: 0.00016 seconds

Memory Before: 2,847.219 KB
Memory After: 2,863.383 KB
Memory Used: 16.164 KB

SQL Query
SELECT  post.postid, post.attach
FROM post AS post

WHERE post.threadid = 173425
	AND post.visible = 1
	
	
ORDER BY post.dateline 
LIMIT 0, 50
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefthreadid,idx_ksoursidx_ksours6const,const211Using where; Using index

Time Before: 0.03640 seconds
Time After: 0.03654 seconds
Time Taken: 0.00014 seconds

Memory Before: 2,849.797 KB
Memory After: 2,866.758 KB
Memory Used: 16.961 KB

SQL Query
SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
	postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
	attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
FROM attachment
LEFT JOIN attachmenttype AS attachmenttype USING (extension)
WHERE postid IN (0,289726,289727,289735,289951,290230,290287,290483,290493,290511,290690,293942,294232,294283,294294,294316,294411,294447,294515,294527,296076,296088,296090,296103,296105,296109,296151,296164,296283,296323,296424,296437,296450,296453,296623,296640,296721,296727,297076,298457,298458,298460,298463,298465,298471,298482,298484,299021,299099,299120,299124)
ORDER BY attachmentid
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEattachmentrangepostidpostid4 51Using index condition; Using filesort
1SIMPLEattachmenttypeeq_refPRIMARYPRIMARY22wckediden_vb3.attachment.extension1 

Time Before: 0.03686 seconds
Time After: 0.03720 seconds
Time Taken: 0.00034 seconds

Memory Before: 2,854.664 KB
Memory After: 2,870.109 KB
Memory Used: 15.445 KB

SQL Query
SELECT
	post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
	user.*, userfield.*, usertextfield.*,
	icon.title as icontitle, icon.iconpath,
	avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
	
	
	editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
	editlog.reason AS edit_reason, editlog.hashistory,
	postparsed.pagetext_html, postparsed.hasimages,
	sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
	sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
	, '' AS field20, '' AS field27
	,modification.last_update,modification.author,modification.mod_productid,modification.mod_supported,modification.mod_dbchanges,modification.mod_usesplugins,modification.mod_edtemplates,modification.mod_autemplates,modification.mod_reuseable,modification.mod_codechange,modification.mod_additional,modification.mod_translation,modification.mod_licence,modification.mod_verified,modification.mod_external,modification.mod_betastage,modification.mod_version,modification.mod_coauthors,modification.mod_installcount,modification.mod_vbversion,modification.motm,licence.title AS licence_used,licence.licence
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

	
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 78 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 78 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
	LEFT JOIN modsys_settings AS modification ON(modification.threadid = 173425) LEFT JOIN modsys_licences AS licence ON(licence.modsys_licencesid = modification.mod_licence) 
WHERE post.postid IN (0,289726,289727,289735,289951,290230,290287,290483,290493,290511,290690,293942,294232,294283,294294,294316,294411,294447,294515,294527,296076,296088,296090,296103,296105,296109,296151,296164,296283,296323,296424,296437,296450,296453,296623,296640,296721,296727,297076,298457,298458,298460,298463,298465,298471,298482,298484,299021,299099,299120,299124)
ORDER BY post.dateline
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrangePRIMARYPRIMARY4 51Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4wckediden_vb3.post.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4wckediden_vb3.user.userid1Using where
1SIMPLEusertextfieldeq_refPRIMARYPRIMARY4wckediden_vb3.user.userid1Using where
1SIMPLEiconeq_refPRIMARYPRIMARY2wckediden_vb3.post.iconid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2wckediden_vb3.user.avatarid1Using where
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4wckediden_vb3.user.userid1Using where
1SIMPLEeditlogeq_refPRIMARYPRIMARY4wckediden_vb3.post.postid1 
1SIMPLEpostparsedeq_refPRIMARYPRIMARY8wckediden_vb3.post.postid,const,const1 
1SIMPLEsigparsedeq_refPRIMARYPRIMARY8wckediden_vb3.user.userid,const,const1Using where
1SIMPLEsigpiceq_refPRIMARYPRIMARY4wckediden_vb3.post.userid1 
1SIMPLEmodificationconstuniq_threadiduniq_threadid4const1 
1SIMPLElicenceeq_refPRIMARYPRIMARY4wckediden_vb3.modification.mod_licence1Using where

Time Before: 0.03775 seconds
Time After: 0.03941 seconds
Time Taken: 0.00166 seconds

Memory Before: 2,882.125 KB
Memory After: 3,090.695 KB
Memory Used: 208.570 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.03996 seconds
Time After: 0.04006 seconds
Time Taken: 0.00010 seconds

Memory Before: 3,178.703 KB
Memory After: 3,194.828 KB
Memory Used: 16.125 KB

SQL Query
SELECT * FROM modsys_user_notification WHERE userid=0 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.04019 seconds
Time After: 0.04029 seconds
Time Taken: 0.00009 seconds

Memory Before: 3,184.609 KB
Memory After: 3,200.953 KB
Memory Used: 16.344 KB

SQL Query
SELECT manual_notify FROM modsys_user_notification WHERE threadid=173425 AND manual_notify='1'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationrefuniq_thread_useruniq_thread_user4const177Using where

Time Before: 0.04083 seconds
Time After: 0.04152 seconds
Time Taken: 0.00069 seconds

Memory Before: 3,219.734 KB
Memory After: 3,235.828 KB
Memory Used: 16.094 KB

SQL Query
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0,289726,289727,289735,289951,290230,290287,290483,290493,290511,290690,293942,294232,294283,294294,294316,294411,294447,294515,294527,296076,296088,296090,296103,296105,296109,296151,296164,296283,296323,296424,296437,296450,296453,296623,296640,296721,296727,297076,298457,298458,298460,298463,298465,298471,298482,298484,299021,299099,299120,299124) ORDER BY post_thanks.username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_thanksrangepostidpostid4 127Using index condition; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4wckediden_vb3.post_thanks.userid1Using where

Time Before: 0.04190 seconds
Time After: 0.04309 seconds
Time Taken: 0.00119 seconds

Memory Before: 3,225.055 KB
Memory After: 3,323.156 KB
Memory Used: 98.102 KB

SQL Query
SELECT
					tag.tagid,tagthread.threadid
					FROM tag AS tag
					LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid)
					LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid)
					WHERE tag.tagtext='build'
					AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.04405 seconds
Time After: 0.04426 seconds
Time Taken: 0.00021 seconds

Memory Before: 3,334.406 KB
Memory After: 3,349.586 KB
Memory Used: 15.180 KB

SQL Query
SELECT
					tag.tagid,tagthread.threadid
					FROM tag AS tag
					LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid)
					LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid)
					WHERE tag.tagtext=' juicy'
					AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.04457 seconds
Time After: 0.04485 seconds
Time Taken: 0.00027 seconds

Memory Before: 3,350.586 KB
Memory After: 3,365.766 KB
Memory Used: 15.180 KB

SQL Query
SELECT
					tag.tagid,tagthread.threadid
					FROM tag AS tag
					LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid)
					LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid)
					WHERE tag.tagtext=' kitchen'
					AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.04526 seconds
Time After: 0.04549 seconds
Time Taken: 0.00023 seconds

Memory Before: 3,350.586 KB
Memory After: 3,365.766 KB
Memory Used: 15.180 KB

SQL Query
SELECT
					tag.tagid,tagthread.threadid
					FROM tag AS tag
					LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid)
					LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid)
					WHERE tag.tagtext=' rom'
					AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.04571 seconds
Time After: 0.04589 seconds
Time Taken: 0.00017 seconds

Memory Before: 3,350.586 KB
Memory After: 3,365.766 KB
Memory Used: 15.180 KB

SQL Query
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (289726) ORDER BY post_thanks.username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_thanksrefpostidpostid4const49Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4wckediden_vb3.post_thanks.userid1Using where

Time Before: 0.05034 seconds
Time After: 0.05109 seconds
Time Taken: 0.00076 seconds

Memory Before: 3,339.273 KB
Memory After: 3,405.063 KB
Memory Used: 65.789 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.05274 seconds
Time After: 0.05287 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,358.008 KB
Memory After: 3,374.102 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.05478 seconds
Time After: 0.05492 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,382.227 KB
Memory After: 3,398.352 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=19259 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.05665 seconds
Time After: 0.05680 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,384.938 KB
Memory After: 3,401.031 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=19259 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.05843 seconds
Time After: 0.05856 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,389.391 KB
Memory After: 3,405.484 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.06023 seconds
Time After: 0.06036 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,399.531 KB
Memory After: 3,415.656 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=19259 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.06270 seconds
Time After: 0.06283 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,410.039 KB
Memory After: 3,426.133 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=22391 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.06445 seconds
Time After: 0.06465 seconds
Time Taken: 0.00020 seconds

Memory Before: 3,415.039 KB
Memory After: 3,431.273 KB
Memory Used: 16.234 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=19259 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.06634 seconds
Time After: 0.06647 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,426.719 KB
Memory After: 3,442.813 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.06816 seconds
Time After: 0.06830 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,436.898 KB
Memory After: 3,453.023 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.07004 seconds
Time After: 0.07016 seconds
Time Taken: 0.00011 seconds

Memory Before: 3,446.383 KB
Memory After: 3,462.508 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07187 seconds
Time After: 0.07202 seconds
Time Taken: 0.00015 seconds

Memory Before: 3,452.719 KB
Memory After: 3,468.813 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=9731 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07370 seconds
Time After: 0.07382 seconds
Time Taken: 0.00012 seconds

Memory Before: 3,463.445 KB
Memory After: 3,479.539 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=24820 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07536 seconds
Time After: 0.07548 seconds
Time Taken: 0.00012 seconds

Memory Before: 3,468.938 KB
Memory After: 3,485.031 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.07724 seconds
Time After: 0.07737 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,481.883 KB
Memory After: 3,498.008 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07910 seconds
Time After: 0.07922 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,489.453 KB
Memory After: 3,505.547 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.08084 seconds
Time After: 0.08096 seconds
Time Taken: 0.00012 seconds

Memory Before: 3,498.742 KB
Memory After: 3,514.867 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12307 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08260 seconds
Time After: 0.08273 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,505.750 KB
Memory After: 3,521.844 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.08428 seconds
Time After: 0.08441 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,515.984 KB
Memory After: 3,532.109 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.08607 seconds
Time After: 0.08620 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,524.102 KB
Memory After: 3,540.227 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08777 seconds
Time After: 0.08790 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,530.867 KB
Memory After: 3,546.961 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.08949 seconds
Time After: 0.08963 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,540.961 KB
Memory After: 3,557.086 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.09126 seconds
Time After: 0.09138 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,551.266 KB
Memory After: 3,567.359 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.09302 seconds
Time After: 0.09316 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,560.281 KB
Memory After: 3,576.375 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.09474 seconds
Time After: 0.09488 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,569.422 KB
Memory After: 3,585.547 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.09649 seconds
Time After: 0.09664 seconds
Time Taken: 0.00015 seconds

Memory Before: 3,576.781 KB
Memory After: 3,592.875 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.09857 seconds
Time After: 0.09868 seconds
Time Taken: 0.00012 seconds

Memory Before: 3,585.875 KB
Memory After: 3,602.000 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.10031 seconds
Time After: 0.10041 seconds
Time Taken: 0.00009 seconds

Memory Before: 3,593.883 KB
Memory After: 3,609.977 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.10199 seconds
Time After: 0.10208 seconds
Time Taken: 0.00009 seconds

Memory Before: 3,607.078 KB
Memory After: 3,623.203 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.10371 seconds
Time After: 0.10380 seconds
Time Taken: 0.00009 seconds

Memory Before: 3,614.914 KB
Memory After: 3,631.008 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.10549 seconds
Time After: 0.10561 seconds
Time Taken: 0.00012 seconds

Memory Before: 3,623.266 KB
Memory After: 3,639.391 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.10729 seconds
Time After: 0.10740 seconds
Time Taken: 0.00011 seconds

Memory Before: 3,634.633 KB
Memory After: 3,650.727 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.10892 seconds
Time After: 0.10902 seconds
Time Taken: 0.00010 seconds

Memory Before: 3,644.477 KB
Memory After: 3,660.602 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12387 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.11063 seconds
Time After: 0.11077 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,651.648 KB
Memory After: 3,667.742 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.11237 seconds
Time After: 0.11250 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,661.727 KB
Memory After: 3,677.852 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=34360 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.11414 seconds
Time After: 0.11426 seconds
Time Taken: 0.00012 seconds

Memory Before: 3,667.836 KB
Memory After: 3,683.930 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.11582 seconds
Time After: 0.11595 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,678.242 KB
Memory After: 3,694.367 KB
Memory Used: 16.125 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.11756 seconds
Time After: 0.11767 seconds
Time Taken: 0.00011 seconds

Memory Before: 3,685.922 KB
Memory After: 3,702.016 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.11932 seconds
Time After: 0.11947 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,697.672 KB
Memory After: 3,713.766 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.12114 seconds
Time After: 0.12130 seconds
Time Taken: 0.00016 seconds

Memory Before: 3,707.289 KB
Memory After: 3,723.383 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.12310 seconds
Time After: 0.12319 seconds
Time Taken: 0.00010 seconds

Memory Before: 3,713.609 KB
Memory After: 3,729.703 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.12476 seconds
Time After: 0.12485 seconds
Time Taken: 0.00009 seconds

Memory Before: 3,722.914 KB
Memory After: 3,739.008 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.12653 seconds
Time After: 0.12662 seconds
Time Taken: 0.00009 seconds

Memory Before: 3,733.828 KB
Memory After: 3,749.922 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.12823 seconds
Time After: 0.12832 seconds
Time Taken: 0.00009 seconds

Memory Before: 3,743.102 KB
Memory After: 3,759.195 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.12999 seconds
Time After: 0.13013 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,750.219 KB
Memory After: 3,766.313 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.13211 seconds
Time After: 0.13232 seconds
Time Taken: 0.00022 seconds

Memory Before: 3,759.383 KB
Memory After: 3,775.477 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.13400 seconds
Time After: 0.13413 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,766.891 KB
Memory After: 3,782.984 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.13580 seconds
Time After: 0.13593 seconds
Time Taken: 0.00012 seconds

Memory Before: 3,775.758 KB
Memory After: 3,791.852 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=36020 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.13757 seconds
Time After: 0.13769 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,786.602 KB
Memory After: 3,802.695 KB
Memory Used: 16.094 KB

SQL Query
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmodsys_user_notificationconstuniq_thread_user,idx_user_threaduniq_thread_user8const,const1 

Time Before: 0.13929 seconds
Time After: 0.13943 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,793.180 KB
Memory After: 3,809.305 KB
Memory Used: 16.125 KB

Time after parsing all posts: 0.14082002639771 Memory After: 3,542KB
SQL Query
SELECT user.username, user.usergroupid, user.membergroupids,
	session.userid, session.inthread, session.lastactivity, session.badlocation,
	IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid,
	IF(user.options & 512, 1, 0) AS invisible
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1789846633
ORDER BY  username ASC, lastactivity DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    351Using where; Using temporary; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4wckediden_vb3.session.userid1 

Time Before: 0.14119 seconds
Time After: 0.14204 seconds
Time Taken: 0.00085 seconds

Memory Before: 3,544.500 KB
Memory After: 3,564.180 KB
Memory Used: 19.680 KB

SQL Query
SELECT thread.threadid, thread.forumid, thread.title, thread.prefixid, thread.taglist, postusername, postuserid,
	thread.lastpost, thread.replycount,
	forum.title AS forumtitle
	,post.pagetext AS preview
	, 0 AS issubscribed
	
FROM thread AS thread
INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)



WHERE thread.threadid IN (186813, 187605, 187950, 193332, 182874) AND thread.visible = 1
	AND forum.password = ''
	
	
ORDER BY lastpost DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrangePRIMARY,forumidPRIMARY4 5Using where; Using filesort
1SIMPLEforumeq_refPRIMARYPRIMARY2wckediden_vb3.thread.forumid1Using where
1SIMPLEposteq_refPRIMARYPRIMARY4wckediden_vb3.thread.firstpostid1 

Time Before: 0.14252 seconds
Time After: 0.14289 seconds
Time Taken: 0.00037 seconds

Memory Before: 3,544.242 KB
Memory After: 3,655.875 KB
Memory Used: 111.633 KB

SQL Query
SELECT userid, lastactivity, useragent
FROM session
WHERE lastactivity > 1789846633
AND userid = 0
AND inthread = 173425
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    351Using where

Time Before: 0.14447 seconds
Time After: 0.14478 seconds
Time Taken: 0.00031 seconds

Memory Before: 3,728.430 KB
Memory After: 3,744.422 KB
Memory Used: 15.992 KB

SQL Query
SELECT forumid, forumpermissions FROM forumpermission WHERE usergroupid = 1 AND forumid IN (491,528,4)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumpermissionrangeugid_fidugid_fid4 3Using index condition

Time Before: 0.15208 seconds
Time After: 0.15225 seconds
Time Taken: 0.00017 seconds

Memory Before: 4,512.547 KB
Memory After: 4,528.617 KB
Memory Used: 16.070 KB

SQL Query
SELECT postid, userid, username, dateline, pagetext, visible FROM post WHERE postid = 289726 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostconstPRIMARYPRIMARY4const1 

Time Before: 0.15254 seconds
Time After: 0.15274 seconds
Time Taken: 0.00020 seconds

Memory Before: 4,512.250 KB
Memory After: 4,568.570 KB
Memory Used: 56.320 KB

SQL Query
UPDATE session
SET lastactivity = 1789847533, location = '/showthread.php?explain=1&p=299124', inforum = 491, inthread = 173425
WHERE sessionhash = '2b1b20e77785fbb1a30e93b4d0992918'

Time Before: 0.15552 seconds
Time After: 0.15592 seconds
Time Taken: 0.00040 seconds

Memory Before: 5,084.867 KB
Memory After: 5,084.820 KB
Memory Used: -0.047 KB

SQL Query
UPDATE thread
SET views = views + 1
WHERE threadid = 173425

Time Before: 0.15596 seconds
Time After: 0.22540 seconds
Time Taken: 0.06944 seconds

Memory Before: 5,082.688 KB
Memory After: 5,082.813 KB
Memory Used: 0.125 KB

Page generated in 0.14593911170959 seconds with 79 queries, spending 0.10096001625061 doing MySQL queries and 0.044979095458984 doing PHP things.
Shutdown Queries:
DISABLED