Total Time	Avg Time	Count	Template
18 ms	18 ms	1	C:\websites\wsadmnbz\index.cfm
13 ms	13 ms	1	C:/websites/wsadmnbz/templates/MainNav.cfm
10 ms	10 ms	1	C:/websites/wsadmnbz/Application.cfm
2 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
30 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

    SELECT  tbl_WebSite.WEBSITE_ID,
            tbl_WebSite.WebSite_MainURL,
            tbl_WebSite.WebSite_Name,
            tbl_WebSite.WebSite_Title,
            tbl_WebSite.WebSite_HeaderHTML,
            tbl_WebSite.WebSite_AssetFolder,
            tbl_WebSite.WebSite_Delimiter,
            tbl_WebSite.WebSite_Doctype,
            tbl_WebSite.WebSite_Secure,
            tbl_WebSite.Website_DefaultToXML,
            tbl_WebSite.Page_ID_lkp,
            tbl_WebSiteServices.OpenTracker_Active,
            tbl_WebSiteServices.OpenTracker_URL,
            tbl_WebSiteServices.GoogleAnalytics_Active,
            tbl_WebSiteServices.GoogleAnalytics_SiteID,
            tbl_WebSiteServices.Clicky_Active, 
            tbl_WebSiteServices.Clicky_SiteID, 
            tbl_WebSiteServices.Clicky_SiteKey,
            tbl_WebSiteServices.Amazon_DistributionID,
            tbl_Company.Company_Name, 
			tbl_User.User_Email
      FROM  tbl_WebSite WITH (NOLOCK)
INNER JOIN  tbl_WebSiteServices WITH (NOLOCK) ON Website_ID = WebSite_ID_lkp
 LEFT JOIN  tbl_Company WITH (NOLOCK) ON Company_ID = Company_ID_lkp
 LEFT JOIN  tbl_User WITH (NOLOCK) ON User_ID = User_ID_mstr
	
     WHERE  WebSite_MainURL = ?
        OR  WebSite_MainURL = ?
        OR  WebSite_MainURL = ?
        OR  WebSite_MainURL = ?
        OR  WebSite_MainURL = ?
        OR  WebSite_MainURL = ?
        OR  WebSite_ID IN (SELECT WebSite_ID_lkp 
                            FROM tbl_URL WITH (NOLOCK)
                           WHERE URL_Name = ?)
	

SELECT Feature_Name
  FROM tbl_Feature tF WITH (NOLOCK)
 INNER JOIN tbl_WebSite_Feature tWF WITH (NOLOCK) ON tF.Feature_ID = tWF.Feature_ID_lkp
 WHERE tWF.WebSite_ID_lkp = ? 

SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
	  (SELECT COUNT(*) FROM tbl_WebSite WHERE Page_Id_lkp  = P.Page_ID) AS IsHomePage, 
      (SELECT Page_ID  FROM tbl_Page    WHERE Page_Id_orig = P.Page_ID 
      		  							  AND Version_ID_lkp = ? 
                                          AND Website_ID_lkp = ?) AS IsVersion
From tbl_Page P WITH (NOLOCK)
WHERE Page_ID_prnt = ?
  AND Website_ID_lkp = ?
  AND Page_NavSet = ?
  AND Page_OnNavigation = 1
  AND Page_ID <> (SELECT Page = CASE WHEN Page_ID_lkp > 0 THEN Page_ID_lkp ELSE 0 END FROM tbl_WebSite WHERE Website_ID = ?)
  AND Page_ID_orig is NULL
ORDER BY SYS_TimeStamp_Position

		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		

		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		

		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		

		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		

		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		

		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		

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=C:\websites\wsadmnbz\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=
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.nisen.com
HTTP_REFERER=
HTTP_URL=/index.cfm
HTTP_USER_AGENT=Amazon CloudFront
LOCAL_ADDR=172.31.28.92
PATH_INFO=
PATH_TRANSLATED=C:\websites\wsadmnbz\index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.nisen.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=

Client Variables:
cfid=359548290
cftoken=65954144
hitcount=1
lastvisit={ts '2024-10-16 13:07:21'}
timecreated={ts '2024-10-16 13:07:21'}
urltoken=CFID=359548290&CFTOKEN=65954144

Cookie Variables:
CFID=359548290
CFTOKEN=65954144
HTTP_REFERER=http://www.nisen.com?