John Jasper,1812-1901, Slave Preacher, Pastor

Total Time	Avg Time	Count	Template
153 ms	153 ms	1	C:\inetpub\wwwroot\believersweb\view.cfm
5 ms	5 ms	1	C:/inetpub/wwwroot/believersweb/header.cfm
1 ms	1 ms	1	C:/inetpub/wwwroot/believersweb/Application.cfm
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/believersweb/Portcullis.cfc | scan([complex value], form, 192.168.10.1) ] from C:/inetpub/wwwroot/believersweb/Portcullis.cfc
1 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
155 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SELECT docName, docDescription, keywords, keyverse
FROM Documents
WHERE docID =  ? 

	SELECT visnum
 	FROM  stats
 	WHERE recid = 1
	

	UPDATE stats
	SET visnum ='38720818'
	WHERE recid = 1
	

SELECT docID, docName, docDate, docAuthor, docCategory, docFileName, docDescription, docsource, viewtimes, keywords, keyverse, docbody
FROM Documents
WHERE docID = ? 

SELECT authorName FROM Authors WHERE authorID = ? 

SELECT categoryName FROM Categories WHERE categoryID = ? 

SELECT	docid, 	
		docname,
		keywords,
		keyword_ids
	
FROM documents
WHERE docid = ? 

SELECT	keyword
	
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword
	
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword
	
FROM keyword_list
WHERE word_id =  ? 

SELECT	docid, 	
		docname,
		keywords
		

FROM documents
WHERE keyword_ids LIKE ? AND docid <>  ?
ORDER BY docid

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	docid, 	
		docname,
		keywords
		

FROM documents
WHERE keyword_ids LIKE ? AND docid <>  ?
ORDER BY docid

SELECT	docid, 	
		docname,
		keywords
		

FROM documents
WHERE keyword_ids LIKE ? AND docid <>  ?
ORDER BY docid

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT	keyword, word_id 	
		
FROM keyword_list
WHERE word_id =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

SELECT docID, docName, docCategory, docDescription
FROM Documents
WHERE docID =  ? 

SELECT categoryName FROM Categories WHERE categoryID =  ? 

	SELECT docviews, pageviews, rc_views, visnum
 	FROM  stats
 	WHERE recid = 1

Application Variables:
applicationname=Believersweb
portcullis=Struct (21)

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=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
CERT_SERVER_SUBJECT=OU=Domain Control Validated, OU=PositiveSSL, CN=believersweb.org
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\believersweb\view.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=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
HTTPS_SERVER_SUBJECT=OU=Domain Control Validated, OU=PositiveSSL, CN=believersweb.org
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=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=believersweb.org
HTTP_REFERER=
HTTP_URL=/view.cfm?id=111&rc=1&list=multi
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=192.168.10.5
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\believersweb\view.cfm
QUERY_STRING=id=111&rc=1&list=multi
REMOTE_ADDR=192.168.10.1
REMOTE_HOST=192.168.10.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/view.cfm
SERVER_NAME=believersweb.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.0
WEB_SERVER_API=

Cookie Variables:
CFID=2564182
CFTOKEN=b6c665b539b8ef3e-8CCF8D33-C294-74F4-34D26EADE249D925

Server Variables:
coldfusion=Struct (10)
os=Struct (5)

Session Variables:
cfid=2564182
cftoken=b6c665b539b8ef3e-8CCF8D33-C294-74F4-34D26EADE249D925
contentwidth=825
sessionid=BELIEVERSWEB_2564182_b6c665b539b8ef3e-8CCF8D33-C294-74F4-34D26EADE249D925
sessiontimer={ts '2019-08-18 21:21:11'}
urltoken=CFID=2564182&CFTOKEN=b6c665b539b8ef3e-8CCF8D33-C294-74F4-34D26EADE249D925
visitor=1

URL Parameters:
id=111
list=multi
rc=1