Time Before: 0.00781 seconds
Time After: 0.01853 seconds
Time Taken: 0.01072 seconds
Memory Before: 1,688.500 KB
Memory After: 2,916.750 KB
Memory Used: 1,228.250 KB
Time Before: 0.01860 seconds
Time After: 0.01947 seconds
Time Taken: 0.00087 seconds
Memory Before: 2,916.688 KB
Memory After: 2,917.641 KB
Memory Used: 0.953 KB
SET @@sql_mode = ''
Time Before: 0.01966 seconds
Time After: 0.01979 seconds
Time Taken: 0.00013 seconds
Memory Before: 2,918.383 KB
Memory After: 2,918.938 KB
Memory Used: 0.555 KB
SELECT *
FROM vb_datastore
WHERE title IN ('crondata','mailqueue','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 | vb_datastore | range | PRIMARY | PRIMARY | 152 | 18 | Using index condition |
Time Before: 0.02051 seconds
Time After: 0.02140 seconds
Time Taken: 0.00089 seconds
Memory Before: 2,921.789 KB
Memory After: 2,922.641 KB
Memory Used: 0.852 KB
Time Before: 0.01983 seconds
Time After: 0.04275 seconds
Time Taken: 0.02293 seconds
Memory Before: 2,918.188 KB
Memory After: 3,764.008 KB
Memory Used: 845.820 KB
SELECT *
FROM vb_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.06537 seconds
Time After: 0.06562 seconds
Time Taken: 0.00024 seconds
Memory Before: 6,456.375 KB
Memory After: 6,456.906 KB
Memory Used: 0.531 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, 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 vb_language WHERE languageid = 4
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | vb_language | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.06660 seconds
Time After: 0.06713 seconds
Time Taken: 0.00052 seconds
Memory Before: 6,480.039 KB
Memory After: 6,480.125 KB
Memory Used: 0.086 KB
Time Before: 0.06578 seconds
Time After: 0.06725 seconds
Time Taken: 0.00147 seconds
Memory Before: 6,463.711 KB
Memory After: 6,545.242 KB
Memory Used: 81.531 KB
REPLACE INTO vb_datastore
(title, data, unserialize)
VALUES
('loadcache', 'a:2:{s:7:\"loadavg\";s:4:\"1.16\";s:9:\"lastcheck\";i:1769990750;}', 1)Time Before: 0.08431 seconds
Time After: 0.08484 seconds
Time Taken: 0.00053 seconds
Memory Before: 6,767.172 KB
Memory After: 6,767.422 KB
Memory Used: 0.250 KB
SELECT * FROM vb_style WHERE (styleid = 4 AND userselect = 1) OR styleid = 4 ORDER BY styleid ASC LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | vb_style | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.08915 seconds
Time After: 0.08966 seconds
Time Taken: 0.00050 seconds
Memory Before: 6,974.352 KB
Memory After: 6,974.961 KB
Memory Used: 0.609 KB
SELECT title, template FROM vb_template WHERE templateid IN (7280,12573,12553,14939,3440,3439,3441,3436,3435,4028,4029,4027,12569,3444,3445,4033,14654,14928,11222,14604,14601,14602,14603,14958,0,0,14938,14899,14624,14625,14627,14628,14851,14970,14952,14902,14903,14451,14450,14454,14014,0,0,0,0)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | vb_template | range | PRIMARY | PRIMARY | 4 | 40 | Using index condition |
Time Before: 0.11056 seconds
Time After: 0.11151 seconds
Time Taken: 0.00095 seconds
Memory Before: 7,798.172 KB
Memory After: 7,799.391 KB
Memory Used: 1.219 KB