Debugging Information
ColdFusion Server Enterprise 8,0,1,195765
Template /cf/redirect.cfm
Time Stamp 27-May-17 02:01 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.162.136.26
Host Name 54.162.136.26


Execution Time

Total Time Avg Time Count Template
6 ms 6 ms 1 top level /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/redirect.cfm
1 ms 1 ms 1 CFC[ /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/Application.cfc | onSessionStart() ] from /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/Application.cfc
0 ms 0 ms 1 CFC[ /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/Application.cfc | onRequestEnd(/cf/redirect.cfm) ] from /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/Application.cfc
0 ms 0 ms 1 CFC[ /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/Application.cfc | onRequestStart(/cf/redirect.cfm) ] from /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/Application.cfc
0 ms 0 ms 1 CFC[ /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/com/bcu/screening/handleScreening.cfc | init() ] from /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/com/bcu/screening/handleScreening.cfc
7 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
14 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

urlinfo (Datasource=BCU_NEW, Time=1ms, Records=1) in /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/redirect.cfm @ 02:01:06.006
		SELECT p.protocol, u.url, u.active_flag
		FROM url u LEFT OUTER JOIN protocol p
			ON u.protocol_id=p.protocol_id
		WHERE u.url_id=?
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 87

logClick (Datasource=BCU_NEW, Time=1ms, Records=1) in /opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/redirect.cfm @ 02:01:06.006
				INSERT INTO click 
					(url_id, screening_id, prev_screening_id, cfid, cftoken, source_id, org_id, partner_id, subset_id, language_id,
						access_id, oe_client_id, oe_user_id, preset_state_id, test_flag, target_flag, oe_flag, click_datetime)
				VALUES
					(
					?, 
					NULL,
					NULL, 
					121619, 
					95511866, 
					NULL, 
					NULL,
					NULL, 
					NULL, 
					NULL, 
					NULL, 
					NULL, 
					NULL,
					NULL, 
					NULL, 
					?, 
					?, 
					{ts '2017-05-27 02:01:06'})
			
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 87
Parameter #2(cf_sql_integer) = 0
Parameter #3(cf_sql_integer) = 0


Scope Variables

Application Variables:
aep_subset=86
answerfieldpool=Struct (10)
applicationname=YE
approot=approot
bcuanswerfieldsubsetpartnerpool=Struct (4)
bcudisplaypool=Struct (16)
bcuhelppool=Struct (4)
bcuimagepool=Struct (3)
bcuoptionpool=Struct (3)
bcupartnerquery=Struct (163)
bcuprogrampool=Struct (5)
bcuprogrampoolp=Struct (1959)
bcuquestionpool=Struct (3)
bcurequisitepool=Struct (3)
bcurulepool=Struct (4)
bcustatepool=Struct (4)
bcusubsetpool=Struct (4)
bcusubsetquestionanswerfieldpool=Struct (2)
bcusubsetquestionpool=Struct (2)
bcutemplatepool=Struct (4)
bcutoteboard=Struct (5)
bcuvalidationpool=Struct (4)
bcuwrapperquery=Struct (163)
chicagovars=Struct (0)
cmsserverurl=http://38.118.166.249/EligibilityInfo.aspx
consumerurl=redesign.benefitscheckup.org
cookcityvars=Struct (1)
cookvars=Struct (0)
dbsrc=BCU_NEW
dbsrc_new=BCU_NEW
dbsrc_wp=wp_benefitscheckup
dbsrcesi=ESI
dbsrcoe=OE_QA
dbsrcwarehouse=bcu_warehouse
debug=true
enablelis=true
formpath=forms
imgroot=img
lastrefresh={ts '2017-05-23 15:53:14'}
lsidebug=false
optionpool=Struct (7)
optionvars=Struct (482)
partnervars=Struct (161)
pgrecap=Struct (23)
pgvars=Struct (23)
prgvars=Struct (2516)
questionpool=Struct (4)
quotevars=Struct (2)
recapvars=Struct (1)
remotesurvey=n
response_list=<?xml version="1.0" encoding="utf-16"?>
<ScreeningSet>
	<Screening Subset_id="75">
		<Answers>
			<Answer AnswerField="mqc_submit" AnswerValue="1" />
			<Answer AnswerField="mqc_zipcode" AnswerValue="22202" />
			<Answer AnswerField="mqc_birth_month" AnswerValue="5" />
			<Answer AnswerField="mqc_birth_day" AnswerValue="18" />
			<Answer AnswerField="mqc_birth_year" AnswerValue="1952" />
			<Answer AnswerField="mqc_client" AnswerValue="1359-test" />
			<Answer AnswerField="mqc_medicare_enroll_situation" AnswerValue="mqc_medicare_enroll_within_1_year_yes" />
			<Answer AnswerField="mqc_receivingparta" AnswerValue="y" />
			<Answer AnswerField="mqc_health_insurance" AnswerValue="n" />
			<Answer AnswerField="mqc_receive_hsa" AnswerValue="n" />
			<Answer AnswerField="mqc_coveragesatisfaction_2" AnswerValue="satisfied_no" />
			<Answer AnswerField="mqc_situationmedicare" AnswerValue="mqc_situationmedicare_heedhelp" />
			<Answer AnswerField="mqc_noneofabove" AnswerValue="y" />
			<Answer AnswerField="mqc_none_apply" AnswerValue="y" />
			<Answer AnswerField="mqc_income" AnswerValue="mqc_income_under" />
			<Answer AnswerField="mqc_income_retired" AnswerValue="mqc_income_retire_under" />
		</Answers>
	</Screening>
</ScreeningSet>

serverpath=redesign.benefitscheckup.org
serverpathcanonical=redesign.benefitscheckup.org
serverpathes=stimulus2008-qa.benefitscheckup.org
serverpathesaarp=aarp-stimulus2008-qa.benefitscheckup.org
serverpathoe=oeqa.benefitscheckup.org/oe
subsetsuseviews=true
transfertype=https
transfertypecanonical=https
udf=Struct (1)
validationpool=Struct (4)
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=/opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/redirect.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=redesign.benefitscheckup.org
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/opt/bcu/apps/bcu_code/branch.benefitscheckup.org/code/redirect.cfm
QUERY_STRING=id=87&partner_id=0&visible=false
REMOTE_ADDR=54.162.136.26
REMOTE_HOST=54.162.136.26
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/cf/redirect.cfm
SERVER_NAME=redesign.benefitscheckup.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache/2.2.31
WEB_SERVER_API=
Client Variables:
cfid=121619
cftoken=95511866
hitcount=1
lastvisit={ts '2017-05-27 02:01:06'}
serverpath=redesign.benefitscheckup.org
timecreated={ts '2017-05-27 02:01:06'}
urltoken=CFID=121619&CFTOKEN=95511866
Cookie Variables:
CFID=121619
CFTOKEN=95511866
Request Parameters:
comments_address=comments@benefitscheckup.org
eformurl=http://test.realchoices.org/utilities/dataload/dataload.aspx
Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)
Session Variables:
assistguide=1
cfid=121619
cftoken=95511866
click=Struct (3)
clientnum=0
cmsserverurl=http://38.118.166.249/EligibilityInfo.aspx
cso_id=
csodb=OE_QA
datasrc=BCU_NEW
enablelogfeature=1
evaluation=0
feedbacksrc=bcudev
gender=x
handlescreening=Struct (32)
loggedin=true
ltccservername=demo.ltccounselor.org/ltcc
maintenancedatetime=
oeservername=oeqa.benefitscheckup.org/oe
path=redesign.benefitscheckup.org
pdftkexecutionpath=pdftk
pharmacylocatorurl=http://search.benefitscheckup.org/pharmacy/searchPharmacy.aspx
prg_list=0
requeststarttime={ts '2017-05-27 02:01:06'}
resetapp=false
screening=Struct (2)
server_id=0
servername=redesign.benefitscheckup.org
sessionid=YE_121619_95511866
sessionstarttime={ts '2017-05-27 02:01:06'}
start_time={ts '2017-05-27 02:01:06'}
strbatchpath=/opt/bcu/apps/bcu_code/other/print/
strclient=0
strformpath=/opt/bcu/apps/bcu_code/other/print/forms/
strincludepath=/home/Homes/web/BCU/include/
strlogopath=https://oeqa.benefitscheckup.org/img/logos/
strlogopathnonssl=http://oeqa.benefitscheckup.org/img/logos/
strpartnerlogopath=/home/Homes/web/BCU/img/partners/
strpdfpath=/opt/bcu/apps/bcu_code/other/pdf/
strslash=/
subdomain=redesign
subsettest=1
transfertype=https
urltoken=CFID=121619&CFTOKEN=95511866
warehousedb=bcu_warehouse
URL Parameters:
ID=87
PARTNER_ID=0
VISIBLE=false
Debug Rendering Time: 16 ms