Including Functions.php

Time Before: 0.02413 seconds
Time After: 0.03650 seconds
Time Taken: 0.01237 seconds

Memory Before: 2,342.375 KB
Memory After: 3,886.227 KB
Memory Used: 1,543.852 KB

Connect to Database on Server:

Time Before: 0.03654 seconds
Time After: 0.03695 seconds
Time Taken: 0.00041 seconds

Memory Before: 3,886.258 KB
Memory After: 3,887.180 KB
Memory Used: 0.922 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.03719 seconds
Time After: 0.03734 seconds
Time Taken: 0.00015 seconds

Memory Before: 3,887.906 KB
Memory After: 3,888.492 KB
Memory Used: 0.586 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue','activeblocks','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY50 23100.00Using where

Time Before: 0.04833 seconds
Time After: 0.04886 seconds
Time Taken: 0.00053 seconds

Memory Before: 3,891.984 KB
Memory After: 3,892.961 KB
Memory Used: 0.977 KB

Time Before: 0.03740 seconds
Time After: 0.05023 seconds
Time Taken: 0.01283 seconds

Memory Before: 3,887.742 KB
Memory After: 4,691.023 KB
Memory Used: 803.281 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('blogcategorycache','blogstats','dbtech_dbseo_keyword','dbtech_dbseo_gwt_cache','dbtech_dbseo_oauth','profilefield')
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY50 6100.00Using where

Time Before: 0.12354 seconds
Time After: 0.12381 seconds
Time Taken: 0.00027 seconds

Memory Before: 7,426.758 KB
Memory After: 7,427.344 KB
Memory Used: 0.586 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '216.73.216.136'
	AND idhash = 'ea5a359a73a8141a16de516480d33c34'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refuser_activity,guest_lookupguest_lookup51const,const,const2100.00 

Time Before: 0.12456 seconds
Time After: 0.12484 seconds
Time Taken: 0.00027 seconds

Memory Before: 7,444.000 KB
Memory After: 7,444.641 KB
Memory Used: 0.641 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_activitystream AS phrasegroup_activitystream,
			phrasegroup_holiday AS phrasegroup_holiday,
			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.12568 seconds
Time After: 0.12609 seconds
Time Taken: 0.00041 seconds

Memory Before: 7,455.844 KB
Memory After: 7,455.875 KB
Memory Used: 0.031 KB

Time Before: 0.12406 seconds
Time After: 0.12619 seconds
Time Taken: 0.00213 seconds

Memory Before: 7,436.711 KB
Memory After: 7,516.156 KB
Memory Used: 79.445 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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcalendar ALL    1100.00Using filesort
1SIMPLEcalendarpermission refcalendarid,usergroupidcalendarid4melanotan_test.calendar.calendarid1100.00Using where

Time Before: 0.14962 seconds
Time After: 0.14999 seconds
Time Taken: 0.00037 seconds

Memory Before: 7,710.563 KB
Memory After: 7,710.922 KB
Memory Used: 0.359 KB

SQL Query
SELECT MAX(permissions & 1) AS perm
FROM cms_permissions
WHERE nodeid = 1 AND usergroupid IN (1)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcms_permissions constusergroupid,nodeidusergroupid8const,const1100.00 

Time Before: 0.15063 seconds
Time After: 0.15087 seconds
Time Taken: 0.00024 seconds

Memory Before: 7,738.266 KB
Memory After: 7,738.813 KB
Memory Used: 0.547 KB

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

Time Before: 0.17260 seconds
Time After: 0.17294 seconds
Time Taken: 0.00034 seconds

Memory Before: 8,235.234 KB
Memory After: 8,235.867 KB
Memory Used: 0.633 KB

End call of global.php: 0.17358493804932
SQL Query
SELECT username, userid, birthday, showbirthday
FROM user
WHERE (birthday LIKE '07-03-%' OR birthday LIKE '07-04-%')
AND usergroupid IN (0, 6, 10, 11, 7, 2, 5)
AND showbirthday IN (2, 3)
AND lastactivity >= 1749027228
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEuser rangeusergroupid,birthdaybirthday12 226.37Using index condition; Using where

Time Before: 0.19291 seconds
Time After: 0.19325 seconds
Time Taken: 0.00035 seconds

Memory Before: 9,658.039 KB
Memory After: 9,658.438 KB
Memory Used: 0.398 KB

SQL Query
REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('birthdaycache', 'a:4:{s:4:\"day1\";s:10:\"2025-07-03\";s:4:\"day2\";s:10:\"2025-07-04\";s:6:\"users1\";a:0:{}s:6:\"users2\";a:0:{}}', 1)

Time Before: 0.19334 seconds
Time After: 0.22913 seconds
Time Taken: 0.03579 seconds

Memory Before: 9,659.555 KB
Memory After: 9,659.797 KB
Memory Used: 0.242 KB

SQL Query
SELECT calendarid
FROM calendar
WHERE options & 2
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcalendar ALL    1100.00Using where

Time Before: 0.23197 seconds
Time After: 0.23217 seconds
Time Taken: 0.00020 seconds

Memory Before: 9,970.672 KB
Memory After: 9,971.273 KB
Memory Used: 0.602 KB

SQL Query
SELECT *
FROM holiday
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEholiday ALL    1100.00 

Time Before: 0.23268 seconds
Time After: 0.23290 seconds
Time Taken: 0.00022 seconds

Memory Before: 9,971.102 KB
Memory After: 9,971.703 KB
Memory Used: 0.602 KB

SQL Query
SELECT eventid, userid, event.title, recurring, recuroption, dateline_from, dateline_to, event.calendarid, IF (dateline_to = 0, 1, 0) AS singleday, customfields,
	dateline_from AS dateline_from_user, dateline_to AS dateline_to_user, utc, dst
FROM event AS event
INNER JOIN calendar AS calendar USING (calendarid)
WHERE ((dateline_to >= 1751446428 AND dateline_from < 1751792028) OR (dateline_to = 0 AND dateline_from >= 1751446428 AND dateline_from <= 1751792028 ))
	AND visible = 1
	AND calendar.options & 512
ORDER BY dateline_from
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEevent refcalendarid,visible,daterangevisible2const1100.00Using index condition; Using where; Using filesort
1SIMPLEcalendar eq_refPRIMARYPRIMARY4melanotan_test.event.calendarid1100.00Using where

Time Before: 0.23369 seconds
Time After: 0.23407 seconds
Time Taken: 0.00038 seconds

Memory Before: 9,973.172 KB
Memory After: 9,973.258 KB
Memory Used: 0.086 KB

SQL Query
REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('eventcache', 'a:1:{s:4:\"date\";s:8:\"7-6-2025\";}', 1)

Time Before: 0.23414 seconds
Time After: 0.27087 seconds
Time Taken: 0.03673 seconds

Memory Before: 9,972.508 KB
Memory After: 9,972.820 KB
Memory Used: 0.313 KB

SQL Query
SELECT
	user.username, (user.options & 512) AS invisible, user.usergroupid, user.lastvisit,
	session.userid, session.inforum, session.lastactivity, session.badlocation,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
	
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)

WHERE session.lastactivity > 1751618328
	
ORDER BY username ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession rangelast_activitylast_activity4 180100.00Using where; Using temporary; Using filesort
1SIMPLEuser eq_refPRIMARYPRIMARY4melanotan_test.session.userid1100.00 

Time Before: 0.27138 seconds
Time After: 0.27233 seconds
Time Taken: 0.00095 seconds

Memory Before: 9,974.141 KB
Memory After: 9,988.961 KB
Memory Used: 14.820 KB

SQL Query
SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
	user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
	
FROM forum AS forum

LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEforum ALL    2100.00 
1SIMPLEuser eq_refPRIMARYPRIMARY4melanotan_test.forum.lastposterid1100.00 
1SIMPLEuserlist eq_refPRIMARY,relationid,useridPRIMARY9const,melanotan_test.user.userid,const1100.00 

Time Before: 0.27364 seconds
Time After: 0.27398 seconds
Time Taken: 0.00034 seconds

Memory Before: 9,978.836 KB
Memory After: 9,979.141 KB
Memory Used: 0.305 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (427,428,1353,484,485,487,488,489,490,486,1344,557,563,558,1427,1445,1428,562,908,1361,1343,1393,1059,0,0,436,430,429,434,435,433,432,437,438,439,745,1430,1381,695,692,693,694,1057,0,0,1020,1022,715,716,718,719,942,984,983,1033,985,1420,541,545,1352,61,85,1386,1385,1387,1389,1388,1390,1382,1384)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 67100.00Using where

Time Before: 0.30328 seconds
Time After: 0.31635 seconds
Time Taken: 0.01307 seconds

Memory Before: 10,567.844 KB
Memory After: 10,569.672 KB
Memory Used: 1.828 KB

SQL Query
SELECT user.userid as usersuserid, user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
	customavatar.width, customavatar.height, customavatar.width_thumb, customavatar.height_thumb
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.username = 'Shaans'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEuser refusernameusername102const1100.00 
1SIMPLEavatar eq_refPRIMARYPRIMARY2melanotan_test.user.avatarid1100.00Using where
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4melanotan_test.user.userid1100.00 

Time Before: 0.32592 seconds
Time After: 0.32622 seconds
Time Taken: 0.00030 seconds

Memory Before: 10,853.625 KB
Memory After: 10,853.906 KB
Memory Used: 0.281 KB

SQL Query
SELECT user.userid as usersuserid, user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
	customavatar.width, customavatar.height, customavatar.width_thumb, customavatar.height_thumb
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.username = 'Talktomikey@gmail.com'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEuser refusernameusername102const1100.00 
1SIMPLEavatar eq_refPRIMARYPRIMARY2melanotan_test.user.avatarid1100.00Using where
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4melanotan_test.user.userid1100.00 

Time Before: 0.32818 seconds
Time After: 0.32846 seconds
Time Taken: 0.00028 seconds

Memory Before: 10,857.961 KB
Memory After: 10,858.227 KB
Memory Used: 0.266 KB

SQL Query
SELECT post.dateline, post.pagetext AS message, post.allowsmilie, post.postid,
	thread.threadid, thread.title, thread.prefixid, post.attach,
	forum.forumid,
	user.*
	,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM post AS post
JOIN thread AS thread ON (thread.threadid = post.threadid)
JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN user AS user ON (post.userid = user.userid)
 LEFT JOIN cms_nodeinfo AS info ON info.associatedthreadid = thread.threadid 
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
			WHERE 1=1
AND thread.forumid IN(42,34)
AND thread.visible = 1
AND post.visible = 1
AND thread.open <> 10
AND post.dateline > 1749027228

 AND info.associatedthreadid IS NULL 
			ORDER BY post.dateline DESC
			LIMIT 0,5
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEpost rangethreadid,threadid_visible_dateline,datelinedateline4 110.00Using index condition; Using where
1SIMPLEthread eq_refPRIMARY,forumid,forumid_lastpostPRIMARY4melanotan_test.post.threadid190.00Using where
1SIMPLEforum eq_refPRIMARYPRIMARY2melanotan_test.thread.forumid1100.00Using index
1SIMPLEuser eq_refPRIMARYPRIMARY4melanotan_test.post.userid1100.00 
1SIMPLEinfo refassociatedthreadidassociatedthreadid4melanotan_test.post.threadid35100.00Using where; Not exists; Using index
1SIMPLEavatar eq_refPRIMARYPRIMARY2melanotan_test.user.avatarid1100.00Using where
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4melanotan_test.user.userid1100.00 

Time Before: 0.33567 seconds
Time After: 0.33645 seconds
Time Taken: 0.00078 seconds

Memory Before: 11,072.945 KB
Memory After: 11,072.563 KB
Memory Used: -0.383 KB

SQL Query
SELECT stream.*, type.section, type.type
FROM activitystream AS stream
LEFT JOIN activitystreamtype AS type ON (stream.typeid = type.typeid)
WHERE stream.dateline <> 0 AND stream.dateline <= 1751619228
ORDER BY dateline DESC
LIMIT 0, 5
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstream ALLdateline   1100.00Using where; Using filesort
1SIMPLEtype eq_refPRIMARYPRIMARY4melanotan_test.stream.typeid1100.00 

Time Before: 0.35212 seconds
Time After: 0.35243 seconds
Time Taken: 0.00031 seconds

Memory Before: 11,782.531 KB
Memory After: 11,782.906 KB
Memory Used: 0.375 KB

SQL Query
SELECT b.blogid, b.userid, b.username,b.attach, b.title,b.attach, pagetext
FROM blog b join blog_text as bt on ( b.blogid = bt.blogid ) where b.userid = bt.userid ORDER BY b.blogid Desc LIMIT 5
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEb ALLPRIMARY,userid   17100.00Using filesort
1SIMPLEbt refblogid,useridblogid4melanotan_test.b.blogid410.00Using where

Time Before: 0.35452 seconds
Time After: 0.35494 seconds
Time Taken: 0.00043 seconds

Memory Before: 11,840.109 KB
Memory After: 11,840.852 KB
Memory Used: 0.742 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vb_types.types'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

Time Before: 0.39321 seconds
Time After: 0.39344 seconds
Time Taken: 0.00023 seconds

Memory Before: 12,441.188 KB
Memory After: 12,441.758 KB
Memory Used: 0.570 KB

SQL Query
SELECT
				fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
				a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
				at.contenttypes
FROM attachment AS a
			INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
			LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
			
			
				WHERE
					a.contentid = 53
						AND
					a.contenttypeid = 19

ORDER BY a.contentid, a.displayorder
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEa refcontenttypeid,contentid,filedataidcontenttypeid8const,const1100.00Using index condition; Using filesort
1SIMPLEfd eq_refPRIMARYPRIMARY4melanotan_test.a.filedataid1100.00 
1SIMPLEat eq_refPRIMARYPRIMARY20melanotan_test.fd.extension1100.00Using where

Time Before: 0.39429 seconds
Time After: 0.39470 seconds
Time Taken: 0.00041 seconds

Memory Before: 12,517.375 KB
Memory After: 12,517.594 KB
Memory Used: 0.219 KB

SQL Query
SELECT
				fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
				a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
				at.contenttypes
FROM attachment AS a
			INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
			LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
			
			
				WHERE
					a.contentid = 51
						AND
					a.contenttypeid = 19

ORDER BY a.contentid, a.displayorder
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEa refcontenttypeid,contentid,filedataidcontenttypeid8const,const1100.00Using index condition; Using filesort
1SIMPLEfd eq_refPRIMARYPRIMARY4melanotan_test.a.filedataid1100.00 
1SIMPLEat eq_refPRIMARYPRIMARY20melanotan_test.fd.extension1100.00Using where

Time Before: 0.39563 seconds
Time After: 0.39615 seconds
Time Taken: 0.00053 seconds

Memory Before: 12,522.891 KB
Memory After: 12,523.109 KB
Memory Used: 0.219 KB

SQL Query
SELECT
				fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
				a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
				at.contenttypes
FROM attachment AS a
			INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
			LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
			
			
				WHERE
					a.contentid = 50
						AND
					a.contenttypeid = 19

ORDER BY a.contentid, a.displayorder
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEa refcontenttypeid,contentid,filedataidcontenttypeid8const,const1100.00Using index condition; Using filesort
1SIMPLEfd eq_refPRIMARYPRIMARY4melanotan_test.a.filedataid1100.00 
1SIMPLEat eq_refPRIMARYPRIMARY20melanotan_test.fd.extension1100.00Using where

Time Before: 0.39702 seconds
Time After: 0.39735 seconds
Time Taken: 0.00033 seconds

Memory Before: 12,524.703 KB
Memory After: 12,524.922 KB
Memory Used: 0.219 KB

SQL Query
SELECT
				fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
				a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
				at.contenttypes
FROM attachment AS a
			INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
			LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
			
			
				WHERE
					a.contentid = 46
						AND
					a.contenttypeid = 19

ORDER BY a.contentid, a.displayorder
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEa refcontenttypeid,contentid,filedataidcontenttypeid8const,const1100.00Using index condition; Using filesort
1SIMPLEfd eq_refPRIMARYPRIMARY4melanotan_test.a.filedataid1100.00 
1SIMPLEat eq_refPRIMARYPRIMARY20melanotan_test.fd.extension1100.00Using where

Time Before: 0.39825 seconds
Time After: 0.39859 seconds
Time Taken: 0.00034 seconds

Memory Before: 12,526.531 KB
Memory After: 12,526.750 KB
Memory Used: 0.219 KB

SQL Query
SELECT thread.threadid, thread.title, thread.replycount 
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE 1=1
ORDER BY thread.replycount DESC
LIMIT 0,10
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEthread ALL    2939100.00Using filesort
1SIMPLEpost eq_refPRIMARYPRIMARY4melanotan_test.thread.firstpostid1100.00Using index

Time Before: 0.39929 seconds
Time After: 0.40131 seconds
Time Taken: 0.00202 seconds

Memory Before: 12,522.930 KB
Memory After: 12,523.688 KB
Memory Used: 0.758 KB

SQL Query
SELECT * FROM thread ORDER BY dateline DESC LIMIT 10
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEthread index dateline4 10100.00 

Time Before: 0.40198 seconds
Time After: 0.40226 seconds
Time Taken: 0.00027 seconds

Memory Before: 12,534.164 KB
Memory After: 12,537.633 KB
Memory Used: 3.469 KB

SQL Query
SELECT post.dateline, post.pagetext AS message, post.allowsmilie, post.postid,
					thread.threadid, thread.title, thread.prefixid, post.attach,
					forum.forumid,
					user.*
					, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
				FROM post AS post
				JOIN thread AS thread ON (thread.threadid = post.threadid)
				JOIN forum AS forum ON(forum.forumid = thread.forumid)
				LEFT JOIN user AS user ON (post.userid = user.userid)
				LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
			WHERE 1=1
				
				AND thread.visible = 1
				AND post.visible = 1
				AND thread.open <> 10
				
			ORDER BY post.dateline DESC
			LIMIT 0,8
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEforum indexPRIMARYPRIMARY2 2100.00Using index; Using temporary; Using filesort
1SIMPLEthread ALLPRIMARY,forumid,forumid_lastpost   29394.50Using where; Using join buffer (Block Nested Loop)
1SIMPLEpost refthreadid,threadid_visible_datelinethreadid_visible_dateline6melanotan_test.thread.threadid,const6100.00 
1SIMPLEuser eq_refPRIMARYPRIMARY4melanotan_test.post.userid1100.00 
1SIMPLEavatar eq_refPRIMARYPRIMARY2melanotan_test.user.avatarid1100.00Using where
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4melanotan_test.user.userid1100.00 

Time Before: 0.40353 seconds
Time After: 0.98985 seconds
Time Taken: 0.58632 seconds

Memory Before: 12,568.555 KB
Memory After: 12,574.305 KB
Memory Used: 5.750 KB

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

Time Before: 0.99448 seconds
Time After: 0.99469 seconds
Time Taken: 0.00021 seconds

Memory Before: 12,672.734 KB
Memory After: 12,673.320 KB
Memory Used: 0.586 KB

SQL Query
UPDATE session
SET lastactivity = 1751619228, location = '/realpeptide/forum/?explain=1', badlocation = 0
WHERE sessionhash = '4e145e044435654f40912e620db4de17'

Time Before: 1.02435 seconds
Time After: 1.02456 seconds
Time Taken: 0.00021 seconds

Memory Before: 13,741.133 KB
Memory After: 13,741.398 KB
Memory Used: 0.266 KB

Page generated in 0.99527788162231 seconds with 33 queries, spending 0.68434500694275 doing MySQL queries and 0.31093287467957 doing PHP things.
Shutdown Queries:
DISABLED