Time Before: 0.00383 seconds
Time After: 0.00962 seconds
Time Taken: 0.00579 seconds
Memory Before: 2,902.859 KB
Memory After: 5,173.156 KB
Memory Used: 2,270.297 KB
Time Before: 0.00968 seconds
Time After: 0.01026 seconds
Time Taken: 0.00058 seconds
Memory Before: 5,173.070 KB
Memory After: 5,176.672 KB
Memory Used: 3.602 KB
SET @@sql_mode = ''
Time Before: 0.01036 seconds
Time After: 0.01043 seconds
Time Taken: 0.00007 seconds
Memory Before: 5,176.711 KB
Memory After: 5,177.203 KB
Memory Used: 0.492 KB
SELECT * FROM vb_datastore WHERE title IN ('routes','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 | 15 | Using index condition |
Time Before: 0.01082 seconds
Time After: 0.01124 seconds
Time Taken: 0.00042 seconds
Memory Before: 5,179.844 KB
Memory After: 5,182.109 KB
Memory Used: 2.266 KB
Time Before: 0.01045 seconds
Time After: 0.01195 seconds
Time Taken: 0.00150 seconds
Memory Before: 5,176.313 KB
Memory After: 5,844.070 KB
Memory Used: 667.758 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.01351 seconds
Time After: 0.01359 seconds
Time Taken: 0.00008 seconds
Memory Before: 6,623.195 KB
Memory After: 6,625.195 KB
Memory Used: 2.000 KB
SELECT * FROM vb_session WHERE userid = 0 AND host = '18.97.14.88' AND idhash = '3baccf9796c876a91b207ca555fa88a5' 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.01404 seconds
Time After: 0.01416 seconds
Time Taken: 0.00012 seconds
Memory Before: 6,639.086 KB
Memory After: 6,641.289 KB
Memory Used: 2.203 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_vbcms AS phrasegroup_vbcms, 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.01534 seconds
Time After: 0.01614 seconds
Time Taken: 0.00080 seconds
Memory Before: 6,650.336 KB
Memory After: 6,651.961 KB
Memory Used: 1.625 KB
Time Before: 0.01375 seconds
Time After: 0.01622 seconds
Time Taken: 0.00246 seconds
Memory Before: 6,633.500 KB
Memory After: 6,721.773 KB
Memory Used: 88.273 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.01808 seconds
Time After: 0.01818 seconds
Time Taken: 0.00010 seconds
Memory Before: 6,928.633 KB
Memory After: 6,930.609 KB
Memory Used: 1.977 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'vbcms_item_1_data'
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.02424 seconds
Time After: 0.02435 seconds
Time Taken: 0.00010 seconds
Memory Before: 9,143.500 KB
Memory After: 9,145.516 KB
Memory Used: 2.016 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'vbcms_nav_.fea43f89061af446a212dce956aad951'
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.02510 seconds
Time After: 0.02521 seconds
Time Taken: 0.00012 seconds
Memory Before: 9,314.820 KB
Memory After: 9,316.813 KB
Memory Used: 1.992 KB
SELECT navigation.nodeid, navigation.nodelist, nodeinfo.title, node.permissionsfrom, node.setpublish, node.publishdate FROM vb_cms_navigation AS navigation INNER JOIN vb_cms_node AS node ON node.nodeid = navigation.nodeid LEFT JOIN vb_cms_nodeinfo AS nodeinfo ON nodeinfo.nodeid = navigation.nodeid WHERE navigation.nodeid IN (1) AND navigation.nodelist IS NOT NULL AND (navigation.nodelist <> '') ORDER BY node.nodeleft DESC LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | navigation | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | nodeinfo | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.02684 seconds
Time After: 0.02697 seconds
Time Taken: 0.00013 seconds
Memory Before: 9,519.453 KB
Memory After: 9,521.133 KB
Memory Used: 1.680 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'cms_priv_user_0'
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.02848 seconds
Time After: 0.02856 seconds
Time Taken: 0.00008 seconds
Memory Before: 10,032.289 KB
Memory After: 10,034.313 KB
Memory Used: 2.023 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'vbcms_sectionlist_long'
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.03210 seconds
Time After: 0.03219 seconds
Time Taken: 0.00009 seconds
Memory Before: 11,419.656 KB
Memory After: 11,421.672 KB
Memory Used: 2.016 KB
SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid, node.layoutid, node.publishdate, node.setpublish, node.issection, parent.permissionsfrom as parentpermissions, node.showrating, node.permissionsfrom, node.publicpreview, node.shownav, node.hidden, node.nosearch , info.description, info.title, info.viewcount, info.creationdate, info.workflowdate, info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid, user.username, sectionorder.displayorder FROM vb_cms_node AS node INNER JOIN vb_cms_nodeinfo AS info ON info.nodeid = node.nodeid LEFT JOIN vb_user AS user ON user.userid = node.userid LEFT JOIN vb_cms_sectionorder AS sectionorder ON sectionorder.sectionid = node.parentnode AND sectionorder.nodeid = node.nodeid LEFT JOIN vb_cms_node AS parent ON parent.nodeid = node.parentnode WHERE node.new != 1 AND node.nodeid IN (1,10,19) AND ( (node.permissionsfrom IN (-1)) OR ( node.permissionsfrom in (1) AND (node.parentnode IN (1) OR node.nodeid = 1) AND node.setpublish > 0 AND node.publishdate < 1737140629 ))AND node.new != 1 ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC, node.publishdate DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | node | ALL | PRIMARY,parentnode,publishdate,new | 5 | Using where; Using temporary; Using filesort | |||
1 | SIMPLE | info | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.node.nodeid | 1 | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.node.userid | 1 | |
1 | SIMPLE | sectionorder | eq_ref | sectionid | sectionid | 8 | zabvo_db.node.parentnode,zabvo_db.node.nodeid | 1 | Using where |
1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.node.parentnode | 1 |
Time Before: 0.03295 seconds
Time After: 0.03362 seconds
Time Taken: 0.00067 seconds
Memory Before: 11,423.875 KB
Memory After: 11,425.508 KB
Memory Used: 1.633 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'vbcms_types.types'
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.03440 seconds
Time After: 0.03451 seconds
Time Taken: 0.00010 seconds
Memory Before: 11,633.828 KB
Memory After: 11,635.844 KB
Memory Used: 2.016 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'vbcms_item_19_data'
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.03499 seconds
Time After: 0.03508 seconds
Time Taken: 0.00009 seconds
Memory Before: 11,766.234 KB
Memory After: 11,768.250 KB
Memory Used: 2.016 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'vbcms_item_10_data'
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.03556 seconds
Time After: 0.03565 seconds
Time Taken: 0.00009 seconds
Memory Before: 11,830.039 KB
Memory After: 11,832.055 KB
Memory Used: 2.016 KB
SELECT node.nodeid AS itemid, parent.nodeid, parent.url, parent.styleid, parent.layoutid, parent.publishdate, parent.setpublish, parent.hidden, info.title, info.description FROM vb_cms_node AS node INNER JOIN vb_cms_node AS parent ON (node.nodeleft >= parent.nodeleft AND node.nodeleft <= parent.noderight) INNER JOIN vb_cms_nodeinfo AS info ON info.nodeid = parent.nodeid LEFT JOIN vb_cms_sectionorder AS ord ON ord.nodeid = node.nodeid AND ord.sectionid = node.parentnode WHERE node.nodeid IN (19,10,1) AND parent.nodeid != node.nodeid ORDER BY parent.nodeleft, ord.displayorder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | node | ALL | PRIMARY,nodeleft | 5 | Using where; Using temporary; Using filesort | |||
1 | SIMPLE | ord | eq_ref | sectionid | sectionid | 8 | zabvo_db.node.parentnode,zabvo_db.node.nodeid | 1 | Using where |
1 | SIMPLE | parent | ALL | PRIMARY,nodeleft,noderight | 5 | Range checked for each record (index map: 0xD) | |||
1 | SIMPLE | info | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.parent.nodeid | 1 |
Time Before: 0.03635 seconds
Time After: 0.03687 seconds
Time Taken: 0.00052 seconds
Memory Before: 11,889.016 KB
Memory After: 11,890.695 KB
Memory Used: 1.680 KB
REPLACE INTO vb_cache SET cacheid = 'vbcms_nav_.fea43f89061af446a212dce956aad951', expires = 1737141229, created = 1737140629, locktime = 0, data = "a:3:{i:1;O:26:\"vBCms_Item_Content_Section\":89:{s:8:\"\0*\0class\";s:7:\"Section\";s:10:\"\0*\0package\";s:5:\"vBCms\";s:11:\"\0*\0dm_class\";s:16:\"vBCms_DM_Section\";s:11:\"\0*\0cachable\";b:1;s:13:\"\0*\0canusehtml\";i:-1;s:12:\"\0*\0cache_ttl\";i:1440;s:14:\"\0*\0cached_data\";i:27;s:13:\"\0*\0query_hook\";s:23:\"vbcms_content_querydata\";s:11:\"\0*\0INFO_ALL\";i:127;s:20:\"\0*\0INFO_DEPENDENCIES\";a:1:{i:64;i:8;}s:13:\"\0*\0query_info\";a:5:{i:1;i:7;i:2;i:8;i:3;i:16;i:4;i:32;i:5;i:64;}s:21:\"\0*\0content_properties\";a:0:{}s:18:\"\0*\0item_properties\";a:55:{i:0;s:6:\"nodeid\";i:1;s:6:\"isroot\";i:2;s:9:\"contentid\";i:3;s:13:\"contenttypeid\";i:4;s:3:\"url\";i:5;s:6:\"userid\";i:6;s:10:\"parentnode\";i:7;s:8:\"layoutid\";i:8;s:7:\"styleid\";i:9;s:11:\"publishdate\";i:10;s:10:\"setpublish\";i:11;s:9:\"issection\";i:12;s:15:\"permissionsfrom\";i:13;s:17:\"parentpermissions\";i:14;s:11:\"lastupdated\";i:15;s:13:\"publicpreview\";i:16;s:16:\"comments_enabled\";i:17;s:3:\"new\";i:18;s:5:\"depth\";i:19;s:8:\"username\";i:20;s:5:\"title\";i:21;s:10:\"html_title\";i:22;s:11:\"description\";i:23;s:8:\"nodeleft\";i:24;s:9:\"noderight\";i:25;s:10:\"showrating\";i:26;s:9:\"showtitle\";i:27;s:8:\"showuser\";i:28;s:15:\"showpreviewonly\";i:29;s:11:\"showupdated\";i:30;s:13:\"showviewcount\";i:31;s:15:\"showpublishdate\";i:32;s:15:\"settingsforboth\";i:33;s:15:\"includechildren\";i:34;s:7:\"showall\";i:35;s:16:\"editshowchildren\";i:36;s:9:\"ratingnum\";i:37;s:11:\"ratingtotal\";i:38;s:6:\"rating\";i:39;s:6:\"hidden\";i:40;s:7:\"shownav\";i:41;s:8:\"nosearch\";i:42;s:12:\"creationdate\";i:43;s:9:\"viewcount\";i:44;s:15:\"workflowlevelid\";i:45;s:14:\"workflowstatus\";i:46;s:12:\"workflowdate\";i:47;s:18:\"workflowcheckedout\";i:48;s:18:\"associatedthreadid\";i:49;s:10:\"replycount\";i:50;s:8:\"keywords\";i:51;s:11:\"parenttitle\";i:52;s:12:\"displayorder\";i:53;s:16:\"navigation_nodes\";i:54;s:7:\"parents\";}s:9:\"\0*\0nodeid\";s:1:\"1\";s:9:\"\0*\0isroot\";s:1:\"1\";s:12:\"\0*\0contentid\";s:1:\"0\";s:16:\"\0*\0contenttypeid\";s:2:\"17\";s:6:\"\0*\0url\";s:4:\"news\";s:13:\"\0*\0parentnode\";N;s:11:\"\0*\0layoutid\";s:1:\"1\";s:10:\"\0*\0styleid\";s:1:\"1\";s:12:\"\0*\0issection\";s:1:\"1\";s:11:\"\0*\0username\";N;s:14:\"\0*\0publishdate\";s:10:\"1287054120\";s:6:\"\0*\0new\";s:1:\"0\";s:13:\"\0*\0setpublish\";s:1:\"1\";s:8:\"\0*\0depth\";N;s:15:\"\0*\0creationdate\";s:10:\"1287053559\";s:12:\"\0*\0viewcount\";s:1:\"0\";s:18:\"\0*\0workflowlevelid\";s:1:\"0\";s:17:\"\0*\0workflowstatus\";N;s:15:\"\0*\0workflowdate\";N;s:21:\"\0*\0workflowcheckedout\";N;s:21:\"\0*\0associatedthreadid\";s:1:\"0\";s:16:\"\0*\0publicCanView\";N;s:19:\"\0*\0navigation_nodes\";N;s:17:\"\0*\0pending_parent\";N;s:9:\"\0*\0layout\";N;s:14:\"\0*\0node_layout\";N;s:15:\"\0*\0node_styleid\";N;s:10:\"\0*\0parents\";a:0:{}s:9:\"\0*\0config\";a:5:{s:11:\"contentfrom\";s:1:\"2\";s:14:\"content_layout\";s:1:\"1\";s:17:\"items_perhomepage\";s:1:\"7\";s:16:\"pagination_links\";s:1:\"0\";s:16:\"section_priority\";s:1:\"1\";}s:9:\"\0*\0userid\";s:1:\"0\";s:18:\"\0*\0permissionsfrom\";s:1:\"1\";s:20:\"\0*\0parentpermissions\";N;s:13:\"publicpreview\";s:1:\"0\";s:13:\"\0*\0replycount\";N;s:15:\"\0*\0displayorder\";N;s:19:\"\0*\0comments_enabled\";s:1:\"0\";s:11:\"\0*\0keywords\";s:0:\"\";s:12:\"\0*\0pagetitle\";N;s:8:\"\0*\0title\";s:14:\"Новости\";s:13:\"\0*\0html_title\";s:14:\"Новости\";s:14:\"\0*\0parenttitle\";N;s:11:\"\0*\0nodeleft\";s:1:\"1\";s:12:\"\0*\0noderight\";s:2:\"10\";s:14:\"\0*\0lastupdated\";s:10:\"1360253509\";s:12:\"\0*\0ratingnum\";s:1:\"0\";s:14:\"\0*\0ratingtotal\";s:1:\"0\";s:9:\"\0*\0rating\";s:1:\"0\";s:21:\"\0*\0navigation_ownmenu\";N;s:18:\"\0*\0navigation_node\";N;s:25:\"\0*\0navigation_parenttitle\";N;s:12:\"\0*\0showtitle\";s:1:\"1\";s:11:\"\0*\0showuser\";s:1:\"1\";s:18:\"\0*\0showpreviewonly\";s:1:\"1\";s:14:\"\0*\0showupdated\";s:1:\"0\";s:16:\"\0*\0showviewcount\";s:1:\"0\";s:18:\"\0*\0showpublishdate\";s:1:\"1\";s:18:\"\0*\0settingsforboth\";s:1:\"1\";s:18:\"\0*\0includechildren\";s:1:\"1\";s:10:\"\0*\0showall\";s:1:\"1\";s:13:\"\0*\0showrating\";s:1:\"0\";s:19:\"\0*\0editshowchildren\";s:1:\"0\";s:9:\"\0*\0hidden\";s:1:\"0\";s:10:\"\0*\0shownav\";s:1:\"0\";s:11:\"\0*\0nosearch\";s:1:\"0\";s:19:\"\0*\0resolved_styleid\";N;s:14:\"\0*\0description\";s:4:\"Home\";s:16:\"\0*\0dm_load_flags\";i:1;s:9:\"\0*\0itemid\";i:1;s:18:\"\0*\0allow_no_itemid\";b:0;s:11:\"\0*\0is_valid\";b:1;s:14:\"\0*\0loaded_info\";i:27;s:16:\"\0*\0required_info\";i:1;s:20:\"\0*\0always_load_basic\";b:1;s:11:\"\0*\0autoload\";b:0;s:12:\"\0*\0important\";b:0;s:14:\"\0*\0cache_basic\";b:0;}i:10;O:26:\"vBCms_Item_Content_Article\":108:{s:8:\"\0*\0class\";s:7:\"Article\";s:10:\"\0*\0package\";s:5:\"vBCms\";s:11:\"\0*\0dm_class\";s:16:\"vBCms_DM_Article\";s:13:\"\0*\0query_info\";a:4:{i:1;i:39;i:2;i:8;i:5;i:64;i:3;i:16;}s:11:\"\0*\0INFO_ALL\";i:255;s:21:\"\0*\0content_properties\";a:20:{i:0;s:8:\"pagetext\";i:1;s:8:\"threadid\";i:2;s:6:\"blogid\";i:3;s:9:\"posttitle\";i:4;s:10:\"postauthor\";i:5;s:11:\"poststarter\";i:6;s:6:\"postid\";i:7;s:10:\"blogpostid\";i:8;s:10:\"showrating\";i:9;s:9:\"htmlstate\";i:10;s:11:\"post_posted\";i:11;s:12:\"post_started\";i:12;s:12:\"previewimage\";i:13;s:10:\"imagewidth\";i:14;s:11:\"imageheight\";i:15;s:12:\"previewvideo\";i:16;s:11:\"allcomments\";i:17;s:10:\"keepthread\";i:18;s:10:\"movethread\";i:19;s:13:\"comment_count\";}s:11:\"\0*\0pagetext\";s:2727:\"[CENTER][SIZE=4][B][COLOR=red][SIZE=3]Дорогой Забайкалец! Этот сайт создан для тебя.[/SIZE]\r\n[/COLOR][/B][/SIZE][/CENTER]\r\n \r\n Для того, чтобы ты смог найти здесь друзей по службе в славном Забайкальском Ордена Ленина Военном Округе. Или приобрести новых, с которыми ты был незнаком во время оное, а встретился уже здесь. Общайся, делись воcпоминаниями с друзьями и знакомыми. Для нас, твоих друзей, ценен твой жизненный опыт и знания,\r\n От тебя зависит существование этого сайта, здешняя атмосфера дружбы, которая позволит привлечь на наш и твой сайт больше участников.\r\n \r\n[CENTER] На нашем сайте действуют правила, вот они:\r\n[/CENTER]\r\n \r\n 1. Наш сайт основан на уважении. Уважении личного мнения каждого из нас, опыта и возраста участников. Звание, полученное во время службы в ВС, значения не имеет, у нас одинаковым уважением пользуются и рядовой, и генерал.\r\n 2. Считайся с мнениями других участников форума, будь снисходителен к ошибкам окружающих. Будь, а не кажись.\r\n 3. Если тебе потребовалось выяснить с кем-либо отношения - используй специальную ветку форума или личные сообщения. Помни только - в споре неправы обе стороны, если он не закончился согласием.\r\n 4. Твои личные обиды - твои проблемы. Наш сайт важнее для нас всех.\r\n 5. Будь сдержанным, на сайте нет цензора. Грубые и нецензурные выражения мы считаем недопустимыми. Если выпил - держи себя в рамках.\r\n 6. Помни, что твои сообщения на форуме доступны посетителям сайта, твоим потенциальным друзьям.\r\n 7. Придерживайся тематики сообщений форума. Флуд не запрещен, но снижает интерес к сайту.\";s:12:\"\0*\0htmlstate\";s:8:\"on_nl2br\";s:11:\"\0*\0threadid\";N;s:9:\"\0*\0blogid\";N;s:12:\"\0*\0posttitle\";N;s:13:\"\0*\0postauthor\";s:0:\"\";s:14:\"\0*\0poststarter\";N;s:9:\"\0*\0postid\";N;s:13:\"\0*\0blogpostid\";N;s:15:\"\0*\0post_started\";N;s:14:\"\0*\0post_posted\";N;s:15:\"\0*\0previewimage\";s:0:\"\";s:13:\"\0*\0imagewidth\";s:1:\"0\";s:14:\"\0*\0imageheight\";s:1:\"0\";s:15:\"\0*\0previewvideo\";s:0:\"\";s:13:\"\0*\0showrating\";s:1:\"1\";s:13:\"\0*\0keepthread\";s:1:\"0\";s:14:\"\0*\0allcomments\";s:1:\"0\";s:13:\"\0*\0query_hook\";s:23:\"vbcms_article_querydata\";s:16:\"\0*\0comment_count\";N;s:13:\"\0*\0movethread\";s:1:\"0\";s:11:\"\0*\0cachable\";b:1;s:13:\"\0*\0canusehtml\";i:-1;s:12:\"\0*\0cache_ttl\";i:1440;s:14:\"\0*\0cached_data\";i:59;s:20:\"\0*\0INFO_DEPENDENCIES\";a:1:{i:64;i:8;}s:18:\"\0*\0item_properties\";a:75:{i:0;s:6:\"nodeid\";i:1;s:6:\"isroot\";i:2;s:9:\"contentid\";i:3;s:13:\"contenttypeid\";i:4;s:3:\"url\";i:5;s:6:\"userid\";i:6;s:10:\"parentnode\";i:7;s:8:\"layoutid\";i:8;s:7:\"styleid\";i:9;s:11:\"publishdate\";i:10;s:10:\"setpublish\";i:11;s:9:\"issection\";i:12;s:15:\"permissionsfrom\";i:13;s:17:\"parentpermissions\";i:14;s:11:\"lastupdated\";i:15;s:13:\"publicpreview\";i:16;s:16:\"comments_enabled\";i:17;s:3:\"new\";i:18;s:5:\"depth\";i:19;s:8:\"username\";i:20;s:5:\"title\";i:21;s:10:\"html_title\";i:22;s:11:\"description\";i:23;s:8:\"nodeleft\";i:24;s:9:\"noderight\";i:25;s:10:\"showrating\";i:26;s:9:\"showtitle\";i:27;s:8:\"showuser\";i:28;s:15:\"showpreviewonly\";i:29;s:11:\"showupdated\";i:30;s:13:\"showviewcount\";i:31;s:15:\"showpublishdate\";i:32;s:15:\"settingsforboth\";i:33;s:15:\"includechildren\";i:34;s:7:\"showall\";i:35;s:16:\"editshowchildren\";i:36;s:9:\"ratingnum\";i:37;s:11:\"ratingtotal\";i:38;s:6:\"rating\";i:39;s:6:\"hidden\";i:40;s:7:\"shownav\";i:41;s:8:\"nosearch\";i:42;s:12:\"creationdate\";i:43;s:9:\"viewcount\";i:44;s:15:\"workflowlevelid\";i:45;s:14:\"workflowstatus\";i:46;s:12:\"workflowdate\";i:47;s:18:\"workflowcheckedout\";i:48;s:18:\"associatedthreadid\";i:49;s:10:\"replycount\";i:50;s:8:\"keywords\";i:51;s:11:\"parenttitle\";i:52;s:12:\"displayorder\";i:53;s:16:\"navigation_nodes\";i:54;s:7:\"parents\";i:55;s:8:\"pagetext\";i:56;s:8:\"threadid\";i:57;s:6:\"blogid\";i:58;s:9:\"posttitle\";i:59;s:10:\"postauthor\";i:60;s:11:\"poststarter\";i:61;s:6:\"postid\";i:62;s:10:\"blogpostid\";i:63;s:10:\"showrating\";i:64;s:9:\"htmlstate\";i:65;s:11:\"post_posted\";i:66;s:12:\"post_started\";i:67;s:12:\"previewimage\";i:68;s:10:\"imagewidth\";i:69;s:11:\"imageheight\";i:70;s:12:\"previewvideo\";i:71;s:11:\"allcomments\";i:72;s:10:\"keepthread\";i:73;s:10:\"movethread\";i:74;s:13:\"comment_count\";}s:9:\"\0*\0nodeid\";s:2:\"10\";s:9:\"\0*\0isroot\";s:1:\"0\";s:12:\"\0*\0contentid\";s:1:\"9\";s:16:\"\0*\0contenttypeid\";s:2:\"18\";s:6:\"\0*\0url\";s:15:\"Начало...\";s:13:\"\0*\0parentnode\";s:1:\"1\";s:11:\"\0*\0layoutid\";N;s:10:\"\0*\0styleid\";N;s:12:\"\0*\0issection\";s:1:\"0\";s:11:\"\0*\0username\";s:18:\"Александр\";s:14:\"\0*\0publishdate\";s:10:\"1287053640\";s:6:\"\0*\0new\";s:1:\"0\";s:13:\"\0*\0setpublish\";s:1:\"1\";s:8:\"\0*\0depth\";N;s:15:\"\0*\0creationdate\";s:10:\"1287057295\";s:12:\"\0*\0viewcount\";s:5:\"37149\";s:18:\"\0*\0workflowlevelid\";s:1:\"0\";s:17:\"\0*\0workflowstatus\";N;s:15:\"\0*\0workflowdate\";N;s:21:\"\0*\0workflowcheckedout\";N;s:21:\"\0*\0associatedthreadid\";s:3:\"155\";s:16:\"\0*\0publicCanView\";N;s:19:\"\0*\0navigation_nodes\";N;s:17:\"\0*\0pending_parent\";N;s:9:\"\0*\0layout\";N;s:14:\"\0*\0node_layout\";N;s:15:\"\0*\0node_styleid\";N;s:10:\"\0*\0parents\";a:1:{i:1;a:10:{s:6:\"itemid\";s:2:\"10\";s:6:\"nodeid\";s:1:\"1\";s:3:\"url\";s:4:\"news\";s:7:\"styleid\";s:1:\"1\";s:8:\"layoutid\";s:1:\"1\";s:11:\"publishdate\";s:10:\"1287054120\";s:10:\"setpublish\";s:1:\"1\";s:6:\"hidden\";s:1:\"0\";s:5:\"title\";s:14:\"Новости\";s:11:\"description\";s:4:\"Home\";}}s:9:\"\0*\0config\";a:0:{}s:9:\"\0*\0userid\";s:1:\"9\";s:18:\"\0*\0permissionsfrom\";s:1:\"1\";s:20:\"\0*\0parentpermissions\";s:1:\"1\";s:13:\"publicpreview\";s:1:\"0\";s:13:\"\0*\0replycount\";s:2:\"25\";s:15:\"\0*\0displayorder\";s:1:\"2\";s:19:\"\0*\0comments_enabled\";s:1:\"1\";s:11:\"\0*\0keywords\";s:0:\"\";s:12:\"\0*\0pagetitle\";N;s:8:\"\0*\0title\";s:15:\"Начало...\";s:13:\"\0*\0html_title\";s:15:\"Начало...\";s:14:\"\0*\0parenttitle\";s:14:\"Новости\";s:11:\"\0*\0nodeleft\";s:1:\"4\";s:12:\"\0*\0noderight\";s:1:\"5\";s:14:\"\0*\0lastupdated\";s:10:\"1731993891\";s:12:\"\0*\0ratingnum\";s:2:\"47\";s:14:\"\0*\0ratingtotal\";s:1:\"5\";s:9:\"\0*\0rating\";s:8:\"0.106383\";s:21:\"\0*\0navigation_ownmenu\";N;s:18:\"\0*\0navigation_node\";N;s:25:\"\0*\0navigation_parenttitle\";N;s:12:\"\0*\0showtitle\";s:1:\"1\";s:11:\"\0*\0showuser\";s:1:\"2\";s:18:\"\0*\0showpreviewonly\";s:1:\"0\";s:14:\"\0*\0showupdated\";s:1:\"0\";s:16:\"\0*\0showviewcount\";s:1:\"1\";s:18:\"\0*\0showpublishdate\";s:1:\"1\";s:18:\"\0*\0settingsforboth\";s:1:\"1\";s:18:\"\0*\0includechildren\";s:1:\"1\";s:10:\"\0*\0showall\";s:1:\"1\";s:19:\"\0*\0editshowchildren\";s:1:\"0\";s:9:\"\0*\0hidden\";s:1:\"0\";s:10:\"\0*\0shownav\";s:1:\"1\";s:11:\"\0*\0nosearch\";s:1:\"0\";s:19:\"\0*\0resolved_styleid\";N;s:14:\"\0*\0description\";s:23:\"статья Новая\";s:16:\"\0*\0dm_load_flags\";i:1;s:9:\"\0*\0itemid\";i:10;s:18:\"\0*\0allow_no_itemid\";b:0;s:11:\"\0*\0is_valid\";b:1;s:14:\"\0*\0loaded_info\";i:59;s:16:\"\0*\0required_info\";i:1;s:20:\"\0*\0always_load_basic\";b:1;s:11:\"\0*\0autoload\";b:0;s:12:\"\0*\0important\";b:0;s:14:\"\0*\0cache_basic\";b:0;}i:19;O:26:\"vBCms_Item_Content_Article\":108:{s:8:\"\0*\0class\";s:7:\"Article\";s:10:\"\0*\0package\";s:5:\"vBCms\";s:11:\"\0*\0dm_class\";s:16:\"vBCms_DM_Article\";s:13:\"\0*\0query_info\";a:4:{i:1;i:39;i:2;i:8;i:5;i:64;i:3;i:16;}s:11:\"\0*\0INFO_ALL\";i:255;s:21:\"\0*\0content_properties\";a:20:{i:0;s:8:\"pagetext\";i:1;s:8:\"threadid\";i:2;s:6:\"blogid\";i:3;s:9:\"posttitle\";i:4;s:10:\"postauthor\";i:5;s:11:\"poststarter\";i:6;s:6:\"postid\";i:7;s:10:\"blogpostid\";i:8;s:10:\"showrating\";i:9;s:9:\"htmlstate\";i:10;s:11:\"post_posted\";i:11;s:12:\"post_started\";i:12;s:12:\"previewimage\";i:13;s:10:\"imagewidth\";i:14;s:11:\"imageheight\";i:15;s:12:\"previewvideo\";i:16;s:11:\"allcomments\";i:17;s:10:\"keepthread\";i:18;s:10:\"movethread\";i:19;s:13:\"comment_count\";}s:11:\"\0*\0pagetext\";s:311:\"[CENTER][ATTACH=CONFIG]3332[/ATTACH][/CENTER]\n\n[B][I][SIZE=4][COLOR=red][CENTER]Все желающие получить Знак \"Братство ЗабВО\" - пишите мне в личку или на почту\n[EMAIL=\"znak-zabvo@yandex.ru\"]znak-zabvo@yandex.ru[/EMAIL]![/CENTER]\n[/COLOR][/SIZE][/I][/B]\";s:12:\"\0*\0htmlstate\";s:8:\"on_nl2br\";s:11:\"\0*\0threadid\";N;s:9:\"\0*\0blogid\";N;s:12:\"\0*\0posttitle\";N;s:13:\"\0*\0postauthor\";s:0:\"\";s:14:\"\0*\0poststarter\";N;s:9:\"\0*\0postid\";N;s:13:\"\0*\0blogpostid\";N;s:15:\"\0*\0post_started\";N;s:14:\"\0*\0post_posted\";N;s:15:\"\0*\0previewimage\";s:43:\"attachment.php?attachmentid=3332&cid=18\";s:13:\"\0*\0imagewidth\";s:3:\"100\";s:14:\"\0*\0imageheight\";s:2:\"65\";s:15:\"\0*\0previewvideo\";s:0:\"\";s:13:\"\0*\0showrating\";s:1:\"1\";s:13:\"\0*\0keepthread\";s:1:\"0\";s:14:\"\0*\0allcomments\";s:1:\"0\";s:13:\"\0*\0query_hook\";s:23:\"vbcms_article_querydata\";s:16:\"\0*\0comment_count\";N;s:13:\"\0*\0movethread\";s:1:\"0\";s:11:\"\0*\0cachable\";b:1;s:13:\"\0*\0canusehtml\";i:-1;s:12:\"\0*\0cache_ttl\";i:1440;s:14:\"\0*\0cached_data\";i:59;s:20:\"\0*\0INFO_DEPENDENCIES\";a:1:{i:64;i:8;}s:18:\"\0*\0item_properties\";a:75:{i:0;s:6:\"nodeid\";i:1;s:6:\"isroot\";i:2;s:9:\"contentid\";i:3;s:13:\"contenttypeid\";i:4;s:3:\"url\";i:5;s:6:\"userid\";i:6;s:10:\"parentnode\";i:7;s:8:\"layoutid\";i:8;s:7:\"styleid\";i:9;s:11:\"publishdate\";i:10;s:10:\"setpublish\";i:11;s:9:\"issection\";i:12;s:15:\"permissionsfrom\";i:13;s:17:\"parentpermissions\";i:14;s:11:\"lastupdated\";i:15;s:13:\"publicpreview\";i:16;s:16:\"comments_enabled\";i:17;s:3:\"new\";i:18;s:5:\"depth\";i:19;s:8:\"username\";i:20;s:5:\"title\";i:21;s:10:\"html_title\";i:22;s:11:\"description\";i:23;s:8:\"nodeleft\";i:24;s:9:\"noderight\";i:25;s:10:\"showrating\";i:26;s:9:\"showtitle\";i:27;s:8:\"showuser\";i:28;s:15:\"showpreviewonly\";i:29;s:11:\"showupdated\";i:30;s:13:\"showviewcount\";i:31;s:15:\"showpublishdate\";i:32;s:15:\"settingsforboth\";i:33;s:15:\"includechildren\";i:34;s:7:\"showall\";i:35;s:16:\"editshowchildren\";i:36;s:9:\"ratingnum\";i:37;s:11:\"ratingtotal\";i:38;s:6:\"rating\";i:39;s:6:\"hidden\";i:40;s:7:\"shownav\";i:41;s:8:\"nosearch\";i:42;s:12:\"creationdate\";i:43;s:9:\"viewcount\";i:44;s:15:\"workflowlevelid\";i:45;s:14:\"workflowstatus\";i:46;s:12:\"workflowdate\";i:47;s:18:\"workflowcheckedout\";i:48;s:18:\"associatedthreadid\";i:49;s:10:\"replycount\";i:50;s:8:\"keywords\";i:51;s:11:\"parenttitle\";i:52;s:12:\"displayorder\";i:53;s:16:\"navigation_nodes\";i:54;s:7:\"parents\";i:55;s:8:\"pagetext\";i:56;s:8:\"threadid\";i:57;s:6:\"blogid\";i:58;s:9:\"posttitle\";i:59;s:10:\"postauthor\";i:60;s:11:\"poststarter\";i:61;s:6:\"postid\";i:62;s:10:\"blogpostid\";i:63;s:10:\"showrating\";i:64;s:9:\"htmlstate\";i:65;s:11:\"post_posted\";i:66;s:12:\"post_started\";i:67;s:12:\"previewimage\";i:68;s:10:\"imagewidth\";i:69;s:11:\"imageheight\";i:70;s:12:\"previewvideo\";i:71;s:11:\"allcomments\";i:72;s:10:\"keepthread\";i:73;s:10:\"movethread\";i:74;s:13:\"comment_count\";}s:9:\"\0*\0nodeid\";s:2:\"19\";s:9:\"\0*\0isroot\";s:1:\"0\";s:12:\"\0*\0contentid\";s:2:\"18\";s:16:\"\0*\0contenttypeid\";s:2:\"18\";s:6:\"\0*\0url\";s:8:\"Знак\";s:13:\"\0*\0parentnode\";s:1:\"1\";s:11:\"\0*\0layoutid\";N;s:10:\"\0*\0styleid\";N;s:12:\"\0*\0issection\";s:1:\"0\";s:11:\"\0*\0username\";s:18:\"Александр\";s:14:\"\0*\0publishdate\";s:10:\"1328185260\";s:6:\"\0*\0new\";s:1:\"0\";s:13:\"\0*\0setpublish\";s:1:\"1\";s:8:\"\0*\0depth\";N;s:15:\"\0*\0creationdate\";s:10:\"1328185191\";s:12:\"\0*\0viewcount\";s:5:\"27405\";s:18:\"\0*\0workflowlevelid\";s:1:\"0\";s:17:\"\0*\0workflowstatus\";N;s:15:\"\0*\0workflowdate\";N;s:21:\"\0*\0workflowcheckedout\";N;s:21:\"\0*\0associatedthreadid\";s:3:\"320\";s:16:\"\0*\0publicCanView\";N;s:19:\"\0*\0navigation_nodes\";N;s:17:\"\0*\0pending_parent\";N;s:9:\"\0*\0layout\";N;s:14:\"\0*\0node_layout\";N;s:15:\"\0*\0node_styleid\";N;s:10:\"\0*\0parents\";a:1:{i:1;a:10:{s:6:\"itemid\";s:2:\"19\";s:6:\"nodeid\";s:1:\"1\";s:3:\"url\";s:4:\"news\";s:7:\"styleid\";s:1:\"1\";s:8:\"layoutid\";s:1:\"1\";s:11:\"publishdate\";s:10:\"1287054120\";s:10:\"setpublish\";s:1:\"1\";s:6:\"hidden\";s:1:\"0\";s:5:\"title\";s:14:\"Новости\";s:11:\"description\";s:4:\"Home\";}}s:9:\"\0*\0config\";a:0:{}s:9:\"\0*\0userid\";s:1:\"9\";s:18:\"\0*\0permissionsfrom\";s:1:\"1\";s:20:\"\0*\0parentpermissions\";s:1:\"1\";s:13:\"publicpreview\";s:1:\"0\";s:13:\"\0*\0replycount\";s:2:\"19\";s:15:\"\0*\0displayorder\";s:1:\"1\";s:19:\"\0*\0comments_enabled\";s:1:\"1\";s:11:\"\0*\0keywords\";s:66:\"пишите,личку,почту,znak-zabvo@yandex.ru,забво\";s:12:\"\0*\0pagetitle\";N;s:8:\"\0*\0title\";s:48:\"Знак "Братство ЗабВО"\";s:13:\"\0*\0html_title\";s:48:\"Знак "Братство ЗабВО"\";s:14:\"\0*\0parenttitle\";s:14:\"Новости\";s:11:\"\0*\0nodeleft\";s:1:\"6\";s:12:\"\0*\0noderight\";s:1:\"7\";s:14:\"\0*\0lastupdated\";s:10:\"1735615539\";s:12:\"\0*\0ratingnum\";s:2:\"49\";s:14:\"\0*\0ratingtotal\";s:2:\"71\";s:9:\"\0*\0rating\";s:7:\"1.44898\";s:21:\"\0*\0navigation_ownmenu\";N;s:18:\"\0*\0navigation_node\";N;s:25:\"\0*\0navigation_parenttitle\";N;s:12:\"\0*\0showtitle\";s:1:\"1\";s:11:\"\0*\0showuser\";s:1:\"2\";s:18:\"\0*\0showpreviewonly\";s:1:\"0\";s:14:\"\0*\0showupdated\";s:1:\"0\";s:16:\"\0*\0showviewcount\";s:1:\"1\";s:18:\"\0*\0showpublishdate\";s:1:\"1\";s:18:\"\0*\0settingsforboth\";s:1:\"1\";s:18:\"\0*\0includechildren\";s:1:\"1\";s:10:\"\0*\0showall\";s:1:\"1\";s:19:\"\0*\0editshowchildren\";s:1:\"0\";s:9:\"\0*\0hidden\";s:1:\"0\";s:10:\"\0*\0shownav\";s:1:\"1\";s:11:\"\0*\0nosearch\";s:1:\"0\";s:19:\"\0*\0resolved_styleid\";N;s:14:\"\0*\0description\";s:23:\"статья Новая\";s:16:\"\0*\0dm_load_flags\";i:1;s:9:\"\0*\0itemid\";i:19;s:18:\"\0*\0allow_no_itemid\";b:0;s:11:\"\0*\0is_valid\";b:1;s:14:\"\0*\0loaded_info\";i:59;s:16:\"\0*\0required_info\";i:1;s:20:\"\0*\0always_load_basic\";b:1;s:11:\"\0*\0autoload\";b:0;s:12:\"\0*\0important\";b:0;s:14:\"\0*\0cache_basic\";b:0;}}", serialized = '1'
Time Before: 0.03726 seconds
Time After: 0.03778 seconds
Time Taken: 0.00052 seconds
Memory Before: 11,965.508 KB
Memory After: 11,945.422 KB
Memory Used: -20.086 KB
SELECT nodeid, permissionsfrom, hidden, setpublish, publishdate, userid FROM vb_cms_node where nodeid in (0,1,2)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_cms_node | ALL | PRIMARY | 5 | Using where |
Time Before: 0.03801 seconds
Time After: 0.03810 seconds
Time Taken: 0.00008 seconds
Memory Before: 11,886.469 KB
Memory After: 11,888.508 KB
Memory Used: 2.039 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'cms_priv_user_9'
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.03850 seconds
Time After: 0.03858 seconds
Time Taken: 0.00008 seconds
Memory Before: 11,895.063 KB
Memory After: 11,897.086 KB
Memory Used: 2.023 KB
UPDATE vb_cache SET locktime = 1737140629 WHERE cacheid = 'cms_priv_user_9'
Time Before: 0.03863 seconds
Time After: 0.03872 seconds
Time Taken: 0.00009 seconds
Memory Before: 11,900.797 KB
Memory After: 11,901.156 KB
Memory Used: 0.359 KB
SELECT usergroupid, membergroupids FROM vb_user WHERE userid = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.03887 seconds
Time After: 0.03894 seconds
Time Taken: 0.00007 seconds
Memory Before: 11,895.063 KB
Memory After: 11,897.086 KB
Memory Used: 2.023 KB
SELECT vbcmspermissions FROM vb_administrator WHERE userid = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_administrator | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.04040 seconds
Time After: 0.04048 seconds
Time Taken: 0.00008 seconds
Memory Before: 11,897.367 KB
Memory After: 11,899.391 KB
Memory Used: 2.023 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 vb_cms_permissions p WHERE usergroupid IN (6) GROUP BY nodeid;
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | p | ref | usergroupid,nodeid | usergroupid | 4 | const | 1 | Using where |
Time Before: 0.04066 seconds
Time After: 0.04075 seconds
Time Taken: 0.00009 seconds
Memory Before: 11,897.961 KB
Memory After: 11,899.828 KB
Memory Used: 1.867 KB
REPLACE INTO vb_cache SET cacheid = 'cms_priv_user_9', expires = 1737140929, created = 1737140629, locktime = 0, data = "a:10:{s:7:\"canview\";a:1:{i:0;s:1:\"1\";}s:9:\"cancreate\";a:1:{i:0;s:1:\"1\";}s:7:\"canedit\";a:1:{i:0;s:1:\"1\";}s:10:\"canpublish\";a:1:{i:0;s:1:\"1\";}s:10:\"canusehtml\";a:1:{i:0;i:-1;}s:5:\"admin\";s:1:\"3\";s:11:\"candownload\";a:1:{i:0;s:1:\"1\";}s:7:\"alledit\";a:1:{i:0;s:1:\"1\";}s:8:\"viewonly\";a:0:{}s:7:\"allview\";a:1:{i:0;s:1:\"1\";}}", serialized = '1'
Time Before: 0.04082 seconds
Time After: 0.04092 seconds
Time Taken: 0.00010 seconds
Memory Before: 11,904.891 KB
Memory After: 11,904.828 KB
Memory Used: -0.063 KB
SELECT * FROM vb_style WHERE (styleid = 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.04155 seconds
Time After: 0.04180 seconds
Time Taken: 0.00025 seconds
Memory Before: 11,942.508 KB
Memory After: 11,944.688 KB
Memory Used: 2.180 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'vbcms_view_data_1'
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.04269 seconds
Time After: 0.04277 seconds
Time Taken: 0.00008 seconds
Memory Before: 12,610.063 KB
Memory After: 12,612.078 KB
Memory Used: 2.016 KB
SELECT cacheid, data, expires, locktime, serialized FROM vb_cache WHERE cacheid in ('vbcms_item_1_data','vb_types.types','cms_priv_user_0','vbcms_sectionlist_long','vbcms_types.types','vbcms_item_19_data','vbcms_item_10_data','cms_priv_user_9','vbcms_item_3_data','vBCms_Article_pagetext_19.6c31be9642b05002e92dd73f1a7c88af','vBCms_Article_pagetext_10.526b201f3e88fd8c57e6c263050b50b2','cms_priv_user_1','vBCms_Article_pagetext_3.f969eaa3937cac2deb9254c2763ca0f0','vBCms_Article_previewtext_3_quotes.40cd750bba9870f18aada2478b248','widget_3.2269a700121855225b5fbd0a3f311b46','vbcms_nav_.fea43f89061af446a212dce956aad951') AND expires > 1737140629
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_cache | range | PRIMARY,expires | PRIMARY | 66 | 16 | Using index condition; Using where |
Time Before: 0.04301 seconds
Time After: 0.04325 seconds
Time Taken: 0.00024 seconds
Memory Before: 12,621.680 KB
Memory After: 12,623.719 KB
Memory Used: 2.039 KB
(SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid, package.productid AS productid, if(package.productid = 'vbulletin', 1, product.active) AS enabled, package.class AS class, -1 as isaggregator FROM vb_package AS package LEFT JOIN vb_product AS product ON product.productid = package.productid WHERE product.active = 1 OR package.productid = 'vbulletin' ) UNION (SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid, 1, 1, contenttype.class AS class , contenttype.isaggregator FROM vb_contenttype AS contenttype INNER JOIN vb_package AS package ON package.packageid = contenttype.packageid LEFT JOIN vb_product AS product ON product.productid = package.productid WHERE product.active = 1 OR package.productid = 'vbulletin' )
Time Before: 0.04695 seconds
Time After: 0.04826 seconds
Time Taken: 0.00131 seconds
Memory Before: 13,889.289 KB
Memory After: 13,892.469 KB
Memory Used: 3.180 KB
REPLACE INTO vb_cache SET cacheid = 'vb_types.types', expires = 0, created = 1737140629, locktime = 0, data = "a:31:{i:0;a:7:{s:9:\"classtype\";s:7:\"package\";s:6:\"typeid\";s:1:\"1\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:9:\"vbulletin\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:7:\"vBForum\";s:12:\"isaggregator\";s:2:\"-1\";}i:1;a:7:{s:9:\"classtype\";s:7:\"package\";s:6:\"typeid\";s:1:\"2\";s:9:\"packageid\";s:1:\"2\";s:9:\"productid\";s:6:\"vbblog\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:6:\"vBBlog\";s:12:\"isaggregator\";s:2:\"-1\";}i:2;a:7:{s:9:\"classtype\";s:7:\"package\";s:6:\"typeid\";s:1:\"3\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:5:\"vbcms\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:5:\"vBCms\";s:12:\"isaggregator\";s:2:\"-1\";}i:3;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:1:\"8\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:5:\"Album\";s:12:\"isaggregator\";s:1:\"0\";}i:4;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:1:\"4\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:12:\"Announcement\";s:12:\"isaggregator\";s:1:\"0\";}i:5;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"14\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:8:\"Calendar\";s:12:\"isaggregator\";s:1:\"0\";}i:6;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"13\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:5:\"Event\";s:12:\"isaggregator\";s:1:\"0\";}i:7;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:1:\"3\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:5:\"Forum\";s:12:\"isaggregator\";s:1:\"0\";}i:8;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"23\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:10:\"Infraction\";s:12:\"isaggregator\";s:1:\"0\";}i:9;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:1:\"9\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:7:\"Picture\";s:12:\"isaggregator\";s:1:\"0\";}i:10;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"10\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:14:\"PictureComment\";s:12:\"isaggregator\";s:1:\"0\";}i:11;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:1:\"1\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:4:\"Post\";s:12:\"isaggregator\";s:1:\"0\";}i:12;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"22\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:14:\"PrivateMessage\";s:12:\"isaggregator\";s:1:\"0\";}i:13;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"24\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:9:\"Signature\";s:12:\"isaggregator\";s:1:\"0\";}i:14;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:1:\"7\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:11:\"SocialGroup\";s:12:\"isaggregator\";s:1:\"0\";}i:15;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:1:\"6\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:21:\"SocialGroupDiscussion\";s:12:\"isaggregator\";s:1:\"0\";}i:16;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:1:\"5\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:18:\"SocialGroupMessage\";s:12:\"isaggregator\";s:1:\"0\";}i:17;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:1:\"2\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:6:\"Thread\";s:12:\"isaggregator\";s:1:\"0\";}i:18;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"12\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:4:\"User\";s:12:\"isaggregator\";s:1:\"0\";}i:19;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"25\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:8:\"UserNote\";s:12:\"isaggregator\";s:1:\"0\";}i:20;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"11\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:14:\"VisitorMessage\";s:12:\"isaggregator\";s:1:\"0\";}i:21;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"16\";s:9:\"packageid\";s:1:\"2\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:11:\"BlogComment\";s:12:\"isaggregator\";s:1:\"0\";}i:22;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"27\";s:9:\"packageid\";s:1:\"2\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:15:\"BlogCustomBlock\";s:12:\"isaggregator\";s:1:\"0\";}i:23;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"26\";s:9:\"packageid\";s:1:\"2\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:15:\"BlogDescription\";s:12:\"isaggregator\";s:1:\"0\";}i:24;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"15\";s:9:\"packageid\";s:1:\"2\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:9:\"BlogEntry\";s:12:\"isaggregator\";s:1:\"0\";}i:25;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"18\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:7:\"Article\";s:12:\"isaggregator\";s:1:\"0\";}i:26;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"28\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:14:\"ArticleComment\";s:12:\"isaggregator\";s:1:\"0\";}i:27;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"19\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:11:\"ContentNode\";s:12:\"isaggregator\";s:1:\"0\";}i:28;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"21\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:7:\"PhpEval\";s:12:\"isaggregator\";s:1:\"0\";}i:29;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"17\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:7:\"Section\";s:12:\"isaggregator\";s:1:\"1\";}i:30;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"20\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:10:\"StaticPage\";s:12:\"isaggregator\";s:1:\"0\";}}", serialized = '1'
Time Before: 0.04851 seconds
Time After: 0.04870 seconds
Time Taken: 0.00019 seconds
Memory Before: 13,964.781 KB
Memory After: 13,958.320 KB
Memory Used: -6.461 KB
SELECT node.nodeid AS itemid, (node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid, node.layoutid, node.publishdate, node.setpublish, node.issection, parent.permissionsfrom as parentpermissions, node.permissionsfrom, node.publicpreview, node.showtitle, node.showuser, node.showpreviewonly, node.showall, node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren, node.shownav, node.hidden, node.nosearch, node.nodeleft, info.description, info.title, info.html_title, info.viewcount, info.creationdate, info.workflowdate, info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid, user.username, sectionorder.displayorder, thread.replycount, parentinfo.title AS parenttitle FROM vb_cms_node AS node INNER JOIN vb_cms_nodeinfo AS info ON info.nodeid = node.nodeid LEFT JOIN vb_user AS user ON user.userid = node.userid LEFT JOIN vb_thread AS thread ON thread.threadid = info.associatedthreadid LEFT JOIN vb_cms_sectionorder AS sectionorder ON sectionorder.sectionid = 1 AND sectionorder.nodeid = node.nodeid LEFT JOIN vb_cms_node AS parent ON parent.nodeid = node.parentnode LEFT JOIN vb_cms_nodeinfo AS parentinfo ON parentinfo.nodeid = parent.nodeid INNER JOIN vb_cms_node AS rootnode ON rootnode.nodeid = 1 AND (node.nodeleft >= rootnode.nodeleft AND node.nodeleft <= rootnode.noderight) AND node.nodeleft != rootnode.nodeleft AND node.contenttypeid <> 17 AND node.new != 1 AND ( (( (node.permissionsfrom IN (-1)) OR ( node.permissionsfrom in (1) AND (node.parentnode IN (1) OR node.nodeid = 1) AND node.setpublish > 0 AND node.publishdate < 1737140629 ))) OR (node.setpublish AND node.publishdate <1737140629 AND node.publicpreview > 0))AND node.hidden = 0 AND ((node.setpublish = '1' AND node.publishdate <= 1737140629 ) OR node.userid = 0) ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC, node.publishdate DESC LIMIT 0, 7
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rootnode | const | PRIMARY,nodeleft,noderight | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
1 | SIMPLE | node | range | PRIMARY,contentid,nodeleft,parentnode,contenttype,publishdate,new | nodeleft | 4 | 3 | Using index condition; Using where | |
1 | SIMPLE | info | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.node.nodeid | 1 | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.node.userid | 1 | |
1 | SIMPLE | thread | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.info.associatedthreadid | 1 | |
1 | SIMPLE | sectionorder | eq_ref | sectionid | sectionid | 8 | const,zabvo_db.node.nodeid | 1 | Using where |
1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.node.parentnode | 1 | |
1 | SIMPLE | parentinfo | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.parent.nodeid | 1 |
Time Before: 0.05145 seconds
Time After: 0.05249 seconds
Time Taken: 0.00104 seconds
Memory Before: 14,264.508 KB
Memory After: 14,265.813 KB
Memory Used: 1.305 KB
SELECT FOUND_ROWS() AS qty
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | No tables used |
Time Before: 0.05266 seconds
Time After: 0.05271 seconds
Time Taken: 0.00005 seconds
Memory Before: 14,262.305 KB
Memory After: 14,264.367 KB
Memory Used: 2.063 KB
SELECT fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize, a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder, at.contenttypes FROM vb_attachment AS a INNER JOIN vb_filedata AS fd ON (fd.filedataid = a.filedataid) LEFT JOIN vb_attachmenttype AS at ON (at.extension = fd.extension) WHERE a.contentid = 19 AND a.contenttypeid = 18 ORDER BY a.contentid, a.displayorder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | contenttypeid,contentid,filedataid | contenttypeid | 8 | const,const | 1 | Using where; Using filesort |
1 | SIMPLE | fd | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.a.filedataid | 1 | |
1 | SIMPLE | at | eq_ref | PRIMARY | PRIMARY | 60 | zabvo_db.fd.extension | 1 | Using where |
Time Before: 0.05727 seconds
Time After: 0.05751 seconds
Time Taken: 0.00024 seconds
Memory Before: 15,496.883 KB
Memory After: 15,498.617 KB
Memory Used: 1.734 KB
SELECT category, cat.categoryid FROM vb_cms_nodecategory nc INNER JOIN vb_cms_category cat ON cat.categoryid = nc.categoryid WHERE nc.nodeid = 19
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cat | system | PRIMARY | 1 | ||||
1 | SIMPLE | nc | const | PRIMARY,categoryid | PRIMARY | 8 | const,const | 1 | Using index |
Time Before: 0.05882 seconds
Time After: 0.05891 seconds
Time Taken: 0.00009 seconds
Memory Before: 15,500.039 KB
Memory After: 15,501.984 KB
Memory Used: 1.945 KB
SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM vb_user AS user LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) WHERE user.userid = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
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.06485 seconds
Time After: 0.06505 seconds
Time Taken: 0.00021 seconds
Memory Before: 17,575.977 KB
Memory After: 17,579.141 KB
Memory Used: 3.164 KB
SELECT title FROM vb_template WHERE title LIKE 'vbcms_%section%' OR title LIKE 'vbcms_%content%' OR title LIKE 'vbcms_%edit%' OR title LIKE 'vbcms_%comments%' OR title LIKE 'vbcms_%grid%' OR title LIKE 'vbcms_%widget%' OR title LIKE 'vbcms_%searchresult%' OR title LIKE 'editor_%' OR title LIKE 'newpost_%' OR title LIKE 'vbcms_%postbit%'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_template | range | title | title | 302 | 430 | Using where; Using index |
Time Before: 0.06661 seconds
Time After: 0.06760 seconds
Time Taken: 0.00099 seconds
Memory Before: 17,749.234 KB
Memory After: 17,756.703 KB
Memory Used: 7.469 KB
SELECT title, template FROM vb_template WHERE templateid IN (3989,715,4322,4323,0,0,980,974,3381,978,979,977,4312,981,982,4318,3696,3992,3642,3646,3643,3644,3645,4008,0,0,3971,3973,3666,3667,3669,3670,3893,3935,3934,3984,3936,3493,3492,3496,3054,3951,3175,3195,3434,3855,3138,3970,3727,3732,3730,2921,2922,3478,3479,3480,3481,3482,0,3483,3484,3485,3486,3487,3488,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3489,0,3652,3653,3654,3655,3656,3657,3658,3659,3660,3139,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3166,0,0,3167,3168,3169,3170,3171,3172,1744,0,3176,3177,3178,3179,3180,3182,0,3183,3184,3185,3186,0,3187,3188,0,3189,3190,3191,3192,3193,3194,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3231,3232,3233,3234,3235,3236,3237,3238,3239,3240,3241,3242,3243,3244,3245,3246,3247,3248,3249,3250,3251,3252,3253,3254,3255,3256,3257,3258,3259,3260,3261)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_template | range | PRIMARY | PRIMARY | 4 | 188 | Using index condition |
Time Before: 0.06894 seconds
Time After: 0.07008 seconds
Time Taken: 0.00114 seconds
Memory Before: 18,063.203 KB
Memory After: 18,068.617 KB
Memory Used: 5.414 KB
SELECT category, cat.categoryid FROM vb_cms_nodecategory nc INNER JOIN vb_cms_category cat ON cat.categoryid = nc.categoryid WHERE nc.nodeid = 10
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cat | system | PRIMARY | 1 | ||||
1 | SIMPLE | nc | const | PRIMARY,categoryid | PRIMARY | 8 | const,const | 1 | Using index |
Time Before: 0.07452 seconds
Time After: 0.07461 seconds
Time Taken: 0.00009 seconds
Memory Before: 18,498.883 KB
Memory After: 18,500.828 KB
Memory Used: 1.945 KB
SELECT usergroupid, membergroupids FROM vb_user WHERE userid = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.07575 seconds
Time After: 0.07583 seconds
Time Taken: 0.00008 seconds
Memory Before: 18,510.594 KB
Memory After: 18,512.617 KB
Memory Used: 2.023 KB
SELECT vbcmspermissions FROM vb_administrator WHERE userid = 1
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.07597 seconds
Time After: 0.07603 seconds
Time Taken: 0.00005 seconds
Memory Before: 18,512.945 KB
Memory After: 18,514.945 KB
Memory Used: 2.000 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 vb_cms_permissions p WHERE usergroupid IN (8) GROUP BY nodeid;
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | p | ref | usergroupid,nodeid | usergroupid | 4 | const | 1 | Using where |
Time Before: 0.07621 seconds
Time After: 0.07631 seconds
Time Taken: 0.00010 seconds
Memory Before: 18,513.195 KB
Memory After: 18,515.063 KB
Memory Used: 1.867 KB
REPLACE INTO vb_cache SET cacheid = 'cms_priv_user_1', expires = 1737140929, created = 1737140629, 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.07639 seconds
Time After: 0.07652 seconds
Time Taken: 0.00013 seconds
Memory Before: 18,520.328 KB
Memory After: 18,520.266 KB
Memory Used: -0.063 KB
SELECT category, cat.categoryid FROM vb_cms_nodecategory nc INNER JOIN vb_cms_category cat ON cat.categoryid = nc.categoryid WHERE nc.nodeid = 3
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.07740 seconds
Time After: 0.07748 seconds
Time Taken: 0.00008 seconds
Memory Before: 18,531.563 KB
Memory After: 18,533.477 KB
Memory Used: 1.914 KB
SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM vb_user AS user LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) WHERE user.userid = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
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.07808 seconds
Time After: 0.07829 seconds
Time Taken: 0.00021 seconds
Memory Before: 18,534.977 KB
Memory After: 18,538.141 KB
Memory Used: 3.164 KB
SELECT layout.layoutid AS itemid, layout.title , layout.gridid, layout.contentcolumn, layout.contentindex FROM vb_cms_layout AS layout WHERE layoutid = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | layout | system | PRIMARY | 1 |
Time Before: 0.08006 seconds
Time After: 0.08015 seconds
Time Taken: 0.00008 seconds
Memory Before: 18,537.305 KB
Memory After: 18,539.266 KB
Memory Used: 1.961 KB
SELECT widgetid, layoutcolumn AS `column`, layoutindex AS `index` FROM vb_cms_layoutwidget WHERE layoutid = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_cms_layoutwidget | ref | layoutid | layoutid | 4 | const | 2 |
Time Before: 0.08123 seconds
Time After: 0.08133 seconds
Time Taken: 0.00010 seconds
Memory Before: 18,538.578 KB
Memory After: 18,540.586 KB
Memory Used: 2.008 KB
SELECT widget.widgetid AS itemid ,widget.title, widget.description, widget.widgettypeid FROM vb_cms_widget AS widget WHERE 1=1 AND widget.widgetid IN (3,2,4) ORDER BY widget.title ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | widget | ALL | PRIMARY | 4 | Using where; Using filesort |
Time Before: 0.08258 seconds
Time After: 0.08269 seconds
Time Taken: 0.00011 seconds
Memory Before: 18,839.766 KB
Memory After: 18,841.750 KB
Memory Used: 1.984 KB
SELECT widgetid AS itemid, name, value, (nodeid = 0) instance, serialized FROM vb_cms_widgetconfig WHERE widgetid IN (3,4,2) AND nodeid = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_cms_widgetconfig | ALL | PRIMARY | 10 | Using where |
Time Before: 0.08334 seconds
Time After: 0.08347 seconds
Time Taken: 0.00013 seconds
Memory Before: 18,950.313 KB
Memory After: 18,952.703 KB
Memory Used: 2.391 KB
SELECT phrasegroup_contenttypes AS contenttypes,phrasegroup_global AS global,phrasegroup_vbcms AS vbcms,phrasegroup_search AS search 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.08954 seconds
Time After: 0.09023 seconds
Time Taken: 0.00069 seconds
Memory Before: 20,624.414 KB
Memory After: 20,626.352 KB
Memory Used: 1.938 KB
SELECT searchlog.* FROM vb_searchlog AS searchlog WHERE searchhash = '270a6dd1c2dcaa0df6214e150323e200' AND sortby = 'replycount' AND sortorder = 'desc' AND dateline > 1737137029 AND userid = 0 AND completed = 1 ORDER BY dateline DESC LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | searchlog | ref | search,userfloodcheck | search | 150 | const,const,const,const | 1 | Using index condition; Using where; Using filesort |
Time Before: 0.09148 seconds
Time After: 0.09163 seconds
Time Taken: 0.00015 seconds
Memory Before: 21,015.844 KB
Memory After: 21,017.688 KB
Memory Used: 1.844 KB
SELECT searchgroup.searchgroupid , thread.replycount FROM vb_searchgroup AS searchgroup INNER JOIN vb_thread AS thread ON ( searchgroup.contenttypeid = 2 AND searchgroup.groupid = thread.threadid) WHERE searchgroup.dateline >= 1737054229 AND thread.replycount >= '2' AND searchgroup.contenttypeid IN ('2')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | searchgroup | range | groupunique,dateline | dateline | 4 | 5 | Using index condition; Using where | |
1 | SIMPLE | thread | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.searchgroup.groupid | 1 | Using where |
Time Before: 0.09215 seconds
Time After: 0.09232 seconds
Time Taken: 0.00017 seconds
Memory Before: 21,020.789 KB
Memory After: 21,022.602 KB
Memory Used: 1.813 KB
SELECT searchgroup.contenttypeid, searchgroup.groupid, searchgroup.searchgroupid FROM vb_searchgroup AS searchgroup WHERE searchgroup.searchgroupid IN (168,70,713)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | searchgroup | range | PRIMARY | PRIMARY | 4 | 3 | Using index condition |
Time Before: 0.09252 seconds
Time After: 0.09261 seconds
Time Taken: 0.00009 seconds
Memory Before: 21,022.055 KB
Memory After: 21,024.039 KB
Memory Used: 1.984 KB
REPLACE INTO vb_searchlog (userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,criteria,results) VALUES (0,'18.97.14.88','270a6dd1c2dcaa0df6214e150323e200','replycount','desc',0,1737140629,0,'O:18:\"vB_Search_Criteria\":15:{s:28:\"\0vB_Search_Criteria\0keywords\";a:0:{}s:32:\"\0vB_Search_Criteria\0raw_keywords\";s:0:\"\";s:29:\"\0vB_Search_Criteria\0titleonly\";b:0;s:27:\"\0vB_Search_Criteria\0filters\";a:3:{s:11:\"contenttype\";a:1:{s:2:\"eq\";a:1:{i:0;i:1;}}s:13:\"groupdateline\";a:1:{s:2:\"gt\";i:1737054229;}s:10:\"replycount\";a:1:{s:2:\"gt\";s:1:\"2\";}}s:24:\"\0vB_Search_Criteria\0sort\";a:2:{i:0;s:10:\"replycount\";i:1;s:4:\"desc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i:1;s:31:\"\0vB_Search_Criteria\0searchterms\";N;s:32:\"\0vB_Search_Criteria\0criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";s:1:\"1\";s:35:\"\0vB_Search_Criteria\0display_strings\";a:2:{s:4:\"type\";s:20:\": Сообщения\";s:4:\"date\";s:22:\"Дата 16.01.2025\";}s:32:\"\0vB_Search_Criteria\0common_words\";a:0:{}s:30:\"\0vB_Search_Criteria\0highlights\";a:0:{}s:33:\"\0vB_Search_Criteria\0search_string\";N;s:26:\"\0vB_Search_Criteria\0errors\";a:1:{i:0;a:3:{i:0;s:9:\"invalidid\";i:1;s:10:\"Форум\";i:2;s:50:\"sendmessage.php?s=f73556449771cb402f27e6737b45bf41\";}}s:11:\"search_type\";s:8:\"advanced\";}','')
Time Before: 0.09272 seconds
Time After: 0.09289 seconds
Time Taken: 0.00017 seconds
Memory Before: 21,028.930 KB
Memory After: 21,028.016 KB
Memory Used: -0.914 KB
UPDATE vb_searchlog SET results = 'a:4:{i:0;a:3:{i:0;a:2:{i:0;s:1:\"2\";i:1;s:2:\"74\";}i:1;a:2:{i:0;s:1:\"2\";i:1;s:2:\"30\";}i:2;a:2:{i:0;s:1:\"2\";i:1;s:3:\"323\";}}i:1;i:-1;i:2;N;i:3;N;}' WHERE searchlogid = 5092016
Time Before: 0.09295 seconds
Time After: 0.09305 seconds
Time Taken: 0.00010 seconds
Memory Before: 21,022.898 KB
Memory After: 21,023.109 KB
Memory Used: 0.211 KB
UPDATE vb_searchlog SET searchtime = 0.00140, completed = 1 WHERE searchlogid = 5092016
Time Before: 0.09308 seconds
Time After: 0.09316 seconds
Time Taken: 0.00008 seconds
Memory Before: 21,022.289 KB
Memory After: 21,022.633 KB
Memory Used: 0.344 KB
SELECT moderator.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM vb_moderator AS moderator INNER JOIN vb_user AS user USING(userid)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | moderator | ALL | userid_forumid | 4 | ||||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.moderator.userid | 1 |
Time Before: 0.09459 seconds
Time After: 0.09475 seconds
Time Taken: 0.00016 seconds
Memory Before: 21,396.617 KB
Memory After: 21,398.789 KB
Memory Used: 2.172 KB
SELECT thread.*,post.pagetext AS preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision, customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height, customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb, first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath, NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline, first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS first_filedata_thumb,lastpost.lastposttime FROM vb_thread AS thread LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid) LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_user AS first_user ON (first_user.userid = thread.postuserid) LEFT JOIN vb_avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid) LEFT JOIN vb_customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid) LEFT JOIN ( SELECT threadid, MAX(dateline) AS lastposttime FROM vb_post WHERE threadid IN (74,30,323) AND userid = 0 GROUP BY threadid ) AS lastpost ON (lastpost.threadid = thread.threadid) WHERE thread.threadid IN (74,30,323)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | avatar | system | PRIMARY | 0 | const row not found | |||
1 | PRIMARY | first_avatar | system | PRIMARY | 0 | const row not found | |||
1 | PRIMARY | thread | range | PRIMARY | PRIMARY | 4 | 3 | Using index condition | |
1 | PRIMARY | post | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.thread.firstpostid | 1 | |
1 | PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.thread.lastposterid | 1 | |
1 | PRIMARY | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.user.userid | 1 | |
1 | PRIMARY | first_user | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.thread.postuserid | 1 | |
1 | PRIMARY | first_customavatar | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.first_user.userid | 1 | |
1 | PRIMARY | ref | 4 | zabvo_db.thread.threadid | 2 | ||||
2 | DERIVED | vb_post | range | threadid,threadid_visible_dateline,userid,user_date | threadid | 8 | 35 | Using index condition |
Time Before: 0.09657 seconds
Time After: 0.09727 seconds
Time Taken: 0.00070 seconds
Memory Before: 21,423.594 KB
Memory After: 21,425.563 KB
Memory Used: 1.969 KB
UPDATE vb_searchlog SET results = 'a:4:{i:0;a:3:{i:0;a:2:{i:0;s:1:\"2\";i:1;s:2:\"74\";}i:1;a:2:{i:0;s:1:\"2\";i:1;s:2:\"30\";}i:2;a:2:{i:0;s:1:\"2\";i:1;s:3:\"323\";}}i:1;i:2;i:2;a:1:{i:2;a:3:{i:0;s:2:\"74\";i:1;s:2:\"30\";i:2;s:3:\"323\";}}i:3;a:1:{i:2;a:0:{}}}' WHERE searchlogid = 5092016
Time Before: 0.09838 seconds
Time After: 0.09859 seconds
Time Taken: 0.00021 seconds
Memory Before: 21,585.695 KB
Memory After: 21,585.836 KB
Memory Used: 0.141 KB
REPLACE INTO vb_cache SET cacheid = 'widget_3.2269a700121855225b5fbd0a3f311b46', expires = 1737140929, created = 1737140629, locktime = 0, data = "a:3:{i:0;O:28:\"vBForum_Search_Result_Thread\":2:{s:39:\"\0vBForum_Search_Result_Thread\0replydata\";a:0:{}s:36:\"\0vBForum_Search_Result_Thread\0thread\";O:16:\"vB_Legacy_Thread\":5:{s:23:\"\0vB_Legacy_Thread\0forum\";N;s:28:\"\0vB_Legacy_Thread\0subscribed\";a:0:{}s:26:\"\0vB_Legacy_Thread\0lastread\";a:0:{}s:26:\"\0vB_Legacy_Thread\0lastpost\";a:1:{i:0;s:10:\"1356200135\";}s:9:\"\0*\0record\";a:50:{s:8:\"threadid\";s:2:\"74\";s:5:\"title\";s:43:\"Погода там где мы живём.\";s:8:\"prefixid\";s:0:\"\";s:11:\"firstpostid\";s:4:\"6898\";s:10:\"lastpostid\";s:6:\"403742\";s:8:\"lastpost\";s:10:\"1737106410\";s:7:\"forumid\";s:2:\"17\";s:6:\"pollid\";s:1:\"0\";s:4:\"open\";s:1:\"1\";s:10:\"replycount\";s:5:\"23626\";s:11:\"hiddencount\";s:1:\"0\";s:12:\"deletedcount\";s:3:\"119\";s:12:\"postusername\";s:12:\"Замок79\";s:10:\"postuserid\";s:2:\"64\";s:10:\"lastposter\";s:25:\"Сергей Карцев\";s:12:\"lastposterid\";s:4:\"3643\";s:8:\"dateline\";s:10:\"1265125897\";s:5:\"views\";s:7:\"6788831\";s:6:\"iconid\";s:1:\"0\";s:5:\"notes\";s:0:\"\";s:7:\"visible\";s:1:\"1\";s:6:\"sticky\";s:1:\"0\";s:7:\"votenum\";s:2:\"12\";s:9:\"votetotal\";s:2:\"60\";s:6:\"attach\";s:4:\"1058\";s:7:\"similar\";s:0:\"\";s:7:\"taglist\";N;s:8:\"keywords\";s:126:\"января, градус, широты, северной, дворе, живём, дождь, пасмурно, погода\";s:16:\"firstpoststicked\";s:1:\"0\";s:11:\"postercount\";s:3:\"103\";s:7:\"preview\";s:141:\"Мужики я послушаю савета Михаила,и с вашего разрешения открою ветку о погоде.\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"1\";s:14:\"avatarrevision\";s:1:\"0\";s:14:\"avatardateline\";s:10:\"1576941507\";s:5:\"width\";s:3:\"100\";s:6:\"height\";s:3:\"155\";s:12:\"height_thumb\";s:2:\"80\";s:11:\"width_thumb\";s:2:\"52\";s:14:\"filedata_thumb\";s:1973:\"\0JFIF\0\0\0\0\0\0\0;CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 75\n\0C\0 \n\r\Z\Z $.\' \",#(7),01444\'9=82<.342\0C \r\r2!!22222222222222222222222222222222222222222222222222\0\0P\04\"\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\n1Ao?gk͎c-0[HPGpR1n.y) \0`;\ZmcXi[)|{}y˨j% E4TuI<l\0Fqh-2L<+W7\Z}Ԃ)/!.-HÁ;ϰLGۛ:5qu13*gx4B[%M(N\'Yl}8Qkt{6}9ߊL{G0jP](=[OV\'H8ފ.Z\0\'yf|Meid0\'+ump\n;z*-1ṷܹcxOŖKji~.vye~r ʜu^F}+5uGfnF}^~;=.\"${p7OsW l $2杄t~uXAgnv E>Y\0:kנK(P*XĊsfg.Ybc?\0{`xt(&Ͱds&efHe\rȢ!:_N^]\\Ckp$CWGMx5l-N&&v?Wx\0@յK\'\ZyL\'W;9KD2\\l~m1.}k͡a9u%դT\Znr[[bV;3[[ׯ-?Xs^4FcUzNs^:\nTy̓\nZ+s\0\0Gu\"H2i|$/(\0Ojg/O܆G 0f?ZYY[ywl\0ee\0uֺ\ZcfqZ:DTl}j0(J(\";s:20:\"first_avatarrevision\";s:1:\"0\";s:16:\"first_avatarpath\";N;s:21:\"first_hascustomavatar\";s:1:\"1\";s:20:\"first_avatardateline\";s:10:\"1366011127\";s:11:\"first_width\";s:2:\"80\";s:12:\"first_height\";s:3:\"160\";s:18:\"first_height_thumb\";s:2:\"80\";s:17:\"first_width_thumb\";s:2:\"40\";s:20:\"first_filedata_thumb\";s:1682:\"\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鼔y}ǽNֱQW\";ݱfF\r!Ʃj^XG?U Aj*[`EGTfCI\0Q@\\؊\ZL4ɗd{\nI8\0}j[ȴGRĕAҼŚ)P6\"z\0-4\08F!7$g*{H\rb\\I,]QSNI{k$~1u\rK[\\dsӎF5>]6j#rJ1a8@#][ܦF -uPϯSכ\0 H-yk.HN㣱|K5;}o\ZG pճ\'5\rBC)o[7590]|WJ5huX>G q$3Фa\ZkL@\0Old\0~)+-XYD-a3\ZFg`zPe\\\0u]]b+Y\'=FhҢ]M@>Xv#h3E5om|PmCZ%,Lr?J<\0zE>kw{W6$d=;\0\Z\05[XtX(rdc\\[v7\\@x,q%Ava$M (HgҹZTVXٛz|q`lc3z\0\'Zb#r67\'\nb7~CzB!Y\n3?\nLG~hqaOϰ|\0k&*vc~{fơlp\\~Pe)&a߸+\00\0mpEk]nxmE<ׅ3+{ᆮuuos;EoyYk㠑o\ZZ[RnInc 9^h *ƣ 㠮 4]Ykih1d*ۆx=k]/cd[ !-PNN\nwɏwњ8{kݍ(1CyyӚ_U0\nny[0czFXh_*n57w)Jɣ|W.%0wtSt6kDud-U6ߑy7]\\7I2R\",hT\0\0Ua_AQE1\";s:20:\"first_avatarrevision\";s:1:\"0\";s:16:\"first_avatarpath\";N;s:21:\"first_hascustomavatar\";s:1:\"1\";s:20:\"first_avatardateline\";s:10:\"1450171224\";s:11:\"first_width\";s:3:\"100\";s:12:\"first_height\";s:3:\"131\";s:18:\"first_height_thumb\";s:2:\"79\";s:17:\"first_width_thumb\";s:2:\"60\";s:20:\"first_filedata_thumb\";s:2016:\"\0JFIF\0\0\0\0\0\0\0;CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 75\n\0C\0 \n\r\Z\Z $.\' \",#(7),01444\'9=82<.342\0C \r\r2!!22222222222222222222222222222222222222222222222222\0\0O\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?\0Odh3_lX%O\0|kJO0C\Z^xVRBkB9:+I Zޞ\Zc%8kW9r:ViZ0L_n\\$h/:$lw}wWzTrI,Lb,L@+=\\,Iou\0,v-CGpjETl-D4-@OZ+r1ֹ{dU!˿Q1ҬŨl饽\\rG\ZkS3×6C3c H/[XS^\\Gkr6\'Fva\"hW٧)%im߳nn9.dxnZڇpתH\';W57vVtت%9A1w/$:Hc{fx Z23ن?:ek\0>\0߱\\*EtyΔvgZ[R(N?J|@kbF1\"~3c?JǷS\rk\0kUU#fF.h㛉BSd1\0Kzycj\0q*VzOt/,z\0lgY\\nZ; \rŊ6f;p,;izVi )\n*JNQ?zq\0\Z`}MJ\"|moG4$kKE2 TEpVm|&$Fe0͖P#Sӥz\0tpeI4\0C <4.,||TVT<><|vtLFD,&$lfd\\b\\Ĕ$&$|ztTNL<64trl,2,¼db\\DJL\\ZT|$ĺDB<,*$|~tv|LRLdjd4:4~Ĵľljd|~ttvl\\^dDFL,.4|d^\\Ԅ~tlnt42,LJDTRL<:4lbd\\^\\$\"DFD,.,\"$tz|LNTdfl46 D|TV\\<>D|v|lfl\\bd$&,|z|trt,24dbd\\Z\\DBD,*,LRTdjl4:<ľljl|~|tvtd^d~|424LJLTRT<:<$\"$\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0,\0\0\0\0<\0J\0\0\0CPD@P(QAE|xTX0DQ+x|@\Ztb\'BA!DK,yx\'ψoBzÙXPd \'f24\n PXyjG\Z=\"!XRzf4rҙ\'/+t́Y(,9͉CĔɐF^E|֭;w/VZw2m6Ab\rVfKS*\rLV8p)wݭK.3ZJQM0 lDB0|:%T*\"h\'thTUDǠ%T)fz9LG6H\n\ZR*+ŷz,UUeg%$\n\'ah2,П\nlH\"tzT^K\'Yԙp,1#h|p+z| ,l&Dp \'UoK5_\'s0tX0!\0lh,<0I&p,u^}AJQp,z \00\'/&*EU[I6Rw& zk `1xr $@\'q@O|9U]eGĒB\ZI -\0 -jB< TK!%PJU W\"+mA q$I@\0@@Bi\")faJ&|4 \nc;8JL@#\0G F$9d+1h%|\"QLD%d4UYROq\n!cB+\0(=@%d%9F!ҤEጶG补`!q\0k<(c*fT \nzRym!J$$%H \' AiP,3|rB(7H!xL10z]Ǚ_)\\JL\ZQ0[R ˏ2)2\r\n +L`Rݥ>pZf & \n($\nGx!$ \ncp>\r\00<hC(*!FA\0X*q8\"\npD(>!JBN\0\n1\nРqYd)p;\\pAL8*tpD%zB\\@pQ \\zH|K\nB/\0~8HF\\&u\0$6Ө0 D7hU\n +xٌRdЈb%XPBaXXE&DHY+?. CPB\0P`A>5@(P&y&@@.@+ϐτ3.\n\\`)wAi.щBaO$ 2d X Xh\'b>Rwf`\0N< `0`fHPԴ\0$}Qp\0^pr&gP0\0D0 @tA0P\'P0o^quDTr\n\nP\0\0\0f0 0pqd]aH$.E)` aP\"!0\nn2Piryp^\0 \nUJ ~]E)Q:\0\n(v K pPQ2`np\nn\nڅ/E]]-|0 @\n@:` `@\0y T<~\0dHUP2r% y@\n^ HU\0f\n\n\\@\n\0Ef \0KX(FDfP 3`&34?8P\0Li \ny\0P\"\n\n@0o| !0P {tL cfp T0I*o 0pz\nWY) \\@\0.!7FD~w8 08( 00^9o0 P nC\nI [T=9 & I\n\0^y\0g\n\n\\В@ l3J98nQ{MM@@0 p\n8\n\n@8\0Q G8CE\n \0<\n?@\\LC0Wp \n\"\n yPcp9o@-ɏ 4i0s,0s\0O9Inu\0o\n\\@\n<8z\n0R镙Y \nvŏny)5f@0 @^ @?0c9@\n\\\0O@\\\'٩*9:9<?\ry\n&p\nn?@\n0xB\\ [nPr0 <yPx\Z嬒\nA S@\050UYH0\nCY,6x)F6c`I\n07B`x`*MȩWY\Zxc?S? x#*pzHCc\0U@yB:?\\DT *0Zp\0* =Y `QC [:xS \\CS2kzKUefk@\r2LD˷?0\ZAc=kpKDjıS[ k =?вlzkZ= ռ%0\n!\\][;!MUwd3G:\n SNeՓbQ+=Y 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:6:\"userid\";s:4:\"1226\";}}}}", serialized = '1'
Time Before: 0.09899 seconds
Time After: 0.10026 seconds
Time Taken: 0.00127 seconds
Memory Before: 21,674.789 KB
Memory After: 21,652.203 KB
Memory Used: -22.586 KB
SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'widget_2.f97f8ca801e0809eb9010ca389b7f251'
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.10503 seconds
Time After: 0.10511 seconds
Time Taken: 0.00009 seconds
Memory Before: 21,965.508 KB
Memory After: 21,967.500 KB
Memory Used: 1.992 KB
UPDATE vb_cache SET locktime = 1737140629 WHERE cacheid = 'widget_2.f97f8ca801e0809eb9010ca389b7f251'
Time Before: 0.10516 seconds
Time After: 0.10525 seconds
Time Taken: 0.00009 seconds
Memory Before: 21,966.820 KB
Memory After: 21,967.148 KB
Memory Used: 0.328 KB
SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername, thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost, thread.lastposterid, thread.lastposter, thread.replycount, forum.forumid, forum.title_clean as forumtitle, post.pagetext AS message, post.allowsmilie, post.postid, user.userid, user.username, user.avatarrevision, thread.lastposter AS lastpostername ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight FROM vb_thread AS thread INNER JOIN vb_forum AS forum ON(forum.forumid = thread.forumid) LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid) LEFT JOIN vb_user AS user ON (thread.postuserid = 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 1=1 AND ( thread.forumid IN(1,2,16,17,23,26,3,13,15,19,4,5,6,7,8,9,10,11,12,14,18,38,28,33,36,20,21,22,34) AND thread.visible = 1 AND post.visible = 1 AND open <> 10 AND thread.dateline > 1736535829 AND (thread.forumid <> 27) ) ORDER BY thread.dateline DESC LIMIT 0,6
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 | thread | range | forumid,forumid_lastpost,dateline | dateline | 4 | 2 | Using index condition; Using where | |
1 | SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 2 | zabvo_db.thread.forumid | 1 | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.thread.postuserid | 1 | |
1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.user.userid | 1 | |
1 | SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | zabvo_db.thread.firstpostid | 1 | Using where |
Time Before: 0.10582 seconds
Time After: 0.10609 seconds
Time Taken: 0.00027 seconds
Memory Before: 21,979.523 KB
Memory After: 21,980.453 KB
Memory Used: 0.930 KB
SELECT * FROM vb_bbcode
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_bbcode | ALL | 6 |
Time Before: 0.11094 seconds
Time After: 0.11105 seconds
Time Taken: 0.00011 seconds
Memory Before: 22,867.125 KB
Memory After: 22,869.680 KB
Memory Used: 2.555 KB
REPLACE INTO vb_cache SET cacheid = 'widget_2.f97f8ca801e0809eb9010ca389b7f251', expires = 1737140929, created = 1737140629, locktime = 0, data = "1", serialized = '0'
Time Before: 0.11119 seconds
Time After: 0.11130 seconds
Time Taken: 0.00011 seconds
Memory Before: 22,867.367 KB
Memory After: 22,867.617 KB
Memory Used: 0.250 KB
SELECT phrasegroup_messaging AS messaging 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.11255 seconds
Time After: 0.11279 seconds
Time Taken: 0.00024 seconds
Memory Before: 22,880.867 KB
Memory After: 22,882.875 KB
Memory Used: 2.008 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.11374 seconds
Time After: 0.11394 seconds
Time Taken: 0.00020 seconds
Memory Before: 23,123.641 KB
Memory After: 23,129.641 KB
Memory Used: 6.000 KB
REPLACE INTO vb_cacheevent (cacheid, event) VALUES ('vbcms_nav_.fea43f89061af446a212dce956aad951', 'vbcms_nav_1'), ('vbcms_nav_.fea43f89061af446a212dce956aad951', 'vbcms_nav_global'), ('vbcms_nav_.fea43f89061af446a212dce956aad951', 'sections_updated'), ('cms_priv_user_9', 'cms_permissions_change'), ('cms_priv_user_9', 'permissions_9'), ('vb_types.types', 'vb_types.type_updated'), ('vb_types.types', 'vb_types.package_updated'), ('vb_types.types', 'vb_types.contenttype_updated'), ('cms_priv_user_1', 'cms_permissions_change'), ('cms_priv_user_1', 'permissions_1'), ('widget_3.2269a700121855225b5fbd0a3f311b46', 'widget_3.7cdb8d8d97d041691b89dd1f24fdbeae'), ('widget_2.f97f8ca801e0809eb9010ca389b7f251', '1')
Time Before: 0.11852 seconds
Time After: 0.11907 seconds
Time Taken: 0.00055 seconds
Memory Before: 23,137.180 KB
Memory After: 23,136.883 KB
Memory Used: -0.297 KB
SELECT cacheid FROM vb_cacheevent WHERE event IN ('vbcms_nav_1','vbcms_nav_19','vbcms_nav_10','vbcms_nav_3')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_cacheevent | index | PRIMARY | 118 | 94 | Using where; Using index |
Time Before: 0.11928 seconds
Time After: 0.11942 seconds
Time Taken: 0.00014 seconds
Memory Before: 23,128.672 KB
Memory After: 23,130.695 KB
Memory Used: 2.023 KB
UPDATE vb_cache SET expires = 1737140628 WHERE cacheid IN ('vbcms_nav_.17335fd575321809dbba67213d258597','vbcms_nav_.8003f6e9126b2509bbf75303ab83d755','vbcms_nav_.9f8ad813b7fd261dbdbe989d634e8e3d','vbcms_nav_.cb938a0722be7d0a90a0bdf5e09170f3','vbcms_nav_.fea43f89061af446a212dce956aad951')
Time Before: 0.11950 seconds
Time After: 0.11983 seconds
Time Taken: 0.00033 seconds
Memory Before: 23,128.875 KB
Memory After: 23,129.023 KB
Memory Used: 0.148 KB
UPDATE vb_session SET lastactivity = 1737140629, location = 'route:content|wol|viewing_page|%D0%9D%D0%BE%D0%B2%D0%BE%D1%81%D1%82%D0%B8', badlocation = 0 WHERE sessionhash = 'f73556449771cb402f27e6737b45bf41'
Time Before: 0.11993 seconds
Time After: 0.12005 seconds
Time Taken: 0.00011 seconds
Memory Before: 23,131.539 KB
Memory After: 23,131.750 KB
Memory Used: 0.211 KB