DPC REPORTS

 

LEGISLATIVE BULLETIN | November 21, 2009

H.R. 3590, the legislative vehicle for the Patient Protection and Affordable Care Act of 2009

DPC

CONTACTS

DPC

  • Jacqueline Garry Lampert (224-3232)

SHARE

Link to this report

Click on field; right-click and copy; paste into your page

E-mail this Report

Your E-mail Message


Democratic Policy Committee
419 Hart Senate Office Building Wash. D.C. 20510 (202-224-3232)


Debugging Information
ColdFusion Server Enterprise 2021,0,10,330161
Template /dpcdoc.cfm
Time Stamp 23-Sep-23 06:50 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 192.168.5.146
Host Name 192.168.5.146


Execution Time

Total Time Avg Time Count Template
28 ms 28 ms 1 top level /usr/ftp/committee/dpc/general/dpcdoc.cfm
20 ms 20 ms 1 /usr/ftp/committee/dpc/general/dpcmainbanner.cfm
19 ms 19 ms 1 /usr/ftp/committee/dpc/general/dpcmenubar.cfm
0 ms 0 ms 1 /usr/ftp/committee/dpc/general/Application.cfm
0 ms 0 ms 1 /usr/ftp/committee/dpc/general/dpcfooter.cfm
0 ms 0 ms 1 /usr/ftp/committee/dpc/general/google_analytics.html
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
30 ms  TOTAL EXECUTION TIME
red = over 2000 ms average execution time


SQL Queries

doc_detail (Datasource=dpc111407, Time=5ms, Records=1) in /usr/ftp/committee/dpc/general/dpcdoc.cfm @ 06:50:58.058
select
		doc_title,
		doc_date,
		pdf_flag,
		release_flag,
		item_visibility,
		dem_seq					/* for retrieving staff contact */
	from dem_index
	where
		doc_type in ('DPC', 'LB') and
		doc_name = 'lb-111-1-151'
		/* doc_name = 'lb-111-1-151' */
		
		
		
			and release_flag = 'y'
list_assigned_staff (Datasource=dpc111407, Time=1ms, Records=1) in /usr/ftp/committee/dpc/general/dpcdoc.cfm @ 06:50:58.058
select 
		dpc_staff.first_name,
		dpc_staff.last_name,
		dpc_staff.staff_code,
		dpc_staff.email,
		dpc_staff.phone,
		dpc_staff_index.staff_order
	from
		dpc_staff, 
		dpc_staff_index
	where
		dpc_staff.staff_code = dpc_staff_index.staff_code and
		dpc_staff_index.dem_seq = 4321
	order by staff_order
dpc_top_terms (Datasource=dpc111407, Time=18ms, Records=13) in /usr/ftp/committee/dpc/general/dpcmenubar.cfm @ 06:50:58.058
select distinct top 15
		dem_topic_terms.dem_topic_term,
		dem_topic_terms.pterm_pkey
	from
		dem_topic_terms,
		dem_terms,
		dem_index
	where
		dem_topic_terms.term_enable = 'y' and 					
		dem_topic_terms.pterm_pkey = dem_terms.dem_code and
		dem_terms.dem_seq = dem_index.dem_seq and
		dem_index.doc_type in ('DPC', 'LB', 'PDF', 'URL') and
			dem_index.release_date > '2008-12-31' and
		hot_button = 'y'
	order by
		dem_topic_term
hearing_terms (Datasource=dpc111407, Time=1ms, Records=11) in /usr/ftp/committee/dpc/general/dpcmenubar.cfm @ 06:50:58.058
select
		dem_topic_terms.dem_topic_term,
		dem_topic_terms.pterm_pkey
	from
		dem_topic_terms
	where
		dem_topic_terms.term_enable = 'h'
	order by dem_topic_term


Scope Variables

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=/usr/ftp/committee/dpc/general/dpcdoc.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
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=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=TE, keep-alive
HTTP_COOKIE=
HTTP_HOST=www.dpc.senate.gov
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=192.168.10.42
PATH_INFO=
PATH_TRANSLATED=/usr/ftp/committee/dpc/general/dpcdoc.cfm
QUERY_STRING=doc_name=lb-111-1-151
REMOTE_ADDR=192.168.5.146
REMOTE_HOST=192.168.5.146
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/dpcdoc.cfm
SERVER_NAME=www.dpc.senate.gov
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/2.4.37 (Red Hat Enterprise Linux) OpenSSL/1.1.1k mod_jk/1.2.46
WEB_SERVER_API=
Request Parameters:
samesite_value=Lax
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
URL Parameters:
doc_name=lb-111-1-151
Debug Rendering Time: 4 ms