SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','ranks','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache')

Time Before: 0.01167 seconds
Time After: 0.01167 seconds
Time Taken: 0.00001 seconds

Memory Before: 2,365.164 KB
Memory After: 2,364.852 KB
Memory Used: -0.313 KB

SELECT varname, value, datatype FROM setting

Time Before: 0.01663 seconds
Time After: 0.01664 seconds
Time Taken: 0.00001 seconds

Memory Before: 3,124.484 KB
Memory After: 3,124.672 KB
Memory Used: 0.188 KB

UPDATE setting
SET value = '/'
WHERE varname = 'cookiepath'

Time Before: 0.01666 seconds
Time After: 0.01666 seconds
Time Taken: 0.00000 seconds

Memory Before: 3,125.867 KB
Memory After: 3,125.883 KB
Memory Used: 0.016 KB

REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('options', 'a:1:{s:10:\"cookiepath\";s:1:\"/\";}', 1)

Time Before: 0.01668 seconds
Time After: 0.01668 seconds
Time Taken: 0.00000 seconds

Memory Before: 3,126.977 KB
Memory After: 3,126.914 KB
Memory Used: -0.063 KB

REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('bitfields', 'a:2:{s:3:\"ugp\";a:13:{s:16:\"forumpermissions\";a:24:{s:7:\"canview\";i:1;s:14:\"canviewthreads\";i:524288;s:13:\"canviewothers\";i:2;s:9:\"cansearch\";i:4;s:8:\"canemail\";i:8;s:10:\"canpostnew\";i:16;s:11:\"canreplyown\";i:32;s:14:\"canreplyothers\";i:64;s:11:\"caneditpost\";i:128;s:13:\"candeletepost\";i:256;s:15:\"candeletethread\";i:512;s:12:\"canopenclose\";i:1024;s:7:\"canmove\";i:2048;s:16:\"cangetattachment\";i:4096;s:17:\"canpostattachment\";i:8192;s:11:\"canpostpoll\";i:16384;s:7:\"canvote\";i:32768;s:13:\"canthreadrate\";i:65536;s:21:\"followforummoderation\";i:131072;s:15:\"canseedelnotice\";i:262144;s:9:\"cantagown\";i:1048576;s:12:\"cantagothers\";i:2097152;s:15:\"candeletetagown\";i:4194304;s:16:\"canseethumbnails\";i:8388608;}s:13:\"pmpermissions\";a:3:{s:10:\"cantrackpm\";i:1;s:17:\"candenypmreceipts\";i:2;s:14:\"canignorequota\";i:4;}s:19:\"calendarpermissions\";a:6:{s:15:\"canviewcalendar\";i:1;s:12:\"canpostevent\";i:2;s:12:\"caneditevent\";i:4;s:14:\"candeleteevent\";i:8;s:18:\"canviewothersevent\";i:16;s:14:\"isnotmoderated\";i:32;}s:14:\"wolpermissions\";a:5:{s:13:\"canwhosonline\";i:1;s:15:\"canwhosonlineip\";i:2;s:17:\"canwhosonlinefull\";i:4;s:16:\"canwhosonlinebad\";i:8;s:21:\"canwhosonlinelocation\";i:16;}s:16:\"adminpermissions\";a:23:{s:11:\"ismoderator\";i:1;s:15:\"cancontrolpanel\";i:2;s:16:\"canadminsettings\";i:4;s:14:\"canadminstyles\";i:8;s:17:\"canadminlanguages\";i:16;s:14:\"canadminforums\";i:32;s:15:\"canadminthreads\";i:64;s:17:\"canadmincalendars\";i:128;s:13:\"canadminusers\";i:256;s:19:\"canadminpermissions\";i:512;s:11:\"canadminfaq\";i:1024;s:14:\"canadminimages\";i:2048;s:15:\"canadminbbcodes\";i:4096;s:12:\"canadmincron\";i:8192;s:16:\"canadminmaintain\";i:16384;s:15:\"canadminplugins\";i:65536;s:15:\"canadminnotices\";i:131072;s:14:\"canadminmodlog\";i:262144;s:10:\"cansitemap\";i:524288;s:11:\"canadminads\";i:1048576;s:12:\"canadmintags\";i:2097152;s:14:\"canadminblocks\";i:4194304;s:20:\"cansetdefaultprofile\";i:8388608;}s:18:\"genericpermissions\";a:31:{s:14:\"canviewmembers\";i:1;s:16:\"canmodifyprofile\";i:2;s:12:\"caninvisible\";i:4;s:22:\"canviewothersusernotes\";i:8;s:21:\"canmanageownusernotes\";i:16;s:12:\"canseehidden\";i:32;s:14:\"canbeusernoted\";i:64;s:13:\"canprofilepic\";i:128;s:20:\"cananimateprofilepic\";i:134217728;s:12:\"canuseavatar\";i:512;s:16:\"cananimateavatar\";i:67108864;s:15:\"canusesignature\";i:1024;s:17:\"canusecustomtitle\";i:2048;s:16:\"canseeprofilepic\";i:4096;s:19:\"canviewownusernotes\";i:8192;s:24:\"canmanageothersusernotes\";i:16384;s:19:\"canpostownusernotes\";i:32768;s:22:\"canpostothersusernotes\";i:65536;s:19:\"caneditownusernotes\";i:131072;s:24:\"canseehiddencustomfields\";i:262144;s:12:\"canseeownrep\";i:256;s:9:\"canuserep\";i:524288;s:10:\"canhiderep\";i:1048576;s:14:\"cannegativerep\";i:2097152;s:17:\"cangiveinfraction\";i:4194304;s:16:\"canseeinfraction\";i:8388608;s:20:\"cangivearbinfraction\";i:536870912;s:20:\"canreverseinfraction\";i:16777216;s:16:\"cansearchft_bool\";i:33554432;s:14:\"canemailmember\";i:268435456;s:12:\"cancreatetag\";i:1073741824;}s:19:\"genericpermissions2\";a:1:{s:13:\"canusefriends\";i:1;}s:16:\"albumpermissions\";a:8:{s:8:\"canalbum\";i:1;s:12:\"canviewalbum\";i:2;s:28:\"picturefollowforummoderation\";i:128;s:13:\"canpiccomment\";i:4;s:20:\"caneditownpiccomment\";i:8;s:22:\"candeleteownpiccomment\";i:16;s:19:\"canmanagepiccomment\";i:32;s:28:\"commentfollowforummoderation\";i:64;}s:18:\"usercsspermissions\";a:7:{s:17:\"caneditfontfamily\";i:1;s:15:\"caneditfontsize\";i:2;s:13:\"caneditcolors\";i:4;s:14:\"caneditbgimage\";i:8;s:14:\"caneditborders\";i:16;s:14:\"caneditprivacy\";i:32;s:12:\"cancustomize\";i:128;}s:14:\"genericoptions\";a:7:{s:9:\"showgroup\";i:1;s:12:\"showbirthday\";i:2;s:14:\"showmemberlist\";i:4;s:12:\"showeditedby\";i:8;s:17:\"allowmembergroups\";i:16;s:16:\"isnotbannedgroup\";i:32;s:14:\"requirehvcheck\";i:64;}s:20:\"signaturepermissions\";a:17:{s:9:\"canbbcode\";i:131072;s:14:\"canbbcodebasic\";i:1;s:14:\"canbbcodecolor\";i:2;s:13:\"canbbcodesize\";i:4;s:13:\"canbbcodefont\";i:8;s:14:\"canbbcodealign\";i:16;s:13:\"canbbcodelist\";i:32;s:13:\"canbbcodelink\";i:64;s:13:\"canbbcodecode\";i:128;s:12:\"canbbcodephp\";i:256;s:13:\"canbbcodehtml\";i:512;s:14:\"canbbcodequote\";i:1024;s:8:\"allowimg\";i:2048;s:12:\"allowsmilies\";i:4096;s:9:\"allowhtml\";i:8192;s:9:\"cansigpic\";i:32768;s:16:\"cananimatesigpic\";i:65536;}s:25:\"visitormessagepermissions\";a:6:{s:20:\"canmessageownprofile\";i:1;s:23:\"canmessageothersprofile\";i:2;s:18:\"caneditownmessages\";i:4;s:20:\"candeleteownmessages\";i:8;s:19:\"canmanageownprofile\";i:32;s:21:\"followforummoderation\";i:16;}s:22:\"socialgrouppermissions\";a:18:{s:13:\"canjoingroups\";i:1;s:15:\"cancreategroups\";i:2;s:18:\"canmanageowngroups\";i:256;s:16:\"caneditowngroups\";i:4;s:18:\"candeleteowngroups\";i:8;s:13:\"canviewgroups\";i:16;s:14:\"canpostmessage\";i:512;s:20:\"canalwayspostmessage\";i:128;s:17:\"canmanagemessages\";i:32;s:19:\"cancreatediscussion\";i:1024;s:25:\"canalwayscreatediscussion\";i:2048;s:18:\"canlimitdiscussion\";i:4096;s:20:\"canmanagediscussions\";i:8192;s:21:\"followforummoderation\";i:64;s:18:\"canuploadgroupicon\";i:16384;s:19:\"cananimategroupicon\";i:32768;s:9:\"canupload\";i:65536;s:26:\"groupfollowforummoderation\";i:131072;}}s:4:\"misc\";a:16:{s:8:\"intperms\";a:24:{s:11:\"attachlimit\";i:1;s:7:\"pmquota\";i:0;s:9:\"pmsendmax\";i:1;s:18:\"pmthrottlequantity\";i:1;s:18:\"profilepicmaxwidth\";i:1;s:19:\"profilepicmaxheight\";i:1;s:17:\"profilepicmaxsize\";i:1;s:14:\"avatarmaxwidth\";i:1;s:15:\"avatarmaxheight\";i:1;s:13:\"avatarmaxsize\";i:1;s:16:\"albumpicmaxwidth\";i:1;s:17:\"albumpicmaxheight\";i:1;s:12:\"albummaxpics\";i:1;s:12:\"albummaxsize\";i:1;s:14:\"sigmaxrawchars\";i:1;s:11:\"sigmaxchars\";i:1;s:11:\"sigmaxlines\";i:1;s:16:\"sigmaxsizebbcode\";i:1;s:12:\"sigmaximages\";i:1;s:14:\"sigpicmaxwidth\";i:1;s:15:\"sigpicmaxheight\";i:1;s:13:\"sigpicmaxsize\";i:1;s:19:\"maximumsocialgroups\";i:1;s:16:\"groupiconmaxsize\";i:1;}s:13:\"bbcodeoptions\";a:5:{s:11:\"strip_empty\";i:1;s:10:\"stop_parse\";i:2;s:15:\"disable_smilies\";i:4;s:16:\"disable_wordwrap\";i:8;s:21:\"disable_urlconversion\";i:16;}s:23:\"calmoderatorpermissions\";a:5:{s:13:\"caneditevents\";i:1;s:15:\"candeleteevents\";i:2;s:17:\"canmoderateevents\";i:4;s:10:\"canviewips\";i:8;s:13:\"canmoveevents\";i:16;}s:20:\"moderatorpermissions\";a:23:{s:12:\"caneditposts\";i:1;s:14:\"candeleteposts\";i:2;s:12:\"canopenclose\";i:4;s:14:\"caneditthreads\";i:8;s:16:\"canmanagethreads\";i:16;s:11:\"canannounce\";i:32;s:16:\"canmoderateposts\";i:64;s:22:\"canmoderateattachments\";i:128;s:11:\"canmassmove\";i:256;s:12:\"canmassprune\";i:512;s:10:\"canviewips\";i:1024;s:14:\"canviewprofile\";i:2048;s:11:\"canbanusers\";i:4096;s:13:\"canunbanusers\";i:8192;s:14:\"newthreademail\";i:16384;s:12:\"newpostemail\";i:32768;s:14:\"cansetpassword\";i:65536;s:14:\"canremoveposts\";i:131072;s:11:\"caneditsigs\";i:262144;s:13:\"caneditavatar\";i:524288;s:11:\"caneditpoll\";i:1048576;s:17:\"caneditprofilepic\";i:2097152;s:17:\"caneditreputation\";i:4194304;}s:21:\"moderatorpermissions2\";a:25:{s:22:\"caneditvisitormessages\";i:1;s:24:\"candeletevisitormessages\";i:2;s:24:\"canremovevisitormessages\";i:4;s:26:\"canmoderatevisitormessages\";i:8;s:19:\"caneditalbumpicture\";i:16;s:21:\"candeletealbumpicture\";i:32;s:19:\"caneditsocialgroups\";i:64;s:21:\"candeletesocialgroups\";i:128;s:20:\"caneditgroupmessages\";i:256;s:22:\"candeletegroupmessages\";i:512;s:22:\"canremovegroupmessages\";i:1024;s:24:\"canmoderategroupmessages\";i:2048;s:26:\"canmoderatepicturecomments\";i:4096;s:24:\"candeletepicturecomments\";i:8192;s:24:\"canremovepicturecomments\";i:16384;s:22:\"caneditpicturecomments\";i:32768;s:19:\"canmoderatepictures\";i:65536;s:18:\"caneditdiscussions\";i:131072;s:20:\"candeletediscussions\";i:262144;s:20:\"canremovediscussions\";i:524288;s:22:\"canmoderatediscussions\";i:1048576;s:23:\"cantransfersocialgroups\";i:2097152;s:19:\"caneditgrouppicture\";i:4194304;s:21:\"candeletegrouppicture\";i:8388608;s:23:\"canmoderategrouppicture\";i:16777216;}s:15:\"languageoptions\";a:2:{s:9:\"direction\";i:1;s:7:\"dirmark\";i:2;}s:12:\"adminoptions\";a:2:{s:11:\"adminavatar\";i:1;s:15:\"adminprofilepic\";i:2;}s:11:\"useroptions\";a:24:{s:14:\"showsignatures\";i:1;s:11:\"showavatars\";i:2;s:10:\"showimages\";i:4;s:9:\"coppauser\";i:8;s:10:\"adminemail\";i:16;s:9:\"showvcard\";i:32;s:7:\"dstauto\";i:64;s:8:\"dstonoff\";i:128;s:9:\"showemail\";i:256;s:9:\"invisible\";i:512;s:14:\"showreputation\";i:1024;s:9:\"receivepm\";i:2048;s:9:\"emailonpm\";i:4096;s:13:\"hasaccessmask\";i:8192;s:14:\"vbasset_enable\";i:16384;s:9:\"postorder\";i:32768;s:16:\"receivepmbuddies\";i:131072;s:17:\"noactivationmails\";i:262144;s:12:\"pmboxwarning\";i:524288;s:11:\"showusercss\";i:1048576;s:25:\"receivefriendemailrequest\";i:2097152;s:9:\"vm_enable\";i:8388608;s:14:\"vm_contactonly\";i:16777216;s:17:\"pmdefaultsavecopy\";i:33554432;}s:12:\"forumoptions\";a:18:{s:6:\"active\";i:1;s:12:\"allowposting\";i:2;s:17:\"cancontainthreads\";i:4;s:15:\"moderatenewpost\";i:8;s:17:\"moderatenewthread\";i:16;s:14:\"moderateattach\";i:32;s:11:\"allowbbcode\";i:64;s:11:\"allowimages\";i:128;s:9:\"allowhtml\";i:256;s:12:\"allowsmilies\";i:512;s:10:\"allowicons\";i:1024;s:12:\"allowratings\";i:2048;s:10:\"countposts\";i:4096;s:15:\"canhavepassword\";i:8192;s:10:\"indexposts\";i:16384;s:13:\"styleoverride\";i:32768;s:15:\"showonforumjump\";i:65536;s:14:\"prefixrequired\";i:131072;}s:10:\"regoptions\";a:27:{s:10:\"adminemail\";i:1;s:13:\"invisiblemode\";i:2;s:12:\"receiveemail\";i:4;s:8:\"enablepm\";i:8;s:9:\"emailonpm\";i:16;s:7:\"pmpopup\";i:32;s:11:\"vbcode_none\";i:64;s:15:\"vbcode_standard\";i:128;s:15:\"vbcode_enhanced\";i:256;s:14:\"subscribe_none\";i:512;s:18:\"subscribe_nonotify\";i:1024;s:17:\"subscribe_instant\";i:2048;s:15:\"subscribe_daily\";i:4096;s:16:\"subscribe_weekly\";i:8192;s:5:\"vcard\";i:16384;s:9:\"signature\";i:32768;s:6:\"avatar\";i:65536;s:5:\"image\";i:131072;s:20:\"thread_linear_oldest\";i:262144;s:20:\"thread_linear_newest\";i:524288;s:15:\"thread_threaded\";i:1048576;s:13:\"thread_hybrid\";i:2097152;s:14:\"showreputation\";i:4194304;s:9:\"vm_enable\";i:8388608;s:14:\"vm_contactonly\";i:16777216;s:17:\"pmdefaultsavecopy\";i:33554432;s:14:\"vbasset_enable\";i:67108864;}s:19:\"announcementoptions\";a:5:{s:11:\"allowbbcode\";i:1;s:9:\"allowhtml\";i:2;s:12:\"allowsmilies\";i:4;s:8:\"parseurl\";i:8;s:9:\"signature\";i:16;}s:11:\"feedoptions\";a:11:{s:7:\"enabled\";i:1;s:10:\"searchboth\";i:2;s:11:\"stickthread\";i:8;s:13:\"unstickthread\";i:16;s:11:\"closethread\";i:32;s:12:\"allowsmilies\";i:64;s:13:\"showsignature\";i:128;s:9:\"allowhtml\";i:256;s:14:\"moderatethread\";i:512;s:11:\"html2bbcode\";i:1024;s:8:\"matchall\";i:2048;}s:6:\"socnet\";a:6:{s:13:\"enable_groups\";i:1;s:13:\"enable_albums\";i:2;s:14:\"enable_friends\";i:4;s:23:\"enable_visitor_tracking\";i:8;s:24:\"enable_visitor_messaging\";i:16;s:22:\"enable_profile_styling\";i:32;}s:18:\"socialgroupoptions\";a:5:{s:15:\"owner_mod_queue\";i:1;s:12:\"join_to_view\";i:2;s:21:\"enable_group_messages\";i:4;s:19:\"enable_group_albums\";i:8;s:22:\"only_owner_discussions\";i:16;}s:13:\"prefixoptions\";a:1:{s:15:\"deny_by_default\";i:1;}s:7:\"hvcheck\";a:5:{s:8:\"register\";i:1;s:4:\"post\";i:2;s:6:\"search\";i:4;s:9:\"contactus\";i:8;s:6:\"lostpw\";i:16;}}}', 1)

Time Before: 0.02098 seconds
Time After: 0.02099 seconds
Time Taken: 0.00001 seconds

Memory Before: 3,636.539 KB
Memory After: 3,624.539 KB
Memory Used: -12.000 KB