Annuity Rate Watch

Annuity Rate Watch for Variable Annuities

The Annuity Rate Watch Single User Edition for Variables Annuities gives full access to our entire database of Structured, IOVA and Traditional Variable Annuities with rates, detailed profiles and our powerful search engine.  The GLIB Rider Quoting tool is available on a pay-per use basis.  You also get access to our SPIA Quoting Engine!

This subscription is for annuity professionals only.
The single user edition may be used only by an individual broker and is not for use by offices serving multiple agents. There may be a delay in account activation as all single user subscriptions are reviewed and approved.


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


Execution Time

Total Time Avg Time Count Template
125 ms 125 ms 1 top level D:\inetpub\wwwroot\secure\subscribe\index.cfm
94 ms 94 ms 1 CFC[ D:/inetpub/wwwroot/application.cfc | onRequestStart(/subscribe/index.cfm) ] from D:/inetpub/wwwroot/application.cfc
79 ms 79 ms 1 D:/inetpub/wwwroot/secure/subscribe/inc_subscribe_choose.cfm
32 ms 32 ms 1 CFC[ D:/inetpub/wwwroot/ratewatch/library/cfc/orgListCFC.cfc | orgTabOptions(0) ] from D:/inetpub/wwwroot/ratewatch/library/cfc/orgListCFC.cfc
31 ms 31 ms 1 CFC[ D:/inetpub/wwwroot/ratewatch/library/cfc/ListCFC.cfc | getTabStruct(orgKey = ) ] from D:/inetpub/wwwroot/ratewatch/library/cfc/ListCFC.cfc
16 ms 16 ms 1 CFC[ D:/inetpub/wwwroot/ratewatch/library/cfc/appHelpers.cfc | subscriptionsAvailable(subscriptionPlan_id = 142) ] from D:/inetpub/wwwroot/ratewatch/library/cfc/appHelpers.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 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_subscribeNav.cfm
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
235 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:34:11.011
        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=15ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\applicationExtension.cfc @ 14:34:11.011
       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:34:11.011
	       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=0ms, Records=1) in D:\inetpub\wwwroot\ratewatch\library\cfc\applicationExtension.cfc @ 14:34:11.011
	 select distinct affiliate_id
	 from affiliateOrgs
	 where organization_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getFeatures (Datasource=dbProdSecure, Time=16ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\applicationExtension.cfc @ 14:34:11.011
     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=16ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\ListCFC.cfc @ 14:34:11.011
		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:34:11.011
		select collection_id
		from users
		where user_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getOrg (Datasource=dbProdSecure, Time=15ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\ListCFC.cfc @ 14:34:11.011
           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:34:11.011
			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:34:11.011
		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:34:11.011
		  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=16ms, Records=0) in D:\inetpub\wwwroot\ratewatch\library\cfc\orgListCFC.cfc @ 14:34:11.011
		  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:34:11.011
		  update users set lastTouch_dte = getDate() where user_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getSession (Datasource=dbProdSecure, Time=31ms, Records=0) in D:\inetpub\wwwroot\secure\subscribe\index.cfm @ 14:34:12.012
  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_19966147_e40abd42a0d9bea2-6A8C5A99-AEC5-F129-846E026BA2256139

getProgressInfo (Datasource=dbProdSecure, Time=0ms, Records=0) in D:\inetpub\wwwroot\secure\subscribe\index.cfm @ 14:34:12.012
	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=0ms, Records=0) in D:\inetpub\wwwroot\secure\subscribe\index.cfm @ 14:34:12.012
	SELECT TOP 1 * FROM signUps
	WHERE signUp_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getCustomerType (Datasource=dbProdSecure, Time=63ms, Records=1) in D:\inetpub\wwwroot\secure\subscribe\inc_subscribe_choose.cfm @ 14:34:12.012
	SELECT TOP 1 customerType
	FROM signUps
	WHERE email = ?
	OR sessionKey = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) =
Parameter #2(CF_SQL_VARCHAR) = PRODROOT_19966147_e40abd42a0d9bea2-6A8C5A99-AEC5-F129-846E026BA2256139

getSubs (Datasource=dbProdSecure, Time=16ms, Records=1) in D:\inetpub\wwwroot\ratewatch\library\cfc\appHelpers.cfc @ 14:34:12.012
            select s.subscription_id
			     , s.subscriptionType_id
			     , s.subscriptionName
			     , sp.subscriptionPlan_id
			     , s.trialPeriod_days
			     , s.trialPeriod_fee
			     , sp.monthly_fee
			     , sp.yearly_fee
			     , sp.setup_fee
				 , sp.isNoCharge
				 , s.subscriptionDescription
			  from subscription_vw s
			    inner join subscriptionPlans sp on sp.subscription_id = s.subscription_id
			 where 1 = 1
		   
			and sp.subscriptionPlan_id = ?
			and sp.isNoCharge != 1
		   
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 142


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 (5)
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?step=2&subCode=VA
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=step=2&subCode=VA
REMOTE_ADDR=172.31.25.145
REMOTE_HOST=172.31.25.145
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=19966147
CFTOKEN=e40abd42a0d9bea2-6A8C5A99-AEC5-F129-846E026BA2256139
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=step=2&subCode=VA
remote_addr=44.210.77.73
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=19966147
cftoken=e40abd42a0d9bea2-6A8C5A99-AEC5-F129-846E026BA2256139
crmsupervisorview=0
login=Struct (6)
pagestack=Array (0)
sessionid=PRODROOT_19966147_e40abd42a0d9bea2-6A8C5A99-AEC5-F129-846E026BA2256139
urltoken=CFID=19966147&CFTOKEN=e40abd42a0d9bea2-6A8C5A99-AEC5-F129-846E026BA2256139
website=Struct (1)
URL Parameters:
step=2
subCode=VA
Debug Rendering Time: 15 ms