Debugging Information
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) - 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) - 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) - 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) - 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) - 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) - 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) - 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) - 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) - 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) - 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) - 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) - 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) - 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=0Debug Rendering Time: 0 ms |