Time Before: 0.00271 seconds
Time After: 0.01930 seconds
Time Taken: 0.01659 seconds
Memory Before: 1,855.531 KB
Memory After: 3,246.391 KB
Memory Used: 1,390.859 KB
Time Before: 0.01938 seconds
Time After: 0.01994 seconds
Time Taken: 0.00056 seconds
Memory Before: 3,246.352 KB
Memory After: 3,247.344 KB
Memory Used: 0.992 KB
SET @@sql_mode = ''
Time Before: 0.02017 seconds
Time After: 0.02030 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,247.984 KB
Memory After: 3,248.508 KB
Memory Used: 0.523 KB
SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','blogcategorycache','blogstats','blogfeatured_settings','blogfeatured_entries','blogtagcloud','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 | 52 | 23 | Using where |
Time Before: 0.02107 seconds
Time After: 0.02365 seconds
Time Taken: 0.00259 seconds
Memory Before: 3,251.555 KB
Memory After: 3,252.438 KB
Memory Used: 0.883 KB
Time Before: 0.02038 seconds
Time After: 0.02797 seconds
Time Taken: 0.00760 seconds
Memory Before: 3,247.789 KB
Memory After: 4,330.805 KB
Memory Used: 1,083.016 KB
SELECT * FROM session WHERE userid = 0 AND host = '192.168.0.1' AND idhash = 'ce294c5626a6c3c128594a952859491f' LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ref | idhash,host,userid,guest_lookup,user_activity | idhash | 32 | const | 2 | Using where |
Time Before: 0.03046 seconds
Time After: 0.03092 seconds
Time Taken: 0.00046 seconds
Memory Before: 4,898.586 KB
Memory After: 4,899.203 KB
Memory Used: 0.617 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_posting AS phrasegroup_posting, phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal, phrasegroup_postbit AS phrasegroup_postbit, phrasegroup_vbblogcat AS phrasegroup_vbblogcat, phrasegroup_inlinemod AS phrasegroup_inlinemod, 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 = 3
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | language | system | PRIMARY | 1 |
Time Before: 0.03338 seconds
Time After: 0.03633 seconds
Time Taken: 0.00295 seconds
Memory Before: 4,911.039 KB
Memory After: 4,910.914 KB
Memory Used: -0.125 KB
Time Before: 0.02974 seconds
Time After: 0.03655 seconds
Time Taken: 0.00681 seconds
Memory Before: 4,890.828 KB
Memory After: 5,000.758 KB
Memory Used: 109.930 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.04269 seconds
Time After: 0.04289 seconds
Time Taken: 0.00019 seconds
Memory Before: 5,562.688 KB
Memory After: 5,563.203 KB
Memory Used: 0.516 KB
SELECT * FROM style WHERE (styleid = 5 AND userselect = 1) OR styleid = 5 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.05891 seconds
Time After: 0.06013 seconds
Time Taken: 0.00122 seconds
Memory Before: 6,838.180 KB
Memory After: 6,838.773 KB
Memory Used: 0.594 KB
SELECT data, expires, locktime, serialized FROM cache WHERE cacheid = 'cms_priv_user_0'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 |
Time Before: 0.07206 seconds
Time After: 0.07233 seconds
Time Taken: 0.00027 seconds
Memory Before: 8,091.305 KB
Memory After: 8,091.844 KB
Memory Used: 0.539 KB
UPDATE cache SET locktime = 1764395014 WHERE cacheid = 'cms_priv_user_0'
Time Before: 0.07246 seconds
Time After: 0.07274 seconds
Time Taken: 0.00028 seconds
Memory Before: 8,096.797 KB
Memory After: 8,097.125 KB
Memory Used: 0.328 KB
SELECT vbcmspermissions FROM administrator WHERE userid = 0
| 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.07317 seconds
Time After: 0.07343 seconds
Time Taken: 0.00026 seconds
Memory Before: 8,093.188 KB
Memory After: 8,093.727 KB
Memory Used: 0.539 KB
SELECT nodeid, MAX(permissions & 1) AS canview, MAX(permissions & 2) AS cancreate , MAX(permissions & 4) AS canedit, MAX(permissions & 8) AS canpublish, MAX(permissions & 16) AS canusehtml, MAX(permissions & 32) AS candownload FROM cms_permissions p WHERE usergroupid IN (1) GROUP BY nodeid;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | p | ref | usergroupid | usergroupid | 4 | const | 1 | Using where |
Time Before: 0.07391 seconds
Time After: 0.07422 seconds
Time Taken: 0.00031 seconds
Memory Before: 8,094.008 KB
Memory After: 8,094.367 KB
Memory Used: 0.359 KB
REPLACE INTO cache
SET cacheid = 'cms_priv_user_0',
expires = 1764395314,
created = 1764395014,
locktime = 0,
data = "a:10:{s:7:\"canview\";a:1:{i:0;s:1:\"1\";}s:9:\"cancreate\";a:1:{i:0;i:-1;}s:7:\"canedit\";a:1:{i:0;i:-1;}s:10:\"canpublish\";a:1:{i:0;i:-1;}s:10:\"canusehtml\";a:1:{i:0;i:-1;}s:5:\"admin\";i:0;s:11:\"candownload\";a:1:{i:0;s:1:\"1\";}s:7:\"alledit\";a:1:{i:0;i:-1;}s:8:\"viewonly\";a:1:{i:0;s:1:\"1\";}s:7:\"allview\";a:1:{i:0;s:1:\"1\";}}",
serialized = '1'Time Before: 0.07445 seconds
Time After: 0.07475 seconds
Time Taken: 0.00031 seconds
Memory Before: 8,107.188 KB
Memory After: 8,107.102 KB
Memory Used: -0.086 KB
SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight , bu.bloguserid, bu.entries, bu.options AS blog_options, bu.subscribeown AS blog_subscribeown, bu.memberids, bu.memberblogids, bu.subscribeothers AS blog_subscribeothers, bu.title AS blog_title, bu.description AS blog_description, bu.allowsmilie AS blog_allowsmilie, bu.draft AS blog_draft, bu.pending AS blog_pending, bu.options_member, bu.options_guest, bu.options_buddy, bu.options_ignore, bu.uncatentries, bu.moderation AS blog_moderation, bu.deleted AS blog_deleted, bu.akismet_key AS blog_akismet_key, isblogmoderator, bu.comments_moderation AS blog_comments_moderation, bu.lastblog, bu.lastblogid, bu.lastblogtitle, bu.categorycache, bu.tagcloud, bu.sidebar, bu.custompages, bu.customblocks, blockparsed.blocktext, 5 AS blogstyleid, blog_usercsscache.csscolors AS blog_csscolors, blog_usercsscache.cachedcss AS blog_cachedcss, IF(blog_usercsscache.cachedcss IS NULL, 0, 1) AS blog_hascachedcss, blog_usercsscache.buildpermissions AS blog_cssbuildpermissions, IF(blog_subscribeuser.blogsubscribeuserid, 1, 0) AS blogsubscribed FROM user AS user LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN blog_user AS bu ON (bu.bloguserid = user.userid) LEFT JOIN blog_custom_block_parsed AS blockparsed ON (blockparsed.userid = user.userid AND blockparsed.styleid = 5 AND blockparsed.languageid = 3) LEFT JOIN blog_subscribeuser AS blog_subscribeuser ON (user.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 76499) LEFT JOIN blog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid) WHERE user.userid = 76499 LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | avatar | system | PRIMARY | 0 | const row not found | |||
| 1 | SIMPLE | customavatar | system | PRIMARY | 0 | const row not found | |||
| 1 | SIMPLE | customprofilepic | system | PRIMARY | 0 | const row not found | |||
| 1 | SIMPLE | bu | system | PRIMARY | 0 | const row not found | |||
| 1 | SIMPLE | blockparsed | system | PRIMARY | 0 | const row not found | |||
| 1 | SIMPLE | blog_subscribeuser | system | bloguserid,userid | 0 | const row not found | |||
| 1 | SIMPLE | blog_usercsscache | system | PRIMARY | 0 | const row not found | |||
| 1 | SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | userfield | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | usertextfield | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.08510 seconds
Time After: 0.08638 seconds
Time Taken: 0.00128 seconds
Memory Before: 8,885.094 KB
Memory After: 8,884.492 KB
Memory Used: -0.602 KB
SELECT bm.userid, bm.permissions, bm.type, user.username FROM blog_moderator AS bm INNER JOIN user AS user USING (userid)
| 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.08772 seconds
Time After: 0.08798 seconds
Time Taken: 0.00026 seconds
Memory Before: 8,952.641 KB
Memory After: 8,953.102 KB
Memory Used: 0.461 KB
SELECT text, languageid, special FROM phrase AS phrase LEFT JOIN phrasetype USING (fieldname) WHERE phrase.fieldname = 'error' AND varname = 'blog_noblog' AND languageid IN (-1, 0, 3)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 276 | 3 | Using where | |
| 1 | SIMPLE | phrasetype | const | PRIMARY | PRIMARY | 22 | const | 1 |
Time Before: 0.09193 seconds
Time After: 0.09254 seconds
Time Taken: 0.00061 seconds
Memory Before: 9,102.766 KB
Memory After: 9,103.195 KB
Memory Used: 0.430 KB
SELECT title, template FROM template WHERE templateid IN (61318,61353,61421,61370,61316,57221,61314,61832,55009,61383,61404,61356,61357,61358,61365,61398,61399,61405,61401,61402,61403,61400,61406,61407,61408,61410,61411,61412,61413,61409,61418,61415,57179,62054,62056,61373,61364,61372,55071,57273,57295,62316,0,0,6082,38961,42855,57213,38966,57292,5992,38968,38969,57230,62031,62305,45486,61981,53288,61979,61980,62335,0,0,62315,62276,62001,62002,62004,62005,62228,62347,62329,62279,62280,61828,61827,61831,47496,61820,61816,61822,61823,61818,61819,61821,61760,61762,61764,61766,55011,61994,61989,61992,61993,62073,62074,61995,61990,61987,61988,62286,61391,0,0,0,0,61659)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 101 | Using where |
Time Before: 0.09613 seconds
Time After: 0.09945 seconds
Time Taken: 0.00331 seconds
Memory Before: 9,398.992 KB
Memory After: 9,401.273 KB
Memory Used: 2.281 KB
REPLACE INTO cacheevent
(cacheid, event)
VALUES ('cms_priv_user_0', 'cms_permissions_change'),
('cms_priv_user_0', 'permissions_0')Time Before: 0.11248 seconds
Time After: 0.11275 seconds
Time Taken: 0.00027 seconds
Memory Before: 9,983.289 KB
Memory After: 9,983.547 KB
Memory Used: 0.258 KB
UPDATE session SET lastactivity = 1764395014, location = 'http://racingweb.org/blog/blog.php?u=76499', badlocation = 3 WHERE sessionhash = '39ddb724842a914d0958248a20ff3416'
Time Before: 0.11295 seconds
Time After: 0.11323 seconds
Time Taken: 0.00028 seconds
Memory Before: 9,988.195 KB
Memory After: 9,988.406 KB
Memory Used: 0.211 KB