Time Before: 0.00792 seconds
Time After: 0.01945 seconds
Time Taken: 0.01154 seconds
Memory Before: 1,568.414 KB
Memory After: 2,763.125 KB
Memory Used: 1,194.711 KB
Time Before: 0.01975 seconds
Time After: 0.02118 seconds
Time Taken: 0.00142 seconds
Memory Before: 2,763.109 KB
Memory After: 2,770.703 KB
Memory Used: 7.594 KB
SET @@sql_mode = ''
Time Before: 0.02146 seconds
Time After: 0.02167 seconds
Time Taken: 0.00021 seconds
Memory Before: 2,771.383 KB
Memory After: 2,771.945 KB
Memory Used: 0.563 KB
SELECT * FROM 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 | datastore | ALL | PRIMARY | 31 | Using where |
Time Before: 0.02222 seconds
Time After: 0.02261 seconds
Time Taken: 0.00039 seconds
Memory Before: 2,774.891 KB
Memory After: 2,796.680 KB
Memory Used: 21.789 KB
Time Before: 0.02173 seconds
Time After: 0.02383 seconds
Time Taken: 0.00210 seconds
Memory Before: 2,771.188 KB
Memory After: 3,150.914 KB
Memory Used: 379.727 KB
SELECT * FROM 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.02718 seconds
Time After: 0.02735 seconds
Time Taken: 0.00017 seconds
Memory Before: 3,724.320 KB
Memory After: 3,726.789 KB
Memory Used: 2.469 KB
SELECT * FROM session WHERE userid = 0 AND host = '3.239.236.140' AND idhash = '5acd19b10503116278910752cd2d1f60' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | ref | user_activity,guest_lookup | guest_lookup | 51 | const,const,const | 2 | Using where |
Time Before: 0.02815 seconds
Time After: 0.02838 seconds
Time Taken: 0.00023 seconds
Memory Before: 3,741.938 KB
Memory After: 3,748.141 KB
Memory Used: 6.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 language WHERE languageid = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | language | system | PRIMARY | 1 |
Time Before: 0.02902 seconds
Time After: 0.02953 seconds
Time Taken: 0.00051 seconds
Memory Before: 3,753.859 KB
Memory After: 3,791.313 KB
Memory Used: 37.453 KB
Time Before: 0.02761 seconds
Time After: 0.02967 seconds
Time Taken: 0.00206 seconds
Memory Before: 3,735.188 KB
Memory After: 3,835.922 KB
Memory Used: 100.734 KB
SELECT MAX(permissions & 1) AS perm FROM cms_permissions WHERE nodeid = 1 AND usergroupid IN (1)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cms_permissions | const | usergroupid,nodeid | usergroupid | 8 | const,const | 1 |
Time Before: 0.03289 seconds
Time After: 0.03311 seconds
Time Taken: 0.00023 seconds
Memory Before: 4,063.992 KB
Memory After: 4,065.961 KB
Memory Used: 1.969 KB
SELECT data, expires, locktime, serialized FROM cache WHERE cacheid = 'vbcms_item_1_data'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 |
Time Before: 0.04772 seconds
Time After: 0.04791 seconds
Time Taken: 0.00019 seconds
Memory Before: 5,411.734 KB
Memory After: 5,414.430 KB
Memory Used: 2.695 KB
SELECT data, expires, locktime, serialized FROM cache WHERE cacheid = 'vbcms_nav_.175fdd27536c9f3cf71107e91fcd7fdd'
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.04953 seconds
Time After: 0.04975 seconds
Time Taken: 0.00022 seconds
Memory Before: 5,556.672 KB
Memory After: 5,559.273 KB
Memory Used: 2.602 KB
SELECT navigation.nodeid, navigation.nodelist, nodeinfo.title, node.permissionsfrom, node.setpublish, node.publishdate FROM cms_navigation AS navigation INNER JOIN cms_node AS node ON node.nodeid = navigation.nodeid LEFT JOIN 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 | Impossible WHERE noticed after reading const tables |
Time Before: 0.05036 seconds
Time After: 0.05061 seconds
Time Taken: 0.00025 seconds
Memory Before: 5,560.250 KB
Memory After: 5,563.039 KB
Memory Used: 2.789 KB
SELECT * FROM style WHERE (styleid = 4 AND userselect = 1) OR styleid = 4 ORDER BY styleid ASC LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.05165 seconds
Time After: 0.05203 seconds
Time Taken: 0.00038 seconds
Memory Before: 5,592.578 KB
Memory After: 5,597.805 KB
Memory Used: 5.227 KB
SELECT data, expires, locktime, serialized FROM cache WHERE cacheid = 'vbcms_view_data_1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 |
Time Before: 0.05453 seconds
Time After: 0.05470 seconds
Time Taken: 0.00018 seconds
Memory Before: 6,327.820 KB
Memory After: 6,330.516 KB
Memory Used: 2.695 KB
SELECT cacheid, data, expires, locktime, serialized FROM cache WHERE cacheid in ('vbcms_item_1_data','vb_types.types','vbcms_types.types','cms_priv_user_0','vbcms_sectionlist_long','vbcms_item_114_data','vbcms_item_121_data','vbcms_item_120_data','cms_priv_user_1','vBCms_Article_pagetext_114.9bb096be7b3236d767765c1879f59e03','vBCms_Article_pagetext_121.77b207a68883d8f963c6b27676abd2ea','vBCms_Article_pagetext_120.3fa24dcf0350650ff7cdb64a6ea25e31','widget_20.e4e6fd90b613163e754a32db3900d070','vbcms_nav_.175fdd27536c9f3cf71107e91fcd7fdd') AND expires > 1610755476
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cache | range | PRIMARY,expires | PRIMARY | 66 | 14 | Using index condition; Using where |
Time Before: 0.05520 seconds
Time After: 0.05563 seconds
Time Taken: 0.00043 seconds
Memory Before: 6,338.211 KB
Memory After: 6,341.102 KB
Memory Used: 2.891 KB
(SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid, package.productid AS productid, product.active AS enabled, package.class AS class FROM package AS package INNER JOIN product AS product ON product.productid = package.productid OR package.productid = 'vbulletin') UNION (SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid, 1, 1, contenttype.class AS class FROM contenttype AS contenttype) UNION (SELECT 'widgettype' AS classtype, widgettypeid AS typeid, widgettype.packageid AS packageid, 1, 1, widgettype.class AS class FROM cms_widgettype AS widgettype)
Time Before: 0.06047 seconds
Time After: 0.06104 seconds
Time Taken: 0.00057 seconds
Memory Before: 7,043.367 KB
Memory After: 7,048.570 KB
Memory Used: 5.203 KB
REPLACE INTO cache SET cacheid = 'vbcms_types.types', expires = 0, created = 1610755476, locktime = 0, data = "a:53:{i:0;a:6:{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:\"0\";s:5:\"class\";s:7:\"vBForum\";}i:1;a:6:{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:\"0\";s:5:\"class\";s:6:\"vBBlog\";}i:2;a:6:{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\";}i:3;a:6:{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\";}i:4;a:6:{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\";}i:5;a:6:{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\";}i:6;a:6:{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\";}i:7;a:6:{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\";}i:8;a:6:{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\";}i:9;a:6:{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\";}i:10;a:6:{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\";}i:11;a:6:{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\";}i:12;a:6:{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\";}i:13;a:6:{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\";}i:14;a:6:{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\";}i:15;a:6:{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\";}i:16;a:6:{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\";}i:17;a:6:{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\";}i:18;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"15\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:14:\"PrivateMessage\";}i:19;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"16\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:10:\"Infraction\";}i:20;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"17\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:9:\"Signature\";}i:21;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"18\";s:9:\"packageid\";s:1:\"1\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:8:\"UserNote\";}i:22;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"19\";s:9:\"packageid\";s:1:\"2\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:9:\"BlogEntry\";}i:23;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"20\";s:9:\"packageid\";s:1:\"2\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:11:\"BlogComment\";}i:24;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"21\";s:9:\"packageid\";s:1:\"2\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:15:\"BlogDescription\";}i:25;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"22\";s:9:\"packageid\";s:1:\"2\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:15:\"BlogCustomBlock\";}i:26;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"23\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:7:\"Section\";}i:27;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"24\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:7:\"Article\";}i:28;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"25\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:11:\"ContentNode\";}i:29;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"26\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:10:\"StaticPage\";}i:30;a:6:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"27\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:7:\"PhpEval\";}i:31;a:6:{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\";}i:32;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:1:\"1\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:13:\"SectionNavExt\";}i:33;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:1:\"2\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:11:\"CategoryNav\";}i:34;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:1:\"3\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:6:\"Static\";}i:35;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:1:\"4\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:3:\"Rss\";}i:36;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:1:\"5\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:9:\"myFriends\";}i:37;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:1:\"6\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:12:\"Searchwidget\";}i:38;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:1:\"7\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:4:\"Poll\";}i:39;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:2:\"14\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:13:\"RecentThreads\";}i:40;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:1:\"9\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:6:\"Recent\";}i:41;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:2:\"10\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:13:\"CategoryNavBU\";}i:42;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:2:\"11\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:17:\"RecentCmsComments\";}i:43;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:2:\"12\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:7:\"ExecPhp\";}i:44;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:2:\"13\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:8:\"Calendar\";}i:45;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:2:\"15\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:11:\"RecentPosts\";}i:46;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:2:\"16\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:14:\"CategoryNavAll\";}i:47;a:6:{s:9:\"classtype\";s:10:\"widgettype\";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:13:\"RecentArticle\";}i:48;a:6:{s:9:\"classtype\";s:10:\"widgettype\";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:10:\"RecentBlog\";}i:49;a:6:{s:9:\"classtype\";s:10:\"widgettype\";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:18:\"RecentBlogComments\";}i:50;a:6:{s:9:\"classtype\";s:10:\"widgettype\";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:18:\"CategoryNavCurrent\";}i:51;a:6:{s:9:\"classtype\";s:10:\"widgettype\";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:13:\"RecentContent\";}i:52;a:6:{s:9:\"classtype\";s:10:\"widgettype\";s:6:\"typeid\";s:2:\"22\";s:9:\"packageid\";s:1:\"3\";s:9:\"productid\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:5:\"class\";s:8:\"TagCloud\";}}", serialized = '1'
Time Before: 0.06164 seconds
Time After: 0.06199 seconds
Time Taken: 0.00035 seconds
Memory Before: 7,157.273 KB
Memory After: 7,147.656 KB
Memory Used: -9.617 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 package AS package LEFT JOIN 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 contenttype AS contenttype INNER JOIN package AS package ON package.packageid = contenttype.packageid LEFT JOIN product AS product ON product.productid = package.productid WHERE product.active = 1 OR package.productid = 'vbulletin' )
Time Before: 0.06473 seconds
Time After: 0.06534 seconds
Time Taken: 0.00061 seconds
Memory Before: 7,425.523 KB
Memory After: 7,429.539 KB
Memory Used: 4.016 KB
REPLACE INTO cache SET cacheid = 'vb_types.types', expires = 0, created = 1610755476, locktime = 0, data = "a:26:{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:\"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:2;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:3;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:4;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:5;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:6;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:7;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"16\";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:8;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:9;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:10;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:11;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"15\";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:12;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"17\";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:13;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:14;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:15;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:16;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:17;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:18;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"18\";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:19;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:20;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"24\";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:21;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:22;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"25\";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:23;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"27\";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:24;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"23\";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:25;a:7:{s:9:\"classtype\";s:11:\"contenttype\";s:6:\"typeid\";s:2:\"26\";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.06567 seconds
Time After: 0.06592 seconds
Time Taken: 0.00026 seconds
Memory Before: 7,488.313 KB
Memory After: 7,482.922 KB
Memory Used: -5.391 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 cms_node AS node INNER JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid LEFT JOIN user AS user ON user.userid = node.userid LEFT JOIN thread AS thread ON thread.threadid = info.associatedthreadid LEFT JOIN cms_sectionorder AS sectionorder ON sectionorder.sectionid = 1 AND sectionorder.nodeid = node.nodeid LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode LEFT JOIN cms_nodeinfo AS parentinfo ON parentinfo.nodeid = parent.nodeid INNER JOIN 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 <> 23 AND node.new != 1 AND ( (( (node.permissionsfrom IN (-1)) OR ( node.permissionsfrom in (1) AND (node.parentnode IN (1,117,118,139,142,154,162) OR node.nodeid = 1) AND node.setpublish > 0 AND node.publishdate < 1610755476 ))) OR (node.setpublish AND node.publishdate <1610755476 AND node.publicpreview > 0))AND node.hidden = 0 AND ((node.setpublish = '1' AND node.publishdate <= 1610755476 ) OR node.userid = 0) AND (node.parentnode = 1 OR sectionorder.displayorder > 0 ) AND sectionorder.displayorder > 0 ORDER BY sectionorder.displayorder ASC 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 | |
1 | SIMPLE | sectionorder | ref | sectionid | sectionid | 4 | const | 13 | Using where; Using filesort |
1 | SIMPLE | node | eq_ref | PRIMARY,contentid,nodeleft,parentnode,contenttype,publishdate,new | PRIMARY | 4 | moghscom_moghal.sectionorder.nodeid | 1 | Using index condition; Using where |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | moghscom_moghal.node.userid | 1 | |
1 | SIMPLE | info | eq_ref | PRIMARY | PRIMARY | 4 | moghscom_moghal.node.nodeid | 1 | |
1 | SIMPLE | thread | eq_ref | PRIMARY | PRIMARY | 4 | moghscom_moghal.info.associatedthreadid | 1 | |
1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | moghscom_moghal.node.parentnode | 1 | Using where |
1 | SIMPLE | parentinfo | eq_ref | PRIMARY | PRIMARY | 4 | moghscom_moghal.parent.nodeid | 1 | Using where |
Time Before: 0.07821 seconds
Time After: 0.07898 seconds
Time Taken: 0.00077 seconds
Memory Before: 8,780.094 KB
Memory After: 8,791.039 KB
Memory Used: 10.945 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.07933 seconds
Time After: 0.07945 seconds
Time Taken: 0.00012 seconds
Memory Before: 8,788.570 KB
Memory After: 8,790.648 KB
Memory Used: 2.078 KB
SELECT category, cat.categoryid FROM cms_nodecategory nc INNER JOIN cms_category cat ON cat.categoryid = nc.categoryid WHERE nc.nodeid = 114
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | nc | ref | PRIMARY,categoryid | PRIMARY | 4 | const | 1 | Using index |
1 | SIMPLE | cat | eq_ref | PRIMARY | PRIMARY | 4 | moghscom_moghal.nc.categoryid | 1 |
Time Before: 0.08546 seconds
Time After: 0.08567 seconds
Time Taken: 0.00021 seconds
Memory Before: 9,290.391 KB
Memory After: 9,292.563 KB
Memory Used: 2.172 KB
SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM user AS user LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN 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.09627 seconds
Time After: 0.09654 seconds
Time Taken: 0.00027 seconds
Memory Before: 10,595.406 KB
Memory After: 10,618.242 KB
Memory Used: 22.836 KB
SELECT title FROM 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 | template | range | title | title | 102 | 555 | Using where; Using index |
Time Before: 0.09762 seconds
Time After: 0.09815 seconds
Time Taken: 0.00054 seconds
Memory Before: 10,716.453 KB
Memory After: 10,723.781 KB
Memory Used: 7.328 KB
SELECT title, template FROM template WHERE templateid IN (1330,1329,2336,2406,0,0,429,423,422,427,428,426,425,430,431,432,2092,2388,1325,2042,2039,2040,2041,2404,0,0,2367,2369,2062,2063,2065,2066,2289,2331,2330,2380,2332,1889,1888,1892,2347,1571,1591,1830,2251,1534,2366,2123,2128,2126,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,2048,2049,2050,2051,2052,2053,2054,2055,2056,1535,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1562,1563,1564,1565,1566,1567,1568,294,1361,1309,1363,1367,295,296,297,298,299,300,301,302,1572,1573,1574,1575,1576,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 197 | Using index condition |
Time Before: 0.09964 seconds
Time After: 0.10193 seconds
Time Taken: 0.00229 seconds
Memory Before: 11,017.984 KB
Memory After: 11,023.844 KB
Memory Used: 5.859 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 attachment AS a INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid) LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension) WHERE a.contentid = 121 AND a.contenttypeid = 24 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 | moghscom_moghal.a.filedataid | 1 | |
1 | SIMPLE | at | eq_ref | PRIMARY | PRIMARY | 20 | moghscom_moghal.fd.extension | 1 | Using where |
Time Before: 0.10689 seconds
Time After: 0.10716 seconds
Time Taken: 0.00027 seconds
Memory Before: 11,650.438 KB
Memory After: 11,655.078 KB
Memory Used: 4.641 KB
SELECT category, cat.categoryid FROM cms_nodecategory nc INNER JOIN cms_category cat ON cat.categoryid = nc.categoryid WHERE nc.nodeid = 121
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | nc | ref | PRIMARY,categoryid | PRIMARY | 4 | const | 1 | Using index |
1 | SIMPLE | cat | eq_ref | PRIMARY | PRIMARY | 4 | moghscom_moghal.nc.categoryid | 1 |
Time Before: 0.10754 seconds
Time After: 0.10769 seconds
Time Taken: 0.00016 seconds
Memory Before: 11,652.117 KB
Memory After: 11,654.266 KB
Memory Used: 2.148 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 attachment AS a INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid) LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension) WHERE a.contentid = 120 AND a.contenttypeid = 24 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 | moghscom_moghal.a.filedataid | 1 | |
1 | SIMPLE | at | eq_ref | PRIMARY | PRIMARY | 20 | moghscom_moghal.fd.extension | 1 | Using where |
Time Before: 0.10927 seconds
Time After: 0.10952 seconds
Time Taken: 0.00025 seconds
Memory Before: 11,672.844 KB
Memory After: 11,677.453 KB
Memory Used: 4.609 KB
SELECT category, cat.categoryid FROM cms_nodecategory nc INNER JOIN cms_category cat ON cat.categoryid = nc.categoryid WHERE nc.nodeid = 120
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | nc | ref | PRIMARY,categoryid | PRIMARY | 4 | const | 1 | Using index |
1 | SIMPLE | cat | eq_ref | PRIMARY | PRIMARY | 4 | moghscom_moghal.nc.categoryid | 1 |
Time Before: 0.10986 seconds
Time After: 0.11002 seconds
Time Taken: 0.00016 seconds
Memory Before: 11,674.375 KB
Memory After: 11,676.547 KB
Memory Used: 2.172 KB
SELECT layout.layoutid AS itemid, layout.title , layout.gridid, layout.contentcolumn, layout.contentindex FROM cms_layout AS layout WHERE layoutid = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | layout | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.11173 seconds
Time After: 0.11194 seconds
Time Taken: 0.00022 seconds
Memory Before: 11,677.711 KB
Memory After: 11,680.609 KB
Memory Used: 2.898 KB
SELECT widgetid, layoutcolumn AS `column`, layoutindex AS `index` FROM cms_layoutwidget WHERE layoutid = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cms_layoutwidget | ref | layoutid | layoutid | 4 | const | 5 |
Time Before: 0.11233 seconds
Time After: 0.11252 seconds
Time Taken: 0.00019 seconds
Memory Before: 11,678.477 KB
Memory After: 11,681.070 KB
Memory Used: 2.594 KB
SELECT widget.widgetid AS itemid ,widget.title, widget.description, widget.widgettypeid FROM cms_widget AS widget WHERE 1=1 AND widget.widgetid IN (33,20,38,36,35) ORDER BY widget.title ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | widget | ALL | PRIMARY | 26 | Using where; Using filesort |
Time Before: 0.11519 seconds
Time After: 0.11546 seconds
Time Taken: 0.00027 seconds
Memory Before: 11,886.398 KB
Memory After: 11,889.125 KB
Memory Used: 2.727 KB
SELECT widgetid AS itemid, name, value, (nodeid = 0) instance, serialized FROM cms_widgetconfig WHERE widgetid IN (36,20,33,35) AND nodeid = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cms_widgetconfig | range | PRIMARY | PRIMARY | 8 | 7 | Using index condition |
Time Before: 0.11645 seconds
Time After: 0.11681 seconds
Time Taken: 0.00036 seconds
Memory Before: 11,949.125 KB
Memory After: 11,952.227 KB
Memory Used: 3.102 KB
REPLACE INTO cache SET cacheid = 'vbcms_view_data_1', expires = 1610841876, created = 1610755476, locktime = 0, data = "a:2:{s:8:\"cacheids\";a:14:{s:17:\"vbcms_item_1_data\";i:1610755476;s:14:\"vb_types.types\";i:1610755476;s:17:\"vbcms_types.types\";i:1610755476;s:15:\"cms_priv_user_0\";i:1610755476;s:22:\"vbcms_sectionlist_long\";i:1610755476;s:19:\"vbcms_item_114_data\";i:1610755476;s:19:\"vbcms_item_121_data\";i:1610755476;s:19:\"vbcms_item_120_data\";i:1610755476;s:15:\"cms_priv_user_1\";i:1610755476;s:59:\"vBCms_Article_pagetext_114.9bb096be7b3236d767765c1879f59e03\";i:1610755476;s:59:\"vBCms_Article_pagetext_121.77b207a68883d8f963c6b27676abd2ea\";i:1610755476;s:59:\"vBCms_Article_pagetext_120.3fa24dcf0350650ff7cdb64a6ea25e31\";i:1610755476;s:42:\"widget_20.e4e6fd90b613163e754a32db3900d070\";i:1610755476;s:43:\"vbcms_nav_.175fdd27536c9f3cf71107e91fcd7fdd\";i:1610755476;}s:11:\"last_update\";i:1610755476;}", serialized = '1'
Time Before: 0.11958 seconds
Time After: 0.11988 seconds
Time Taken: 0.00030 seconds
Memory Before: 12,102.617 KB
Memory After: 12,102.070 KB
Memory Used: -0.547 KB
SELECT phrasegroup_contenttypes AS contenttypes,phrasegroup_global AS global,phrasegroup_vbcms AS vbcms,phrasegroup_messaging AS messaging FROM language WHERE languageid = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | language | system | PRIMARY | 1 |
Time Before: 0.12067 seconds
Time After: 0.12109 seconds
Time Taken: 0.00041 seconds
Memory Before: 12,110.461 KB
Memory After: 12,113.148 KB
Memory Used: 2.688 KB
SELECT * FROM navigation WHERE state & 4 = 0 ORDER BY navtype, displayorder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | navigation | ALL | 41 | Using where; Using filesort |
Time Before: 0.12328 seconds
Time After: 0.12362 seconds
Time Taken: 0.00033 seconds
Memory Before: 12,509.281 KB
Memory After: 12,518.547 KB
Memory Used: 9.266 KB
REPLACE INTO cacheevent (cacheid, event) VALUES ('vbcms_types.types', 'vb_types.type_updated'), ('vbcms_types.types', 'vb_types.package_updated'), ('vbcms_types.types', 'vb_types.contenttype_updated'), ('vbcms_types.types', 'vbcms_types.widgettype_updated'), ('vb_types.types', 'vb_types.type_updated'), ('vb_types.types', 'vb_types.package_updated'), ('vb_types.types', 'vb_types.contenttype_updated')
Time Before: 0.13021 seconds
Time After: 0.13054 seconds
Time Taken: 0.00033 seconds
Memory Before: 12,511.477 KB
Memory After: 12,511.516 KB
Memory Used: 0.039 KB
SELECT cacheid FROM cacheevent WHERE event IN ('vbcms_nav_1','vbcms_nav_114','vbcms_nav_121','vbcms_nav_120')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cacheevent | index | PRIMARY | 118 | 510 | Using where; Using index |
Time Before: 0.13095 seconds
Time After: 0.13148 seconds
Time Taken: 0.00053 seconds
Memory Before: 12,508.547 KB
Memory After: 12,510.531 KB
Memory Used: 1.984 KB
UPDATE session SET lastactivity = 1610755476, location = 'route:content|wol|viewing_page|Moghal+Brothers', badlocation = 0 WHERE sessionhash = '68e3547bf1204bd5f31cf4744764d10e'
Time Before: 0.13168 seconds
Time After: 0.13184 seconds
Time Taken: 0.00017 seconds
Memory Before: 12,512.664 KB
Memory After: 12,512.945 KB
Memory Used: 0.281 KB