Time Before: 0.00095 seconds
Time After: 0.00129 seconds
Time Taken: 0.00034 seconds
Memory Before: 852.414 KB
Memory After: 965.578 KB
Memory Used: 113.164 KB
Time Before: 0.00135 seconds
Time After: 0.04190 seconds
Time Taken: 0.04055 seconds
Memory Before: 965.578 KB
Memory After: 966.523 KB
Memory Used: 0.945 KB
SET @@sql_mode = ''
Time Before: 0.04217 seconds
Time After: 0.04236 seconds
Time Taken: 0.00019 seconds
Memory Before: 967.188 KB
Memory After: 967.750 KB
Memory Used: 0.563 KB
SELECT * FROM rxdatastore WHERE title IN ('smiliecache','bbcodecache','noavatarperms','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxdatastore | range | PRIMARY | PRIMARY | 50 | 19 | Using where |
Time Before: 0.04300 seconds
Time After: 0.04387 seconds
Time Taken: 0.00086 seconds
Memory Before: 971.008 KB
Memory After: 971.234 KB
Memory Used: 0.227 KB
Time Before: 0.04242 seconds
Time After: 0.04864 seconds
Time Taken: 0.00621 seconds
Memory Before: 966.992 KB
Memory After: 3,726.141 KB
Memory Used: 2,759.148 KB
SELECT * FROM rxdatastore WHERE title IN ('profilefield')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | Impossible WHERE noticed after reading const tables |
Time Before: 0.04979 seconds
Time After: 0.04998 seconds
Time Taken: 0.00019 seconds
Memory Before: 4,187.641 KB
Memory After: 4,188.094 KB
Memory Used: 0.453 KB
SELECT * FROM rxsession WHERE userid = 0 AND host = '172.69.6.174' AND idhash = 'f8513cd8351beb21683ad0e93609c7cd' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxsession | ref | guest_lookup,user_activity | guest_lookup | 51 | const,const,const | 2 | Using where |
Time Before: 0.05060 seconds
Time After: 0.05087 seconds
Time Taken: 0.00027 seconds
Memory Before: 4,202.031 KB
Memory After: 4,202.398 KB
Memory Used: 0.367 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_calendar AS phrasegroup_calendar, phrasegroup_holiday AS phrasegroup_holiday, phrasegroup_timezone AS phrasegroup_timezone, phrasegroup_posting AS phrasegroup_posting, 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 rxlanguage WHERE languageid = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxlanguage | system | PRIMARY | 1 |
Time Before: 0.05164 seconds
Time After: 0.05209 seconds
Time Taken: 0.00045 seconds
Memory Before: 4,213.461 KB
Memory After: 4,213.102 KB
Memory Used: -0.359 KB
Time Before: 0.05012 seconds
Time After: 0.05226 seconds
Time Taken: 0.00213 seconds
Memory Before: 4,194.977 KB
Memory After: 4,335.422 KB
Memory Used: 140.445 KB
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions, calendar.calendarid,calendar.title, displayorder FROM rxcalendar AS calendar LEFT JOIN rxcalendarpermission AS calendarpermission ON (calendarpermission.calendarid = calendar.calendarid AND usergroupid IN (1)) ORDER BY displayorder ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | calendar | ALL | 1 | Using filesort | ||||
1 | SIMPLE | calendarpermission | ref | calendarid,usergroupid | calendarid | 4 | 03forums.calendar.calendarid | 1 | Using where |
Time Before: 0.05644 seconds
Time After: 0.05691 seconds
Time Taken: 0.00047 seconds
Memory Before: 4,900.984 KB
Memory After: 4,901.188 KB
Memory Used: 0.203 KB
SELECT * FROM rxstyle WHERE (styleid = 21 AND userselect = 1) OR styleid = 21 ORDER BY styleid ASC LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxstyle | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.05888 seconds
Time After: 0.05919 seconds
Time Taken: 0.00031 seconds
Memory Before: 5,079.797 KB
Memory After: 5,080.188 KB
Memory Used: 0.391 KB
SELECT * FROM rxcalendar WHERE calendarid = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxcalendar | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.06152 seconds
Time After: 0.06173 seconds
Time Taken: 0.00021 seconds
Memory Before: 5,643.250 KB
Memory After: 5,643.734 KB
Memory Used: 0.484 KB
SELECT birthday, username, userid, showbirthday FROM rxuser WHERE (birthday LIKE '11-%' OR birthday LIKE '12-%') AND usergroupid IN (0,6,26,9,14,23,7,27,2,22,5,10) AND showbirthday IN (2,3)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxuser | range | usergroupid,birthday | birthday | 12 | 54366 | Using index condition; Using where |
Time Before: 0.06417 seconds
Time After: 0.43612 seconds
Time Taken: 0.37195 seconds
Memory Before: 5,664.070 KB
Memory After: 5,664.375 KB
Memory Used: 0.305 KB
SELECT * FROM rxholiday
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxholiday | ALL | 1 |
Time Before: 0.44422 seconds
Time After: 0.44458 seconds
Time Taken: 0.00036 seconds
Memory Before: 6,990.023 KB
Memory After: 6,990.516 KB
Memory Used: 0.492 KB
SELECT event.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, user.adminoptions, user.usergroupid, user.usertitle, user.membergroupids, user.infractiongroupids, IF(options & 8192, 1, 0) AS hasaccessmask, IF(dateline_to = 0, 1, 0) AS singleday ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, user.avatarrevision, customavatar.height_thumb AS avheight_thumb, customavatar.filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom FROM rxevent AS event LEFT JOIN rxuser AS user ON (user.userid = event.userid) LEFT JOIN rxavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN rxcustomavatar AS customavatar ON(customavatar.userid = user.userid) WHERE calendarid = 1 AND ((dateline_to >= 1351684800 AND dateline_from < 1357041600) OR (dateline_to = 0 AND dateline_from >= 1351684800 AND dateline_from <= 1357041600 )) AND event.visible = 1 ORDER BY dateline_from
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | event | ALL | calendarid,visible,daterange | 5 | Using where; Using filesort | |||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 03forums.event.userid | 1 | |
1 | SIMPLE | avatar | eq_ref | PRIMARY | PRIMARY | 2 | 03forums.user.avatarid | 1 | Using where |
1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | 03forums.user.userid | 1 | Using where |
Time Before: 0.44581 seconds
Time After: 0.44636 seconds
Time Taken: 0.00055 seconds
Memory Before: 6,997.180 KB
Memory After: 6,996.594 KB
Memory Used: -0.586 KB
SELECT title, template FROM rxtemplate WHERE templateid IN (10876,10877,10851,10853,10855,10857,10859,10903,10882,10888,10884,10885,10883,10886,10887,10898,10899,10896,10897,10901,10902,10900,10892,10873,10728,10723,11387,11407,977,976,978,973,972,1595,4948,10720,10699,981,982,1600,11122,11396,11068,11072,11069,11070,11071,11426,0,0,11406,11367,11092,11093,11095,11096,11319,11438,11420,11370,11371,10919,10918,10922)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxtemplate | range | PRIMARY | PRIMARY | 4 | 63 | Using where |
Time Before: 0.44770 seconds
Time After: 0.44946 seconds
Time Taken: 0.00176 seconds
Memory Before: 7,188.953 KB
Memory After: 7,189.047 KB
Memory Used: 0.094 KB
UPDATE rxsession SET lastactivity = 1713937687, location = '/calendar.php?c=1&do=displayweek&explain=1', incalendar = 1, badlocation = 0 WHERE sessionhash = 'ff9fa2385a30e05b38e726c83aad26a8'
Time Before: 0.48357 seconds
Time After: 0.48378 seconds
Time Taken: 0.00021 seconds
Memory Before: 7,714.781 KB
Memory After: 7,714.969 KB
Memory Used: 0.188 KB