Including Functions.php

Time Before: 0.00129 seconds
Time After: 0.00182 seconds
Time Taken: 0.00053 seconds

Memory Before: 1,074.500 KB
Memory After: 1,099.664 KB
Memory Used: 25.164 KB

Connect to Database on Server: localhost

Time Before: 0.00192 seconds
Time After: 0.00371 seconds
Time Taken: 0.00179 seconds

Memory Before: 1,099.578 KB
Memory After: 1,100.359 KB
Memory Used: 0.781 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00384 seconds
Time After: 0.00402 seconds
Time Taken: 0.00017 seconds

Memory Before: 1,100.398 KB
Memory After: 1,100.867 KB
Memory Used: 0.469 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('routes','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY50 15Using where

Time Before: 0.00459 seconds
Time After: 0.00678 seconds
Time Taken: 0.00219 seconds

Memory Before: 1,103.500 KB
Memory After: 1,103.805 KB
Memory Used: 0.305 KB

Time Before: 0.00406 seconds
Time After: 0.01055 seconds
Time Taken: 0.00649 seconds

Memory Before: 1,100.000 KB
Memory After: 2,874.117 KB
Memory Used: 1,774.117 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.161.108.158'
	AND idhash = 'c30b9197066afeefa2ac175ec15954d5'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrefguest_lookup,user_activityguest_lookup51const,const,const2Using where

Time Before: 0.01356 seconds
Time After: 0.01415 seconds
Time Taken: 0.00059 seconds

Memory Before: 3,497.492 KB
Memory After: 3,497.898 KB
Memory Used: 0.406 KB

SQL Query
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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguagesystemPRIMARY   1 

Time Before: 0.01513 seconds
Time After: 0.01528 seconds
Time Taken: 0.00016 seconds

Memory Before: 3,509.328 KB
Memory After: 3,509.188 KB
Memory Used: -0.141 KB

Time Before: 0.01292 seconds
Time After: 0.01549 seconds
Time Taken: 0.00257 seconds

Memory Before: 3,491.078 KB
Memory After: 3,561.906 KB
Memory Used: 70.828 KB

SQL Query
SELECT MAX(permissions & 1) AS perm
FROM cms_permissions
WHERE nodeid = 1 AND usergroupid IN (1)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcms_permissionsconstusergroupid,nodeidusergroupid8const,const1 

Time Before: 0.01834 seconds
Time After: 0.01845 seconds
Time Taken: 0.00012 seconds

Memory Before: 3,868.523 KB
Memory After: 3,868.969 KB
Memory Used: 0.445 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_item_178_data'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.70952 seconds
Time After: 0.70986 seconds
Time Taken: 0.00034 seconds

Memory Before: 5,396.250 KB
Memory After: 5,396.711 KB
Memory Used: 0.461 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_nav_.9924449d2647b6ad3c3cb0bdfa7c88d7'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.71121 seconds
Time After: 0.71146 seconds
Time Taken: 0.00026 seconds

Memory Before: 5,561.172 KB
Memory After: 5,561.609 KB
Memory Used: 0.438 KB

SQL Query
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 (178,1,31,48,52) AND navigation.nodelist IS NOT NULL AND (navigation.nodelist <> '')
				
				ORDER BY node.nodeleft DESC LIMIT 0,1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnoderangePRIMARYPRIMARY4 5Using where; Using filesort
1SIMPLEnavigationeq_refPRIMARYPRIMARY4wildhogh_vbulletin2.node.nodeid1Using where
1SIMPLEnodeinfoeq_refPRIMARYPRIMARY4wildhogh_vbulletin2.node.nodeid1 

Time Before: 0.71222 seconds
Time After: 0.71273 seconds
Time Taken: 0.00050 seconds

Memory Before: 5,563.664 KB
Memory After: 5,563.758 KB
Memory Used: 0.094 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'cms_priv_user_0'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.71357 seconds
Time After: 0.71368 seconds
Time Taken: 0.00011 seconds

Memory Before: 5,644.070 KB
Memory After: 5,644.523 KB
Memory Used: 0.453 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_sectionlist_long'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.71447 seconds
Time After: 0.71482 seconds
Time Taken: 0.00035 seconds

Memory Before: 5,684.719 KB
Memory After: 5,685.164 KB
Memory Used: 0.445 KB

SQL Query
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 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 cms_sectionorder AS sectionorder ON sectionorder.sectionid = node.parentnode
				AND sectionorder.nodeid = node.nodeid
				LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode 	
				
				WHERE node.new != 1  AND node.nodeid IN (1)  AND ( (node.permissionsfrom IN (-1)) OR ( node.permissionsfrom in (1) AND (node.parentnode IN (1,35,37,23,27,25,30,355,31,48,52,68,69,216,217,218,219,70,411,54,249,250,251,252,253,254,255,256,257,262,258,259,260,261,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,56,57,58,59,110,115,194,198,203,207,210,66,77,363,44,45) OR node.nodeid = 1) AND
				node.setpublish > 0 AND node.publishdate < 1511191429 ))AND node.new != 1 
				
				  ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
					 node.publishdate DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeconstPRIMARY,parentnode,publishdate,newPRIMARY4const1 
1SIMPLEinfoconstPRIMARYPRIMARY4const1 
1SIMPLEuserconstPRIMARYPRIMARY4const0unique row not found
1SIMPLEsectionorderconstsectionid   1 
1SIMPLEparentconstPRIMARY   1 

Time Before: 0.71648 seconds
Time After: 0.71707 seconds
Time Taken: 0.00059 seconds

Memory Before: 5,949.789 KB
Memory After: 5,948.664 KB
Memory Used: -1.125 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_types.types'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.71781 seconds
Time After: 0.71808 seconds
Time Taken: 0.00028 seconds

Memory Before: 5,989.164 KB
Memory After: 5,989.625 KB
Memory Used: 0.461 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_item_1_data'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.71925 seconds
Time After: 0.71953 seconds
Time Taken: 0.00029 seconds

Memory Before: 6,198.109 KB
Memory After: 6,198.570 KB
Memory Used: 0.461 KB

SQL Query
SELECT node.nodeid AS itemid, parent.nodeid, parent.url, parent.styleid, parent.layoutid, parent.publishdate,
						parent.setpublish, parent.hidden, info.title, info.description
				
				FROM cms_node AS node
				INNER JOIN cms_node AS parent ON (node.nodeleft >= parent.nodeleft AND node.nodeleft <= parent.noderight)
				INNER JOIN cms_nodeinfo AS info ON info.nodeid = parent.nodeid
				LEFT JOIN cms_sectionorder AS ord ON ord.nodeid = node.nodeid AND ord.sectionid = node.parentnode 
				WHERE node.nodeid IN (1)
				AND parent.nodeid != node.nodeid
				
				ORDER BY parent.nodeleft, ord.displayorder
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeconstPRIMARY,nodeleftPRIMARY4const1Using filesort
1SIMPLEordconstsectionid   1 
1SIMPLEparentALLPRIMARY,nodeleft,noderight   321Using where
1SIMPLEinfoeq_refPRIMARYPRIMARY4wildhogh_vbulletin2.parent.nodeid1 

Time Before: 0.72055 seconds
Time After: 0.72068 seconds
Time Taken: 0.00012 seconds

Memory Before: 6,223.602 KB
Memory After: 6,223.570 KB
Memory Used: -0.031 KB

SQL Query
REPLACE INTO cache
SET cacheid = 'vbcms_nav_.9924449d2647b6ad3c3cb0bdfa7c88d7',
	expires = 1511192029,
	created = 1511191429,
	locktime = 0,
	data = "a:1:{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:21:\"Wild-Hog-Hunters-Home\";s:13:\"\0*\0parentnode\";N;s:11:\"\0*\0layoutid\";s:1:\"2\";s:10:\"\0*\0styleid\";N;s:12:\"\0*\0issection\";s:1:\"1\";s:11:\"\0*\0username\";N;s:14:\"\0*\0publishdate\";s:10:\"1269876180\";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:\"1267536584\";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:\"4\";s:17:\"items_perhomepage\";s:2:\"20\";s:16:\"pagination_links\";s:1:\"0\";s:16:\"section_priority\";s:1:\"5\";}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:334:\"wild hog hunting, wild boar hunting, hog hunting, boar hunting, hog hunts, pig hunts, boar hunts, feral hogs, feral hog hunting, pig hunting, hog traps, hog trapping, wild hog recipes, dog hunting, night hunting, boars, feral hog hunts, hog hunting videos, hog hunting pictures, wild hog pictures, wild hog videos, boar hunting videos\";s:12:\"\0*\0pagetitle\";N;s:8:\"\0*\0title\";s:21:\"Wild Hog Hunters Home\";s:13:\"\0*\0html_title\";s:44:\"Texas style hog hunting for real hog hunters\";s:14:\"\0*\0parenttitle\";N;s:11:\"\0*\0nodeleft\";s:1:\"1\";s:12:\"\0*\0noderight\";s:3:\"642\";s:14:\"\0*\0lastupdated\";s:10:\"1346189529\";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:\"1\";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:91:\"Hog hunting information, articles and videos, including trapping, snaring and night hunting\";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;}}",
	serialized = '1'

Time Before: 0.72096 seconds
Time After: 0.72187 seconds
Time Taken: 0.00091 seconds

Memory Before: 6,236.859 KB
Memory After: 6,232.094 KB
Memory Used: -4.766 KB

SQL Query
SELECT nodeid, permissionsfrom, hidden, setpublish, publishdate, userid FROM cms_node where nodeid in (0)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.72244 seconds
Time After: 0.72255 seconds
Time Taken: 0.00011 seconds

Memory Before: 6,219.133 KB
Memory After: 6,219.578 KB
Memory Used: 0.445 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 2 AND userselect = 1)
	OR styleid = 2
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 

Time Before: 0.72362 seconds
Time After: 0.72382 seconds
Time Taken: 0.00020 seconds

Memory Before: 6,234.711 KB
Memory After: 6,235.133 KB
Memory Used: 0.422 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_view_data_178'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.72556 seconds
Time After: 0.72587 seconds
Time Taken: 0.00031 seconds

Memory Before: 6,858.063 KB
Memory After: 6,858.523 KB
Memory Used: 0.461 KB

SQL Query
SELECT cacheid, data, expires, locktime, serialized
FROM cache
WHERE cacheid in ('vbcms_item_178_data','vbcms_nav_.86b410896c6e8ad18568e17f4ccc651a','cms_priv_user_0','vbcms_sectionlist_long','vbcms_types.types','vbcms_item_1_data','vb_types.types','cms_priv_user_4','vBCms_Article_pagetext_178.685858be8f80557fc55ef4d2982ae370','widget_2.7aa77f27d718c88e5dddef10c8af616d','widget_3.19faa36c95d26b4d94e9c999862324f3','vbcms_nav_.9924449d2647b6ad3c3cb0bdfa7c88d7') AND expires > 1511191429
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacherangePRIMARY,expiresPRIMARY66 12Using where

Time Before: 0.72645 seconds
Time After: 0.72716 seconds
Time Taken: 0.00071 seconds

Memory Before: 6,866.898 KB
Memory After: 6,866.961 KB
Memory Used: 0.063 KB

SQL Query
(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.72885 seconds
Time After: 0.72899 seconds
Time Taken: 0.00014 seconds

Memory Before: 6,951.219 KB
Memory After: 6,950.938 KB
Memory Used: -0.281 KB

SQL Query
REPLACE INTO cache
SET cacheid = 'vb_types.types',
	expires = 0,
	created = 1511191429,
	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.72936 seconds
Time After: 0.72997 seconds
Time Taken: 0.00061 seconds

Memory Before: 7,024.758 KB
Memory After: 7,018.297 KB
Memory Used: -6.461 KB

SQL Query
SELECT usergroupid, membergroupids FROM user WHERE userid = 4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 

Time Before: 0.73098 seconds
Time After: 0.73125 seconds
Time Taken: 0.00027 seconds

Memory Before: 7,028.570 KB
Memory After: 7,029.078 KB
Memory Used: 0.508 KB

SQL Query
SELECT vbcmspermissions FROM administrator WHERE userid = 4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEadministratorconstPRIMARYPRIMARY4const1 

Time Before: 0.73167 seconds
Time After: 0.73191 seconds
Time Taken: 0.00024 seconds

Memory Before: 7,030.891 KB
Memory After: 7,031.391 KB
Memory Used: 0.500 KB

SQL Query
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 cms_permissions p
			WHERE usergroupid IN (6)
			GROUP BY nodeid;
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEprefusergroupidusergroupid4const1Using where

Time Before: 0.73237 seconds
Time After: 0.73249 seconds
Time Taken: 0.00011 seconds

Memory Before: 7,031.484 KB
Memory After: 7,031.734 KB
Memory Used: 0.250 KB

SQL Query
REPLACE INTO cache
SET cacheid = 'cms_priv_user_4',
	expires = 1511191729,
	created = 1511191429,
	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;s:1:\"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.73265 seconds
Time After: 0.73291 seconds
Time Taken: 0.00026 seconds

Memory Before: 7,036.648 KB
Memory After: 7,036.563 KB
Memory Used: -0.086 KB

SQL Query
UPDATE cms_nodeinfo set viewcount = viewcount + 1 where nodeid = 178

Time Before: 0.73495 seconds
Time After: 0.74276 seconds
Time Taken: 0.00781 seconds

Memory Before: 7,104.453 KB
Memory After: 7,104.828 KB
Memory Used: 0.375 KB

SQL Query
SELECT tag.tagtext
FROM tag AS tag
JOIN tagcontent AS tagcontent ON (tag.tagid = tagcontent.tagid)
WHERE tagcontent.contenttypeid = 18
	AND tagcontent.contentid = 140
ORDER BY tag.tagtext
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtagcontentrefPRIMARY,id_type_userid_type_user8const,const1Using index; Using temporary; Using filesort
1SIMPLEtageq_refPRIMARYPRIMARY4wildhogh_vbulletin2.tagcontent.tagid1 

Time Before: 0.74457 seconds
Time After: 0.74494 seconds
Time Taken: 0.00037 seconds

Memory Before: 7,314.906 KB
Memory After: 7,315.242 KB
Memory Used: 0.336 KB

SQL Query
SELECT title
FROM template
WHERE title LIKE 'vbcms_%article%' 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%'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangetitletitle102 455Using where; Using index

Time Before: 0.74624 seconds
Time After: 0.74731 seconds
Time Taken: 0.00107 seconds

Memory Before: 7,337.008 KB
Memory After: 7,337.219 KB
Memory Used: 0.211 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (1957,2284,2337,3391,0,0,1045,1039,2762,2342,3675,2350,2098,1046,1047,1048,3077,3373,1954,3027,3024,3025,3026,3389,0,0,3352,3354,3047,3048,3050,3051,3274,3316,3315,3365,3317,2874,2873,2877,2435,3332,2556,2576,2815,3236,2519,3351,3108,3113,3111,3671,2859,2860,2861,2862,2863,0,2864,2865,2866,2867,2868,2869,0,0,0,0,0,0,0,0,0,0,0,0,0,2870,0,3033,3034,3035,3036,3037,3038,3039,3040,3041,2520,2522,2523,2524,2525,2526,2527,2528,2529,2530,2531,2532,2533,2534,2535,2536,2537,2538,2539,2540,2541,2542,2543,2544,2545,2547,0,0,2548,2549,2550,2551,2552,2553,846,0,2045,2557,2558,2559,2560,2561,0,2563,0,2564,2565,2566,2567,0,2568,2569,0,2570,2571,2572,2573,2574,2575,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,3682,3683,2641,2642)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 190Using where

Time Before: 0.75066 seconds
Time After: 0.75121 seconds
Time Taken: 0.00055 seconds

Memory Before: 7,671.773 KB
Memory After: 7,671.297 KB
Memory Used: -0.477 KB

SQL Query
SELECT template
FROM template
WHERE templateid = 2876
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

Time Before: 0.75777 seconds
Time After: 0.75803 seconds
Time Taken: 0.00026 seconds

Memory Before: 8,021.766 KB
Memory After: 8,022.242 KB
Memory Used: 0.477 KB

SQL Query
SELECT category, cat.categoryid FROM cms_nodecategory nc INNER JOIN cms_category cat ON cat.categoryid = nc.categoryid
			WHERE nc.nodeid = 178
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.75866 seconds
Time After: 0.75891 seconds
Time Taken: 0.00026 seconds

Memory Before: 8,019.641 KB
Memory After: 8,020.055 KB
Memory Used: 0.414 KB

SQL Query
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 = 4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 

Time Before: 0.76189 seconds
Time After: 0.76236 seconds
Time Taken: 0.00047 seconds

Memory Before: 8,168.594 KB
Memory After: 8,168.742 KB
Memory Used: 0.148 KB

SQL Query
SELECT layoutid FROM cms_node AS node
					WHERE (165 BETWEEN node.nodeleft AND node.noderight) AND layoutid > 0 ORDER BY nodeleft DESC LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnoderangenodeleft,noderightnodeleft4 68Using where

Time Before: 0.76475 seconds
Time After: 0.76522 seconds
Time Taken: 0.00046 seconds

Memory Before: 8,221.102 KB
Memory After: 8,221.516 KB
Memory Used: 0.414 KB

SQL Query
SELECT layout.layoutid AS itemid,	layout.title ,	layout.gridid, layout.contentcolumn, layout.contentindex
				FROM cms_layout AS layout
				WHERE layoutid = 2
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElayoutconstPRIMARYPRIMARY4const1 

Time Before: 0.76570 seconds
Time After: 0.76580 seconds
Time Taken: 0.00010 seconds

Memory Before: 8,221.883 KB
Memory After: 8,222.250 KB
Memory Used: 0.367 KB

SQL Query
SELECT widgetid, layoutcolumn AS `column`, layoutindex AS `index` 
FROM cms_layoutwidget 
WHERE layoutid = 2
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcms_layoutwidgetreflayoutidlayoutid4const5 

Time Before: 0.76627 seconds
Time After: 0.76638 seconds
Time Taken: 0.00011 seconds

Memory Before: 8,222.148 KB
Memory After: 8,222.578 KB
Memory Used: 0.430 KB

SQL Query
SELECT widget.widgetid AS itemid    ,widget.title, widget.description, widget.widgettypeid 
				
				FROM cms_widget AS widget 
				
				WHERE 1=1 AND widget.widgetid IN (2,7,3,8,4,6)
				ORDER BY widget.title ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetALLPRIMARY   8Using where; Using filesort

Time Before: 0.76749 seconds
Time After: 0.76761 seconds
Time Taken: 0.00012 seconds

Memory Before: 8,315.047 KB
Memory After: 8,315.391 KB
Memory Used: 0.344 KB

SQL Query
SELECT widgetid AS itemid, name, value, (nodeid = 0) instance, serialized
				
				FROM cms_widgetconfig
				
				WHERE widgetid IN (2,3,6,4,7,8)
				AND nodeid = 0 OR nodeid = 140
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcms_widgetconfigALLPRIMARY   25Using where

Time Before: 0.76888 seconds
Time After: 0.76925 seconds
Time Taken: 0.00037 seconds

Memory Before: 8,425.250 KB
Memory After: 8,425.617 KB
Memory Used: 0.367 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'widget_3.aee849aeb9f5f2dd2b64ea765ba748c0'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.77077 seconds
Time After: 0.77102 seconds
Time Taken: 0.00025 seconds

Memory Before: 8,500.867 KB
Memory After: 8,501.297 KB
Memory Used: 0.430 KB

SQL Query
REPLACE INTO cache
SET cacheid = 'widget_3.aee849aeb9f5f2dd2b64ea765ba748c0',
	expires = 1511191729,
	created = 1511191429,
	locktime = 0,
	data = "
\n \"\"\n
\n Black Hog Down
\"\"\n

\n \"\"\n
\n Hunting New Zealand - Venison ...
\"\"\n

\n \"\"\n
\n Boar Hunting Durville Island S...
\"\"\n

", serialized = '0'

Time Before: 0.77199 seconds
Time After: 0.77235 seconds
Time Taken: 0.00035 seconds

Memory Before: 8,511.500 KB
Memory After: 8,510.172 KB
Memory Used: -1.328 KB

SQL Query
REPLACE INTO cache
SET cacheid = 'vbcms_view_data_178',
	expires = 1511277829,
	created = 1511191429,
	locktime = 0,
	data = "a:2:{s:8:\"cacheids\";a:12:{s:19:\"vbcms_item_178_data\";i:1511191429;s:15:\"cms_priv_user_0\";i:1511191429;s:22:\"vbcms_sectionlist_long\";i:1511191429;s:17:\"vbcms_types.types\";i:1511191429;s:17:\"vbcms_item_1_data\";i:1511191429;s:14:\"vb_types.types\";i:1511191429;s:15:\"cms_priv_user_4\";i:1511191429;s:59:\"vBCms_Article_pagetext_178.685858be8f80557fc55ef4d2982ae370\";i:1511191429;s:41:\"widget_2.7aa77f27d718c88e5dddef10c8af616d\";i:1511191429;s:41:\"widget_3.19faa36c95d26b4d94e9c999862324f3\";i:1511136908;s:43:\"vbcms_nav_.9924449d2647b6ad3c3cb0bdfa7c88d7\";i:1511191429;s:41:\"widget_3.aee849aeb9f5f2dd2b64ea765ba748c0\";i:1511191429;}s:11:\"last_update\";i:1511191429;}",
	serialized = '1'

Time Before: 0.77328 seconds
Time After: 0.77363 seconds
Time Taken: 0.00035 seconds

Memory Before: 8,527.719 KB
Memory After: 8,527.313 KB
Memory Used: -0.406 KB

SQL Query
SELECT phrasegroup_contenttypes AS contenttypes,phrasegroup_global AS global,phrasegroup_vbcms AS vbcms,phrasegroup_messaging AS messaging
				FROM language
				WHERE languageid = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguagesystemPRIMARY   1 

Time Before: 0.77462 seconds
Time After: 0.77479 seconds
Time Taken: 0.00016 seconds

Memory Before: 8,537.992 KB
Memory After: 8,538.375 KB
Memory Used: 0.383 KB

SQL Query
SELECT *
FROM navigation
WHERE state & 4 = 0
ORDER BY navtype, displayorder
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnavigationALL    36Using where; Using filesort

Time Before: 0.77729 seconds
Time After: 0.77743 seconds
Time Taken: 0.00014 seconds

Memory Before: 9,026.242 KB
Memory After: 9,026.711 KB
Memory Used: 0.469 KB

SQL Query
REPLACE INTO cacheevent
	(cacheid, event)
VALUES ('vbcms_nav_.9924449d2647b6ad3c3cb0bdfa7c88d7', 'vbcms_nav_1'),
	('vbcms_nav_.9924449d2647b6ad3c3cb0bdfa7c88d7', 'vbcms_nav_global'),
	('vbcms_nav_.9924449d2647b6ad3c3cb0bdfa7c88d7', 'sections_updated'),
	('vb_types.types', 'vb_types.type_updated'),
	('vb_types.types', 'vb_types.package_updated'),
	('vb_types.types', 'vb_types.contenttype_updated'),
	('cms_priv_user_4', 'cms_permissions_change'),
	('cms_priv_user_4', 'permissions_4'),
	('widget_3.aee849aeb9f5f2dd2b64ea765ba748c0', 'vBCms_event_ExecPhp_3')

Time Before: 0.81272 seconds
Time After: 0.81323 seconds
Time Taken: 0.00051 seconds

Memory Before: 9,057.344 KB
Memory After: 9,057.211 KB
Memory Used: -0.133 KB

SQL Query
SELECT cacheid
FROM cacheevent
WHERE event IN ('vbcms_nav_178')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheeventindex PRIMARY118 8835Using where; Using index

Time Before: 0.81376 seconds
Time After: 0.82547 seconds
Time Taken: 0.01171 seconds

Memory Before: 9,050.180 KB
Memory After: 9,050.664 KB
Memory Used: 0.484 KB

SQL Query
UPDATE session
SET lastactivity = 1511191429, location = 'route:content%2F178-scat|wol|viewing_page|Scat', inforum = 0, inthread = 0, badlocation = 0
WHERE sessionhash = 'c2b316987f74e93a4a4d8d016119f8bb'

Time Before: 0.82580 seconds
Time After: 0.82646 seconds
Time Taken: 0.00066 seconds

Memory Before: 9,055.375 KB
Memory After: 9,055.594 KB
Memory Used: 0.219 KB

Page generated in 0.78474020957947 seconds with 46 queries, spending 0.037930965423584 doing MySQL queries and 0.74680924415588 doing PHP things.
Shutdown Queries:
DISABLED