We continue with the Project V4

On 22nd and 23rd of June 2017 experts from V4 will meet again in Lindner Hotel Gallery Central, Bratislava, for the 3rd and 4th Round Table Discussions. This meeting will be focused namely on problems and solutions in the field of health and social problems of persons with disabilities. We are expecting again about 18 – 20 participants, including 8 confirmed participants from Poland, Hungary and Czech Republic. For more information on the schedule of the meeting see the program on the Project V4 web site.

PARTNERS

Debugging Information

ColdFusion Server Standard	10,0,0,283922
Template	/index.cfm
Time Stamp	24-Aug-23 09:53 AM
Locale	English (US)
User Agent	Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
Remote IP	78.141.79.228
Host Name	78.141.79.228

Execution Time

Total Time	Avg Time	Count	Template
47 ms	47 ms	1	D:\projects\aozpo\Site\wwwroot\index.cfm
31 ms	31 ms	1	D:/projects/aozpo/Site/modules/Default/objects/Default.cfm
16 ms	16 ms	1	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/Document/Document.cfm
16 ms	16 ms	1	D:/projects/aozpo/Site/modules/ActiveWeb/main/SetRequestVariables.cfm
15 ms	3 ms	5	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/WebObjects/WebObject.cfm
15 ms	15 ms	1	D:/projects/aozpo/Site/modules/Default/objects/FooterObject.cfm
0 ms	0 ms	1	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/ActiveWebRequestSettings.cfm
0 ms	0 ms	1	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/BrowseEdit.cfm
0 ms	0 ms	4	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/Category.cfm
0 ms	0 ms	1	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/NavigationVariablesSetup.cfm
0 ms	0 ms	7	D:/projects/aozpo/Site/functions/ShowLabel.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/ActiveWeb/graphics/WebPage.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/ActiveWeb/objects/Document.cfm
0 ms	0 ms	2	D:/projects/aozpo/Site/modules/Default/objects/BodyObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Default/objects/FooterMenuObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Default/objects/HeaderObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Default/objects/LeftMenuObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Default/objects/LeftSection.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Default/objects/NavigationBarObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Default/objects/RightSection.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Default/objects/SearchObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Default/objects/TopMenuObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/wwwroot/Application.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
47 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

qCheckGroup (Datasource=aozpo, Time=0ms, Records=0) in D:\projects\aozpo\Site\wwwroot\Application.cfm @ 09:53:31.031

	SELECT a.Status, b.GroupID, b.GroupTitle
      FROM us_vUser a
      LEFT OUTER JOIN us_vUserGroup b ON (a.UserID = b.UserID)
     WHERE a.UserID = '0'
       AND a.ProjectID = '2'
	   AND b.GroupID IN (52, 51)

qGetDocument (Datasource=aozpo, Time=16ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\Document\Document.cfm @ 09:53:31.031

		SELECT  
			DocumentID, DocumentSystemTitle, CategoryID, DocumentType, VersionNumber, LanguageID
			
			FROM aw_vDocument
			WHERE ProjectID = '2'
			  AND UILanguageID = 'en'
	
			
			  AND DocumentID = '3222'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'approved'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY VersionNumber DESC

qGetCategory (Datasource=aozpo, Time=0ms, Records=4) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\Category.cfm @ 09:53:31.031

		SELECT 
			CategoryID, ParentCategoryID, CategoryTitleSys, CategoryType,
	        CategoryTitle, LanguageID, URL, URLTarget, RecordOrder, Status
			FROM ca_vCategory
			WHERE ProjectID = '2'
	
			
			  AND LanguageID = 'en'
			
			  AND ParentCategoryID = '156'
			
			  AND Status = 'active'
						
			

			ORDER BY RecordOrder ASC

qGetCategory (Datasource=aozpo, Time=0ms, Records=11) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\Category.cfm @ 09:53:31.031

		SELECT 
			CategoryID, ParentCategoryID, CategoryTitleSys, CategoryType,
	        CategoryTitle, LanguageID, URL, URLTarget, RecordOrder, Status
			FROM ca_vCategory
			WHERE ProjectID = '2'
	
			
			  AND LanguageID = 'en'
			
			  AND ParentCategoryID = '121'
			
			  AND Status = 'active'
						
			

			ORDER BY RecordOrder ASC

qGetCategory (Datasource=aozpo, Time=0ms, Records=0) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\Category.cfm @ 09:53:31.031

		SELECT 
			CategoryID, ParentCategoryID, CategoryTitleSys, CategoryType,
	        CategoryTitle, LanguageID, URL, URLTarget, RecordOrder, Status
			FROM ca_vCategory
			WHERE ProjectID = '2'
	
			
			  AND LanguageID = 'en'
			
			  AND ParentCategoryID = '326'
			
			  AND Status = 'active'
						
			

			ORDER BY RecordOrder ASC

qGetWebObject (Datasource=aozpo, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\WebObjects\WebObject.cfm @ 09:53:31.031

		SELECT 
			WebObjectID, WebObjectSystemTitle, LanguageID, Content
			FROM  aw_vWebObject a
			WHERE ProjectID = '2'

			
			  AND WebObjectSystemTitle = 'Left_Banner'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'active'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY WebObjectSystemTitle

qGetWebObject (Datasource=aozpo, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\WebObjects\WebObject.cfm @ 09:53:31.031

		SELECT 
			WebObjectID, WebObjectSystemTitle, LanguageID, Content
			FROM  aw_vWebObject a
			WHERE ProjectID = '2'

			
			  AND WebObjectSystemTitle = 'Left_Banner2'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'active'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY WebObjectSystemTitle

qGetDocument (Datasource=aozpo, Time=0ms, Records=1) in D:\projects\aozpo\Site\modules\ActiveWeb\objects\Document.cfm @ 09:53:31.031

	SELECT 
		DocumentID, CategoryID, DocumentType, VersionNumber, LanguageID
		
			, DocumentTitle, DocumentDescription, 
			Content, Status, Author, AuthorEmail, IssuedDate
		
		FROM aw_vDocument
		WHERE ProjectID = '2'
		  AND UILanguageID = 'en'

		
		  AND DocumentID = '3222'
		
		  AND LanguageID = 'en'
		
		  AND Status = 'approved'
		  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
		  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
		

		ORDER BY VersionNumber DESC

qGetWebObject (Datasource=aozpo, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\WebObjects\WebObject.cfm @ 09:53:31.031

		SELECT 
			WebObjectID, WebObjectSystemTitle, LanguageID, Content
			FROM  aw_vWebObject a
			WHERE ProjectID = '2'

			
			  AND WebObjectSystemTitle = 'RIGHT_Banner'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'active'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY WebObjectSystemTitle

qGetWebObject (Datasource=aozpo, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\WebObjects\WebObject.cfm @ 09:53:31.031

		SELECT 
			WebObjectID, WebObjectSystemTitle, LanguageID, Content
			FROM  aw_vWebObject a
			WHERE ProjectID = '2'

			
			  AND WebObjectSystemTitle = 'RIGHT_Banner2'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'active'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY WebObjectSystemTitle

qGetWebObject (Datasource=aozpo, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\WebObjects\WebObject.cfm @ 09:53:31.031

		SELECT 
			WebObjectID, WebObjectSystemTitle, LanguageID, Content
			FROM  aw_vWebObject a
			WHERE ProjectID = '2'

			
			  AND WebObjectSystemTitle = 'Text_Copyright'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'active'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY WebObjectSystemTitle

qGetCategory (Datasource=aozpo, Time=0ms, Records=0) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\Category.cfm @ 09:53:31.031

		SELECT 
			CategoryID, ParentCategoryID, CategoryTitleSys, CategoryType,
	        CategoryTitle, LanguageID, URL, URLTarget, RecordOrder, Status
			FROM ca_vCategory
			WHERE ProjectID = '2'
	
			
			  AND LanguageID = 'en'
			
			  AND ParentCategoryID = '122'
			
			  AND Status = 'active'
						
			

			ORDER BY RecordOrder ASC

Stored Procedures

ca_spCategoryPath (Datasource=aozpo, Time=0ms) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\NavigationVariablesSetup.cfm @ 09:53:31.031

parameters

type CFSQLType value variable dbVarName

IN CF_SQL_integer 326

IN CF_SQL_integer 2

IN CF_SQL_varchar en

OUT CF_SQL_varchar CategoryIDList = CategoryIDList

OUT CF_SQL_varchar CategoryTitleList = CategoryTitleList

OUT CF_SQL_varchar CategoryURLList = CategoryURLList

OUT CF_SQL_integer ReturnValue = ReturnValue

OUT CF_SQL_varchar ReturnMessage = ReturnMessage

resultsets

name resultset

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\projects\aozpo\Site\wwwroot\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
HTTP_ACCEPT_ENCODING=gzip, identity;q=0.9
HTTP_ACCEPT_LANGUAGE=sk, *
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=$Version=1; CFID=18873284; $Path=/; CFTOKEN=14bb24440d0722fb-813FD46B-D3AA-8E13-D8E509BB2AE453AB; $Path=/; LANGUAGEID=en; $Path=/
HTTP_HOST=www.aozpooz.sk
HTTP_REFERER=http://www.aozpooz.sk/index.cfm?NewLanguageID=sk
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
PATH_INFO=
PATH_TRANSLATED=D:\projects\aozpo\Site\wwwroot\index.cfm
QUERY_STRING=module=ActiveWeb&Page=WebPage&layout=article&DocumentID=3222
REMOTE_ADDR=78.141.79.228
REMOTE_HOST=78.141.79.228
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.aozpooz.sk
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=

Cookie Variables:
CFID=18873284
CFTOKEN=14bb24440d0722fb-813FD46B-D3AA-8E13-D8E509BB2AE453AB
LANGUAGEID=en

Session Variables:
browseediton=no
cfid=18873284
cftoken=14bb24440d0722fb-813FD46B-D3AA-8E13-D8E509BB2AE453AB
labelmode=normal
sessionid=AOZPO_01912_18873284_14bb24440d0722fb-813FD46B-D3AA-8E13-D8E509BB2AE453AB
urltoken=CFID=18873284&CFTOKEN=14bb24440d0722fb-813FD46B-D3AA-8E13-D8E509BB2AE453AB
userid=0
username=

URL Parameters:
DocumentID=3222
Page=WebPage
layout=article
module=ActiveWeb

Debug Rendering Time: 141 ms