Projects

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
32 ms	32 ms	1	D:/projects/aozpo/Site/modules/Default/objects/Default.cfm
16 ms	16 ms	1	D:/projects/aozpo/Site/modules/ActiveWeb/graphics/Articles.cfm
16 ms	16 ms	1	D:/projects/aozpo/Site/modules/Default/objects/FooterMenuObject.cfm
16 ms	16 ms	1	D:/projects/aozpo/Site/modules/Default/objects/FooterObject.cfm
15 ms	15 ms	1	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/NavigationVariablesSetup.cfm
15 ms	15 ms	1	D:/projects/aozpo/Site/modules/ActiveWeb/main/SetRequestVariables.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/Utils/ResultsListing.cfm
0 ms	0 ms	6	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/WebObjects/WebObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/functions/GetShorterText.cfm
0 ms	0 ms	8	D:/projects/aozpo/Site/functions/ShowLabel.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/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:08.008

	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)

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

		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:08.008

		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:08.008

		SELECT 
			CategoryID, ParentCategoryID, CategoryTitleSys, CategoryType,
	        CategoryTitle, LanguageID, URL, URLTarget, RecordOrder, Status
			FROM ca_vCategory
			WHERE ProjectID = '2'
	
			
			  AND LanguageID = 'en'
			
			  AND ParentCategoryID = '339'
			
			  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:08.008

		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:08.008

		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

qGetArticles (Datasource=aozpo, Time=0ms, Records=0) in D:\projects\aozpo\Site\modules\ActiveWeb\graphics\Articles.cfm @ 09:53:08.008

SELECT DocumentID, CategoryID, DocumentType, VersionNumber, LanguageID, DocumentTitle, DocumentDescription, 
			Content, Status, Author, AuthorEmail, IssuedDate
	FROM aw_vDocument
		WHERE ProjectID = '2'
		  AND UILanguageID = 'en'
		  AND LanguageID = 'en'
		  AND CategoryID = '339'
		  AND Status = 'approved'
		  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
		  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
	
		ORDER BY created DESC

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

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

			
			  AND WebObjectSystemTitle = 'aw_Articles_Top'
			
			  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:08.008

		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:08.008

		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:08.008

		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:08.008

		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=15ms) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\NavigationVariablesSetup.cfm @ 09:53:08.008

parameters

type CFSQLType value variable dbVarName

IN CF_SQL_integer 339

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=Articles&CategoryID=339
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:
CategoryID=339
Page=Articles
module=ActiveWeb

Debug Rendering Time: 140 ms