Annuity Rate Watch


Debugging Information
ColdFusion Server Standard 2016,0,17,325979
Template /subscribe/index.cfm
Time Stamp 28-Nov-23 02:59 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.31.80.26
Host Name 172.31.80.26


Execution Time

Total Time Avg Time Count Template
32 ms 32 ms 1 top level D:\inetpub\wwwroot\secure\subscribe\index.cfm
31 ms 31 ms 1 CFC[ D:/inetpub/wwwroot/application.cfc | onRequestStart(/subscribe/index.cfm) ] from D:/inetpub/wwwroot/application.cfc
15 ms 15 ms 1 CFC[ D:/inetpub/wwwroot/ratewatch/library/cfc/orgListCFC.cfc | orgTabOptions(0) ] from D:/inetpub/wwwroot/ratewatch/library/cfc/orgListCFC.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/wwwroot/application.cfc | onRequestEnd(/subscribe/index.cfm) ] from D:/inetpub/wwwroot/application.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/wwwroot/application.cfc | onSessionStart() ] from D:/inetpub/wwwroot/application.cfc
0 ms 0 ms 10 CFC[ D:/inetpub/wwwroot/ratewatch/library/cfc/AuthCheck.cfc | INIT() ] from D:/inetpub/wwwroot/ratewatch/library/cfc/AuthCheck.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/wwwroot/ratewatch/library/cfc/ListCFC.cfc | getTabStruct(orgKey = ) ] from D:/inetpub/wwwroot/ratewatch/library/cfc/ListCFC.cfc
0 ms 0 ms 1 D:/inetpub/wwwroot/ratewatch/library/layouts/footer.cfm
0 ms 0 ms 1 D:/inetpub/wwwroot/ratewatch/library/layouts/header.cfm
0 ms 0 ms 1 D:/inetpub/wwwroot/ratewatch/library/layouts/public.cfm
0 ms 0 ms 1 D:/inetpub/wwwroot/secure/init_globals.cfm
0 ms 0 ms 1 D:/inetpub/wwwroot/secure/subscribe/inc_subscribe_start.cfm
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
79 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getSite (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\applicationExtension.cfc @ 14:59:49.049
        select s.organization_id
		     , o.orgName
		     , s.site_id
			 , s.dirName
	    from sites s
		  inner join organizations o on o.organization_id = s.organization_id
		where 1 = 1
	  
		and  1 = 2
	  
getUser (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\applicationExtension.cfc @ 14:59:49.049
       select  u.organization_id
			  ,u.orgName
			  ,u.isOrgDisabled
		      ,u.accessDisabled
		      ,u.user_id
		      ,u.firstName
		      ,u.lastName
		      ,u.email
		      ,u.email2
		      ,u.agencyName
		      ,u.defaultSite_id
		--
		      ,u.username
		      ,u.userpswd
		      ,u.access_key
		      ,u.isForcePswdChange
		      ,u.isPswdEncrypted
		--
		      ,u.isDisabled
		     , u.isStaff
		     , u.isApproved
		--
		      ,u.agreementFile
		      ,u.agreementSigned
		      ,u.agreementCountDown
			  ,u.lastLoginType
		--
		      ,u.isAdmin
		      ,u.adminOrganization_id
		      ,u.isBillingContact
		      ,u.isContentContact
		      ,u.isLicensingContact
		      ,u.isMarketingContact
			  ,u.isCompetitiveIntel
		      ,u.isWebHostContact
		      ,u.isManager
		      ,u.isPrimaryAdmin
			  ,u.currentSession
			  ,u.orgKey
			  ,u.isCarrier
			  ,u.isEApp
			  ,isNull((select 1 from userEAppPrivileges up
                    inner join EAppPrivileges p on p.privilege_id = up.privilege_id
                where up.user_id = u.user_id
                and   p.privilegeCode = 'SU'
				),0) as isEAppSU
			  ,case when u.expandAccountsTip > 0 then 0 else 1 end as isShowExpandAccountsTip
		 from users_active_vw u
         WHERE u.user_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getOrg (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\applicationExtension.cfc @ 14:59:49.049
	       select  u.organization_id
				  ,u.orgName
				  ,u.isDisabled as isOrgDisabled
				  ,u.orgKey
				  ,case when exists (select top 1 company_id from carrierOrganizations car where car.organization_id = u.organization_id) then 1 else 0 end isCarrier
			 from organizations u
	         WHERE 1 = 1
			
			  and 1 = 2
			
getAff (Datasource=dbProdSecure, Time=16ms, Records=1) in D:\inetpub\wwwroot\ratewatch\library\cfc\applicationExtension.cfc @ 14:59:49.049
	 select distinct affiliate_id
	 from affiliateOrgs
	 where organization_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getFeatures (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\applicationExtension.cfc @ 14:59:49.049
     select distinct feature_code
      from user_subscriptions_vw usub
        inner join subscription_features_vw vw on usub.subscription_id = vw.subscription_id
      where usub.organization_id = ?
      and   usub.organization_id > 1
      and   usub.user_id is null
      and  (usub.isExpired = 0 or uSub.isCancelled = 0)
     UNION
     select distinct feature_code
      from user_subscriptions_vw usub
        inner join subscription_features_vw vw on usub.subscription_id = vw.subscription_id
     where usub.organization_id = ?
      and  usub.user_id = ?
      and  usub.isActive = 1
    
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 0

getData (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\ListCFC.cfc @ 14:59:49.049
		select vw.tab_id
		     , vw.orgTab_id
			 , vw.orgList_id
			 , vw.isDataTab
			 , vw.isCompIntel
			 , vw.isCarrier
			 , vw.isDatafeed
			 , vw.isUseGroups
			 , ol.isRetiredProducts
		     , ml.list_id
			 , vw.tabName
			 , vw.tabTitle
			 , vw.isLive
			 , vw.dirName
		 	 , vw.orgKey
		from orgTabs_vw vw
		 left join myLists ml on ml.orgTab_id = vw.orgTab_id
							 and ml.user_id = ?
         left join orgLists ol on ol.orgList_id = vw.orgList_id
		where 1 = 1
		and ((vw.isUseGroups = 0)
		 or  exists (select top 1 1 from orgGroupTabUsers_vw tu where tu.orgTab_id = vw.orgTab_id and tu.user_id = ?)
		    )
		and ((vw.organization_id > 0)
	     or exists (select top 1 1 from user_subscriptions_vw us where us.isActive = 1 and us.subscription_id = vw.subscription_id and us.user_id = ?)
		    )
       
		and   vw.dirName = ?  
	     and 1 = 2
	   
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_VARCHAR) = subscribe

getData (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\ListCFC.cfc @ 14:59:49.049
		select collection_id
		from users
		where user_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getOrg (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\ListCFC.cfc @ 14:59:49.049
           select orgKey
		    from organizations
		   where organization_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getData (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\orgListCFC.cfc @ 14:59:49.049
			select oT.isLearnMore
			      ,oT.learnButtonLabel
				  ,oT.learnAddColumn
				  ,oT.learnAddButton
				  ,oT.learnClickDefault
				  ,oT.learnPopUp
				  ,oT.learnPopUpText
				  ,oT.learnOpenURL
				  ,oT.learnOpenWidth
				  ,oT.learnOpenHeight
				  ,oT.learnForm
				  ,oT.learnFormURL
				  ,oT.learnFormPost
				  ,oT.learnFormThankYou
				  ,oT.isFeatureOption 
	              ,oT.featureOnFirstPage
			      ,oT.featureAlsoInGrid
			      ,oT.featureMenuOption
				  ,oT.isCollections
				  ,oT.isCMS
				  ,oT.isDOL
				  ,oT.isFNA
				  ,oT.isSPIA
				  ,oT.isIllustrator
				  ,oT.isHideIllustratorEmail
				  ,oT.isHideFiaMenus
				  ,oT.showCommissions
				  ,oT.isHidePrintGrid
				  ,oT.isHideCurrentYieldToSurrender
				  ,oT.isHideFixedIndexed
				  ,oT.orgTab_id
				  ,'' as commissionCarriers
				  ,t.tabCode
				  ,oT.organization_id
				  ,oT.isP2pCapSP500Only
				  ,oT.isHideAdvSearch
				  ,oT.isHideFiaSearch
				  ,oT.isHideCommission
				  ,oT.isHideRiderExpandOnGrids
				  ,oT.isHideAnalytics
				  ,oT.isRiderLockNames
				  ,oT.isChooseProductCatalog
	        from orgTabs oT
			  inner join tabs t on t.tab_id = oT.tab_id
	      
		    where 1 = 2
		  
getPref (Datasource=dbProdSecure, Time=0ms, Records=1) in D:\inetpub\wwwroot\ratewatch\library\cfc\orgListCFC.cfc @ 14:59:49.049
		select p.preference_id
		     , p.preference_code
			 , isNull(o.preferenceValue, p.defaultValue) as preferenceValue
		 from preferences p
		   left join OrgTabpreferences o on o.preference_id = p.preference_id and o.orgTab_id = ?
         where p.isSetbyOrgTab = 1
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getData (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\orgListCFC.cfc @ 14:59:49.049
		  select subscription_id
			from user_subscriptions_active_vw where organization_id = ?
		  	and  subscription_id in (67,2)
	   	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getData (Datasource=dbProdSecure, Time=15ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\orgListCFC.cfc @ 14:59:49.049
		  select subscription_id
			from user_subscriptions_active_vw where organization_id = ?
		  and  subscription_id in (37,52,53,58,2)
	   
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

updateTouch (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\applicationExtension.cfc @ 14:59:49.049
		  update users set lastTouch_dte = getDate() where user_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getSession (Datasource=dbProdSecure, Time=16ms, Records=0) in D:\inetpub\wwwroot\secure\subscribe\index.cfm @ 14:59:49.049
  SELECT TOP 1 signup_id
  FROM signUps
  where sessionKey = ?
  
  and dateDiff(minute,modified_dte,getDate()) < 1440
  and  isCartComplete = 0
  
  order by modified_dte desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = PRODROOT_15714907_c1d1a54fff8852f5-EB274F3C-B635-D77A-B8E9BC024CAE579D

getProgressInfo (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\secure\subscribe\index.cfm @ 14:59:49.049
	SELECT TOP 1 username, lastName, city, agreementSigned_dte, ccNumber
	FROM signUps
	WHERE signUp_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getInfo (Datasource=dbProdSecure, Time=16ms, Records=0) in D:\inetpub\wwwroot\secure\subscribe\index.cfm @ 14:59:49.049
	SELECT TOP 1 * FROM signUps
	WHERE signUp_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0


Scope Variables

Application Variables:
accountcfc=Struct (62)
admincfc=Struct (13)
apphelpers=Struct (90)
applicationname=prodRoot
carrierreportscfc=Struct (2)
cmscfc=Struct (12)
creditcardcfc=Struct (10)
crmapplication=Struct (9)
crmcfc=Struct (31)
crmcorecfc=Struct (26)
crmebixcfc=Struct (16)
eappcfc=Struct (17)
ebixcfc=Struct (15)
emailserver=Struct (8)
illustratorcfc=Struct (24)
invoicecfc=Struct (11)
isdebug=1
listcfc=Struct (67)
orglistcfc=Struct (29)
productcfc=Struct (23)
querycfc=Struct (26)
riderscfc=Struct (32)
servercall=Struct (107)
spiacfc=Struct (43)
spytrack=Struct (1)
ticketdscfc=Struct (43)
ticketscfc=Struct (43)
twiliourl=https://twilio.annuityratewatch.com
utilitiescfc=Struct (18)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=Sectigo Limited, CN=Sectigo RSA Organization Validation Secure Server CA
CERT_SERVER_SUBJECT=C=US, S=Massachusetts, O="AnnuityRateWatch.com, Inc.", CN=annuityratewatch.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\wwwroot\secure\subscribe\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=Sectigo Limited, CN=Sectigo RSA Organization Validation Secure Server CA
HTTPS_SERVER_SUBJECT=C=US, S=Massachusetts, O="AnnuityRateWatch.com, Inc.", CN=annuityratewatch.com
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=secure.annuityratewatch.com
HTTP_REFERER=
HTTP_URL=/subscribe/index.cfm
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=172.31.9.136
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\wwwroot\secure\subscribe\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.31.80.26
REMOTE_HOST=172.31.80.26
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/subscribe/index.cfm
SERVER_NAME=secure.annuityratewatch.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=15714907
CFTOKEN=c1d1a54fff8852f5-EB274F3C-B635-D77A-B8E9BC024CAE579D
Request Parameters:
bodycontent=
colorlist=89CF61,6CC4C4,B89F5F,CF6D61,936EB8,CFCB5E,69C48E,B8875D,CF5FB2,6C75B8,CF9E41,92C44D,B84443,6C42CF,52B1B8,CF7123,C4BE30,B82894,2438CF,37B88A,CF0A1C,C47D06,2B00B8,09CDCF,4DB80F,red,yellow,blue,996699,green,996633,99cc66,ffcc00,660066,cc6666,99ccff,99cc66,89CF61,6CC4C4,B89F5F,CF6D61,936EB8,CFCB5E,69C48E,B8875D,CF5FB2,6C75B8,CF9E41,92C44D,B84443,6C42CF,52B1B8,CF7123
creditprices=Array (5)
customorgs=Struct (5)
datapath=/userfiles/
datasource=dbProdSecure
developeremail=debug@annuityratewatch.com
encryptionkey=arw6209key$2008
environment=Prod
fullpagewidth=0
gatewayid=C87201-01
gatewaypwd=51851h449i1m193k5g19yzzpgm04p9b9
gatewayurl=https://api.globalgatewaye4.firstdata.com/transaction/v11
helpintrocode=
issueageanytext=Any Age
istestserver=0
login=Struct (39)
orgdirname=
orgkey=
page=Struct (4)
pagetitle=
querystring=
remote_addr=3.80.4.147
samesite_value=
scriptname=/subscribe/index.cfm
securedatasource=dbProdSecure
showfeedback=1
signup_id=
taboptions=Struct (50)
tabstruct=Struct (15)
tempurldir=D:\inetpub\arwTempFiles
testemailaddress=debug@annuityratewatch.com
use12pointgrid=1
website=Struct (6)
Session Variables:
accounts=Struct (0)
affiliatemasteruser_id=
cfid=15714907
cftoken=c1d1a54fff8852f5-EB274F3C-B635-D77A-B8E9BC024CAE579D
crmsupervisorview=0
login=Struct (6)
pagestack=Array (0)
sessionid=PRODROOT_15714907_c1d1a54fff8852f5-EB274F3C-B635-D77A-B8E9BC024CAE579D
urltoken=CFID=15714907&CFTOKEN=c1d1a54fff8852f5-EB274F3C-B635-D77A-B8E9BC024CAE579D
website=Struct (1)
URL Parameters:
SESSIONTIMEOUT=0
Debug Rendering Time: 0 ms