Including Functions.php

Time Before: 0.00018 seconds
Time After: 0.00020 seconds
Time Taken: 0.00002 seconds

Memory Before: 428.961 KB
Memory After: 495.914 KB
Memory Used: 66.953 KB

Connect to Database on Server: localhost

Time Before: 0.00022 seconds
Time After: 0.00045 seconds
Time Taken: 0.00023 seconds

Memory Before: 495.867 KB
Memory After: 496.758 KB
Memory Used: 0.891 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00051 seconds
Time After: 0.00056 seconds
Time Taken: 0.00005 seconds

Memory Before: 496.781 KB
Memory After: 496.836 KB
Memory Used: 0.055 KB

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

Time Before: 0.00084 seconds
Time After: 0.00115 seconds
Time Taken: 0.00031 seconds

Memory Before: 498.477 KB
Memory After: 655.734 KB
Memory Used: 157.258 KB

Time Before: 0.00058 seconds
Time After: 0.00903 seconds
Time Taken: 0.00845 seconds

Memory Before: 496.602 KB
Memory After: 941.688 KB
Memory Used: 445.086 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('profilefield')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.00938 seconds
Time After: 0.00946 seconds
Time Taken: 0.00008 seconds

Memory Before: 1,099.109 KB
Memory After: 1,115.367 KB
Memory Used: 16.258 KB

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

Time Before: 0.00976 seconds
Time After: 0.00990 seconds
Time Taken: 0.00014 seconds

Memory Before: 1,129.727 KB
Memory After: 1,146.414 KB
Memory Used: 16.688 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.01023 seconds
Time After: 0.01048 seconds
Time Taken: 0.00025 seconds

Memory Before: 1,137.117 KB
Memory After: 1,205.680 KB
Memory Used: 68.563 KB

Time Before: 0.00954 seconds
Time After: 0.01052 seconds
Time Taken: 0.00098 seconds

Memory Before: 1,126.922 KB
Memory After: 1,190.828 KB
Memory Used: 63.906 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.01254 seconds
Time After: 0.01263 seconds
Time Taken: 0.00010 seconds

Memory Before: 1,312.578 KB
Memory After: 1,328.688 KB
Memory Used: 16.109 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.01298 seconds
Time After: 0.01352 seconds
Time Taken: 0.00053 seconds

Memory Before: 1,505.570 KB
Memory After: 1,527.070 KB
Memory Used: 21.500 KB

SQL Query
SELECT node.nodeid , (node.nodeleft = 1) AS isroot, node.contenttypeid, node.contentid, node.url, node.parentnode,
				(CASE WHEN node.contenttypeid = 17 THEN node.styleid ELSE parent.styleid end ) AS styleid, node.userid,
					(CASE WHEN node.contenttypeid = 17 THEN node.layoutid ELSE parent.layoutid end ) AS layoutid,
					node.publishdate, node.setpublish, node.issection, node.permissionsfrom, node.nodeleft, node.noderight, node.new,
					node.userid, node.showtitle, node.showuser, node.showpreviewonly, node.lastupdated, node.showall, node.showrating,
					node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren,
					parent.permissionsfrom as parentpermissions, node.publicpreview, node.comments_enabled, node.shownav,
					node.hidden, node.nosearch, node.new 
					
				FROM cms_node AS node
				LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode 
				
				WHERE node.nodeid = 114
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeconstPRIMARYPRIMARY4const1 
1SIMPLEparentconstPRIMARYPRIMARY4const1 

Time Before: 0.01391 seconds
Time After: 0.01413 seconds
Time Taken: 0.00022 seconds

Memory Before: 1,528.867 KB
Memory After: 1,545.992 KB
Memory Used: 17.125 KB

SQL Query
SELECT node.nodeid , (node.nodeleft = 1) AS isroot, node.contenttypeid, node.contentid, node.url, node.parentnode,
				(CASE WHEN node.contenttypeid = 17 THEN node.styleid ELSE parent.styleid end ) AS styleid, node.userid,
					(CASE WHEN node.contenttypeid = 17 THEN node.layoutid ELSE parent.layoutid end ) AS layoutid,
					node.publishdate, node.setpublish, node.issection, node.permissionsfrom, node.nodeleft, node.noderight, node.new,
					node.userid, node.showtitle, node.showuser, node.showpreviewonly, node.lastupdated, node.showall, node.showrating,
					node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren,
					parent.permissionsfrom as parentpermissions, node.publicpreview, node.comments_enabled, node.shownav,
					node.hidden, node.nosearch, node.new , info.description, info.title, info.html_title, info.viewcount, info.creationdate, info.workflowdate, info.keywords,
					info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid, info.creationdate, node.showrating,
					info.ratingnum, info.ratingtotal, info.rating,
					user.username, thread.replycount, 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 thread AS thread ON thread.threadid = info.associatedthreadid
				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.nodeid = 114
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeconstPRIMARYPRIMARY4const1 
1SIMPLEinfoconstPRIMARYPRIMARY4const1 
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEthreadconstPRIMARYPRIMARY4const1Unique row not found
1SIMPLEsectionorderconstsectionidsectionid8const,const1Unique row not found
1SIMPLEparentconstPRIMARYPRIMARY4const1 

Time Before: 0.01477 seconds
Time After: 0.01515 seconds
Time Taken: 0.00038 seconds

Memory Before: 1,538.906 KB
Memory After: 1,556.031 KB
Memory Used: 17.125 KB

SQL Query
SELECT parent.nodeid, parent.url, parent.publishdate, parent.setpublish, parent.issection, parent.hidden,
						info.title, info.html_title, info.description, node.nodeleft, parent.styleid
				
				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
				WHERE node.nodeid = 114
				AND parent.nodeid != node.nodeid
				
				ORDER BY parent.nodeleft
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeconstPRIMARY,nodeleftPRIMARY4const1 
1SIMPLEparentrangePRIMARY,nodeleft,noderightnodeleft4 2Using index condition; Using where
1SIMPLEinfoeq_refPRIMARYPRIMARY4vbsuite_dev.parent.nodeid1 

Time Before: 0.01548 seconds
Time After: 0.01564 seconds
Time Taken: 0.00016 seconds

Memory Before: 1,545.594 KB
Memory After: 1,562.281 KB
Memory Used: 16.688 KB

SQL Query
SELECT nodeconfig.name, nodeconfig.value, nodeconfig.serialized
				
				FROM cms_nodeconfig AS nodeconfig
				
				WHERE nodeid = 114
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeconfigrefunique_1,nodeidunique_14const5 

Time Before: 0.01582 seconds
Time After: 0.01593 seconds
Time Taken: 0.00011 seconds

Memory Before: 1,546.594 KB
Memory After: 1,563.344 KB
Memory Used: 16.750 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 (114,1) AND navigation.nodelist IS NOT NULL AND (navigation.nodelist <> '')
				
				ORDER BY node.nodeleft DESC LIMIT 0,1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnavigationrangePRIMARYPRIMARY4 2Using index condition; Using where; Using temporary; Using filesort
1SIMPLEnodeeq_refPRIMARYPRIMARY4vbsuite_dev.navigation.nodeid1 
1SIMPLEnodeinfoeq_refPRIMARYPRIMARY4vbsuite_dev.navigation.nodeid1 

Time Before: 0.01647 seconds
Time After: 0.01681 seconds
Time Taken: 0.00035 seconds

Memory Before: 1,551.102 KB
Memory After: 1,567.695 KB
Memory Used: 16.594 KB

SQL Query
SELECT vbcmspermissions FROM administrator WHERE userid = 0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.01704 seconds
Time After: 0.01711 seconds
Time Taken: 0.00007 seconds

Memory Before: 1,632.883 KB
Memory After: 1,649.234 KB
Memory Used: 16.352 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 (1)
			GROUP BY nodeid;
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEprefusergroupidusergroupid4const1Using where

Time Before: 0.01732 seconds
Time After: 0.01745 seconds
Time Taken: 0.00014 seconds

Memory Before: 1,633.414 KB
Memory After: 1,649.898 KB
Memory Used: 16.484 KB

SQL Query
SELECT node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
			node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden, COUNT(child.nodeid) AS children,
  			SUM(CASE WHEN (child.setpublish > 0 AND child.publishdate < 1764996232 AND child.contenttypeid <> 17) THEN 1 ELSE 0 END) AS publish_count
			FROM cms_node AS node
			LEFT JOIN cms_node AS child ON child.parentnode = node.nodeid AND child.new != 1
			LEFT JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
			WHERE (node.contenttypeid = 17)
			GROUP BY node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
			node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden  HAVING COUNT(child.nodeid) > 0 
			ORDER by node.nodeleft;
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnoderefcontentid,contenttypecontentid4const3Using where; Using temporary; Using filesort
1SIMPLEchildrefparentnode,newparentnode5vbsuite_dev.node.nodeid2Using where
1SIMPLEinfoeq_refPRIMARYPRIMARY4vbsuite_dev.node.nodeid1 

Time Before: 0.01787 seconds
Time After: 0.01837 seconds
Time Taken: 0.00050 seconds

Memory Before: 1,650.070 KB
Memory After: 1,667.008 KB
Memory Used: 16.938 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,114,117)  AND ( (node.permissionsfrom IN (-1)) OR ( node.permissionsfrom in (1) AND (node.parentnode IN (1,114,123) OR node.nodeid = 1) AND
				node.setpublish > 0 AND node.publishdate < 1764996232 ))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
1SIMPLEnoderangePRIMARY,parentnode,publishdate,newPRIMARY4 3Using index condition; Using where; Using temporary; Using filesort
1SIMPLEinfoeq_refPRIMARYPRIMARY4vbsuite_dev.node.nodeid1 
1SIMPLEusereq_refPRIMARYPRIMARY4vbsuite_dev.node.userid1 
1SIMPLEsectionordereq_refsectionidsectionid8vbsuite_dev.node.parentnode,vbsuite_dev.node.nodeid1Using where
1SIMPLEparenteq_refPRIMARYPRIMARY4vbsuite_dev.node.parentnode1Using where

Time Before: 0.01876 seconds
Time After: 0.01940 seconds
Time Taken: 0.00064 seconds

Memory Before: 1,650.914 KB
Memory After: 1,668.727 KB
Memory Used: 17.813 KB

SQL Query
(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.01946 seconds
Time After: 0.01989 seconds
Time Taken: 0.00043 seconds

Memory Before: 1,674.398 KB
Memory After: 1,699.898 KB
Memory Used: 25.500 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 (117,114,1)
				AND parent.nodeid != node.nodeid
				
				ORDER BY parent.nodeleft, ord.displayorder
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnoderangePRIMARY,nodeleftPRIMARY4 3Using index condition; Using temporary; Using filesort
1SIMPLEordeq_refsectionidsectionid8vbsuite_dev.node.parentnode,vbsuite_dev.node.nodeid1Using where
1SIMPLEparentALLPRIMARY,nodeleft,noderight   7Range checked for each record (index map: 0xD)
1SIMPLEinfoeq_refPRIMARYPRIMARY4vbsuite_dev.parent.nodeid1 

Time Before: 0.02059 seconds
Time After: 0.02096 seconds
Time Taken: 0.00036 seconds

Memory Before: 1,756.289 KB
Memory After: 1,772.883 KB
Memory Used: 16.594 KB

SQL Query
SELECT nodeid, permissionsfrom, hidden, setpublish, publishdate, userid FROM cms_node where nodeid in (0,1,2)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcms_noderangePRIMARYPRIMARY4 3Using index condition

Time Before: 0.02116 seconds
Time After: 0.02125 seconds
Time Taken: 0.00009 seconds

Memory Before: 1,758.078 KB
Memory After: 1,774.422 KB
Memory Used: 16.344 KB

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

Time Before: 0.02149 seconds
Time After: 0.02157 seconds
Time Taken: 0.00008 seconds

Memory Before: 1,761.641 KB
Memory After: 1,777.953 KB
Memory Used: 16.313 KB

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

Time Before: 0.02171 seconds
Time After: 0.02179 seconds
Time Taken: 0.00007 seconds

Memory Before: 1,762.438 KB
Memory After: 1,778.828 KB
Memory Used: 16.391 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.02199 seconds
Time After: 0.02212 seconds
Time Taken: 0.00013 seconds

Memory Before: 1,762.969 KB
Memory After: 1,779.453 KB
Memory Used: 16.484 KB

SQL Query
SELECT
	permissionsfrom, hidden, setpublish, publishdate, userid
FROM cms_node
WHERE
	nodeid = 117
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcms_nodeconstPRIMARYPRIMARY4const1 

Time Before: 0.02233 seconds
Time After: 0.02241 seconds
Time Taken: 0.00008 seconds

Memory Before: 1,765.523 KB
Memory After: 1,781.820 KB
Memory Used: 16.297 KB

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

Time Before: 0.02270 seconds
Time After: 0.02288 seconds
Time Taken: 0.00018 seconds

Memory Before: 1,740.133 KB
Memory After: 1,876.758 KB
Memory Used: 136.625 KB

SQL Query
SELECT node.nodeid , (node.nodeleft = 1) AS isroot, node.contenttypeid, node.contentid, node.url, node.parentnode,
				(CASE WHEN node.contenttypeid = 17 THEN node.styleid ELSE parent.styleid end ) AS styleid, node.userid,
					(CASE WHEN node.contenttypeid = 17 THEN node.layoutid ELSE parent.layoutid end ) AS layoutid,
					node.publishdate, node.setpublish, node.issection, node.permissionsfrom, node.nodeleft, node.noderight, node.new,
					node.userid, node.showtitle, node.showuser, node.showpreviewonly, node.lastupdated, node.showall, node.showrating,
					node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren,
					parent.permissionsfrom as parentpermissions, node.publicpreview, node.comments_enabled, node.shownav,
					node.hidden, node.nosearch, node.new , info.description, info.title, info.html_title, info.viewcount, info.creationdate, info.workflowdate, info.keywords,
					info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid, info.creationdate, node.showrating,
					info.ratingnum, info.ratingtotal, info.rating,
					user.username, thread.replycount, 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 thread AS thread ON thread.threadid = info.associatedthreadid
				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.nodeid = 114
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeconstPRIMARYPRIMARY4const1 
1SIMPLEinfoconstPRIMARYPRIMARY4const1 
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEthreadconstPRIMARYPRIMARY4const1Unique row not found
1SIMPLEsectionorderconstsectionidsectionid8const,const1Unique row not found
1SIMPLEparentconstPRIMARYPRIMARY4const1 

Time Before: 0.03005 seconds
Time After: 0.03041 seconds
Time Taken: 0.00037 seconds

Memory Before: 2,311.852 KB
Memory After: 2,328.977 KB
Memory Used: 17.125 KB

SQL Query
SELECT nodeconfig.name, nodeconfig.value, nodeconfig.serialized
				
				FROM cms_nodeconfig AS nodeconfig
				
				WHERE nodeid = 114
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeconfigrefunique_1,nodeidunique_14const5 

Time Before: 0.03067 seconds
Time After: 0.03080 seconds
Time Taken: 0.00014 seconds

Memory Before: 2,319.359 KB
Memory After: 2,336.109 KB
Memory Used: 16.750 KB

SQL Query
SELECT parent.nodeid, parent.url, parent.publishdate, parent.setpublish, parent.issection, parent.hidden,
						info.title, info.html_title, info.description, node.nodeleft, parent.styleid
				
				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
				WHERE node.nodeid = 114
				AND parent.nodeid != node.nodeid
				
				ORDER BY parent.nodeleft
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeconstPRIMARY,nodeleftPRIMARY4const1 
1SIMPLEparentrangePRIMARY,nodeleft,noderightnodeleft4 2Using index condition; Using where
1SIMPLEinfoeq_refPRIMARYPRIMARY4vbsuite_dev.parent.nodeid1 

Time Before: 0.03126 seconds
Time After: 0.03147 seconds
Time Taken: 0.00021 seconds

Memory Before: 2,328.617 KB
Memory After: 2,345.305 KB
Memory Used: 16.688 KB

SQL Query
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 = 114
					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 = 114 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,114,123) OR node.nodeid = 1) AND
				node.setpublish > 0 AND node.publishdate < 1764996232 ))) OR (node.setpublish AND node.publishdate <1764996232 AND node.publicpreview > 0))AND node.hidden = 0  AND ((node.setpublish = '1' AND node.publishdate <= 1764996232 ) OR node.userid = 0)  AND (node.parentnode = 114 OR sectionorder.displayorder > 0 ) AND sectionorder.displayorder > 0 
				
				  ORDER BY sectionorder.displayorder ASC  LIMIT 0, 7
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErootnodeconstPRIMARY,nodeleft,noderightPRIMARY4const1 
1SIMPLEsectionorderrefsectionidsectionid4const1Using where; Using filesort
1SIMPLEnodeeq_ref|filterPRIMARY,contentid,nodeleft,parentnode,contenttype,publishdate,newPRIMARY|nodeleft4|4vbsuite_dev.sectionorder.nodeid1 (14%)Using index condition; Using where; Using rowid filter
1SIMPLEinfoeq_refPRIMARYPRIMARY4vbsuite_dev.node.nodeid1 
1SIMPLEparenteq_refPRIMARYPRIMARY4vbsuite_dev.node.parentnode1Using where
1SIMPLEparentinfoeq_refPRIMARYPRIMARY4vbsuite_dev.parent.nodeid1Using where
1SIMPLEusereq_refPRIMARYPRIMARY4vbsuite_dev.node.userid1 
1SIMPLEthreadeq_refPRIMARYPRIMARY4vbsuite_dev.info.associatedthreadid1 

Time Before: 0.03236 seconds
Time After: 0.03277 seconds
Time Taken: 0.00041 seconds

Memory Before: 2,352.430 KB
Memory After: 2,368.656 KB
Memory Used: 16.227 KB

SQL Query
SELECT FOUND_ROWS()
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       No tables used

Time Before: 0.03294 seconds
Time After: 0.03302 seconds
Time Taken: 0.00008 seconds

Memory Before: 2,365.094 KB
Memory After: 2,381.547 KB
Memory Used: 16.453 KB

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

Time Before: 0.03332 seconds
Time After: 0.03340 seconds
Time Taken: 0.00008 seconds

Memory Before: 2,349.602 KB
Memory After: 2,366.055 KB
Memory Used: 16.453 KB

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

Time Before: 0.03356 seconds
Time After: 0.03365 seconds
Time Taken: 0.00009 seconds

Memory Before: 2,349.852 KB
Memory After: 2,366.320 KB
Memory Used: 16.469 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,27,20)
				ORDER BY widget.title ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetrangePRIMARYPRIMARY4 3Using index condition; Using filesort

Time Before: 0.03392 seconds
Time After: 0.03410 seconds
Time Taken: 0.00018 seconds

Memory Before: 2,367.586 KB
Memory After: 2,384.211 KB
Memory Used: 16.625 KB

SQL Query
SELECT widgetid AS itemid, name, value, (nodeid = 0) instance, serialized
				
				FROM cms_widgetconfig
				
				WHERE widgetid IN (27,2,20)
				AND nodeid = 0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcms_widgetconfigALLPRIMARY   98Using where

Time Before: 0.03442 seconds
Time After: 0.03461 seconds
Time Taken: 0.00019 seconds

Memory Before: 2,381.445 KB
Memory After: 2,401.242 KB
Memory Used: 19.797 KB

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

Time Before: 0.03528 seconds
Time After: 0.03546 seconds
Time Taken: 0.00018 seconds

Memory Before: 2,576.633 KB
Memory After: 2,653.070 KB
Memory Used: 76.438 KB

SQL Query
SELECT forum.title from forum AS
				forum WHERE forumid = 3
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumconstPRIMARYPRIMARY2const1 

Time Before: 0.03896 seconds
Time After: 0.03912 seconds
Time Taken: 0.00016 seconds

Memory Before: 2,741.813 KB
Memory After: 2,758.109 KB
Memory Used: 16.297 KB

SQL Query
SELECT searchcore.searchcoreid, searchcore.dateline
FROM searchcore AS searchcore
			
WHERE searchcore.dateline >= 1763786632 AND searchcore.contenttypeid IN (18)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsearchcorerangecontentunique,datelinedateline4 1Using index condition; Using where

Time Before: 0.03944 seconds
Time After: 0.03958 seconds
Time Taken: 0.00014 seconds

Memory Before: 2,746.258 KB
Memory After: 2,762.609 KB
Memory Used: 16.352 KB

SQL Query
REPLACE INTO searchlog
	(userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,criteria,results)
VALUES
	(0,'216.73.216.48','36d1844d44f3765cad2fbcbfc068c26c','dateline','desc',0,1764996232,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:18;}}s:8:\"dateline\";a:1:{s:2:\"gt\";i:1763786632;}s:7:\"forumid\";a:1:{s:3:\"neq\";i:3;}}s:24:\"\0vB_Search_Criteria\0sort\";a:2:{i:0;s:8:\"dateline\";i:1;s:4:\"desc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i:2;s:31:\"\0vB_Search_Criteria\0searchterms\";N;s:32:\"\0vB_Search_Criteria\0criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";s:2:\"18\";s:35:\"\0vB_Search_Criteria\0display_strings\";a:3:{s:4:\"type\";s:10:\": Articles\";s:13:\"exclude_forum\";N;s:4:\"date\";s:18:\"Date    11-22-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:0:{}s:11:\"search_type\";s:8:\"advanced\";}','')

Time Before: 0.03968 seconds
Time After: 0.07848 seconds
Time Taken: 0.03880 seconds

Memory Before: 2,750.141 KB
Memory After: 2,750.391 KB
Memory Used: 0.250 KB

SQL Query
UPDATE searchlog
SET results = 'a:4:{i:0;a:0:{}i:1;i:-1;i:2;N;i:3;N;}'
WHERE searchlogid = 472502

Time Before: 0.07853 seconds
Time After: 0.08680 seconds
Time Taken: 0.00827 seconds

Memory Before: 2,746.102 KB
Memory After: 2,746.195 KB
Memory Used: 0.094 KB

SQL Query
UPDATE searchlog
SET searchtime = 0.04766,
	completed = 1
WHERE searchlogid = 472502

Time Before: 0.08685 seconds
Time After: 0.09508 seconds
Time Taken: 0.00823 seconds

Memory Before: 2,745.789 KB
Memory After: 2,745.758 KB
Memory Used: -0.031 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('blogcategorycache','profilefield')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY50 2Using index condition

Time Before: 0.09550 seconds
Time After: 0.09567 seconds
Time Taken: 0.00017 seconds

Memory Before: 2,750.102 KB
Memory After: 2,766.398 KB
Memory Used: 16.297 KB

SQL Query
SELECT forum.title from forum AS
				forum WHERE forumid = 3
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumconstPRIMARYPRIMARY2const1 

Time Before: 0.09585 seconds
Time After: 0.09593 seconds
Time Taken: 0.00007 seconds

Memory Before: 2,751.859 KB
Memory After: 2,768.156 KB
Memory Used: 16.297 KB

SQL Query
SELECT searchcore.searchcoreid, searchcore.dateline
FROM searchcore AS searchcore
			
WHERE searchcore.dateline >= 1763268232 AND searchcore.contenttypeid IN (15)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsearchcorerefcontentunique,datelinecontentunique4const1Using where

Time Before: 0.09614 seconds
Time After: 0.09626 seconds
Time Taken: 0.00012 seconds

Memory Before: 2,754.016 KB
Memory After: 2,770.367 KB
Memory Used: 16.352 KB

SQL Query
REPLACE INTO searchlog
	(userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,criteria,results)
VALUES
	(0,'216.73.216.48','ac6f173eb3405c5330a3a1f0987d7082','dateline','desc',0,1764996232,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:15;}}s:8:\"dateline\";a:1:{s:2:\"gt\";i:1763268232;}s:7:\"forumid\";a:1:{s:3:\"neq\";i:3;}}s:24:\"\0vB_Search_Criteria\0sort\";a:2:{i:0;s:8:\"dateline\";i:1;s:4:\"desc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i:2;s:31:\"\0vB_Search_Criteria\0searchterms\";N;s:32:\"\0vB_Search_Criteria\0criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";s:2:\"15\";s:35:\"\0vB_Search_Criteria\0display_strings\";a:3:{s:4:\"type\";s:14:\": Blog Entries\";s:13:\"exclude_forum\";N;s:4:\"date\";s:18:\"Date    11-16-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:0:{}s:11:\"search_type\";s:8:\"advanced\";}','')

Time Before: 0.09631 seconds
Time After: 0.10336 seconds
Time Taken: 0.00705 seconds

Memory Before: 2,757.898 KB
Memory After: 2,758.148 KB
Memory Used: 0.250 KB

SQL Query
UPDATE searchlog
SET results = 'a:4:{i:0;a:0:{}i:1;i:-1;i:2;N;i:3;N;}'
WHERE searchlogid = 472503

Time Before: 0.10339 seconds
Time After: 0.11178 seconds
Time Taken: 0.00838 seconds

Memory Before: 2,753.859 KB
Memory After: 2,753.953 KB
Memory Used: 0.094 KB

SQL Query
UPDATE searchlog
SET searchtime = 0.01583,
	completed = 1
WHERE searchlogid = 472503

Time Before: 0.11180 seconds
Time After: 0.12010 seconds
Time Taken: 0.00829 seconds

Memory Before: 2,753.547 KB
Memory After: 2,753.516 KB
Memory Used: -0.031 KB

SQL Query
SELECT node.nodeid, node.parentnode, node.url, node.permissionsfrom,
			node.setpublish, node.publishdate, node.noderight, info.title FROM cms_node AS node INNER JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
			 WHERE node.contenttypeid = 17  AND
		((node.permissionsfrom IN (1)  AND node.hidden = 0 ) OR (node.permissionsfrom IN (-1)))
			 ORDER BY node.nodeleft
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnoderefPRIMARY,contentid,contenttypecontentid4const3Using where; Using filesort
1SIMPLEinfoeq_refPRIMARYPRIMARY4vbsuite_dev.node.nodeid1 

Time Before: 0.12058 seconds
Time After: 0.12083 seconds
Time Taken: 0.00025 seconds

Memory Before: 2,749.164 KB
Memory After: 2,765.508 KB
Memory Used: 16.344 KB

SQL Query
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%'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangetitletitle102 512Using where; Using index

Time Before: 0.12142 seconds
Time After: 0.12193 seconds
Time Taken: 0.00050 seconds

Memory Before: 2,758.070 KB
Memory After: 2,795.672 KB
Memory Used: 37.602 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (32694,32726,32727,32747,0,0,7160,7154,18829,7158,7159,7157,7156,7161,7162,7163,32462,32736,32408,32412,32409,32410,32411,32766,0,0,32746,32707,32432,32433,32435,32436,32659,32778,32760,32710,32711,32259,32258,32262,5067,5038,6105,6107,31822,32720,31943,31963,32199,32621,31906,32765,32493,32498,32496,32244,32245,32246,32247,32248,32249,32250,32251,32252,32253,32254,0,0,32255,32418,32419,32420,32421,32422,32423,32424,32425,32426,31907,31909,31910,31911,31912,31913,31914,31915,31916,31917,31918,31919,31920,31921,31922,31923,31924,31925,31926,31927,31928,31929,31930,31931,31932,31934,31935,31936,31937,31938,31939,31940,976,0,0,0,0,0,0,0,977,978,979,980,981,982,983,984,31944,31945,31946,31947,31948,31950,31951,31952,31953,31954,31955,31956,31957,31958,31959,31960,31961,31962,31964,31965,31966,31967,31968,31969,31970,31971,31972,31973,31974,31975,31976,31977,31978,31979,31980,31981,31982,31983,31984,31985,31986,31987,31988,31989,31990,31991,31992,31993,31994,31995,31996,31997,31998,31999,32000,32001,32002,32003,32004,32005,32006,32007,32008,32009,32010,32011,6106,6104,32012,32013,32014,32015,32016,32017,32018,32019,32020,32021,32022,32023,32024,32025,32026,32027,32028,32029,32030,32031)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 202Using index condition

Time Before: 0.12352 seconds
Time After: 0.12489 seconds
Time Taken: 0.00137 seconds

Memory Before: 3,024.148 KB
Memory After: 3,570.539 KB
Memory Used: 546.391 KB

SQL Query
SELECT phrasegroup_messaging AS messaging
				FROM language
				WHERE languageid = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguagesystemPRIMARY   1 

Time Before: 0.12671 seconds
Time After: 0.12696 seconds
Time Taken: 0.00025 seconds

Memory Before: 3,486.953 KB
Memory After: 3,503.344 KB
Memory Used: 16.391 KB

SQL Query
SELECT cacheid
FROM cacheevent
WHERE event IN ('vbcms_nav_114')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.12843 seconds
Time After: 0.12857 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,633.500 KB
Memory After: 3,649.617 KB
Memory Used: 16.117 KB

SQL Query
UPDATE session
SET location = 'route:content%2F114-Documentation|wol|viewing_page|Documentation', inforum = 0, inthread = 0, badlocation = 0
WHERE sessionhash = '0fcbc3c6fdaea91b34f40f93920f0cf9'

Time Before: 0.12862 seconds
Time After: 0.12878 seconds
Time Taken: 0.00016 seconds

Memory Before: 3,634.461 KB
Memory After: 3,634.336 KB
Memory Used: -0.125 KB

Page generated in 0.1280951499939 seconds with 51 queries, spending 0.090001344680786 doing MySQL queries and 0.03809380531311 doing PHP things.
Shutdown Queries: DISABLED