Tenmile? Hx 318x50 Second Focal Plane (sfp) Riflescope W/ Mrad Center Dot (red/

ID: TMHX1850C3000009   UPC: 719307403550   CLASSIFICATION: PAL REQUIRED

View More Items by: Trijicon

$2,390.00

This product is out of stock.

Notify me when back in stock







  • Product Information
  • Review

Product Information

Product information coming soon.

Review

Write a Review
Very Poor Poor Average Very Good Excellent

Are you a robot?
What is the sum of 1 and 10:
Overall Rating
0.0/5.0 (Based on 0 Review)


No reviews have been written for this product.
Be the first one!  


Debugging Information
ColdFusion Server Standard 2021,0,13,330286
Template /products.cfm
Time Stamp 15-May-24 05:42 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 3.22.68.49
Host Name 3.22.68.49


Execution Time

Total Time Avg Time Count Template
500 ms 500 ms 1 C:/websites/bullseye/products.cfm
500 ms 500 ms 1 CFC[ C:/websites/bullseye/application.cfc | onRequest(/products.cfm) ] from C:/websites/bullseye/application.cfc
218 ms 218 ms 1 CFC[ C:/websites/bullseye/functions/clientCustomizations.cfc | weRecommend([complex value], 16, 16) ] from C:/websites/bullseye/functions/clientCustomizations.cfc
140 ms 9 ms 16 C:/websites/bullseye/includes/views/thumbnails.cfm
31 ms 31 ms 1 C:/websites/bullseye/includes/footer.cfm
31 ms 31 ms 1 CFC[ C:/websites/bullseye/functions/category.cfc | getIndividualProductByStyleId(26520) ] from C:/websites/bullseye/functions/category.cfc
16 ms 16 ms 1 C:/websites/bullseye/includes/application/check_db.cfm
16 ms 16 ms 1 CFC[ C:/websites/bullseye/application.cfc | onRequestStart(/products.cfm) ] from C:/websites/bullseye/application.cfc
16 ms 8 ms 2 CFC[ C:/websites/bullseye/functions/clientCustomizations.cfc | retrieveSpecs(26520) ] from C:/websites/bullseye/functions/clientCustomizations.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(236CFAC8-155D-9BEA-014EF87802FDB145) ] from C:/websites/bullseye/functions/cms.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(9954, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(8165, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(9212, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(9141) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getWebTaxonomyInfoByProduct(26520) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(26520) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(9351) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/notification.cfc | outOfStockIframe([complex value]) ] from C:/websites/bullseye/functions/notification.cfc
15 ms 15 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(2363C0DF-155D-9BEA-018D2CD496E7A280) ] from C:/websites/bullseye/functions/cms.cfc
15 ms 15 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(11112, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
15 ms 15 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(28754, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
15 ms 15 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(9005, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
15 ms 15 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(7746) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 C:/websites/bullseye/includes/application/create_query_string.cfm
0 ms 0 ms 1 C:/websites/bullseye/includes/application/session_defaults.cfm
0 ms 0 ms 1 C:/websites/bullseye/includes/application/sql_injection.cfm
0 ms 0 ms 1 C:/websites/bullseye/includes/application/url_actions.cfm
0 ms 0 ms 1 C:/websites/bullseye/includes/application/url_variable_defaults.cfm
0 ms 0 ms 1 C:/websites/bullseye/includes/header.cfm
0 ms 0 ms 1 CFC[ C:/websites/bullseye/application.cfc | onRequestEnd(/products.cfm) ] from C:/websites/bullseye/application.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/application.cfc | onSessionStart() ] from C:/websites/bullseye/application.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cart.cfc | getCartQtyTotal(false) ] from C:/websites/bullseye/functions/cart.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getChildren(25C195B5-155D-9BEA-01E09712618C03C4) ] from C:/websites/bullseye/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(236C0F49-155D-9BEA-014E0DE3321A0824) ] from C:/websites/bullseye/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(236C2F35-155D-9BEA-0116EE02CB815150) ] from C:/websites/bullseye/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(236CDE9D-155D-9BEA-018641D3692BE8E9) ] from C:/websites/bullseye/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(236D22DF-155D-9BEA-010FAA115A719DE2) ] from C:/websites/bullseye/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(23CAF9FB-155D-9BEA-014DE05AEA6984A7) ] from C:/websites/bullseye/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(25C195B5-155D-9BEA-01E09712618C03C4) ] from C:/websites/bullseye/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(36A31A9E-E77A-435E-A56D80D272E5C3DB) ] from C:/websites/bullseye/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(831A3F76-155D-9BEA-01EECAF7F29E927E) ] from C:/websites/bullseye/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(10224, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(12170, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(18958, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(26520, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(4396, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(4399, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(7317, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(7714, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(7746, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(8165, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(9141, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(9212, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(9351, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getAlternateImages(26520) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getAttr2(style_id = 26520, siz = , attr2 = NULL, attr1 = NULL, showOutOfStockSizes = true) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getColors(26520) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getColors(style_id = 26520, siz = , attr2 = NULL, attr1 = NULL, showOutOfStockSizes = true) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getLookup(style_id = 26520) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getMatchingWebStyles(TMHX1850C3000009) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(10224, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(11112, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(12170, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(18958, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(26520, [complex value]) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(28754, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(4396, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(4399, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(7317, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(7714, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(7746, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(9005, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(9141, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(9351, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(9954, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(10224) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(11112) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(12170) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(18958) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 2 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(26520) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(28754) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(4396) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(4399) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(7317) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(7714) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(8165) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(9005) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(9212) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(9351) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(9954) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getReviewsStarDisplay(0) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getSizes(style_id = 26520, siz = , attr2 = NULL, attr1 = NULL, showOutOfStockSizes = true) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(10224) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(11112) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(12170) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(18958) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(28754) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(4396) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(4399) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(7317) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(7714) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(7746) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(8165) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(9005) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(9141) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(9212) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(9954) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | productBreadCrumbs([complex value], [complex value], ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | productBreadCrumbsJSON([complex value], [complex value]) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/tracking.cfc | googleTrackingPixel(UA-59690783-1) ] from C:/websites/bullseye/functions/tracking.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | prepUrlVar(Trijicon) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Bushnell Banner Rifle Scope 4-12x 40mm Adjustable Objective Multi-X Reticle Matte, 8165) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Leupold QR Dovetail Rings, 1" Super High, Matte Black, 18958) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Magpul M-LOK Aluminum Rail Section 3 Slots Beveled Ends Mil-Spec Anodized Aluminum Black MAG580, 4396) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Magpul M-LOK Aluminum Rail Section 9 Slots Beveled Ends Mil-Spec Anodized Aluminum Black MAG583, 4399) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Stoeger Airgun Scope 3-9x40 AO 1", 12170) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(TruGlo 45 Degree Off-Set Riser Mount Picatinny Compatible Aluminum Matte Black, 9212) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Truglo GLO-DOT Universal Wing and Clay Shotgun Sight Green TG91, 7317) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Vortex Hunter Rings, 30mm Medium, Matte Black, 2 Rings Included, 9351) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Vortex Optics SPARC SOLAR Red Dot Sight 2 MOA Dot with Multi-Height Mount System Matte, 11112) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Vortex Strike Eagle Rifle Scope 3-18x44 FFP EBR-7C MOA Reticle 34MM Tube, 28754) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Weaver 1-Piece Extended Multi-Slot Picatinny Ruger American SA Scope Base, 9141) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Weaver 1-Piece Scope Base with 1" Integral Rings CVA, Traditions, 9954) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Weaver Detachable 1-Inch Extra High Top Mount Rings (Matte Black), 10224) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Weaver Tactical 4-Hole Picatinny Ring, 30mm Extra High, Matte Black 99518, 7746) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Weaver Tactical 6-Hole Weaver Rings, 1" Medium, Matte Black 48349, 7714) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Wheeler Anti-Cant Indicator Hinged Matte, 30mm Tube Diameter, 9005) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | titlecase(TENMILE? HX 318X50 SECOND FOCAL PLANE (SFP) RIFLESCOPE W/ MRAD CENTER DOT (RED/) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
516 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

checkThis (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\includes\application\check_db.cfm @ 05:42:19.019
SELECT Style_ID FROM TB_Styles
myQuery (Datasource=koalaSQL, Time=31ms, Records=1) in C:\websites\bullseye\functions\category.cfc @ 05:42:19.019
SELECT * from [dbo].[web_all_products] WHERE style_id='26520'
getStyleIdTax (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
SELECT b.web_url, b.active, b.dept, b.typ, b.subtyp_1, b.subtyp_2, b.subtyp_3,b.SHORT_DESC_ON_PAGE, b.SHORT_DESC, b.LONG_DESCRIPTION, b.backgroundImage
				FROM tb_web_taxonomy b 
				LEFT JOIN tb_styles_web_taxonomy a ON (a.web_taxonomy_id=b.web_taxonomy_id)
				WHERE lower(b.web_url)='/index.cfm' and b.active=1
checkProdTax (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
SELECT count(*) as myCount
				FROM tb_web_taxonomy b 
				LEFT JOIN tb_styles_web_taxonomy a ON (a.web_taxonomy_id=b.web_taxonomy_id)
				WHERE a.style=26520 and b.dept='' and b.typ='' and b.subtyp_1='' and b.subtyp_2='' and b.subtyp_3=''
getStyleIdTax (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
SELECT b.web_url, b.active, b.dept, b.typ, b.subtyp_1, b.subtyp_2, b.subtyp_3,b.SHORT_DESC_ON_PAGE, b.SHORT_DESC, b.LONG_DESCRIPTION, b.backgroundImage
			FROM tb_web_taxonomy b 
			LEFT JOIN tb_styles_web_taxonomy a ON (a.web_taxonomy_id=b.web_taxonomy_id)
			WHERE a.style=26520 and b.active=1
getWebUrlBC (Datasource=, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select web_url from application.getWebTaxonomy where upper(dept)='OPTICS' and typ='EMPTY'
getWebUrl (Datasource=, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select web_url from application.getWebTaxonomy where upper(dept)='OPTICS' and typ='EMPTY'
getWebStyles (Datasource=koalaSQL, Time=0ms, Records=2) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select * from web_all_products where webstyle='TMHX1850C3000009' and len(webstyle)>0
firstQuery (Datasource=koalaSQL, Time=62ms, Records=543) in C:\websites\bullseye\functions\clientCustomizations.cfc @ 05:42:19.019
SELECT distinct a.style_id
		
		, max(url) as url
		, max(realName) as realName
		, max(style) as style
		, max(overallqoh) as overallqoh
		, max(usePackage) as usePackage
		, max(sale) as sale
		, max(new) as new
		, max(TinyPicture) as TinyPicture
		, max(SmallPicture) as SmallPicture
		, max(MediumPicture) as MediumPicture
		, max(LargePicture) as LargePicture
		, max(sortposition) as sortposition
		, max(dept) as dept
		, max(typ) as typ
		, max(subtyp1) as subtyp1
		, max(subtyp2) as subtyp2
		, max(subtyp3) as subtyp3
		, max(brand) as brand
		, max(branddisplay) as branddisplay
		, max(priceRange) as priceRange
		, min(salePriceRangeBottom) as salePriceRangeBottom
		, max(salePriceRangeTop) as salePriceRangeTop
		, max(ListPrice) as ListPrice
		, max(ranking) as ranking
		, max(romanticcopylong) as romanticcopylong
		, max(romanticcopyshort) as romanticcopyshort
		, max(depttree) as depttree
		, max(attr1list) as attr1list
		, max(sizelist) as sizelist
		, max(name) as name
		, max(prodreviewsaverage) as prodreviewsaverage
		, max(INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(INTERNALPRICE) as INTERNALPRICE
		, max(TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(TERMSALEPRICE) as TERMSALEPRICE
		, max(TERMSALE) as TERMSALE		
		, 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(of7) as of7
        , max(of8) as of8
        , max(of9) as of9
        , max(of10) as of10
		, max(of11) as of11
		, max(of12) as of12
		, max(of13) as of13
		, max(of14) as of14
		, max(of15) as of15
		, max(of16) as of16
		, max(of17) as of17
		, max(of18) as of18
		, max(of19) as of19
		, max(of20) as of20
        , max(WEB_OF1) as WEB_OF1
        , max(WEB_OF2) as WEB_OF2
        , max(WEB_OF3) as WEB_OF3
        , max(WEB_OF4) as WEB_OF4
        , max(WEB_OF5) as WEB_OF5
        , max(WEB_OF6) as WEB_OF6
        , max(WEB_OF7) as WEB_OF7
        , max(WEB_OF8) as WEB_OF8
        , max(WEB_OF9) as WEB_OF9
        , max(WEB_OF10) as WEB_OF10
        , max(WEB_OF11) as WEB_OF11
        , max(WEB_OF12) as WEB_OF12 
        , max(WEB_OF13) as WEB_OF13
        , max(WEB_OF14) as WEB_OF14
        , max(WEB_OF15) as WEB_OF15
        , max(WEB_OF16) as WEB_OF16
        , max(WEB_OF17) as WEB_OF17
        , max(WEB_OF18) as WEB_OF18
        , max(WEB_OF19) as WEB_OF19
        , max(WEB_OF20) as WEB_OF20
		, max(CASE WHEN b.ymal_id IS NULL OR RTRIM(LTRIM(b.ymal_id)) = '' THEN 2 ELSE 1 END) as ymal
        , max(CASE WHEN b.ymal_sort IS NULL OR b.ymal_sort = 0 THEN 0 ELSE b.ymal_sort END) as sortBy	
		, CASE WHEN max(overallQOH) > 0 THEN 1 ELSE 0 END as inStock
		, CASE WHEN max(isNull(bestseller,'N')) = 'Y' THEN 1 ELSE 0 END as bestSeller
		, min(deposit) as deposit
		FROM [dbo].[web_all_products] a
		LEFT JOIN web_ymal b WITH (NOLOCK) ON ((a.style_id = b.ymal_style_id or upper(a.style) = upper(b.ymal_style)) and b.style_id = 26520)
		WHERE pictureid is not null
		AND (
			(b.ymal_id IS NOT NULL or b.ymal_id > 0)
		
		
			OR (
			a.style_id<>26520 
				and upper(dept)='OPTICS'
			
			)
		
		
		)
		
		
		
		GROUP BY a.STYLE_ID
returnQry (Datasource=, Time=16ms, Records=16) in C:\websites\bullseye\functions\clientCustomizations.cfc @ 05:42:19.019
SELECT *
            FROM firstQuery
            ORDER BY ymal, inStock DESC, bestSeller DESC,  sortBy
get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7317

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7317

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7317

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 28754

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 28754

getQOHQueryCart (Datasource=koalaSQL, Time=15ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 28754

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4399

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4399

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4399

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9141

get_rating (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9141

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9141

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7714

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7714

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7714

get_reviews (Datasource=koalaSQL, Time=16ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8165

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8165

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8165

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 11112

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 11112

getQOHQueryCart (Datasource=koalaSQL, Time=15ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 11112

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 12170

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 12170

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 12170

get_reviews (Datasource=koalaSQL, Time=16ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9212

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9212

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9212

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9954

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9954

getQOHQueryCart (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9954

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 18958

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 18958

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 18958

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7746

get_rating (Datasource=koalaSQL, Time=15ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7746

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7746

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9351

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9351

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9351

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10224

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10224

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10224

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9005

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9005

getQOHQueryCart (Datasource=koalaSQL, Time=15ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9005

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4396

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4396

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4396

prodSpecs (Datasource=koalaSQL, Time=16ms, Records=0) in C:\websites\bullseye\functions\clientCustomizations.cfc @ 05:42:20.020
SELECT DISTINCT a.spec_name, a.spec_name_id, b.spec_value,a.spec_order
         FROM web_product_spec_name a
         INNER JOIN web_product_specs b WITH (NOLOCK) ON (a.spec_name_id = b.spec_name_id)
         WHERE b.style_id = 26520 And b.spec_value <> ''
         
         GROUP BY a.spec_name, a.spec_name_id, b.spec_value,a.spec_order
         ORDER BY a.spec_order asc, a.spec_name asc
get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26520

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_product_reviews 
        where style_id in (26520,26520)
		and status='A'
get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26520

getAltImg (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select * 
        from tb_alt_pictures 
        where style_id=?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26520

getColorsQuery (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1  ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam
		FROM tb_skus a
		LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id)
		LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id)
        LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1)
		LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id)
		WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and b.attr1<>'NoColor' and a.style_id=? 
			AND e.store_id=1 

		GROUP BY b.attr1
		
        ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26520

getLookupQuery (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
select lookup from
		tb_sku_lookups
		where 
			
			sku_id IN (
				SELECT sku_id
				FROM tb_skus
				WHERE style_id = ?
			)
			
		and prime='Y'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26520

get_term_sale_info (Datasource=koalaSQL, Time=156ms, Records=0) in C:\websites\bullseye\products.cfm @ 05:42:20.020
USP_LOAD_TERM_SALE_FOR_PRODUCT 26520, 1, 'Y'
getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26520

getSizesQuery (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT distinct(b.siz) as origSiz, max(a.style_id) as style_id, max(CASE WHEN b.siz_alias IS NULL OR RTRIM(LTRIM(b.siz_alias)) = '' THEN b.siz  ELSE b.siz_alias END) as siz, max(b.size_order) as size_order, max(a.sku_id) as sku_id, max(a.scale_entry_id) as scale_entry_id, sum(e.qoh+e.qc) as qoh, isNull(max(s.non_invt),'N') as non_invt
		FROM tb_skus a
		LEFT JOIN tb_size_entries b WITH (NOLOCK) ON (b.scale_entry_id = a.scale_entry_id)
		LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id)
        LEFT JOIN tb_styles s WITH (NOLOCK) ON (a.style_id = s.style_id)
		WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id =? 
			AND e.store_id=1 

		GROUP BY b.siz, a.style_id
		
		ORDER BY max(b.size_order), max(a.scale_entry_id)
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26520

getColorsQuery (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1  ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam
		FROM tb_skus a
		LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id)
		LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id)
        LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1)
		LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id)
		WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and b.attr1<>'NoColor' and a.style_id=? 
			AND e.store_id=1 

		GROUP BY b.attr1
		
        ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26520

getAttr2Query (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
SELECT distinct (b.attr2) as origAttr2, max(CASE WHEN b.attr2_alias IS NULL OR RTRIM(LTRIM(b.attr2_alias)) = '' THEN b.attr2  ELSE b.attr2_alias END) as attr2, max(a.sku_id) as sku_id, max(b.attr2_entry_id) as attr2_entry_id, sum(e.qoh+e.qc) as qoh
		FROM tb_skus a
		LEFT JOIN tb_attr2_entries b WITH (NOLOCK) ON (b.attr2_entry_id = a.attr2_entry_id)
		LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id)
		WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=? 
			AND e.store_id=1 
		GROUP BY b.attr2
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26520

prodSpecs (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\clientCustomizations.cfc @ 05:42:20.020
SELECT DISTINCT a.spec_name, a.spec_name_id, b.spec_value,a.spec_order
         FROM web_product_spec_name a
         INNER JOIN web_product_specs b WITH (NOLOCK) ON (a.spec_name_id = b.spec_name_id)
         WHERE b.style_id = 26520 And b.spec_value <> ''
         
         GROUP BY a.spec_name, a.spec_name_id, b.spec_value,a.spec_order
         ORDER BY a.spec_order asc, a.spec_name asc
gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '23CAF9FB-155D-9BEA-014DE05AEA6984A7') AND (active = 1) AND display > 0
gcbi (Datasource=muraDB, Time=15ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '2363C0DF-155D-9BEA-018D2CD496E7A280') AND (active = 1) AND display > 0
gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236C0F49-155D-9BEA-014E0DE3321A0824') AND (active = 1) AND display > 0
gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236C2F35-155D-9BEA-0116EE02CB815150') AND (active = 1) AND display > 0
gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236D22DF-155D-9BEA-010FAA115A719DE2') AND (active = 1) AND display > 0
gcbi (Datasource=muraDB, Time=16ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236CFAC8-155D-9BEA-014EF87802FDB145') AND (active = 1) AND display > 0
gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236CDE9D-155D-9BEA-018641D3692BE8E9') AND (active = 1) AND display > 0
gcbi (Datasource=muraDB, Time=0ms, Records=0) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '25C195B5-155D-9BEA-01E09712618C03C4') AND (active = 1) AND display > 0
getChild (Datasource=muraDB, Time=0ms, Records=5) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, credits, display, Notes
            FROM tcontent
            WHERE (parentID = '25C195B5-155D-9BEA-01E09712618C03C4') AND (active = 1) and display > 0
            ORDER BY orderno
gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '831A3F76-155D-9BEA-01EECAF7F29E927E') AND (active = 1) AND display > 0
gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 05:42:20.020
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '36A31A9E-E77A-435E-A56D80D272E5C3DB') AND (active = 1) AND display > 0
getDepts (Datasource=, Time=0ms, Records=9) in C:\websites\bullseye\includes\footer.cfm @ 05:42:20.020
SELECT dept,web_url,sort_position 
                            FROM application.getWebTaxonomy 
                            WHERE typ='EMPTY'  
                            ORDER BY sort_position
getTyps (Datasource=, Time=0ms, Records=6) in C:\websites\bullseye\includes\footer.cfm @ 05:42:20.020
SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='FIREARMS' 
                                    ORDER BY sort_position
getTyps (Datasource=, Time=0ms, Records=8) in C:\websites\bullseye\includes\footer.cfm @ 05:42:20.020
SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='AMMUNITION' 
                                    ORDER BY sort_position
getTyps (Datasource=, Time=0ms, Records=0) in C:\websites\bullseye\includes\footer.cfm @ 05:42:20.020
SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='MAGAZINES' 
                                    ORDER BY sort_position
getTyps (Datasource=, Time=0ms, Records=8) in C:\websites\bullseye\includes\footer.cfm @ 05:42:20.020
SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='RELOADING' 
                                    ORDER BY sort_position
getTyps (Datasource=, Time=0ms, Records=7) in C:\websites\bullseye\includes\footer.cfm @ 05:42:20.020
SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='STORAGE' 
                                    ORDER BY sort_position
getTyps (Datasource=, Time=0ms, Records=8) in C:\websites\bullseye\includes\footer.cfm @ 05:42:20.020
SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='OPTICS' 
                                    ORDER BY sort_position
getTyps (Datasource=, Time=0ms, Records=0) in C:\websites\bullseye\includes\footer.cfm @ 05:42:20.020
SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='KNIVES' 
                                    ORDER BY sort_position
getTyps (Datasource=, Time=0ms, Records=14) in C:\websites\bullseye\includes\footer.cfm @ 05:42:20.020
SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='ACCESSORIES' 
                                    ORDER BY sort_position
getTyps (Datasource=, Time=0ms, Records=0) in C:\websites\bullseye\includes\footer.cfm @ 05:42:20.020
SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='ON SALE' 
                                    ORDER BY sort_position


Stored Procedures

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  7317    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  28754    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  4399    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  9141    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  7714    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:19.019
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  8165    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  11112    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  12170    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  9212    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  9954    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  18958    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  7746    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  9351    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  10224    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  9005    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  4396    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=16ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:42:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  26520    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1


Scope Variables

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.bullseyenorth.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\websites\bullseye\products.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.bullseyenorth.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.bullseyenorth.com
HTTP_REFERER=
HTTP_URL=/products.cfm?ID=26520
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.16.53.112
PATH_INFO=
PATH_TRANSLATED=C:\websites\bullseye\products.cfm
QUERY_STRING=ID=26520
REMOTE_ADDR=3.22.68.49
REMOTE_HOST=3.22.68.49
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/products.cfm
SERVER_NAME=www.bullseyenorth.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=13008427
CFTOKEN=1f737c53744bd514-D450133A-CCB4-2FBE-83C4E9094EE75068
Form Fields:
KWORD=
Session Variables:
altimgurl=https://www.bullseyenorth.com/prodimages/alt_images/
cartstatus=NEW
cfid=13008427
cftoken=1f737c53744bd514-D450133A-CCB4-2FBE-83C4E9094EE75068
checkout=Struct (4)
couponreset=NO
cs=/index.cfm
customer_id=
customerdiscount=0
display_cc=YES
displaycount=25
email=
employeeloggedin=false
first_name=
getproducts=Query (1)
iconurl=https://www.bullseyenorth.com/images/icons/
last_name=
memberloggedin=N
password=
phone=
picurl=https://www.bullseyenorth.com/images/
prodimgurl=https://www.bullseyenorth.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_13008427_1f737c53744bd514-D450133A-CCB4-2FBE-83C4E9094EE75068
shipmethodlist=0,1
urltoken=CFID=13008427&CFTOKEN=1f737c53744bd514-D450133A-CCB4-2FBE-83C4E9094EE75068
username=
URL Parameters:
ID=26520
Debug Rendering Time: 31 ms