Time Before: 0.00098 seconds
Time After: 0.00116 seconds
Time Taken: 0.00018 seconds
Memory Before: 408.461 KB
Memory After: 410.719 KB
Memory Used: 2.258 KB
Time Before: 0.00122 seconds
Time After: 0.00205 seconds
Time Taken: 0.00083 seconds
Memory Before: 410.703 KB
Memory After: 411.281 KB
Memory Used: 0.578 KB
SET @@sql_mode = ''
Time Before: 0.00228 seconds
Time After: 0.00265 seconds
Time Taken: 0.00037 seconds
Memory Before: 411.328 KB
Memory After: 411.383 KB
Memory Used: 0.055 KB
SELECT *
FROM datastore
WHERE title IN ('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 | datastore | range | PRIMARY | PRIMARY | 150 | 16 | Using where |
Time Before: 0.00349 seconds
Time After: 0.00444 seconds
Time Taken: 0.00096 seconds
Memory Before: 413.242 KB
Memory After: 594.109 KB
Memory Used: 180.867 KB
Time Before: 0.00267 seconds
Time After: 0.00919 seconds
Time Taken: 0.00652 seconds
Memory Before: 411.141 KB
Memory After: 807.609 KB
Memory Used: 396.469 KB
SELECT *
FROM datastore
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.01014 seconds
Time After: 0.01050 seconds
Time Taken: 0.00036 seconds
Memory Before: 808.430 KB
Memory After: 824.625 KB
Memory Used: 16.195 KB
SELECT * FROM session WHERE userid = 0 AND host = '216.73.216.0' AND idhash = 'ea5a359a73a8141a16de516480d33c34' LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ref | user_activity,guest_lookup | user_activity | 4 | const | 1 | Using where |
Time Before: 0.01120 seconds
Time After: 0.01165 seconds
Time Taken: 0.00045 seconds
Memory Before: 814.109 KB
Memory After: 830.742 KB
Memory Used: 16.633 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_messaging AS phrasegroup_messaging, 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | language | system | PRIMARY | 1 |
Time Before: 0.01271 seconds
Time After: 0.01331 seconds
Time Taken: 0.00061 seconds
Memory Before: 819.867 KB
Memory After: 924.469 KB
Memory Used: 104.602 KB
Time Before: 0.01057 seconds
Time After: 0.01344 seconds
Time Taken: 0.00287 seconds
Memory Before: 810.883 KB
Memory After: 865.156 KB
Memory Used: 54.273 KB
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
| 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 | usergroupid | 2 | const | 1 | Using where |
Time Before: 0.01711 seconds
Time After: 0.01764 seconds
Time Taken: 0.00053 seconds
Memory Before: 934.727 KB
Memory After: 950.625 KB
Memory Used: 15.898 KB
SELECT MAX(permissions & 1) AS perm FROM cms_permissions WHERE nodeid = 1 AND usergroupid IN (1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | cms_permissions | const | usergroupid,nodeid | usergroupid | 8 | const,const | 1 |
Time Before: 0.01832 seconds
Time After: 0.01870 seconds
Time Taken: 0.00038 seconds
Memory Before: 946.617 KB
Memory After: 962.672 KB
Memory Used: 16.055 KB
SELECT * FROM style WHERE (styleid = 13 AND userselect = 1) OR styleid = 13 ORDER BY styleid ASC LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.01988 seconds
Time After: 0.02050 seconds
Time Taken: 0.00062 seconds
Memory Before: 946.258 KB
Memory After: 1,186.867 KB
Memory Used: 240.609 KB
SELECT title, template FROM template WHERE templateid IN (961,1023,978,1007,685,0,1403,1404,991,1011,0,0,417,411,410,415,416,414,413,418,419,420,726,1000,672,676,673,674,675,1030,0,0,1010,971,696,697,699,700,923,1042,1024,974,975,523,522,526,85)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 43 | Using where |
Time Before: 0.02675 seconds
Time After: 0.02784 seconds
Time Taken: 0.00109 seconds
Memory Before: 1,503.914 KB
Memory After: 1,602.031 KB
Memory Used: 98.117 KB
UPDATE session SET lastactivity = 1767862759, location = '/sendmessage.php?explain=1', badlocation = 0 WHERE sessionhash = 'ba4c8c2fa72a6db55d198bdc54149d2a'
Time Before: 0.03172 seconds
Time After: 0.03210 seconds
Time Taken: 0.00038 seconds
Memory Before: 1,769.836 KB
Memory After: 1,769.758 KB
Memory Used: -0.078 KB