Time Before: 0.00397 seconds
Time After: 0.00984 seconds
Time Taken: 0.00587 seconds
Memory Before: 3,011.578 KB
Memory After: 5,281.922 KB
Memory Used: 2,270.344 KB
Time Before: 0.00991 seconds
Time After: 0.01049 seconds
Time Taken: 0.00059 seconds
Memory Before: 5,281.820 KB
Memory After: 5,285.422 KB
Memory Used: 3.602 KB
SET @@sql_mode = ''
Time Before: 0.01063 seconds
Time After: 0.01068 seconds
Time Taken: 0.00006 seconds
Memory Before: 5,285.461 KB
Memory After: 5,285.930 KB
Memory Used: 0.469 KB
SELECT * FROM vb_datastore WHERE title IN ('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 | vb_datastore | range | PRIMARY | PRIMARY | 150 | 14 | Using index condition |
Time Before: 0.01112 seconds
Time After: 0.01163 seconds
Time Taken: 0.00051 seconds
Memory Before: 5,288.563 KB
Memory After: 5,290.789 KB
Memory Used: 2.227 KB
Time Before: 0.01070 seconds
Time After: 0.01235 seconds
Time Taken: 0.00165 seconds
Memory Before: 5,285.063 KB
Memory After: 5,932.023 KB
Memory Used: 646.961 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.01402 seconds
Time After: 0.01411 seconds
Time Taken: 0.00010 seconds
Memory Before: 6,711.156 KB
Memory After: 6,713.156 KB
Memory Used: 2.000 KB
SELECT * FROM vb_session WHERE userid = 0 AND host = '98.84.18.52' AND idhash = '94d3b41c222e545ab2504feaa087ab29' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_session | ref | guest_lookup,user_activity | guest_lookup | 145 | const,const,const | 2 | Using where |
Time Before: 0.01451 seconds
Time After: 0.01464 seconds
Time Taken: 0.00013 seconds
Memory Before: 6,723.500 KB
Memory After: 6,725.703 KB
Memory Used: 2.203 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.01576 seconds
Time After: 0.01613 seconds
Time Taken: 0.00037 seconds
Memory Before: 6,734.641 KB
Memory After: 6,736.297 KB
Memory Used: 1.656 KB
Time Before: 0.01420 seconds
Time After: 0.01621 seconds
Time Taken: 0.00200 seconds
Memory Before: 6,717.914 KB
Memory After: 6,793.648 KB
Memory Used: 75.734 KB
SELECT * FROM vb_datastore WHERE title IN ('routes','profilefield')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_datastore | range | PRIMARY | PRIMARY | 150 | 2 | Using index condition |
Time Before: 0.01658 seconds
Time After: 0.01670 seconds
Time Taken: 0.00012 seconds
Memory Before: 6,807.875 KB
Memory After: 6,809.898 KB
Memory Used: 2.023 KB
SELECT MAX(permissions & 1) AS perm FROM vb_cms_permissions WHERE nodeid = 1 AND usergroupid IN (1)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_cms_permissions | const | usergroupid,nodeid | usergroupid | 8 | const,const | 1 |
Time Before: 0.01830 seconds
Time After: 0.01840 seconds
Time Taken: 0.00010 seconds
Memory Before: 6,990.547 KB
Memory After: 6,992.523 KB
Memory Used: 1.977 KB
SELECT * FROM vb_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 | vb_style | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.01998 seconds
Time After: 0.02027 seconds
Time Taken: 0.00029 seconds
Memory Before: 7,217.867 KB
Memory After: 7,220.031 KB
Memory Used: 2.164 KB
SELECT profilefieldid FROM vb_profilefield WHERE profilefieldid = 2
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_profilefield | const | PRIMARY | PRIMARY | 2 | const | 1 | Using index |
Time Before: 0.02567 seconds
Time After: 0.02577 seconds
Time Taken: 0.00010 seconds
Memory Before: 8,301.984 KB
Memory After: 8,304.000 KB
Memory Used: 2.016 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'showgroups.groupcache'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_cache | const | PRIMARY | PRIMARY | 66 | const | 1 |
Time Before: 0.02689 seconds
Time After: 0.02706 seconds
Time Taken: 0.00017 seconds
Memory Before: 8,595.477 KB
Memory After: 8,597.492 KB
Memory Used: 2.016 KB
SELECT user.*, usergroup.title, user.options, usertextfield.buddylist, userfield.field2, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom FROM vb_user AS user LEFT JOIN vb_usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids)) LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid=user.userid) LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid) WHERE (usergroup.genericoptions & 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 | user | ALL | usergroupid | 3357 | ||||
1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.user.userid | 1 | |
1 | SIMPLE | usertextfield | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.user.userid | 1 | |
1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.user.userid | 1 | |
1 | SIMPLE | usergroup | ALL | PRIMARY | 9 | Using where; Using join buffer (Block Nested Loop) |
Time Before: 0.02981 seconds
Time After: 0.07334 seconds
Time Taken: 0.04353 seconds
Memory Before: 8,599.008 KB
Memory After: 8,605.281 KB
Memory Used: 6.273 KB
REPLACE INTO vb_cache SET cacheid = 'showgroups.groupcache', expires = 1728713002, created = 1728702202, locktime = 0, data = "a:2:{s:31:\"Супер-модераторы\";a:2:{s:5:\"XSTRO\";a:93:{s:6:\"userid\";s:1:\"2\";s:11:\"usergroupid\";s:1:\"5\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"5\";s:8:\"username\";s:5:\"Xstro\";s:8:\"password\";s:32:\"669b9b0d3bbd08e61bd8424793521eef\";s:12:\"passworddate\";s:10:\"2012-02-25\";s:5:\"email\";s:0:\"\";s:7:\"styleid\";s:1:\"1\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:5:\"skype\";s:0:\"\";s:10:\"showvbcode\";s:1:\"1\";s:12:\"showbirthday\";s:1:\"0\";s:9:\"usertitle\";s:10:\"Админ\";s:11:\"customtitle\";s:1:\"1\";s:8:\"joindate\";s:10:\"1261688400\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1387990422\";s:12:\"lastactivity\";s:10:\"1387990422\";s:8:\"lastpost\";s:10:\"1313522053\";s:10:\"lastpostid\";s:5:\"59611\";s:5:\"posts\";s:1:\"8\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:1:\"0\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:18:\"profilepicrevision\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45113175\";s:8:\"birthday\";s:0:\"\";s:15:\"birthday_search\";s:10:\"0000-00-00\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"1\";s:9:\"ipaddress\";s:12:\"91.76.162.88\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"2\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:13:\"autosubscribe\";s:2:\"-1\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:30:\"vOcq1*Kl Hިi7v\\ig]sD9lA]olv.Tp/ʪG#?\0vFogg:ꚄQơq,+YwZmΣivq l(rSx|u9jдLќu \0V|Xc3R^hkqn>ϱCe ݞ)u/AykL\r-my#\0+ 2:b5@vB([̂$o%%RF~lo囜@֬cQMEZv>hά 欪` a=Wj͌/?\ZS>rji]銤g\0eIO@ae?_kf{K}w\"OxrvLdZoMbkW6dt_\rFڤ;Y4뤔-\nN0KT1hӬ4k7v<S8ֽᾎ\\wnH-+;A 1$d^YK-Ɣ$GhWZx6=KA&1\\1=rǡ\0r\ZQ鷍m.aS ҪjOv̖qE!CeJL#Mb\'d(ib#]y>\Z_ݬ9\0ɞq#P_Jr\r/MPTWiznݴ8Pyo\\׳xxdڒC+v45Ҳ-\'X*sH@E:x7Dob sp\'dlL\0\r^R(=(YG=qP\\ivQ[h4Q@Llh O]$AFOVϷ]>._1\rwe\n͎P?O$tyΣ\reuvum[>ss D%\ZNGx/ᵷc-6F([<@k;6f\\ɩ&.Sr*`OLpf5qi$vg?㤾<\Zfh][39GNy{N¶ݤmOUޛأhO͚olbL~`PYCqj\ZE>](cM2)}ᩑvFX{9kuo\nk C]sܰG\"!~|fi[7o)BUC4kݮ}H1P#V1q\0lm\";s:9:\"hascustom\";s:1:\"1\";}}s:28:\"Администраторы\";a:4:{s:4:\"GANS\";a:93:{s:6:\"userid\";s:1:\"5\";s:11:\"usergroupid\";s:1:\"6\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"6\";s:8:\"username\";s:4:\"Gans\";s:8:\"password\";s:32:\"d78d2c0246b92c89f574d26e1040d4af\";s:12:\"passworddate\";s:10:\"2024-07-16\";s:5:\"email\";s:14:\"deal_e@mail.ru\";s:7:\"styleid\";s:1:\"1\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:5:\"skype\";s:0:\"\";s:10:\"showvbcode\";s:1:\"2\";s:12:\"showbirthday\";s:1:\"3\";s:9:\"usertitle\";s:14:\"Местный\";s:11:\"customtitle\";s:1:\"1\";s:8:\"joindate\";s:10:\"1261691700\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1728466354\";s:12:\"lastactivity\";s:10:\"1728652090\";s:8:\"lastpost\";s:10:\"1727942396\";s:10:\"lastpostid\";s:6:\"402206\";s:5:\"posts\";s:5:\"18576\";s:10:\"reputation\";s:2:\"18\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:1:\"3\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:18:\"profilepicrevision\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"options\";s:8:\"44621271\";s:8:\"birthday\";s:10:\"06-30-1963\";s:15:\"birthday_search\";s:10:\"1963-06-30\";s:8:\"maxposts\";s:2:\"40\";s:11:\"startofweek\";s:1:\"2\";s:9:\"ipaddress\";s:11:\"78.29.85.40\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"4\";s:10:\"emailstamp\";s:10:\"1404895402\";s:12:\"threadedmode\";s:1:\"0\";s:13:\"autosubscribe\";s:2:\"-1\";s:7:\"pmtotal\";s:3:\"500\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:30:\"EVA[)(2-_#ZVB:{9\\4b~st3),oP0N<\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:12:\"adminoptions\";s:1:\"1\";s:13:\"profilevisits\";s:4:\"7401\";s:11:\"friendcount\";s:1:\"3\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:32:\"4930fe74a4e3f38d90a7c1a638789f05\";s:23:\"post_thanks_user_amount\";s:3:\"574\";s:25:\"post_thanks_thanked_posts\";s:4:\"6165\";s:25:\"post_thanks_thanked_times\";s:5:\"15620\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:17:\"bloggroupreqcount\";s:1:\"0\";s:11:\"showblogcss\";s:1:\"1\";s:13:\"arcadeoptions\";s:1:\"1\";s:14:\"challengecache\";s:1:\"0\";s:8:\"favcache\";s:0:\"\";s:20:\"tournamentid_playing\";s:1:\"0\";s:11:\"newrepcount\";s:1:\"0\";s:5:\"title\";s:28:\"Администраторы\";s:9:\"buddylist\";s:12:\"12 14 30 848\";s:6:\"field2\";s:0:\"\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"1\";s:14:\"avatardateline\";s:10:\"1386765560\";s:7:\"avwidth\";s:2:\"59\";s:8:\"avheight\";s:3:\"160\";s:13:\"avwidth_thumb\";s:2:\"30\";s:14:\"avheight_thumb\";s:2:\"80\";s:14:\"filedata_thumb\";s:1665:\"\0JFIF\0\0\0\0\0\0\0;CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 75\n\0C\0 \n\r\Z\Z $.\' \",#(7),01444\'9=82<.342\0C \r\r2!!22222222222222222222222222222222222222222222222222\0\0P\0\"\0\0\0\0\0\0\0\0\0\0\0\0 \n\0\0\0\0}\0!1AQa\"q2#BR$3br \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0\0\0\0\0\0 \n\0\0\0w\0!1AQaq\"2B #3Rbr\n$4%\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0?\0z\r)<ķG\Z?#N㙃jisso:UB T;ridYɸ\rl`9\"4\rTԭ%ÚQ|1\\M;*Kf%/\\ dYnizŦys*~{xׅ\\E4\\G021<T-|z?6{$xMr\0zk\ZͭݾKf0DNy`ucW_Mrbino$XUs; z;n ?\\u}zP˺ŭRiM7N?1kgC_LUEuL PO\'һ[ɮ#}^d3d 9`),ĸǖ8Os9^Oaq$0$sɃq:1_Ei( $@rnTyt= \0^k{FڇA5(\0u-;\\DUEm~m,:\'\'k/\Z#hD/m\0;GKFۤ\"ی z(I\Z\0p}Gjwz8qax`JG?r4}1.$D)pe-p[3]-iGWMáMdhOid%-,\r9-+ܤTI\";s:9:\"hascustom\";s:1:\"1\";}s:18:\"Александр\";a:93:{s:6:\"userid\";s:1:\"9\";s:11:\"usergroupid\";s:1:\"6\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"6\";s:8:\"username\";s:18:\"Александр\";s:8:\"password\";s:32:\"71a66b606449d0f2272434ae47cd53e2\";s:12:\"passworddate\";s:10:\"2024-07-27\";s:5:\"email\";s:16:\"bm-21m@yandex.ru\";s:7:\"styleid\";s:1:\"1\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:8:\"16515960\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:5:\"skype\";s:16:\"alex-moscow-1969\";s:10:\"showvbcode\";s:1:\"2\";s:12:\"showbirthday\";s:1:\"3\";s:9:\"usertitle\";s:14:\"Местный\";s:11:\"customtitle\";s:1:\"1\";s:8:\"joindate\";s:10:\"1261734120\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1728671761\";s:12:\"lastactivity\";s:10:\"1728675383\";s:8:\"lastpost\";s:10:\"1728329288\";s:10:\"lastpostid\";s:6:\"402290\";s:5:\"posts\";s:5:\"35490\";s:10:\"reputation\";s:2:\"29\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:1:\"3\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:18:\"profilepicrevision\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45636951\";s:8:\"birthday\";s:10:\"05-24-0000\";s:15:\"birthday_search\";s:10:\"0000-05-24\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"2\";s:9:\"ipaddress\";s:12:\"77.108.64.48\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"4\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:13:\"autosubscribe\";s:2:\"-1\";s:7:\"pmtotal\";s:3:\"224\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:30:\"\\y{\"A/_aG.Zyp<~$^}.r59G\\lGT`3f\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:12:\"adminoptions\";s:1:\"0\";s:13:\"profilevisits\";s:4:\"7534\";s:11:\"friendcount\";s:2:\"14\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:32:\"21c1c08f4050895f9f781e8c74d30d6b\";s:23:\"post_thanks_user_amount\";s:4:\"9625\";s:25:\"post_thanks_thanked_posts\";s:4:\"8719\";s:25:\"post_thanks_thanked_times\";s:5:\"21193\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:17:\"bloggroupreqcount\";s:1:\"0\";s:11:\"showblogcss\";s:1:\"1\";s:13:\"arcadeoptions\";s:1:\"1\";s:14:\"challengecache\";s:1:\"0\";s:8:\"favcache\";s:0:\"\";s:20:\"tournamentid_playing\";s:1:\"0\";s:11:\"newrepcount\";s:1:\"0\";s:5:\"title\";s:28:\"Администраторы\";s:9:\"buddylist\";s:62:\"1 7 12 14 20 27 29 30 86 424 848 1087 1701 2857 3308 3799 4491\";s:6:\"field2\";s:12:\"Москва\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"1\";s:14:\"avatardateline\";s:10:\"1374481654\";s:7:\"avwidth\";s:3:\"118\";s:8:\"avheight\";s:3:\"203\";s:13:\"avwidth_thumb\";s:2:\"47\";s:14:\"avheight_thumb\";s:2:\"80\";s:14:\"filedata_thumb\";s:1992:\"\0JFIF\0\0\0\0\0\0\0;CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 75\n\0C\0 \n\r\Z\Z $.\' \",#(7),01444\'9=82<.342\0C \r\r2!!22222222222222222222222222222222222222222222222222\0\0P\0/\"\0\0\0\0\0\0\0\0\0\0\0\0 \n\0\0\0\0}\0!1AQa\"q2#BR$3br \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0\0\0\0\0\0 \n\0\0\0w\0!1AQaq\"2B #3Rbr\n$4%\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0?\0[ⷂV\n)G8XuY[zdJXe!u\"|$1\\w/m3ȠNF?\Z\0T)A֡C#XN Ò\09& ?LWKkI[XqڐH|n?.>SzTCM˻%J|U.A\0+2ḑ7\0x`C\rTe=ȷX#p G=\0jfLe%w \0.D&iY霐I`rZ,hIT.q*Ib^CDTGb6rzL\n\0o2i&*%v0F*=F侌#EynP͉/]z)73O\"FeK\rvZCh8x|Y|^n#IcJpqN\"[4)s%_Y|+B_d :\0 <눹.nd]M6Ummg@״٬/Uʭ=JhpٵL1$w^Z\\}Mm.e*Z=rWm.cl.ңEi\"`I,X0A^q\"B t2wJ21W\'|Hvͪ[츷:!Ĉ PG\Z5\rJkY4l\nfvFyWNB:q~5$m*-K4hP;+/NZ.3g-d_7+v=89gvt8Oe̢kVI\0v\0dNMOIK]\'0QE\";s:9:\"hascustom\";s:1:\"1\";}s:14:\"Комбат56\";a:93:{s:6:\"userid\";s:2:\"15\";s:11:\"usergroupid\";s:1:\"6\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"6\";s:8:\"username\";s:14:\"Комбат56\";s:8:\"password\";s:32:\"158a85fc8ba89942c83ac02ab9b0075b\";s:12:\"passworddate\";s:10:\"2024-06-25\";s:5:\"email\";s:16:\"udaff_vv@mail.ru\";s:7:\"styleid\";s:1:\"1\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:5:\"skype\";s:0:\"\";s:10:\"showvbcode\";s:1:\"2\";s:12:\"showbirthday\";s:1:\"2\";s:9:\"usertitle\";s:16:\"\"Дедушка\"\";s:11:\"customtitle\";s:1:\"1\";s:8:\"joindate\";s:10:\"1261756260\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1728395363\";s:12:\"lastactivity\";s:10:\"1728603913\";s:8:\"lastpost\";s:10:\"1726539763\";s:10:\"lastpostid\";s:6:\"402015\";s:5:\"posts\";s:5:\"19456\";s:10:\"reputation\";s:2:\"14\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:1:\"4\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:18:\"profilepicrevision\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45637079\";s:8:\"birthday\";s:10:\"01-10-1957\";s:15:\"birthday_search\";s:10:\"1957-01-10\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"1\";s:9:\"ipaddress\";s:12:\"95.71.130.49\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"4\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:13:\"autosubscribe\";s:1:\"0\";s:7:\"pmtotal\";s:3:\"355\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:30:\"`F`?g31S=t{t&+`jDFKjhqxMtSNM2q\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:12:\"adminoptions\";s:1:\"1\";s:13:\"profilevisits\";s:4:\"8521\";s:11:\"friendcount\";s:1:\"6\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:32:\"dcaf3d19916b2899f781fa920bfd56c8\";s:23:\"post_thanks_user_amount\";s:4:\"9999\";s:25:\"post_thanks_thanked_posts\";s:4:\"5145\";s:25:\"post_thanks_thanked_times\";s:5:\"14140\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:17:\"bloggroupreqcount\";s:1:\"0\";s:11:\"showblogcss\";s:1:\"1\";s:13:\"arcadeoptions\";s:1:\"1\";s:14:\"challengecache\";s:1:\"0\";s:8:\"favcache\";s:0:\"\";s:20:\"tournamentid_playing\";s:1:\"0\";s:11:\"newrepcount\";s:1:\"0\";s:5:\"title\";s:28:\"Администраторы\";s:9:\"buddylist\";s:27:\"12 30 175 848 885 1077 3064\";s:6:\"field2\";s:59:\"Оренбург и Оренбургская область\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"1\";s:14:\"avatardateline\";s:10:\"1371211042\";s:7:\"avwidth\";s:3:\"100\";s:8:\"avheight\";s:3:\"164\";s:13:\"avwidth_thumb\";s:2:\"49\";s:14:\"avheight_thumb\";s:2:\"80\";s:14:\"filedata_thumb\";s:1983:\"\0JFIF\0\0\0\0\0\0\0;CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 75\n\0C\0 \n\r\Z\Z $.\' \",#(7),01444\'9=82<.342\0C \r\r2!!22222222222222222222222222222222222222222222222222\0\0P\01\"\0\0\0\0\0\0\0\0\0\0\0\0 \n\0\0\0\0}\0!1AQa\"q2#BR$3br \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0\0\0\0\0\0 \n\0\0\0w\0!1AQaq\"2B #3Rbr\n$4%\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0?\0m!B2̀?\Ztvj\Zudwx*ՔedRJ_:~u ]\ZCSP}pDݵ\0KG*]U$׆_5\rFk\\AG.TQr=;bgJU&\\mmYX}g_sP2lc8U]2Zj4@뷌ZWOȗ;ISܜ\0^+67 \nUqcjgF\03I,{K².09rM.[MWFݴH>#+v}mv>(Q;kgijJd# +?i07Ԉ.\\!QǟoҸ*\\iy\0!?:$.Ixmp՜}O+W\'I~:Aͺ)X|0kK%eP\\oy\rz9Ս\no30spe²o\\\0mOKcu5!YbYI}E2c*5Tt=]\nG癟hRtt\n0\0[ͼsR\\i.\n(FWnei$Aur\"1p\\^&c&3IpMm^F\n*zviypKkm8ޱFɐ1ǶNyjU7+NmN7cՔAk\Zg\Z|js7ک{ȶڣwN}[?:_\ZQ{tcd*\'+s9xYj7BWQ NND:wZ^SQ^o-,\0qv+c[hpBhT`\n+c\0(\";s:9:\"hascustom\";s:1:\"1\";}s:14:\"Игорь О.\";a:93:{s:6:\"userid\";s:2:\"19\";s:11:\"usergroupid\";s:1:\"6\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"6\";s:8:\"username\";s:14:\"Игорь О.\";s:8:\"password\";s:32:\"c8e39dcff3d240dc8d36f0367206677f\";s:12:\"passworddate\";s:10:\"2023-01-22\";s:5:\"email\";s:17:\"igor1207@inbox.ru\";s:7:\"styleid\";s:1:\"1\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:5:\"skype\";s:10:\"igor120767\";s:10:\"showvbcode\";s:1:\"2\";s:12:\"showbirthday\";s:1:\"2\";s:9:\"usertitle\";s:14:\"Местный\";s:11:\"customtitle\";s:1:\"1\";s:8:\"joindate\";s:10:\"1261769760\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1683897503\";s:12:\"lastactivity\";s:10:\"1684921559\";s:8:\"lastpost\";s:10:\"1678725337\";s:10:\"lastpostid\";s:6:\"392133\";s:5:\"posts\";s:4:\"2587\";s:10:\"reputation\";s:2:\"11\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:1:\"6\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:18:\"profilepicrevision\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45113143\";s:8:\"birthday\";s:10:\"07-12-1967\";s:15:\"birthday_search\";s:10:\"1967-07-12\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"2\";s:9:\"ipaddress\";s:14:\"79.133.170.230\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"0\";s:10:\"emailstamp\";s:10:\"1323319448\";s:12:\"threadedmode\";s:1:\"0\";s:13:\"autosubscribe\";s:1:\"1\";s:7:\"pmtotal\";s:3:\"282\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:30:\"hGbx]|lLn7X]\\[5*\"`|9QsC5LYU~Y:\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:12:\"adminoptions\";s:1:\"1\";s:13:\"profilevisits\";s:4:\"1734\";s:11:\"friendcount\";s:1:\"4\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:32:\"98ca31a2a883a1bb0143378d27076639\";s:23:\"post_thanks_user_amount\";s:4:\"1166\";s:25:\"post_thanks_thanked_posts\";s:3:\"821\";s:25:\"post_thanks_thanked_times\";s:4:\"1892\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:17:\"bloggroupreqcount\";s:1:\"0\";s:11:\"showblogcss\";s:1:\"1\";s:13:\"arcadeoptions\";s:1:\"1\";s:14:\"challengecache\";s:1:\"0\";s:8:\"favcache\";s:0:\"\";s:20:\"tournamentid_playing\";s:1:\"0\";s:11:\"newrepcount\";s:1:\"0\";s:5:\"title\";s:28:\"Администраторы\";s:9:\"buddylist\";s:14:\"7 8 12 64 2546\";s:6:\"field2\";s:8:\"Омск\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"1\";s:14:\"avatardateline\";s:10:\"1422625912\";s:7:\"avwidth\";s:3:\"148\";s:8:\"avheight\";s:3:\"150\";s:13:\"avwidth_thumb\";s:2:\"60\";s:14:\"avheight_thumb\";s:2:\"61\";s:14:\"filedata_thumb\";s:2066:\"\0JFIF\0\0\0\0\0\0\0;CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 75\n\0C\0 \n\r\Z\Z $.\' \",#(7),01444\'9=82<.342\0C \r\r2!!22222222222222222222222222222222222222222222222222\0\0=\0<\"\0\0\0\0\0\0\0\0\0\0\0\0 \n\0\0\0\0}\0!1AQa\"q2#BR$3br \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0\0\0\0\0\0 \n\0\0\0w\0!1AQaq\"2B #3Rbr\n$4%\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0?\0,1[=n {lvR~r䞸#G\'\'Ly$ͪx^^^1\\ \\)P~`8WN&\\<-^_^!ҬIc5!K=\'^,4, Vr`3\'#|u\rpvQԀBÞ[15XR6U KqYpO<åtU&1m\'JIM5 xwN1n\"KkH$M6xV9/?Os[IM\rEY,`=MO&+d\\D@[bQr1w\\w/V5EV+g<Ϲ;c5xFyvQB8状gY]@l\0\0<}p1u{2+ ۴C)9>`Lmc%k}䏐^r^.v1;$48$.p1 jW.i=,;hrM1ډ2p:cKh`Mq3\"[|d0\\l;Bs|qRGks[1 nDX2\r<;9jDLsEr%kUr8waym\Z}9OC3(rrqEs(-#lѫ }\0+A㷏Ug8_v\0c=y*-V.#P˙c ;pnUA8\"TR> l^r!7dž\0fQiVɎi3JYm`y\0SB6il HV m=5գY--NG1.%\nv\0OLmǠy,d/c.m-FT~\ZYD6b@*9~Pp;֘>K̰}nT7 K\0XM1W%Ќau\0q]-W؏m4Osehg]B6I9 8\0c9vV\'\0g贴.s3\\+\\[^DyHȯnf\\@zU\nkG!p)DĠSگ[um,cJ0Tz9XH;QB\'-Xu-SQ@ KE\";s:9:\"hascustom\";s:1:\"1\";}}}", serialized = '1'
Time Before: 0.07402 seconds
Time After: 0.07475 seconds
Time Taken: 0.00073 seconds
Memory Before: 8,823.664 KB
Memory After: 8,792.703 KB
Memory Used: -30.961 KB
SELECT title, template FROM vb_template WHERE templateid IN (3777,3780,3781,3730,3989,715,4322,4323,0,0,980,974,3381,978,979,977,4312,981,982,4318,3696,3992,903,3646,3643,3644,3645,4008,0,0,3971,3973,3666,3667,3669,3670,3893,3935,3934,3984,3936,3493,3492,3496,3054,2921,2922)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_template | range | PRIMARY | PRIMARY | 4 | 44 | Using index condition |
Time Before: 0.07589 seconds
Time After: 0.07629 seconds
Time Taken: 0.00040 seconds
Memory Before: 8,971.695 KB
Memory After: 8,974.477 KB
Memory Used: 2.781 KB
SELECT user.*, moderator.forumid, usertextfield.buddylist, userfield.field2, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom FROM vb_moderator AS moderator INNER JOIN vb_user AS user USING(userid) INNER JOIN vb_userfield AS userfield ON(userfield.userid = user.userid) INNER JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid=user.userid) LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid) WHERE moderator.forumid <> -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 | moderator | index | userid_forumid | userid_forumid | 6 | 4 | Using where; Using index | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.moderator.userid | 1 | |
1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.moderator.userid | 1 | |
1 | SIMPLE | usertextfield | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.moderator.userid | 1 | |
1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.moderator.userid | 1 |
Time Before: 0.08165 seconds
Time After: 0.08223 seconds
Time Taken: 0.00058 seconds
Memory Before: 9,161.711 KB
Memory After: 9,165.063 KB
Memory Used: 3.352 KB
SELECT * FROM vb_navigation WHERE state & 4 = 0 ORDER BY navtype, displayorder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_navigation | ALL | 36 | Using where; Using filesort |
Time Before: 0.08484 seconds
Time After: 0.08504 seconds
Time Taken: 0.00020 seconds
Memory Before: 9,236.813 KB
Memory After: 9,242.813 KB
Memory Used: 6.000 KB
UPDATE vb_session SET lastactivity = 1728702202, location = '/showgroups.php?explain=1', inforum = 21, incalendar = 0, badlocation = 0 WHERE sessionhash = '087e2ad02a2a93f8929bf37a4edf756d'
Time Before: 0.08701 seconds
Time After: 0.08719 seconds
Time Taken: 0.00018 seconds
Memory Before: 9,527.531 KB
Memory After: 9,527.758 KB
Memory Used: 0.227 KB