Time Before: 0.00065 seconds
Time After: 0.00085 seconds
Time Taken: 0.00020 seconds

Memory Before: 398.148 KB
Memory After: 400.406 KB
Memory Used: 2.258 KB

Time Before: 0.00090 seconds
Time After: 0.00134 seconds
Time Taken: 0.00045 seconds

Memory Before: 400.391 KB
Memory After: 400.969 KB
Memory Used: 0.578 KB

SET @@sql_mode = ''

Time Before: 0.00151 seconds
Time After: 0.00178 seconds
Time Taken: 0.00027 seconds

Memory Before: 401.016 KB
Memory After: 401.070 KB
Memory Used: 0.055 KB

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

Time Before: 0.00180 seconds
Time After: 0.00797 seconds
Time Taken: 0.00617 seconds

Memory Before: 400.828 KB
Memory After: 797.297 KB
Memory Used: 396.469 KB

SELECT *
FROM datastore
WHERE title IN ('profilefield')

Time Before: 0.00860 seconds
Time After: 0.00882 seconds
Time Taken: 0.00021 seconds

Memory Before: 798.305 KB
Memory After: 814.500 KB
Memory Used: 16.195 KB

SELECT *
FROM session
WHERE userid = 0
	AND host = '216.73.216.0'
	AND idhash = 'ea5a359a73a8141a16de516480d33c34'
LIMIT 1

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

Time Before: 0.00903 seconds
Time After: 0.01096 seconds
Time Taken: 0.00193 seconds

Memory Before: 802.352 KB
Memory After: 864.672 KB
Memory Used: 62.320 KB

SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,
	calendar.calendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON
	(calendarpermission.calendarid = calendar.calendarid AND
		usergroupid IN (1))
ORDER BY displayorder ASC

Time Before: 0.01474 seconds
Time After: 0.01507 seconds
Time Taken: 0.00033 seconds

Memory Before: 935.859 KB
Memory After: 951.758 KB
Memory Used: 15.898 KB

SELECT MAX(permissions & 1) AS perm
FROM cms_permissions
WHERE nodeid = 1 AND usergroupid IN (1)

Time Before: 0.01548 seconds
Time After: 0.01574 seconds
Time Taken: 0.00026 seconds

Memory Before: 946.938 KB
Memory After: 962.992 KB
Memory Used: 16.055 KB

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_item_1_data'

Time Before: 0.03618 seconds
Time After: 0.03641 seconds
Time Taken: 0.00023 seconds

Memory Before: 1,194.039 KB
Memory After: 1,210.344 KB
Memory Used: 16.305 KB

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vb_types.types'

Time Before: 0.03787 seconds
Time After: 0.03810 seconds
Time Taken: 0.00024 seconds

Memory Before: 1,195.266 KB
Memory After: 1,211.648 KB
Memory Used: 16.383 KB

SELECT node.nodeid , (node.nodeleft = 1) AS isroot, node.contenttypeid, node.contentid, node.url, node.parentnode,
				(CASE WHEN node.contenttypeid = 24 THEN node.styleid ELSE parent.styleid end ) AS styleid, node.userid,
					(CASE WHEN node.contenttypeid = 24 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 = 1

Time Before: 0.03992 seconds
Time After: 0.04060 seconds
Time Taken: 0.00068 seconds

Memory Before: 1,233.414 KB
Memory After: 1,250.484 KB
Memory Used: 17.070 KB

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 = 1
				AND parent.nodeid != node.nodeid
				
				ORDER BY parent.nodeleft

Time Before: 0.04197 seconds
Time After: 0.04291 seconds
Time Taken: 0.00094 seconds

Memory Before: 1,238.914 KB
Memory After: 1,255.344 KB
Memory Used: 16.430 KB

SELECT nodeconfig.name, nodeconfig.value, nodeconfig.serialized
				
				FROM cms_nodeconfig AS nodeconfig
				
				WHERE nodeid = 1

Time Before: 0.04401 seconds
Time After: 0.04431 seconds
Time Taken: 0.00029 seconds

Memory Before: 1,237.852 KB
Memory After: 1,254.156 KB
Memory Used: 16.305 KB

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_nav_.67a38610d6e15d859202caa8bb997885'

Time Before: 0.04619 seconds
Time After: 0.04650 seconds
Time Taken: 0.00031 seconds

Memory Before: 1,238.133 KB
Memory After: 1,254.438 KB
Memory Used: 16.305 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

Time Before: 0.04735 seconds
Time After: 0.04768 seconds
Time Taken: 0.00032 seconds

Memory Before: 1,239.102 KB
Memory After: 1,255.391 KB
Memory Used: 16.289 KB

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'cms_priv_user_0'

Time Before: 0.05250 seconds
Time After: 0.05273 seconds
Time Taken: 0.00023 seconds

Memory Before: 1,322.227 KB
Memory After: 1,338.406 KB
Memory Used: 16.180 KB

SELECT vbcmspermissions FROM administrator WHERE userid = 0

Time Before: 0.05340 seconds
Time After: 0.05362 seconds
Time Taken: 0.00022 seconds

Memory Before: 1,322.070 KB
Memory After: 1,338.375 KB
Memory Used: 16.305 KB

SELECT nodeid,
			MAX(permissions & 1) AS canview, MAX(permissions & 2) AS cancreate , MAX(permissions & 4) AS canedit,
			MAX(permissions & 8) AS canpublish, MAX(permissions & 16) AS canusehtml, MAX(permissions & 32) AS candownload
			FROM cms_permissions p
			WHERE usergroupid IN (1)
			GROUP BY nodeid;

Time Before: 0.05396 seconds
Time After: 0.05437 seconds
Time Taken: 0.00041 seconds

Memory Before: 1,322.602 KB
Memory After: 1,339.031 KB
Memory Used: 16.430 KB

REPLACE INTO cache
SET cacheid = 'cms_priv_user_0',
	expires = 1767862600,
	created = 1767862300,
	locktime = 0,
	data = "a:10:{s:7:\"canview\";a:1:{i:0;s:1:\"1\";}s:9:\"cancreate\";a:1:{i:0;i:-1;}s:7:\"canedit\";a:1:{i:0;i:-1;}s:10:\"canpublish\";a:1:{i:0;i:-1;}s:10:\"canusehtml\";a:1:{i:0;i:-1;}s:5:\"admin\";i:0;s:11:\"candownload\";a:1:{i:0;s:1:\"1\";}s:7:\"alledit\";a:1:{i:0;i:-1;}s:8:\"viewonly\";a:1:{i:0;s:1:\"1\";}s:7:\"allview\";a:1:{i:0;s:1:\"1\";}}",
	serialized = '1'

Time Before: 0.05443 seconds
Time After: 0.05528 seconds
Time Taken: 0.00085 seconds

Memory Before: 1,349.906 KB
Memory After: 1,349.281 KB
Memory Used: -0.625 KB

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_sectionlist_long'

Time Before: 0.06808 seconds
Time After: 0.06831 seconds
Time Taken: 0.00023 seconds

Memory Before: 1,330.320 KB
Memory After: 1,346.625 KB
Memory Used: 16.305 KB

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 < 1767862300 AND child.contenttypeid <> 24) 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 = 24)
			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;

Time Before: 0.06946 seconds
Time After: 0.07029 seconds
Time Taken: 0.00082 seconds

Memory Before: 1,332.164 KB
Memory After: 1,348.383 KB
Memory Used: 16.219 KB

SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid   ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid,
						node.layoutid, node.publishdate, node.setpublish, node.issection, parent.permissionsfrom as parentpermissions,
						node.showrating,
						node.permissionsfrom, node.publicpreview, node.shownav, node.hidden, node.nosearch , info.description, info.title, info.viewcount, info.creationdate, info.workflowdate,
					 info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid,
					 user.username, sectionorder.displayorder
					 
					 
				FROM 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)) AND
				node.setpublish > 0 AND node.publishdate < 1767862300 ))AND node.new != 1 
				
				  ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
					 node.publishdate DESC

Time Before: 0.07080 seconds
Time After: 0.07124 seconds
Time Taken: 0.00043 seconds

Memory Before: 1,331.977 KB
Memory After: 1,348.156 KB
Memory Used: 16.180 KB

SELECT *
FROM style
WHERE (styleid = 1)
	OR styleid = 13
ORDER BY styleid ASC
LIMIT 1

Time Before: 0.07302 seconds
Time After: 0.07378 seconds
Time Taken: 0.00076 seconds

Memory Before: 1,329.789 KB
Memory After: 1,570.438 KB
Memory Used: 240.648 KB

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_view_data_1'

Time Before: 0.07876 seconds
Time After: 0.07899 seconds
Time Taken: 0.00022 seconds

Memory Before: 1,764.203 KB
Memory After: 1,780.508 KB
Memory Used: 16.305 KB

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_types.types'

Time Before: 0.08441 seconds
Time After: 0.08466 seconds
Time Taken: 0.00025 seconds

Memory Before: 1,844.070 KB
Memory After: 1,860.453 KB
Memory Used: 16.383 KB

SELECT text, languageid
FROM phrase AS phrase
INNER JOIN phrasetype USING(fieldname)
WHERE phrase.fieldname = 'error'
	AND varname = 'access_denied_message'
	AND languageid IN (-1, 0, 1)

Time Before: 0.09085 seconds
Time After: 0.09197 seconds
Time Taken: 0.00111 seconds

Memory Before: 1,930.484 KB
Memory After: 1,946.414 KB
Memory Used: 15.930 KB

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vbcms_nav_.92101c3093e08c3543726b53f85fe1c2'

Time Before: 0.09366 seconds
Time After: 0.09391 seconds
Time Taken: 0.00025 seconds

Memory Before: 1,931.367 KB
Memory After: 1,947.672 KB
Memory Used: 16.305 KB

SELECT node.nodeid , (node.nodeleft = 1) AS isroot, node.contenttypeid, node.contentid, node.url, node.parentnode,
				(CASE WHEN node.contenttypeid = 24 THEN node.styleid ELSE parent.styleid end ) AS styleid, node.userid,
					(CASE WHEN node.contenttypeid = 24 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 = 1

Time Before: 0.09438 seconds
Time After: 0.09475 seconds
Time Taken: 0.00037 seconds

Memory Before: 1,933.086 KB
Memory After: 1,950.156 KB
Memory Used: 17.070 KB

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 = 1
				AND parent.nodeid != node.nodeid
				
				ORDER BY parent.nodeleft

Time Before: 0.09530 seconds
Time After: 0.09607 seconds
Time Taken: 0.00077 seconds

Memory Before: 1,932.680 KB
Memory After: 1,949.109 KB
Memory Used: 16.430 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

Time Before: 0.09649 seconds
Time After: 0.09682 seconds
Time Taken: 0.00033 seconds

Memory Before: 1,932.555 KB
Memory After: 1,948.844 KB
Memory Used: 16.289 KB

SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid   ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid,
						node.layoutid, node.publishdate, node.setpublish, node.issection, parent.permissionsfrom as parentpermissions,
						node.showrating,
						node.permissionsfrom, node.publicpreview, node.shownav, node.hidden, node.nosearch , info.description, info.title, info.viewcount, info.creationdate, info.workflowdate,
					 info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid,
					 user.username, sectionorder.displayorder
					 
					 
				FROM 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)) AND
				node.setpublish > 0 AND node.publishdate < 1767862300 ))AND node.new != 1 
				
				  ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
					 node.publishdate DESC

Time Before: 0.09741 seconds
Time After: 0.09788 seconds
Time Taken: 0.00046 seconds

Memory Before: 1,935.789 KB
Memory After: 1,951.969 KB
Memory Used: 16.180 KB

SELECT phrasegroup_wol AS wol
				FROM language
				WHERE languageid = 1

Time Before: 0.09865 seconds
Time After: 0.09904 seconds
Time Taken: 0.00039 seconds

Memory Before: 1,922.313 KB
Memory After: 1,938.648 KB
Memory Used: 16.336 KB

SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
	AND varname = 'nopermission_loggedout' AND languageid IN (-1, 0, 1)

Time Before: 0.10001 seconds
Time After: 0.10044 seconds
Time Taken: 0.00043 seconds

Memory Before: 2,018.820 KB
Memory After: 2,034.938 KB
Memory Used: 16.117 KB

SELECT title, template
FROM template
WHERE templateid IN (958,990,991,1011,0,0,417,411,410,415,416,414,413,418,419,420,726,1000,672,676,673,674,675,1030,0,0,1010,971,696,697,699,700,923,1042,1024,974,975,523,522,526,85)

Time Before: 0.10304 seconds
Time After: 0.10370 seconds
Time Taken: 0.00066 seconds

Memory Before: 2,159.359 KB
Memory After: 2,257.227 KB
Memory Used: 97.867 KB

REPLACE INTO cacheevent
	(cacheid, event)
VALUES ('cms_priv_user_0', 'cms_permissions_change'),
	('cms_priv_user_0', 'permissions_0')

Time Before: 0.10746 seconds
Time After: 0.10880 seconds
Time Taken: 0.00134 seconds

Memory Before: 2,405.344 KB
Memory After: 2,405.320 KB
Memory Used: -0.023 KB

UPDATE session
SET lastactivity = 1767862300, location = '/content.php?explain=1', badlocation = 1
WHERE sessionhash = 'ba4c8c2fa72a6db55d198bdc54149d2a'

Time Before: 0.10887 seconds
Time After: 0.10915 seconds
Time Taken: 0.00028 seconds

Memory Before: 2,405.219 KB
Memory After: 2,405.133 KB
Memory Used: -0.086 KB