Time Before: 0.02051 seconds
Time After: 0.02957 seconds
Time Taken: 0.00906 seconds
Memory Before: 401.258 KB
Memory After: 409.164 KB
Memory Used: 7.906 KB
Time Before: 0.02966 seconds
Time After: 0.03475 seconds
Time Taken: 0.00509 seconds
Memory Before: 409.117 KB
Memory After: 410.039 KB
Memory Used: 0.922 KB
SELECT title, data FROM datastore WHERE title IN ('','options','bitfields','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','attachmentcache')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 17 | 11 | Using index condition |
Time Before: 0.03552 seconds
Time After: 0.03636 seconds
Time Taken: 0.00084 seconds
Memory Before: 413.008 KB
Memory After: 413.563 KB
Memory Used: 0.555 KB
Time Before: 0.03503 seconds
Time After: 0.03713 seconds
Time Taken: 0.00209 seconds
Memory Before: 409.711 KB
Memory After: 689.219 KB
Memory Used: 279.508 KB
SELECT * FROM session WHERE userid = 0 AND host = '54.146.227.92' AND idhash = '56de9a193a9a709990cded4ab1da6628' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | ALL | 589 | Using where |
Time Before: 0.03803 seconds
Time After: 0.03894 seconds
Time Taken: 0.00091 seconds
Memory Before: 697.852 KB
Memory After: 698.266 KB
Memory Used: 0.414 KB
SELECT languageid, phrasegroup_fronthelp AS phrasegroup_fronthelp, phrasegroup_global AS phrasegroup_global, 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.04277 seconds
Time After: 0.04388 seconds
Time Taken: 0.00112 seconds
Memory Before: 707.156 KB
Memory After: 707.070 KB
Memory Used: -0.086 KB
Time Before: 0.03728 seconds
Time After: 0.04397 seconds
Time Taken: 0.00669 seconds
Memory Before: 693.383 KB
Memory After: 742.117 KB
Memory Used: 48.734 KB
SELECT * FROM style WHERE (styleid = 1 AND userselect = 1) OR styleid = 1 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.04966 seconds
Time After: 0.05169 seconds
Time Taken: 0.00203 seconds
Memory Before: 846.672 KB
Memory After: 847.125 KB
Memory Used: 0.453 KB
SELECT title, template FROM template WHERE templateid IN (3145,3146,3147,450,3422,3389,3260,3405,418,3384,3387,3395,3246,3247,3248,3249,3355,3400,3399,3401,3404)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 21 | Using index condition |
Time Before: 0.05282 seconds
Time After: 0.05479 seconds
Time Taken: 0.00196 seconds
Memory Before: 969.766 KB
Memory After: 970.164 KB
Memory Used: 0.398 KB
SELECT varname, text, languageid, phrasetypeid FROM phrase AS phrase WHERE phrasetypeid = 7000 AND languageid IN(-1, 0, 1)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phrase | range | languageid | languageid | 4 | 102 | Using index condition |
Time Before: 0.05863 seconds
Time After: 0.05922 seconds
Time Taken: 0.00059 seconds
Memory Before: 1,037.766 KB
Memory After: 1,038.203 KB
Memory Used: 0.438 KB
SELECT faqname, faqparent, displayorder FROM faq
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | faq | ALL | 33 |
Time Before: 0.05983 seconds
Time After: 0.06010 seconds
Time Taken: 0.00026 seconds
Memory Before: 1,085.555 KB
Memory After: 1,086.063 KB
Memory Used: 0.508 KB
SELECT varname, text, languageid FROM phrase AS phrase WHERE phrasetypeid = 8000 AND languageid IN(-1, 0, 1) AND varname IN('vb_faq')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 256 | 3 | Using index condition |
Time Before: 0.06082 seconds
Time After: 0.06115 seconds
Time Taken: 0.00033 seconds
Memory Before: 1,079.289 KB
Memory After: 1,079.711 KB
Memory Used: 0.422 KB
UPDATE session SET lastactivity = 1550753051, location = '/members/faq.php?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0 WHERE sessionhash = '5fe36611a47c9228af3e08ca1573cd33'
Time Before: 0.06405 seconds
Time After: 0.06449 seconds
Time Taken: 0.00044 seconds
Memory Before: 1,193.141 KB
Memory After: 1,193.336 KB
Memory Used: 0.195 KB