John Calvin,1504-1564, Founder of Calvinism

Total Time	Avg Time	Count	Template
79 ms	79 ms	1	C:\inetpub\wwwroot\believersweb\view.cfm
4 ms	4 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
2 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
82 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 ='39660075'
	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	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	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	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	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	docid, 	
		docname,
		keywords
		

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

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=105
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=105
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=2822412
CFTOKEN=65faf203c6976acc-AE469B89-C294-74F4-3C16AA7666AF8919

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

Session Variables:
cfid=2822412
cftoken=65faf203c6976acc-AE469B89-C294-74F4-3C16AA7666AF8919
contentwidth=825
sessionid=BELIEVERSWEB_2822412_65faf203c6976acc-AE469B89-C294-74F4-3C16AA7666AF8919
sessiontimer={ts '2019-11-21 22:44:49'}
urltoken=CFID=2822412&CFTOKEN=65faf203c6976acc-AE469B89-C294-74F4-3C16AA7666AF8919
visitor=1

URL Parameters:
ID=105