OUR SPONZORS AND PARTNERS

THANK YOU !

Diskusia

Diskusia		Temy	Prispevky	Posledny prispevok
Všeobecná diskusia Všeobecná diskusia		11	5	15.02.2010, 13:00 Janette

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
141 ms	141 ms	1	D:/projects/aozpo/Site/modules/Default/objects/Default.cfm
141 ms	141 ms	1	D:\projects\aozpo\Site\wwwroot\index.cfm
109 ms	109 ms	1	D:/projects/aozpo/Site/modules/Forums/graphics/index.cfm
78 ms	78 ms	1	D:/projects/aozpo/Site/modules/Forums/objects/indexList.cfm
16 ms	4 ms	4	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/Category.cfm
16 ms	3 ms	6	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/WebObjects/WebObject.cfm
16 ms	16 ms	1	D:/projects/aozpo/Site/modules/Default/objects/LeftMenuObject.cfm
16 ms	16 ms	1	D:/projects/aozpo/Site/modules/Default/objects/LeftSection.cfm
16 ms	16 ms	1	D:/projects/aozpo/Site/modules/Default/objects/RightSection.cfm
15 ms	15 ms	1	D:/projects/aozpo/Site/modules/Members/forms/LoginForm.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	1	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/NavigationVariablesSetup.cfm
0 ms	0 ms	10	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/FooterMenuObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Default/objects/FooterObject.cfm
0 ms	0 ms	2	D:/projects/aozpo/Site/modules/Default/objects/FormObject.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/NavigationBarObject.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/TitleObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Default/objects/TopMenuObject.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/modules/Forums/main/SetRequestVariables.cfm
0 ms	0 ms	2	D:/projects/aozpo/Site/modules/Forums/objects/CheckForumPermission.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/wwwroot/Application.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
141 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:13.013

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

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

		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=16ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\Category.cfm @ 09:53:13.013

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

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

		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

qGetModulModerator (Datasource=aozpo, Time=16ms, Records=1) in D:\projects\aozpo\Site\modules\Forums\objects\indexList.cfm @ 09:53:13.013

                
    SELECT Count(*) AS ForumCount 
      FROM fo_vForumParticipant
     WHERE ForumMode != 'Forum'
       AND UserID = '0'
       AND ParticipantType = 'moderator'

qGetForums (Datasource=aozpo, Time=0ms, Records=1) in D:\projects\aozpo\Site\modules\Forums\objects\indexList.cfm @ 09:53:13.013

	SELECT
    	   CategoryID,
           CategoryTitle,
           RecordOrder
	  FROM ca_vCategory
	 WHERE ProjectID = '2'
       AND CategoryID = '336'
       AND LanguageID = 'en'
       
	   
       		AND CategoryID != '6731'
       
       
  ORDER BY RecordOrder ASC

qGetForumsCount (Datasource=aozpo, Time=15ms, Records=1) in D:\projects\aozpo\Site\modules\Forums\objects\indexList.cfm @ 09:53:13.013

	SELECT Count(*)
      FROM fo_vForum a
     WHERE a.ProjectID = '2'
       AND ( a.Status = 'active'
           OR a.ForumID IN ( SELECT d.ForumID FROM fo_vForumParticipant d WHERE d.UserID = '0' AND d.Status = 'approved' ) )

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

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

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

qGetForumsParent (Datasource=aozpo, Time=31ms, Records=1) in D:\projects\aozpo\Site\modules\Forums\objects\indexList.cfm @ 09:53:13.013

          	SELECT
            	   a.ForumID,
                   a.CategoryID,
                   a.ForumTitle,
                   a.ForumDescription,
                   a.Status,
                   a.ReadStatus,
                   a.PostStatus,
                   
                   ( SELECT Count(*) FROM fo_vMessage d WHERE d.ForumID = a.ForumID AND d.Status = 'waiting' ) AS MessageWaitingCount,
                   ( SELECT Count(*) FROM fo_vForumParticipant d WHERE d.ForumID = a.ForumID AND d.Status = 'waiting' ) AS UserWaitingCount,
                   
                   a.RecordOrder
              FROM fo_vForum a
             WHERE a.CategoryID = '336'
               AND a.ProjectID = 2
               AND ( a.Status = 'active'
               	  OR a.ForumID IN ( SELECT d.ForumID FROM fo_vForumParticipant d WHERE d.UserID = '0' AND d.Status = 'approved' ) )

          ORDER BY a.RecordOrder ASC

qGetForumsTheme (Datasource=aozpo, Time=0ms, Records=1) in D:\projects\aozpo\Site\modules\Forums\objects\indexList.cfm @ 09:53:13.013

                	SELECT COUNT(*) AS ThemeCount
                      FROM fo_vMessageLite a
                     WHERE a.ForumID = '14'
                     
                     
                       AND a.Status = 'approved' 
                     
                     
                       AND a.ParentMessageID IS NULL
                       AND a.Depth = '0'

qGetForumsMessage (Datasource=aozpo, Time=0ms, Records=1) in D:\projects\aozpo\Site\modules\Forums\objects\indexList.cfm @ 09:53:13.013

                	SELECT COUNT(*) AS MessageCount
                      FROM fo_vMessageLite a, fo_vMessageLite b
                     WHERE a.ForumID = '14'
                       AND a.L0 = b.MessageID
                       
                     
                       AND a.Status = 'approved' 
                       AND b.Status = 'approved'
                     
                     
                       AND a.ParentMessageID  > '0'

qGetForumsLastMessage (Datasource=aozpo, Time=16ms, Records=1) in D:\projects\aozpo\Site\modules\Forums\objects\indexList.cfm @ 09:53:13.013

                	SELECT TOP 1 a.MessageID, a.AuthorUserName, a.L0, a.Created
                      FROM fo_vMessageLite a, fo_vMessageLite b
                     WHERE a.ForumID = '14'
                       AND a.L0 = b.MessageID
                       
                     
                       AND a.Status = 'approved' 
                       AND b.Status = 'approved'
                     
                     
                       AND a.ParentMessageID  > '0'
                  ORDER BY a.Created DESC

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

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

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

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

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

parameters

type CFSQLType value variable dbVarName

IN CF_SQL_integer 336

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=forums
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:
module=forums

Debug Rendering Time: 172 ms

Užívate¾ské meno:
Heslo:

	Zabudli ste heslo?
	Zaregistrujte sa.