Smith & Wesson M&P9 Shield 9mm Centerfire Pistol with Night Sights

Smith & Wesson M&P9 Shield 9mm Centerfire Pistol with Night Sights
$384.99 $549.00

No Longer Available
This product is no longer available. We don't know when or if it will be back in stock.

Product Description

America's favorite carry conceal pistol is now ready for night time. Introducing the M&P9 Shield with Night Sights, A slim, concealable and lightweight design combined with the proven and trusted features found in the M&P Pistol Series. From the easily concealed one-inch profile to its optimized 18-degree grip angle, the M&P Shield offers professional-grade features that will provide you with simple operation and reliable performance.

The M&P Shield also features a quick and audible reset made possible by the striker-fired action, allowing multiple rounds to be placed on target both consistently and accurately. And it’s all backed by Smith & Wesson’s Lifetime Service Policy.

  • Features
  • Incorporates the design features of the M&P line of firearms.
  • Extremely thin and lightweight - can be comfortably carried all day.
  • M&P’s patented take-down lever and sear deactivation systems allow for disassembly without pulling the trigger.
  • Includes Night Sights for easy aquisition in low-light situations.
  • Includes 3 magazines: two with extended capacity for full grip.
  • 18 degree grip angle for natural point of aim.
  • Striker-fired for short consistent trigger pull, every time. Backed by Smith & Wesson’s Lifetime Service Policy.
  • No thumb safety

Firearm Specifications

  • SKU:10086
  • Model: M&P9 Shield™
  • Frame Size: Compact
  • Caliber: 9mm
  • Action: Striker Fire
  • Capacity: 7 and 8 Round Magazines
  • Barrel Length: 3.1” (7.9 cm)
  • Front Sight: Tritium Night Sights
  • Rear Sight: Tritium Night Sights
  • Trigger Pull: 6.5 lbs +/-
  • Overall Length: 6.1” (15.5 cm)
  • Frame Width: .95” (2.4 cm)
  • Overall Height: 4.6” (11.7 cm)
  • Grip: Polymer
  • Weight: 19.0 oz. (523.7 g)
  • Barrel Material: Stainless Steel
  • Slide Material: Stainless Steel
  • Frame Material: Polymer
  • Finish: Black/Durable Corrosion Resistant

Customer Comments & Questions

Customer Reviews

(4 out of 5) Almost Perfect
by Jim from Springfield, Mo on December 8, 2016

First off, this is a fantastic little shooter. The feel in your hand is great. Shoots great. Not much recoil at all. Now for the bad. I hate that the sights are so tiny, even for a compact gun. If you don't leave the gun sit in light, the sights do not light up in the dark, and when they do, they look like two tiny green snake eyes. Change the sights. Now when I first bought the gun, I had no problems racking the slide. Now, after about 100 rounds, the slide is a monster to rack. Granted, my hands are old and bad, but why did it work great when new. I called S&W and they are sending a new spring assembly to me; hopefully it will work. I leave the slide open all the time to weaken the spring, and will take it out and put another 100 rounds through it. Maybe it will loosen up some. Other than the spring, I love it as my everyday carry.

(4 out of 5) Excellent, with room for improvement
by Ash from Detroit, MI on May 12, 2017

The rebate from S&W gave me the push I needed to finally snag a Shield. Put around 300 rounds through this gun so far and it is excellent. The accuracy is great and I find myself shooting better with this gun than my full size 9mm. The recoil is a non issue and it feels great in the hand, especially with the 8 round extended mags. Having two of those come along with night sights is great too. The front sight is not as bright as the rear sights for me, which was kind of a disappointment, and it makes focusing a little bit more difficult in dim lighting. Overall it is easy to get a proper sight picture and get shots on target though. The trigger is probably the worst part about the Shield. It really does have that gritty feel that everyone talks about. It's adequate at best. Another small gripe I had was that my gun came in the box without one of those anti corrosive zippered bags and has a few scuffs on the finish as a result. Overall, I'm still extremely pleased with it, especially considering the rebate that's out. SOSS had good service again. Processing took a while, but they shipped it out within 2 days after the order processed.

(3 out of 5) Defective Firing Pin
by John from Wellington, Alabama on June 19, 2017

I ordered my shield on 4-12-2017. I received the handgun on 4-24-2017. I was overall satisfied except for the heavier than expected trigger pull. That was until the firing pin broke while using a snap cap. I sent the handgun back to S&W on 5-5-2017 for repair. I didn't receive the handgun back until 6-19-2017 because customer service said that they were running over 4 weeks behind. Lucky I had my XD45 compact for ccw that has never failed in over 4 years.

(4 out of 5) Great gun but dislike the night sights
by Matt from Wayne, PA on August 13, 2017

Great gun but unfortunately the night sights kind of suck. I have very good vision, 20/10, and despite that, the front sight is too small in my opinion. The sights could be brighter too. I regret purchasing the night sight version of this gun over the standard sight version. I strongly encourage you to examine these sights in person or over the internet very carefully prior to purchasing. Besides that, the gun is excellent and shoots very well. Would give 5 stars if it wasn't for the poor night sights.

(5 out of 5) M&P9 Shield
by Steve from Lake Park, Florida on October 26, 2017

Excellent service! Excellent handgun! Zero buyer's remorse!!!


Debugging Information
ColdFusion Server Standard 2021,0,13,330286
Template /products2.cfm
Time Stamp 13-Apr-26 05:54 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
141 ms 141 ms 1 top level E:\inetpub\wwwroot\products2.cfm
32 ms 32 ms 1 E:/inetpub/wwwroot/includes/dropship.cfm
22 ms 22 ms 1 E:/inetpub/wwwroot/products2_discount_offers.cfm
16 ms 16 ms 1 E:/inetpub/wwwroot/Application.cfm
16 ms 16 ms 1 E:/inetpub/wwwroot/products2_combos.cfm
16 ms 16 ms 1 E:/inetpub/wwwroot/products2_mfgpromo_qry.cfm
16 ms 16 ms 1 E:/inetpub/wwwroot/products2_reviews.cfm
16 ms 16 ms 1 E:/inetpub/wwwroot/products2_similaritems.cfm
16 ms 16 ms 1 E:/inetpub/wwwroot/products2_similaritems_qry.cfm
8 ms 8 ms 1 E:/inetpub/wwwroot/itemdetail/qry_getproducts.cfm
0 ms 0 ms 3 E:/inetpub/wwwroot/includes/brands.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/json/productpage.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/metatags.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/newfooter.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/newheader.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/redirects.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/security/block_access.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/security/library.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/security/sql_injection.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/shipping_disclaimer.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/similar-products.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/itemdetail/dsp_analyze_pricing_structures_new.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/itemdetail/qry_get_price.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/products2_breadcrumbs.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/products2_mfgpromo.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
157 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

find_heirloom (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\itemdetail\qry_getproducts.cfm @ 17:54:30.030
select style from tb_styles with (nolock) where style_id=?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439

GetProducts (Datasource=celerantsql, Time=8ms, Records=1) in E:\inetpub\wwwroot\itemdetail\qry_getproducts.cfm @ 17:54:30.030
select a.*,b.scale_id,b.attr1_id,b.attr2_id 
	 from web_all_products a WITH(NOLOCK)
	 inner join tb_styles b WITH(NOLOCK) on (b.style_id = a.style_id) 
	 where a.style_id=? and a.dept <>'California Guns'
	 order by a.dept asc
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439

check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2.cfm @ 17:54:30.030
select e.qc as qc, max(e.sugg_price) as sugg_price, sum(e.qoh + e.qc) as qoh
	from tb_skus a WITH(NOLOCK)
	left join tb_sku_buckets e WITH(NOLOCK) on (e.sku_id = a.sku_id)
	where a.style_id = 168439
	and e.store_id in (10,32)
	group by a.style_id, qc
	order by qoh desc
check_ss_qoh (Datasource=celerantsql, Time=16ms, Records=0) in E:\inetpub\wwwroot\includes\dropship.cfm @ 17:54:31.031
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 168439 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 17:54:31.031
select *
	from tb_term_sale_entries with (nolock)
	where start_date<= 'Apr 13, 2026 17:54:31' and
	end_date >= 'Apr 13, 2026 17:54:31'
	and store_id=10 and style_id=?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439

get_old (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 17:54:31.031
Select * FROM tb_mfg_promo.dbo.tb_new_version where new_style_id=?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439

get_reviews (Datasource=celerantsql, Time=0ms, Records=5) in E:\inetpub\wwwroot\products2.cfm @ 17:54:31.031
select * from tb_product_reviews with (nolock)
	where (style_id=?)
	and status='A' and site = 'sportsman'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439

get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2.cfm @ 17:54:31.031
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews  with (nolock)
	where (style_id=?)
	and status='A' 
	and site = 'sportsman'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\includes\json\productpage.cfm @ 17:54:31.031
Select web_url, dept from tb_web_taxonomy with (nolock) where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman' and dept <>'California Guns'
get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\includes\json\productpage.cfm @ 17:54:31.031
Select web_url from tb_web_taxonomy with (nolock) where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'
get_promos168439 (Datasource=celerantsql, Time=16ms, Records=0) in E:\inetpub\wwwroot\products2_mfgpromo_qry.cfm @ 17:54:31.031
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 168439 
and (a.start_date<= 'Apr 13, 2026 17:54:31' or a.active = 1)
and a.end_date >= '04/13/2026'
order by a.promo_id desc
get_promos (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_mfgpromo_qry.cfm @ 17:54:31.031
select * from get_promos168439
find_viewed (Datasource=celerantsql, Time=0ms, Records=2) in E:\inetpub\wwwroot\includes\similar-products.cfm @ 17:54:31.031
select * from tb_styles with (nolock) where style_id in (?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439
Parameter #2(cf_sql_integer) = 85

GetBestProductsMain (Datasource=celerantsql, Time=0ms, Records=66355, Cached Query) in E:\inetpub\wwwroot\includes\similar-products.cfm @ 17:54:31.031
select 
*

from GetBestProductsMain
get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_breadcrumbs.cfm @ 17:54:31.031
Select web_url, dept from tb_web_taxonomy with (nolock) where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman' and dept <>'California Guns'
get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_breadcrumbs.cfm @ 17:54:31.031
Select web_url from tb_web_taxonomy with (nolock) where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'
get_alt (Datasource=celerantsql, Time=15ms, Records=2) in E:\inetpub\wwwroot\products2.cfm @ 17:54:31.031
select * from tb_alt_pictures with (nolock) where style_id=168439
GetPrice (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\itemdetail\qry_get_price.cfm @ 17:54:31.031
select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1,max(e.first_price) as first_price, max(e.wholesale_price) as vipprice
		from tb_skus a WITH(NOLOCK)
		left join tb_sku_buckets e WITH(NOLOCK) on (e.sku_id = a.sku_id)
		where a.style_id = ?
		and e.store_id in (10,32)
		group by a.style_id
		order by a.style_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\itemdetail\dsp_analyze_pricing_structures_new.cfm @ 17:54:31.031
select *
			from tb_term_sale_entries with (nolock)
			where start_date<= 'Apr 13, 2026 17:54:31' and
			end_date >= 'Apr 13, 2026 17:54:31'
			and store_id=10 and style_id=?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439

vtx_coupon (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 17:54:31.031
SELECT a.lookup, a.amount_off, a.typ
												FROM tb_coupon a
												LEFT JOIN tb_couponitems b with (NOLOCK) on (a.coupon_id=b.coupon_id)
												WHERE a.act_date <= 'Apr 13, 2026 17:54:31' 
													and a.deact_date >= 'Apr 13, 2026 17:54:31'
													and b.style_id = 168439
													and a.store_id = 10
bulkitems (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 17:54:31.031
select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty, max(qty_multiple) as qty_multiple from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
							group by bulk_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439

n_v (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 17:54:31.031
Select * FROM tb_mfg_promo.dbo.tb_new_version where old_style_id=?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 168439

get_pkg (Datasource=celerantsql, Time=16ms, Records=0) in E:\inetpub\wwwroot\products2_combos.cfm @ 17:54:31.031
SELECT *
FROM 
	tb_mfg_promo.dbo.tb_pkg a WITH (NOLOCK)
	INNER JOIN tb_mfg_promo.dbo.tb_pkg_main_items b WITH (NOLOCK)
		ON (a.pkg_id = b.pkg_id)
where 
b.main_id = 168439 and a.start_date<= '04/13/2026 23:59:00' and a.end_date >= '04/13/2026' and site='sportsman'
discount_offer (Datasource=celerantsql, Time=22ms, Records=0) in E:\inetpub\wwwroot\products2_discount_offers.cfm @ 17:54:31.031
select distinct 
	b.style_id, max(b.web_desc) as web_desc, max(b.brand) as brand, max(b.picture_id) as picture_id, min(a.price) as price, max(d.price) as max_price, sum(d.qoh + d.qc) as qoh, max(a.end_date) as end_date
	from tb_mfg_promo.dbo.tb_discount_offer a with (nolock)
	INNER JOIN tb_styles b WITH (NOLOCK) ON (a.child_id = b.style_id) 
	INNER JOIN tb_skus c WITH (NOLOCK) ON (b.style_id = c.style_id) 
	INNER JOIN tb_sku_buckets d WITH (NOLOCK) ON (c.sku_id = d.sku_id) 
	where a.parent_id=168439 and a.start_date<= 'Apr 13, 2026 17:54:31' and a.end_date >= 'Apr 13, 2026 17:54:31' and a.site='sportsman' and d.store_id=10 and qoh>0 
	group by b.style_id
GetAssociatedMain (Datasource=celerantsql, Time=0ms, Records=0, Cached Query) in E:\inetpub\wwwroot\products2_similaritems_qry.cfm @ 17:54:31.031
SELECT * from GetAssociatedMain with (nolock)
associated (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_qry.cfm @ 17:54:31.031
select distinct top 12 style_id, min(min_price) as min_price,	max(max_price) as max_price,	max(web_style) as web_style, max(style) as style,	max(web_desc) as web_desc,	max(web_description) as web_description,	max(picture_id) as picture_id,   max(dept) as dept, max(typ) as typ, max(subtyp_1) as subtyp_1,   max(qoh) as qoh,	max(qc) as qc,	max(qs) as qs,	sum(qoh + qc) as available,	sum(qs - qc) as sold, max(of1) as of1,	max(of2) as of2,max(of3) as of3, max(of4) as of4,	max(of5) as of5,max(of6) as of6,max(of12) as of12, max(brand) as brand,	MAX(max_sugg_price) AS max_sugg_price, max(non_invt) as non_invt
from GetAssociatedMain where style_id is not null and dept='Firearms' and style_id<>168439 and (available>0 or non_invt='Y')
AND 


(of2='MP9 SHIELD' or of3='9 MM') 
AND 
typ='Handgun Semi-Auto' 
AND 
(of4='MP SHIELD' or of5='CARRY CONCEAL' or brand='SMITH AND WESSON')

group by Style_id order by qc asc, sold desc
associatedammo (Datasource=celerantsql, Time=16ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_qry.cfm @ 17:54:31.031
select distinct top 12 style_id, min(min_price) as min_price,	max(max_price) as max_price,	max(web_style) as web_style, max(style) as style,	max(web_desc) as web_desc,	max(web_description) as web_description,	max(picture_id) as picture_id,   max(dept) as dept, max(typ) as typ, max(subtyp_1) as subtyp_1,   max(qoh) as qoh,	max(qc) as qc,	max(qs) as qs,	sum(qoh + qc) as available,	sum(qs - qc) as sold, max(of1) as of1,	max(of2) as of2,max(of3) as of3, max(of4) as of4,	max(of5) as of5, max(of6) as of6, max(of9) as of9,max(of12) as of12, max(brand) as brand,	MAX(max_sugg_price) AS max_sugg_price
from GetAssociatedMain where style_id is not null and dept='Ammo' and style_id<>168439 and available>0 
AND

of3='9 MM'

group by Style_id order by qc asc, sold desc
associatedmagazines (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_qry.cfm @ 17:54:31.031
select distinct top 12 style_id, min(min_price) as min_price,	max(max_price) as max_price,	max(web_style) as web_style, max(style) as style,	max(web_desc) as web_desc,	max(web_description) as web_description,	max(picture_id) as picture_id,   max(dept) as dept, max(typ) as typ, max(subtyp_1) as subtyp_1,   max(qoh) as qoh,	max(qc) as qc,	max(qs) as qs,	sum(qoh + qc) as available,	sum(qs - qc) as sold, max(of1) as of1,	max(of2) as of2,max(of3) as of3, max(of4) as of4,	max(of5) as of5,max(of6) as of6,max(of12) as of12, max(brand) as brand,	MAX(max_sugg_price) AS max_sugg_price
from GetAssociatedMain where style_id is not null and typ='Magazines' and style_id<>168439 and available>0 and 

(of2='MP9 SHIELD' or (of4='MP SHIELD' and of4 <>''))
AND
of3='9 MM'

group by Style_id order by qc asc, sold desc
vid_url (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 17:54:31.031
select * from tb_mfg_promo.dbo.tb_video_url where style_id=168439 and site <> 'outdoors'
get_response (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_reviews.cfm @ 17:54:31.031
select * from tb_mfg_promo.dbo.tb_product_review_responses where product_review_id=118078
get_response (Datasource=celerantsql, Time=16ms, Records=0) in E:\inetpub\wwwroot\products2_reviews.cfm @ 17:54:31.031
select * from tb_mfg_promo.dbo.tb_product_review_responses where product_review_id=162542
get_response (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_reviews.cfm @ 17:54:31.031
select * from tb_mfg_promo.dbo.tb_product_review_responses where product_review_id=163037
get_response (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_reviews.cfm @ 17:54:31.031
select * from tb_mfg_promo.dbo.tb_product_review_responses where product_review_id=169474
get_response (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_reviews.cfm @ 17:54:31.031
select * from tb_mfg_promo.dbo.tb_product_review_responses where product_review_id=172497


Scope Variables

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOSS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
baseurl=https://www.sportsmansoutdoorsuperstore.com/sezzle/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
[email protected]
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/
privatekay=sz_pr_nMBvrWcNk9cNGP9sN695umNINohQkV4r
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
publickey=sz_pub_T20udXXUkabHIADEGrGe3pgtZjwms0K6
qoh_store=10
safety_stock=0
[email protected]
secureurl=https://www.sportsmansoutdoorsuperstore.com/
sezzleapiurl=https://gateway.sezzle.com
sezzletenderid=66
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, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECT=CN=sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\products2.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, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECT=CN=sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/products2.cfm/ID/168439/10086/smith-and-wesson-mp9-shield-9mm-centerfire-pistol-with-night-sights
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=10.200.30.6
PATH_INFO=/ID/168439/10086/smith-and-wesson-mp9-shield-9mm-centerfire-pistol-with-night-sights
PATH_TRANSLATED=E:\inetpub\wwwroot\products2.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/products2.cfm
SERVER_NAME=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=22859161
cftoken=53958cf92c5e6036-58637AD2-ACA6-AF7B-B3CC690D84AF0B7C
hitcount=1
lastvisit={ts '2026-04-13 17:54:30'}
timecreated={ts '2026-04-13 17:54:30'}
urltoken=CFID=22859161&CFTOKEN=53958cf92c5e6036-58637AD2-ACA6-AF7B-B3CC690D84AF0B7C
Cookie Variables:
CFID=22859161
CFTOKEN=53958cf92c5e6036-58637AD2-ACA6-AF7B-B3CC690D84AF0B7C
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=168439,85
S_U_F345=Y
USERNAME=
Form Fields:
RETURN_TO_PAGE=null
Request Parameters:
samesite_value=
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
cfid=22859161
cftoken=53958cf92c5e6036-58637AD2-ACA6-AF7B-B3CC690D84AF0B7C
cs=/index.cfm
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOSS_22859161_53958cf92c5e6036-58637AD2-ACA6-AF7B-B3CC690D84AF0B7C
strarray=Array (0)
urltoken=CFID=22859161&CFTOKEN=53958cf92c5e6036-58637AD2-ACA6-AF7B-B3CC690D84AF0B7C
URL Parameters:
10086=smith-and-wesson-mp9-shield-9mm-centerfire-pistol-with-night-sights
ATTR1=
ATTR2=
BRAND=
CLEARANCE=
DEPT=Firearms
ID=168439
MULTIBUYITEM=NO
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SIZ=
SORTBY=
SPORTSMAN=
SUBTYP_1=EMPTY
SUBTYP_2=
SUBTYP_3=
TYP=Handgun Semi-Auto
WHATSNEW=
Debug Rendering Time: 0 ms