DELTA 3 WEAPONS DEVELOPMENT GROUP LLC

5919 NW KETONA CIRCLE
PORT ST LUCIE, FL 34986
772-323-3355

More FFL dealers nearby

TOMMY GUNS
718 S US 1
PORT ST LUCIE, FL 34952
772-985-4441

ST LUCIE GUNS INC
492 NW CONCOURSE PLACE
PORT SAINT LUCIE, FL 34986
772-333-2060

BLACKHAWK CUSTOM LLC
5762 NW CONE ST
PORT SAINT LUCIE, FL 34986
954-540-1324

Search again

Debugging Information

ColdFusion Server Evaluation	2021,0,13,330286
Template	/ffl_lookup.cfm
Time Stamp	20-May-24 03:09 PM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP	10.200.2.4
Host Name	10.200.2.4

Execution Time

Total Time	Avg Time	Count	Template
50 ms	50 ms	1	E:\inetpub\wwwroot\ffl_lookup.cfm
47 ms	47 ms	1	E:/inetpub/wwwroot/ffl_lookup_dealer_info.cfm
4 ms	4 ms	1	E:/inetpub/wwwroot/Application.cfm
2 ms	2 ms	1	C:/inetpub/wwwroot/includes/security/sql_injection.cfm
1 ms	1 ms	1	C:/inetpub/wwwroot/includes/security/block_access.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/metatags.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/newfooter.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/newheader.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/security/library.cfm
3 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
57 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

getFFL (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\ffl_lookup_dealer_info.cfm @ 15:09:21.021

SELECT CompanyName, StreetAddress, City, State, Zip, Ph, website, FFL, Expiration, CFD, web_ffl_id
FROM web_FFL_NEW
WHERE web_ffl_id = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 87674

getNear (Datasource=celerantsql, Time=30ms, Records=3) in E:\inetpub\wwwroot\ffl_lookup_dealer_info.cfm @ 15:09:21.021

SELECT CompanyName, StreetAddress, City, State, Zip, Ph, website, FFL, Expiration, CFD, web_ffl_id
					FROM web_FFL_NEW
					WHERE (city = ? or zip  = ?)
					and state = ? 
					and web_ffl_id <> ? 
					and (Expiration > '05/20/2024 00:00:00') 
					and status=1 and FFL <> '1'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = PORT ST LUCIE

			    
			        Parameter #2(cf_sql_integer) = 34986

			    
			        Parameter #3(cf_sql_varchar) = FL

			    
			        Parameter #4(cf_sql_integer) = 87674

Scope Variables

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

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=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\ffl_lookup.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=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=PASSWORD=; EMAIL=; FIRST_NAME=; CUSTOMER_ID=; LAST_NAME=; USERNAME=; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-12076; CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C; CFGLOBALS=urltoken%3DCFID%23%3D12076%26CFTOKEN%23%3D2ff62c93eec686f4%2DEA14D269%2DB1C0%2DBB26%2D2EB7324ADCD36E6C%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2015%3A09%3A20%27%7D%23hitcount%3D3%23timecreated%3D%7Bts%20%272024%2D05%2D20%2015%3A09%3A18%27%7D%23cftoken%3D2ff62c93eec686f4%2DEA14D269%2DB1C0%2DBB26%2D2EB7324ADCD36E6C%23cfid%3D12076%23; fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ; PHPSESSID=54d44eb5f2182befb97a335e2f6d144b; fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/ffl_lookup.cfm/dealer/87674-delta-3-weapons-development-group-llc
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/dealer/87674-delta-3-weapons-development-group-llc
PATH_TRANSLATED=E:\inetpub\wwwroot\ffl_lookup.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/ffl_lookup.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=12076
cftoken=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C
hitcount=3
lastvisit={ts '2024-05-20 15:09:20'}
timecreated={ts '2024-05-20 15:09:18'}
urltoken=CFID=12076&CFTOKEN=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C

Cookie Variables:
CFGLOBALS=urltoken=CFID#=12076&CFTOKEN#=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C#lastvisit={ts '2024-05-20 15:09:20'}#hitcount=3#timecreated={ts '2024-05-20 15:09:18'}#cftoken=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C#cfid=12076#
CFID=12076
CFTOKEN=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PHPSESSID=54d44eb5f2182befb97a335e2f6d144b
USERNAME=
fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ
fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu

Form Fields:
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

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

Session Variables:
cfid=12076
cftoken=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C
cs=/category.cfm/sportsman/pocket-holsters/brand/desantis/make/fn/model/xd-mod2
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_12076_2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C
strarray=Array (0)
urltoken=CFID=12076&CFTOKEN=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C

URL Parameters:
BRAND=
CLEARANCE=
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
dealer=87674-delta-3-weapons-development-group-llc

Debug Rendering Time: 4 ms