Total Time	Avg Time	Count	Template
15 ms	15 ms	1	D:/projects/aozpo/Site/modules/Forums/actions/MessagesList.cfm
15 ms	15 ms	1	D:/projects/aozpo/Site/modules/Forums/main/callAction.cfm
15 ms	15 ms	1	D:\projects\aozpo\Site\wwwroot\indexAction.cfm
0 ms	0 ms	1	C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/ActiveWebRequestSettings.cfm
0 ms	0 ms	1	D:/projects/aozpo/Site/wwwroot/Application.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
15 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

	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)

        SELECT a.L0,
               ( SELECT Count(*) FROM fo_vMessageLite d WHERE d.L0 = a.L0 AND d.Status = 'approved' ) AS MessageCount
          FROM fo_vMessageLite a
         WHERE a.MessageID = '89'
    

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\indexAction.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?module=forums
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
PATH_INFO=
PATH_TRANSLATED=D:\projects\aozpo\Site\wwwroot\indexAction.cfm
QUERY_STRING=module=Forums&action=MessagesList&MessageID=89
REMOTE_ADDR=78.141.79.228
REMOTE_HOST=78.141.79.228
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/indexAction.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:
MessageID=89
action=MessagesList
module=Forums