Time Before: 0.01536 seconds
Time After: 0.02817 seconds
Time Taken: 0.01281 seconds
Memory Before: 2,340.555 KB
Memory After: 3,884.391 KB
Memory Used: 1,543.836 KB
Time Before: 0.02821 seconds
Time After: 0.02865 seconds
Time Taken: 0.00044 seconds
Memory Before: 3,884.422 KB
Memory After: 3,885.344 KB
Memory Used: 0.922 KB
SET @@sql_mode = ''
Time Before: 0.02886 seconds
Time After: 0.02903 seconds
Time Taken: 0.00017 seconds
Memory Before: 3,886.070 KB
Memory After: 3,886.656 KB
Memory Used: 0.586 KB
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')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 50 | 23 | 100.00 | Using where |
Time Before: 0.04648 seconds
Time After: 0.04707 seconds
Time Taken: 0.00060 seconds
Memory Before: 3,890.148 KB
Memory After: 3,891.125 KB
Memory Used: 0.977 KB
Time Before: 0.02908 seconds
Time After: 0.04862 seconds
Time Taken: 0.01954 seconds
Memory Before: 3,885.906 KB
Memory After: 4,689.180 KB
Memory Used: 803.273 KB
SELECT * FROM datastore WHERE title IN ('blogcategorycache','blogstats','dbtech_dbseo_keyword','dbtech_dbseo_gwt_cache','dbtech_dbseo_oauth','profilefield')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 50 | 6 | 100.00 | Using where |
Time Before: 0.10656 seconds
Time After: 0.10684 seconds
Time Taken: 0.00028 seconds
Memory Before: 7,424.563 KB
Memory After: 7,425.148 KB
Memory Used: 0.586 KB
SELECT * FROM session WHERE userid = 0 AND host = '216.73.216.164' AND idhash = 'ea5a359a73a8141a16de516480d33c34' LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | ref | user_activity,guest_lookup | guest_lookup | 51 | const,const,const | 2 | 100.00 |
Time Before: 0.10748 seconds
Time After: 0.10775 seconds
Time Taken: 0.00027 seconds
Memory Before: 7,441.484 KB
Memory After: 7,442.125 KB
Memory Used: 0.641 KB
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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | language | system | PRIMARY | 1 | 100.00 |
Time Before: 0.10850 seconds
Time After: 0.10892 seconds
Time Taken: 0.00041 seconds
Memory Before: 7,453.328 KB
Memory After: 7,453.359 KB
Memory Used: 0.031 KB
Time Before: 0.10698 seconds
Time After: 0.10902 seconds
Time Taken: 0.00203 seconds
Memory Before: 7,434.195 KB
Memory After: 7,513.688 KB
Memory Used: 79.492 KB
SELECT MAX(permissions & 1) AS perm FROM cms_permissions WHERE nodeid = 1 AND usergroupid IN (1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cms_permissions | const | usergroupid,nodeid | usergroupid | 8 | const,const | 1 | 100.00 |
Time Before: 0.13687 seconds
Time After: 0.13709 seconds
Time Taken: 0.00022 seconds
Memory Before: 7,734.438 KB
Memory After: 7,734.984 KB
Memory Used: 0.547 KB
SELECT * FROM style WHERE (styleid = 1 AND userselect = 1) OR styleid = 1 ORDER BY styleid ASC LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 |
Time Before: 0.18920 seconds
Time After: 0.18948 seconds
Time Taken: 0.00028 seconds
Memory Before: 8,231.789 KB
Memory After: 8,232.422 KB
Memory Used: 0.633 KB
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 > 1751490760 ORDER BY username ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | range | last_activity | last_activity | 4 | 111 | 100.00 | Using where; Using temporary; Using filesort | ||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.session.userid | 1 | 100.00 |
Time Before: 0.20155 seconds
Time After: 0.20218 seconds
Time Taken: 0.00064 seconds
Memory Before: 9,538.258 KB
Memory After: 9,548.000 KB
Memory Used: 9.742 KB
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)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | forum | ALL | 2 | 100.00 | ||||||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.forum.lastposterid | 1 | 100.00 | ||
1 | SIMPLE | userlist | eq_ref | PRIMARY,relationid,userid | PRIMARY | 9 | const,melanotan_test.user.userid,const | 1 | 100.00 |
Time Before: 0.20310 seconds
Time After: 0.20338 seconds
Time Taken: 0.00028 seconds
Memory Before: 9,542.820 KB
Memory After: 9,543.125 KB
Memory Used: 0.305 KB
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)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 67 | 100.00 | Using where |
Time Before: 0.22860 seconds
Time After: 0.25609 seconds
Time Taken: 0.02749 seconds
Memory Before: 10,132.023 KB
Memory After: 10,133.852 KB
Memory Used: 1.828 KB
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'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | user | ref | username | username | 102 | const | 1 | 100.00 | ||
1 | SIMPLE | avatar | eq_ref | PRIMARY | PRIMARY | 2 | melanotan_test.user.avatarid | 1 | 100.00 | Using where | |
1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.user.userid | 1 | 100.00 |
Time Before: 0.26712 seconds
Time After: 0.26742 seconds
Time Taken: 0.00030 seconds
Memory Before: 10,418.750 KB
Memory After: 10,419.016 KB
Memory Used: 0.266 KB
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'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | user | ref | username | username | 102 | const | 1 | 100.00 | ||
1 | SIMPLE | avatar | eq_ref | PRIMARY | PRIMARY | 2 | melanotan_test.user.avatarid | 1 | 100.00 | Using where | |
1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.user.userid | 1 | 100.00 |
Time Before: 0.26902 seconds
Time After: 0.26931 seconds
Time Taken: 0.00029 seconds
Memory Before: 10,423.266 KB
Memory After: 10,423.531 KB
Memory Used: 0.266 KB
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 > 1748899660 AND info.associatedthreadid IS NULL ORDER BY post.dateline DESC LIMIT 0,5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | range | threadid,threadid_visible_dateline,dateline | dateline | 4 | 1 | 10.00 | Using index condition; Using where | ||
1 | SIMPLE | thread | eq_ref | PRIMARY,forumid,forumid_lastpost | PRIMARY | 4 | melanotan_test.post.threadid | 1 | 90.00 | Using where | |
1 | SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 2 | melanotan_test.thread.forumid | 1 | 100.00 | Using index | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.post.userid | 1 | 100.00 | ||
1 | SIMPLE | info | ref | associatedthreadid | associatedthreadid | 4 | melanotan_test.post.threadid | 35 | 100.00 | Using where; Not exists; Using index | |
1 | SIMPLE | avatar | eq_ref | PRIMARY | PRIMARY | 2 | melanotan_test.user.avatarid | 1 | 100.00 | Using where | |
1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.user.userid | 1 | 100.00 |
Time Before: 0.27742 seconds
Time After: 0.27797 seconds
Time Taken: 0.00055 seconds
Memory Before: 10,637.359 KB
Memory After: 10,636.977 KB
Memory Used: -0.383 KB
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 <= 1751491660 ORDER BY dateline DESC LIMIT 0, 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | stream | ALL | dateline | 1 | 100.00 | Using where; Using filesort | ||||
1 | SIMPLE | type | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.stream.typeid | 1 | 100.00 |
Time Before: 0.29392 seconds
Time After: 0.29421 seconds
Time Taken: 0.00030 seconds
Memory Before: 11,346.992 KB
Memory After: 11,347.352 KB
Memory Used: 0.359 KB
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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | b | ALL | PRIMARY,userid | 17 | 100.00 | Using filesort | ||||
1 | SIMPLE | bt | ref | blogid,userid | blogid | 4 | melanotan_test.b.blogid | 4 | 10.00 | Using where |
Time Before: 0.29653 seconds
Time After: 0.29695 seconds
Time Taken: 0.00041 seconds
Memory Before: 11,404.586 KB
Memory After: 11,405.328 KB
Memory Used: 0.742 KB
SELECT data, expires, locktime, serialized FROM cache WHERE cacheid = 'vb_types.types'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | 100.00 |
Time Before: 0.32647 seconds
Time After: 0.32672 seconds
Time Taken: 0.00025 seconds
Memory Before: 12,005.594 KB
Memory After: 12,006.164 KB
Memory Used: 0.570 KB
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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | contenttypeid,contentid,filedataid | contenttypeid | 8 | const,const | 1 | 100.00 | Using index condition; Using filesort | |
1 | SIMPLE | fd | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.a.filedataid | 1 | 100.00 | ||
1 | SIMPLE | at | eq_ref | PRIMARY | PRIMARY | 20 | melanotan_test.fd.extension | 1 | 100.00 | Using where |
Time Before: 0.32781 seconds
Time After: 0.32827 seconds
Time Taken: 0.00046 seconds
Memory Before: 12,081.758 KB
Memory After: 12,081.977 KB
Memory Used: 0.219 KB
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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | contenttypeid,contentid,filedataid | contenttypeid | 8 | const,const | 1 | 100.00 | Using index condition; Using filesort | |
1 | SIMPLE | fd | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.a.filedataid | 1 | 100.00 | ||
1 | SIMPLE | at | eq_ref | PRIMARY | PRIMARY | 20 | melanotan_test.fd.extension | 1 | 100.00 | Using where |
Time Before: 0.32905 seconds
Time After: 0.32949 seconds
Time Taken: 0.00044 seconds
Memory Before: 12,087.313 KB
Memory After: 12,087.531 KB
Memory Used: 0.219 KB
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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | contenttypeid,contentid,filedataid | contenttypeid | 8 | const,const | 1 | 100.00 | Using index condition; Using filesort | |
1 | SIMPLE | fd | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.a.filedataid | 1 | 100.00 | ||
1 | SIMPLE | at | eq_ref | PRIMARY | PRIMARY | 20 | melanotan_test.fd.extension | 1 | 100.00 | Using where |
Time Before: 0.33039 seconds
Time After: 0.33082 seconds
Time Taken: 0.00043 seconds
Memory Before: 12,089.164 KB
Memory After: 12,089.383 KB
Memory Used: 0.219 KB
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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | contenttypeid,contentid,filedataid | contenttypeid | 8 | const,const | 1 | 100.00 | Using index condition; Using filesort | |
1 | SIMPLE | fd | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.a.filedataid | 1 | 100.00 | ||
1 | SIMPLE | at | eq_ref | PRIMARY | PRIMARY | 20 | melanotan_test.fd.extension | 1 | 100.00 | Using where |
Time Before: 0.33177 seconds
Time After: 0.33219 seconds
Time Taken: 0.00042 seconds
Memory Before: 12,091.031 KB
Memory After: 12,091.250 KB
Memory Used: 0.219 KB
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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | ALL | 2939 | 100.00 | Using filesort | |||||
1 | SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.thread.firstpostid | 1 | 100.00 | Using index |
Time Before: 0.33293 seconds
Time After: 0.33549 seconds
Time Taken: 0.00257 seconds
Memory Before: 12,087.469 KB
Memory After: 12,088.227 KB
Memory Used: 0.758 KB
SELECT * FROM thread ORDER BY dateline DESC LIMIT 10
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | index | dateline | 4 | 10 | 100.00 |
Time Before: 0.33633 seconds
Time After: 0.33669 seconds
Time Taken: 0.00036 seconds
Memory Before: 12,098.016 KB
Memory After: 12,101.484 KB
Memory Used: 3.469 KB
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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | forum | index | PRIMARY | PRIMARY | 2 | 2 | 100.00 | Using index; Using temporary; Using filesort | ||
1 | SIMPLE | thread | ALL | PRIMARY,forumid,forumid_lastpost | 2939 | 4.50 | Using where; Using join buffer (Block Nested Loop) | ||||
1 | SIMPLE | post | ref | threadid,threadid_visible_dateline | threadid_visible_dateline | 6 | melanotan_test.thread.threadid,const | 6 | 100.00 | ||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.post.userid | 1 | 100.00 | ||
1 | SIMPLE | avatar | eq_ref | PRIMARY | PRIMARY | 2 | melanotan_test.user.avatarid | 1 | 100.00 | Using where | |
1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | melanotan_test.user.userid | 1 | 100.00 |
Time Before: 0.33810 seconds
Time After: 0.93043 seconds
Time Taken: 0.59233 seconds
Memory Before: 12,133.750 KB
Memory After: 12,139.500 KB
Memory Used: 5.750 KB
SELECT template FROM template WHERE templateid = 1407
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 |
Time Before: 0.94727 seconds
Time After: 0.94751 seconds
Time Taken: 0.00024 seconds
Memory Before: 12,239.641 KB
Memory After: 12,240.227 KB
Memory Used: 0.586 KB
UPDATE session SET lastactivity = 1751491660, location = '/realpeptide/forum/?explain=1', inforum = 0, inthread = 0, badlocation = 0 WHERE sessionhash = 'cdbef369184852de5b90e52ed28777d2'
Time Before: 0.97426 seconds
Time After: 0.97476 seconds
Time Taken: 0.00050 seconds
Memory Before: 13,226.141 KB
Memory After: 13,226.375 KB
Memory Used: 0.234 KB