Time Before: 0.05732 seconds
Time After: 0.06612 seconds
Time Taken: 0.00879 seconds
Memory Before: 1,148.742 KB
Memory After: 1,887.164 KB
Memory Used: 738.422 KB
Time Before: 0.06621 seconds
Time After: 0.06821 seconds
Time Taken: 0.00200 seconds
Memory Before: 1,887.148 KB
Memory After: 1,887.719 KB
Memory Used: 0.570 KB
SET @@sql_mode = ''
Time Before: 0.06949 seconds
Time After: 0.06963 seconds
Time Taken: 0.00014 seconds
Memory Before: 1,887.766 KB
Memory After: 1,887.820 KB
Memory Used: 0.055 KB
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 20 | Using index condition |
Time Before: 0.07149 seconds
Time After: 0.07488 seconds
Time Taken: 0.00339 seconds
Memory Before: 1,889.422 KB
Memory After: 1,889.352 KB
Memory Used: -0.070 KB
Time Before: 0.06967 seconds
Time After: 0.08825 seconds
Time Taken: 0.01858 seconds
Memory Before: 1,887.609 KB
Memory After: 2,848.500 KB
Memory Used: 960.891 KB
SELECT * FROM session WHERE userid = 0 AND host = '35.172.223.251' AND idhash = 'e4873a5a4bf34cdf81e1bea96caf3f3d' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | ALL | 179 | Using where |
Time Before: 0.08996 seconds
Time After: 0.09089 seconds
Time Taken: 0.00093 seconds
Memory Before: 2,867.563 KB
Memory After: 2,867.742 KB
Memory Used: 0.180 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_holiday AS phrasegroup_holiday, 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.09313 seconds
Time After: 0.09446 seconds
Time Taken: 0.00133 seconds
Memory Before: 2,874.422 KB
Memory After: 2,874.602 KB
Memory Used: 0.180 KB
Time Before: 0.08892 seconds
Time After: 0.09465 seconds
Time Taken: 0.00573 seconds
Memory Before: 2,867.242 KB
Memory After: 2,937.406 KB
Memory Used: 70.164 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 | 2 | Using filesort | ||||
1 | SIMPLE | calendarpermission | ref | calendarid,usergroupid | usergroupid | 2 | const | 1 | Using where |
Time Before: 0.09970 seconds
Time After: 0.10096 seconds
Time Taken: 0.00126 seconds
Memory Before: 2,972.711 KB
Memory After: 2,972.641 KB
Memory Used: -0.070 KB
SELECT * FROM style WHERE (styleid = 2 AND userselect = 1) OR styleid = 2 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.10276 seconds
Time After: 0.10495 seconds
Time Taken: 0.00219 seconds
Memory Before: 2,982.047 KB
Memory After: 2,982.352 KB
Memory Used: 0.305 KB
SELECT title, template FROM template WHERE templateid IN (8619,1838,8713,1839,1840,1841,1842,8718,8719,8721,1843,1844,1845,1846,8720,8712,2765,2665,2627,8621,8620,8622,8617,8616,8893,1879,1880,8846,8847,9113,9116,9125,8866,8867,8868,8869,9067,9130,9129,1995,1998,2003,632,8477,8479,8480,8481,8482,8483,8484,8485,8486,8487,8488,8489,8490,8491,8492,8493,8494,8495,8496,8497,8478,663,664,668,953,1944,9028,9029,975,2700,2703,8547,8548,8549,1731,1732,1999,2580,2581,2582,2732,2677,2675,2676,2754,2755,9191,1681,1682)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 92 | Using index condition |
Time Before: 0.10956 seconds
Time After: 0.14896 seconds
Time Taken: 0.03939 seconds
Memory Before: 3,187.148 KB
Memory After: 3,186.953 KB
Memory Used: -0.195 KB
UPDATE session SET lastactivity = 1660917943, location = '/forums/index.php?explain=1', bypass = 0 WHERE sessionhash = 'addf3db80549ecffcb06010ef25cc534'
Time Before: 0.16143 seconds
Time After: 0.16168 seconds
Time Taken: 0.00025 seconds
Memory Before: 3,816.063 KB
Memory After: 3,815.969 KB
Memory Used: -0.094 KB