Time Before: 0.07502 seconds
Time After: 0.18967 seconds
Time Taken: 0.11465 seconds
Memory Before: 4,241.117 KB
Memory After: 6,600.078 KB
Memory Used: 2,358.961 KB
Time Before: 0.19030 seconds
Time After: 0.19291 seconds
Time Taken: 0.00261 seconds
Memory Before: 6,601.523 KB
Memory After: 6,604.078 KB
Memory Used: 2.555 KB
SET @@sql_mode = ''
Time Before: 0.19396 seconds
Time After: 0.19440 seconds
Time Taken: 0.00045 seconds
Memory Before: 6,602.219 KB
Memory After: 6,603.398 KB
Memory Used: 1.180 KB
SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','sg_category_cloud','sg_newest_groups','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 18 | Using index condition |
Time Before: 0.19746 seconds
Time After: 0.20054 seconds
Time Taken: 0.00308 seconds
Memory Before: 6,605.914 KB
Memory After: 6,606.711 KB
Memory Used: 0.797 KB
Time Before: 0.19475 seconds
Time After: 0.21687 seconds
Time Taken: 0.02212 seconds
Memory Before: 6,601.344 KB
Memory After: 7,225.438 KB
Memory Used: 624.094 KB
SELECT * FROM session WHERE userid = 0 AND host = '3.235.188.113' AND idhash = '200bab90a670a25b51afdf335110ce19' LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ref | guest_lookup,user_activity | guest_lookup | 51 | const,const,const | 2 | Using where |
Time Before: 0.24780 seconds
Time After: 0.24875 seconds
Time Taken: 0.00095 seconds
Memory Before: 8,024.031 KB
Memory After: 8,024.992 KB
Memory Used: 0.961 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_socialgroups AS phrasegroup_socialgroups, phrasegroup_search AS phrasegroup_search, phrasegroup_user AS phrasegroup_user, phrasegroup_posting AS phrasegroup_posting, phrasegroup_album AS phrasegroup_album, 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 = 2
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | language | system | PRIMARY | 1 |
Time Before: 0.25225 seconds
Time After: 0.25664 seconds
Time Taken: 0.00439 seconds
Memory Before: 8,035.313 KB
Memory After: 8,035.523 KB
Memory Used: 0.211 KB
Time Before: 0.24486 seconds
Time After: 0.25825 seconds
Time Taken: 0.01340 seconds
Memory Before: 8,016.313 KB
Memory After: 8,172.109 KB
Memory Used: 155.797 KB
SELECT *
FROM datastore
WHERE title IN ('routes')| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | datastore | const | PRIMARY | PRIMARY | 52 | const | 1 |
Time Before: 0.26239 seconds
Time After: 0.26320 seconds
Time Taken: 0.00080 seconds
Memory Before: 8,186.555 KB
Memory After: 8,187.594 KB
Memory Used: 1.039 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.34943 seconds
Time After: 0.35451 seconds
Time Taken: 0.00509 seconds
Memory Before: 8,961.711 KB
Memory After: 8,962.688 KB
Memory Used: 0.977 KB
SELECT data, expires, locktime, serialized FROM cache WHERE cacheid = 'vb_types.types'
| 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.57716 seconds
Time After: 0.57817 seconds
Time Taken: 0.00101 seconds
Memory Before: 12,623.797 KB
Memory After: 12,624.805 KB
Memory Used: 1.008 KB
SELECT title, template FROM template WHERE templateid IN (4109,4085,4107,4108,4122,4276,2256,4227,4297,1609,1608,1610,1600,1599,1606,1607,1605,1604,1613,1614,1615,3983,4279,3929,3933,3930,3931,3932,4295,0,0,4258,4260,3953,3954,3956,3957,4180,4222,4221,4271,4223,3780,3779,3783)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 44 | Using index condition |
Time Before: 0.59416 seconds
Time After: 0.59729 seconds
Time Taken: 0.00313 seconds
Memory Before: 12,873.930 KB
Memory After: 12,874.758 KB
Memory Used: 0.828 KB
SELECT socialgroup.*, socialgroup.dateline AS createdate, sgc.title AS categoryname, sgc.socialgroupcategoryid AS categoryid, socialgroup.groupid, socialgroup.name, socialgroup.description, socialgroup.dateline, sgicon.dateline AS icondateline, socialgroupmember.type AS membertype, socialgroupmember.dateline AS joindate, sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height FROM socialgroup AS socialgroup LEFT JOIN socialgroupmember AS socialgroupmember ON (socialgroup.groupid = socialgroupmember.groupid AND socialgroupmember.userid = 0) LEFT JOIN socialgroupicon AS sgicon ON (sgicon.groupid = socialgroup.groupid) INNER JOIN socialgroupcategory AS sgc ON (sgc.socialgroupcategoryid = socialgroup.socialgroupcategoryid) ORDER BY socialgroup.dateline DESC LIMIT 0, 15
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | sgc | system | PRIMARY | 1 | Using filesort | |||
| 1 | SIMPLE | socialgroup | ref | socialgroupcategoryid | socialgroupcategoryid | 4 | const | 1 | Using where |
| 1 | SIMPLE | socialgroupmember | eq_ref | PRIMARY,groupid,userid | PRIMARY | 8 | db0529771.socialgroup.groupid,const | 1 | |
| 1 | SIMPLE | sgicon | eq_ref | PRIMARY | PRIMARY | 4 | db0529771.socialgroup.groupid | 1 |
Time Before: 0.65552 seconds
Time After: 0.65692 seconds
Time Taken: 0.00140 seconds
Memory Before: 13,050.500 KB
Memory After: 13,050.742 KB
Memory Used: 0.242 KB
REPLACE INTO datastore
(title, data, unserialize)
VALUES
('sg_newest_groups', 'a:2:{i:0;a:31:{s:7:\"groupid\";s:1:\"2\";s:4:\"name\";s:17:\"Группа активистов\";s:11:\"description\";s:99:\"Группа тех, кому не безразлична судьба миров, и кто готов принимать активное участие в их развитии!\";s:13:\"creatoruserid\";s:3:\"259\";s:8:\"dateline\";s:10:\"1317825257\";s:7:\"members\";s:1:\"3\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1317825257\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1349795360\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"1\";s:10:\"createdate\";s:10:\"1317825257\";s:12:\"categoryname\";s:13:\"Uncategorized\";s:10:\"categoryid\";s:1:\"1\";s:12:\"icondateline\";s:10:\"1317829183\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"80\";}i:1;a:31:{s:7:\"groupid\";s:1:\"1\";s:4:\"name\";s:10:\"Клан котов\";s:11:\"description\";s:193:\"Сошлись как-то несколько котов и кошек вместе и решили прогуляться. Пошли в музей на экскурсию, многое повидали, о многом поговорили. И тут кто-то обмолвился: "прям целый клан котов".\";s:13:\"creatoruserid\";s:3:\"173\";s:8:\"dateline\";s:10:\"1270315171\";s:7:\"members\";s:1:\"1\";s:12:\"picturecount\";s:1:\"2\";s:8:\"lastpost\";s:10:\"1270315171\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:9:\"moderated\";s:16:\"moderatedmembers\";s:1:\"3\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1320016139\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"1\";s:10:\"createdate\";s:10:\"1270315171\";s:12:\"categoryname\";s:13:\"Uncategorized\";s:10:\"categoryid\";s:1:\"1\";s:12:\"icondateline\";s:10:\"1270315261\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"80\";}}', 1)Time Before: 0.65849 seconds
Time After: 0.66172 seconds
Time Taken: 0.00323 seconds
Memory Before: 13,070.797 KB
Memory After: 13,069.406 KB
Memory Used: -1.391 KB
SELECT socialgroup.*, socialgroup.dateline AS createdate, socialgroupmember.type AS membertype, socialgroupmember.dateline AS joindate, groupread.readtime ,sgicon.dateline AS icondateline, sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height ,sgc.title AS categoryname, sgc.socialgroupcategoryid AS categoryid FROM socialgroup AS socialgroup LEFT JOIN socialgroupmember AS socialgroupmember ON (socialgroup.groupid = socialgroupmember.groupid AND socialgroupmember.userid = 0) LEFT JOIN groupread AS groupread ON (groupread.groupid = socialgroup.groupid AND groupread.userid = 0) LEFT JOIN socialgroupicon AS sgicon ON sgicon.groupid = socialgroup.groupid INNER JOIN socialgroupcategory AS sgc ON (sgc.socialgroupcategoryid = socialgroup.socialgroupcategoryid) ORDER BY socialgroup.lastupdate DESC LIMIT 0, 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | groupread | system | PRIMARY | 0 | const row not found | |||
| 1 | SIMPLE | sgc | system | PRIMARY | 1 | Using filesort | |||
| 1 | SIMPLE | socialgroup | ref | socialgroupcategoryid | socialgroupcategoryid | 4 | const | 1 | Using where |
| 1 | SIMPLE | socialgroupmember | eq_ref | PRIMARY,groupid,userid | PRIMARY | 8 | db0529771.socialgroup.groupid,const | 1 | |
| 1 | SIMPLE | sgicon | eq_ref | PRIMARY | PRIMARY | 4 | db0529771.socialgroup.groupid | 1 |
Time Before: 0.68822 seconds
Time After: 0.68919 seconds
Time Taken: 0.00096 seconds
Memory Before: 13,072.273 KB
Memory After: 13,072.484 KB
Memory Used: 0.211 KB
SELECT COUNT(*) AS total FROM socialgroup AS socialgroup LEFT JOIN socialgroupicon AS sgicon ON (sgicon.groupid = socialgroup.groupid)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | socialgroup | index | PRIMARY | 4 | 2 | Using index | ||
| 1 | SIMPLE | sgicon | eq_ref | PRIMARY | PRIMARY | 4 | db0529771.socialgroup.groupid | 1 | Using index |
Time Before: 0.69256 seconds
Time After: 0.69313 seconds
Time Taken: 0.00057 seconds
Memory Before: 13,082.805 KB
Memory After: 13,083.766 KB
Memory Used: 0.961 KB
SELECT socialgroup.*, socialgroup.dateline AS createdate ,sgicon.dateline AS icondateline, sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height ,sgc.title AS categoryname, sgc.socialgroupcategoryid AS categoryid FROM socialgroup AS socialgroup LEFT JOIN socialgroupicon AS sgicon ON sgicon.groupid = socialgroup.groupid INNER JOIN socialgroupcategory AS sgc ON (sgc.socialgroupcategoryid = socialgroup.socialgroupcategoryid) LIMIT 1, 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | sgc | system | PRIMARY | 1 | ||||
| 1 | SIMPLE | socialgroup | ref | socialgroupcategoryid | socialgroupcategoryid | 4 | const | 1 | |
| 1 | SIMPLE | sgicon | eq_ref | PRIMARY | PRIMARY | 4 | db0529771.socialgroup.groupid | 1 |
Time Before: 0.69707 seconds
Time After: 0.69789 seconds
Time Taken: 0.00081 seconds
Memory Before: 13,085.180 KB
Memory After: 13,085.797 KB
Memory Used: 0.617 KB
SELECT user.*, socialgroupmember.groupid ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight FROM socialgroupmember AS socialgroupmember LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) WHERE socialgroupmember.groupid = 2 AND socialgroupmember.type = 'member' ORDER BY socialgroupmember.dateline DESC LIMIT 10
| 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 | socialgroupmember | ref | PRIMARY,groupid | groupid | 5 | const,const | 3 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db0529771.socialgroupmember.userid | 1 | |
| 1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | db0529771.user.userid | 1 |
Time Before: 0.70543 seconds
Time After: 0.70649 seconds
Time Taken: 0.00106 seconds
Memory Before: 13,091.266 KB
Memory After: 13,091.766 KB
Memory Used: 0.500 KB
SELECT user.*, socialgroupmember.groupid ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight FROM socialgroupmember AS socialgroupmember LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) WHERE socialgroupmember.groupid = 1 AND socialgroupmember.type = 'member' ORDER BY socialgroupmember.dateline DESC LIMIT 10
| 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 | socialgroupmember | ref | PRIMARY,groupid | groupid | 5 | const,const | 1 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db0529771.socialgroupmember.userid | 1 | |
| 1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | db0529771.user.userid | 1 |
Time Before: 0.71226 seconds
Time After: 0.71336 seconds
Time Taken: 0.00110 seconds
Memory Before: 13,138.281 KB
Memory After: 13,138.781 KB
Memory Used: 0.500 KB
SELECT * FROM navigation WHERE state & 4 = 0 ORDER BY navtype, displayorder
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | navigation | ALL | 37 | Using where; Using filesort |
Time Before: 0.75941 seconds
Time After: 0.76100 seconds
Time Taken: 0.00159 seconds
Memory Before: 13,164.977 KB
Memory After: 13,166.023 KB
Memory Used: 1.047 KB
UPDATE session SET lastactivity = 1696272269, location = '/group.php?explain=1', badlocation = 0 WHERE sessionhash = '02b7c7f30ed869fa2ade5a6fad1b4268'
Time Before: 0.81961 seconds
Time After: 0.82061 seconds
Time Taken: 0.00101 seconds
Memory Before: 13,455.766 KB
Memory After: 13,456.586 KB
Memory Used: 0.820 KB