New Enhanced Website – Call Customer Service at 781-531-9164 for pricing and ordering information.

SchureMed
Innovative Solutions in Advanced Surgical Positioning

Schure Loc™ XPS

ProductID: 800-0280
  • Schure Loc™ XPS
  • Schure Loc™ XPS
  • Schure Loc™ XPS
  • Schure Loc™ XPS
Customer Serivce
For product pricing and information, please call our Customer Service Team at 781-531-9164 or fill out the Request a Quote form.

Increase operating room performance and productivity with the new SchureMed Schure Loc™ XPS portable arm and hand positioner. With no foot pedals, hoses, hydraulics or power cords around the operating room table, Schure Loc™ XPS combines strength and flexibility when intra-operatively adjusting the operative limb. Because the Schure Loc™ XPS maintains steady positioning from start-to-finish, the whole surgical team can focus on the open or arthroscopic limb procedure – no need to have the surgical aid hold the patient’s limb during the procedure! Great for beach chair or lateral position and coming soon – Schure Loc™ XPS positioner for elbow, wrist, knee or ankle surgery.

  • Single release lever releases all joints – locking in place when released
  • Easily attached to any OR table – ready for immediate use
  • Smooth, effortless positioning enhances operative site exposure
  • Decrease surgeon fatigue and improve OR team productivity
  • Convenient Schure Loc™ Shoulder Kit includes a sterile drape, foam hand/forearm holder and self-adherent wrap (purchase separately below)
  • 500 lb patient weight capacity

Required Accessory
Disp. Schure Loc™ XPS Sterile Kit

Optional Accessories
Schure Loc™ XPS Adapter
Schure Loc™ XPS Forearm Attachment
Schure Loc™ XPS Armboard
Schure Loc™ XPS Counter Traction Post
Schure Loc™ XPS TKR Positioner
Schure Loc™ XPS Elbow/Ankle Positioner


Download IFU pdf

Copyright Notice
All rights reserved. Any duplication, adaption or translation without prior written consent is prohibited unless otherwise provided in relevant copyright laws.

Schure Loc™ XPS
800-0280
800-0280-EU
800-0280-UK
800-0280-DEN
800-0280-JPN 
800-0280-SWISS

Accessories (sold separately)
790-0039 Adaptor
790-0040 Forearm Attachment
790-0056 Armboard
790-0057 Counter Traction Post
790-0075 Elbow/Ankle Positioner
790-0077 TKR Positioner
800-0281 Disposable Sterile Kit
800-0146 TKR Disposable Sterile Boot Liners


Initial Release: 1/1/2013


Manufacturer

SchureMed (081001460)
452 Randolph Street, Abington, MA 02351 USA 
Toll Free 
(888) 724-8763  |  Ph (781) 982-7000
Fax 
(781) 982-7001  |  orders@schuremed.com


Authorized Representative
Emergo Europe, Prinsessegracht 20, 2514 AP The Hague, The Netherlands

Component Overview



1Schure Loc™ XPS Articulating Arm

Accessories Sold Separately
2—Schure Loc™ XPS Adaptor (790-0039) 
3—Schure Loc™ XPS Forearm Attachment (790-0040)
4—Schure Loc™ XPS TKR Sterile Boot Liner (Disposable-Single use only) (800-0146)
5Schure Loc™ XPS Sterile Drape Kit (Disposable-Single use only) (800-0281)
Sterile Forearm Pad 
Sterile Self-Adherent Coban Wrap 
Sterile Drape
6—Schure Loc™ XPS TKR Positioner (790-0077)
7—Schure Loc™ XPS Counter Traction Post (790-0057) 
8—Schure Loc™ XPS Armboard (790-0056)
9—Schure Loc™ XPS Elbow/Ankle Positioner (790-0075)

GENERAL INFORMATION
  • Product not made with (NRL) Natural Rubber Latex
  • Device supports 500 lb. proportional patient load (6'4" tall patient per 99% human body model)
  • Product warranty covers product from manufacturing defects for period of 2 years (Excluding Disposable 800-0281 and 800-0146)
  • If damaged in shipping, call Customer Service at (888) 724-8763 to obtain Return Material Authorization (RMA) number. For product warranty issues, contact Customer Service.
  • Product is maintenance free, check product condition before next use
  • Life of device is 5 years under normal use.
  • Storage device between –4°F to +86°F
General Specifications
  • Maximum Length: 38” +/- 0.5”
  • Maximum Reach: 40.5” +/- 0.5”
  • Minimum distance from side/rail: 6.5” +/- 0.5”
  • Net Weight, Arm Only: 12.4 lbs.
  • Net Weight with Adapter and Forearm Attachment: 14.3 +/- 0.5 lbs.
  • Gross Weight: 21 +/- 0.5 lbs.
  • Range of motion 360° rotation at each joint
  • Single-person installation

Other products required for use:
800-0281 Disp. Schure Loc™ XPS Sterile Kit, 10 per case (not included)
Disp. Schure Loc™ XPS Sterile Kit (forearm pad, self-adherent wrap and sterile drape) is strictly required for proper use of the Schure Loc™ XPS. All products within sterile kit are disposable and single-use only.

800-0146 Sterile TKR Boot Liner, 12 per case (not included)
Sterile TKR Boot Liner is strictly required for proper use of Schure Loc™ XPS. Liner Pad, within sterile kit, is disposable and single-use only.

INTENDED USE
Schure Loc™ XPS is used to hold a patients extremity securely during surgical procedures. Schure Loc™ XPS is mounted to an accessory rail of a surgical table and has a full range of motion which can be locked in various positions using one hand trigger. You can intra-operatively adjust the patient’s limb while maintaining the sterile field.

PRODUCT USE WARNINGS

All products used may only be used in sterile condition, except Articulating arm which is used with a sterile cover.  



Adaptor, Forearm Attachment and TKR are supplied in a non-sterile condition and must be cleaned and sterilized before first use. 


WARNING!

Risk of injury!
Hazard resulting from incorrect use. Be absolutely sure to follow Instructions for Use for your operating table system.


WARNING!

Risk of injury!
Vital functions can be impaired through incorrect positioning. Position patient correctly and maintain continuous observation.


WARNING!
Risk of injury!
A worn or damaged product/accessory can cause injuries. Only use products/accessories which are in perfect condition.


WARNING!
Risk of injury!
Maximum load should not exceed appropriate proportion of a patient weighing 500 lbs. Use care with low-maximum load capacity surgical tables that accessory rails are not overloaded. Strictly follow Instructions for Use for your Operating Table system.


WARNING!
Risk of injury!
Collisions between accessories, operating table, table top and patient can occur when adjusting or moving operating table or table top or when transferring table top. Observe adjustment procedure and avoid collisions.


WARNING!
Risk of burning!
Patient to burn hazard due to contact with metal components in device or accessories and/or if resting on wet drapes or electrically conductive padding. Avoid any contact between patient and metallic components; never use moist or wet surgical drapes. Be absolutely sure to comply with manufacturers operating instructions!


WARNING!
Risk of injury!
Before opening swivel joints, hold patient's limb securely. Make sure that all swivel joints are closed after each adjustment procedure.


WARNING!
Risk of injury!
Whenever the product is mounted and adjusted, there is a WARNING of pinching and shearing to staff, patient and accessories. Always ensure that no one can be subjected to pinching or shearing action or injured in any other way and that the accessories do not collide with any nearby objects.


WARNING!
Risk of injury!
Patient may be endangered as a result of incorrect use. Follow operating instructions for all accessories.


WARNING!
Risk of mobile operating table tipping over!
The product affects the center of gravity of the mobile operating table. When positioning the patient, be absolutely sure to follow the Instructions for Use for your operating table system.


WARNING!
Property damage!
Do not lubricate or oil Articulating arm. It may lead to irreparable damage to the functioning of unit.


WARNING!
Property damage!
Schure Loc™ XPS is used to support arm of the patient. No other additional forces, may act on Schure Loc™ XPS .


WARNING!
Property damage!
During surgery, Schure Loc™ XPS must be covered by a sterile cover to protect it against from liquids.


WARNING!
Property damage!
High temperatures, moisture and humidity can damage product. Protect product against moisture and humidity, clean by wipe disinfection only. Do not store close to radiators and protect from high solar radiation. Do not expose product to large impacts and vibrations, product is not designed for impulse loads.


WARNING!
Risk of infection!
Do not use sterile set when packaging of sterile set is damaged.

ASSEMBLY
All products used, except articulating arm, which is used with a sterile cover, may only be used in sterile condition.

Mounting PositionPosition for mounting/detaching articulating arm

Neutral Position: Position articulating arm (as shown) when mounting sterile cover

MOUNTING SCHURE LOC™ XPS ONTO SURGICAL TABLE  

Articulating arm must be in mounting position when attaching and detaching unit from surgical table rail. 

  

Mounting Articulating Arm to Table
  • Place articulating arm in mounting position
  • Verify mounting knob is facing upward and in loose unlocked position
  • Place clamp on accessory rail of surgical table in seat plate area between patient hip and knee
  • Tighten clamp by turning mounting knob to the right

You must clamp directly to side rail to fix articulating arm to rail securely . 


Check to ensure the clamp is properly and safely tightened to prevent potential injury to patient or product damage.
 

Draping Schure Loc™ XPS and Mounting Adaptor, Armboard, Counter Traction Post, Elbow/Ankle Positioner, TKR and Forearm Attachments

Position Schure Loc™ XPS articulating arm in the neutral position when draping (See instructions for MOUNTING SCHURE LOC™ XPS ONTO SURGICAL TABLE)

  1. Tape drape to sterilized Schure Loc™ XPS Adaptor so that half the tape is on drape and remainder is on adaptor as shown in (1) .
  2. Attach Adaptor to articulating arm as shown in (2). Twist to lock fully into place.
  3. Pull drape down over Adaptor and to accessory rail to completely cover Articulating Arm as shown in (3).
  4. Slip end of forearm attachment into pocket at bottom of Forearm Pad. Then slide handle into handle slot as shown in (4) and (5).
  5. Attach Schure Loc™ XPS Forearm attachment to Adaptor, and rotate slightly so it is properly attached. See (6).
  6. Attach Schure Loc™ Armboard, Counter Traction Post. Elbow/Ankle Positioner and TKR, and rotate slightly so it is properly attached (see DISASSEMBLY).

SECURE PATIENT'S ARM



Placing and Securing Patient's Arm
  1. Place patient arm into Forearm Pad, ensuring patient’s fingers wrap around Forearm Attachment Handle and wrap pad snugly around patient arm. See (1) and (2).
  2. Using self-adherent wrap, secure patients arm to forearm attachment by wrapping entire assembly. Be sure to secure hands and fingers with wrap. See (3) and (4).

Do not wrap Adaptor in order to allow for intra-operative detachment. 

ADJUSTING ARTICULATING ARM

WARNING!
Risk of injury due to unintended movements downwards! 
When squeezing trigger, swivel joints are released and SCHURE LOC™ XPS can be moved. Due to its own weight and weight of patient it will falls downwards. Before squeezing trigger, firmly hold SCHURE LOC™ XPS with both hands. After every adjustment process, ensure that trigger is released and locks SCHURE LOC™ XPS into place. Check that no foreign bodies (e.g. sterile cover, glove) are pinched. 


WARNING!
Excessive load may cause mechanism to jam slightly. In this case, take load off SCHURE LOC™ XPS, if necessary, detach arm rest and push in handle with increased force to open the joints.


Mount SCHURE LOC™ XPS in seat plate area

  

Adjusting the Articulating Arm 

  1. Release Schure Loc™ XPS upwards
  2. Squeeze Trigger as far as it will go and hold it. All swivel joints are released, and Schure Loc™ XPS can move freely.
  3. Swivel articulating arm to desired position
  4. Release Trigger and Schure Loc™ XPS swivel joints will be locked
OTHER ACCESSORY INSTRUCTIONS
790-0056 Armboard
  1. Place patient’s arm in center of pad, attach strap to velcro on bottom of armboard and wrap it around arm and attach strap to velcro on bottom of board
790-0057 Counter Traction Post
  1. Articulate Schure Loc™ XPS to desired position, wrap patient’s arm around post with elbow pointing up.
  2. Articulate Schure Loc™ XPS to desired position, rest patient bottom foot on post
790-0075 Elbow/Ankle Positioner
  1. Articulate Schure Loc™ XPS to desired position, wrap patient’s arm inside cradle with elbow pointing up
  2. Articulate Schure Loc™ XPS to desired position, rest patient foot in cradle
790-0077 TKR POSITIONER
  1. Drape surgical table
  2. Articulate Schure Loc™ XPS to desired position, the TKR boot must be resting on the table
  3. Line boot with our sterile Disposable Boot Liner #800-0146 (sold separately as a case of 12)
  4. Insert foot into boot, secure foot by wrapping sterile coban
DISASSEMBLY
During surgery you can check range of motion and maintain sterile field by removing forearm attachment, armboard, counter traction post, elbow/ankle positioner or TKR from adaptor. Now their limbs can move independently without Schure Loc™ XPS.



Removing Adaptor, Forearm Attachment, Armboard, Counter Traction Post, Elbow/Ankle Positioner and TKR

  • To remove Forearm Attachment, simultaneously press in both top release buttons (1) of adaptor, and Forearm Attachment will release upward
  • To remove Armboard (3), Counter Traction post (4), Elbow/Ankle Positioner (5) or TKR (6) simultaneously press in both top release buttons (1) of Adaptor, and accessories will release upward
  • To remove Adaptor, simultaneously press in both bottom release buttons (2) of Adaptor, and Adaptor will release from articulating arm
DETACHING SCHURE LOC™ XPS FROM OPERATING TABLE

Articulating arm must be in mounting position when detaching unit from surgical table rail. 

  

Detaching Schure Loc™ XPS
!Place articulating arm in mounting position (as shown in example on the left).

  1. Loosen clamp by turning mounting knob to the left
  2. Move articulating arm in an upward motion to remove from accessory rail
  3. Remove product from accessory rail, clean and store

CLEANING AND DISINFECTION

WARNING!
Product must be cleaned and wipe or spray disinfected after every use.


WARNING!

Clean and sterilize Adaptor 790-0039, Forearm Attachment 790-0040 and TKR Positioner 790-0077 before initial use and after every use.


WARNING!

Do not submerge or use washer cleaning for the Schure Loc XPS 800-0280 or Traction Post 790-0057 or Armboard 790-0056 or Elbow/Ankle Positioner 790-0075.



WARNING!

Risk of infection!
Particles of grime may become encapsulated and lead to product not reaching desired germ-reduction after disinfection. Before disinfection, product must be cleaned thoroughly of contamination and encapsulated particles of grime and then be dried.


WARNING!
Risk of infection!
Do not use sterile set when packaging of sterile set is damaged.



WARNING!
Risk of infection!
If articulating arm is used in areas with varying hygienic requirements, there is a risk of infection. Ensure that articulating arm is always in sterile area while being used.



WARNING!
Improper cleaning and disinfection can cause property damage!
Perform visual and functional inspections after each cleaning and disinfection process.


WARNING!
Improper cleaning and disinfection can cause property damage!
Do not use following products for cleaning and disinfection:

  • Products containing alcohol
  • Halogenides
  • Dehalogenating compound
  • Products that may scratch the surface
  • Water containing iron particles
  • Cleaning sponges containing Iron
  • Products containing hydrochloric acid

Use approved detergents and disinfectants only. Use a soft, lint free cloth or a soft nylon brush to clean product.


CAUTION!
Improper cleaning and disinfection can cause property damage!
Use only as much detergent and disinfectant as required. Thoroughly wipe off any excess detergent and disinfectant with a damp, soft cloth. Avoid surface drying of excess detergent and disinfectants.

HAND AND WASHER MACHINE CLEANING INSTRUCTIONS 

  • Clean Schure Loc™ XPS System thoroughly before each use by either hand or washer cleaning
  • Recommended cleaning products: (All solutions should be used in accordance with manufacturer’s instructions)

- Enzymatic neutral pH detergent solution
- (Enzymatic cleaners are compatible with metal devices/instruments and are preferred)
- Non-enzyme, hydrogen peroxide based solution
- Coverage Plus NPD One Step Cleaner, Disinfectant & Deodorizer Concentrate

  • Disassemble Schure Loc™ XPS System in to separate parts for cleaning
Hand Cleaning
  • Can be used for all Schure Loc XPS components
  • Scrub each piece with a soft, plastic scrub brush and a recommended cleaning solution (see above)
  • Rinse all parts thoroughly to remove any chemical residue
  • Wipe each part completely dry with a clean, lint-free cloth
Washer Cleaning
  • Can only be used for Adaptor 790-0039, Forearm Attachment 790-0040 and TKR Positioner 790-0077
  • Put through washer/decontaminator according to manufacturer’s instruction (Select cycle that does not included lubrication)
  • Prepare for sterilization (device must be cleaned before sterilization)
  • See sterilization instructions below

*Based on information provided by the Healthcare Infection Control Practices Advisory Committee (HICPAC), the Center for Disease Control (CDC), the National Center for Biotechnology Information (NCBI) and the U.S. National Library of Medicine.

STEAM STERILIZATION? Wrap using envelope method or accepted wrap method at your facility.
Pre-Vacuum?Wrapped Instruments?Set Temperature at 132°C (270°F)?Full Cycle Time: 6.5 minutes?Dry Time: 40 minutes

STEAM STERILIZATION
Wrap using envelope method or accepted wrap method at your facility.

Pre-Vacuum?Wrapped Instruments?Set Temperature at 132°C (270°F)?Full Cycle Time: 6.5 minutes?Dry Time: 40 minutes
STEAM STERILIZATION?Wrap using envelope method or accepted wrap method at your facility.
Pre-Vacuum?Wrapped Instruments?Set Temperature at 132°C (270°F)?Full Cycle Time: 6.5 minutes?Dry Time: 40 minutes
STEAM STERILIZATION?Wrap using envelope method or accepted wrap method at your facility.
Pre-Vacuum?Wrapped Instruments?Set Temperature at 132°C (270°F)?Full Cycle Time: 6.5 minutes?Dry Time: 40 minutes

Pre-Vacuum
Wrapped Instruments

Set Temperature at 132°C (270°F)
Full Cycle Time: 6.5 minutes
Dry Time: 40 minutes

DISPOSAL
  1. General - Prevent infection by cleaning and disinfecting product before disposal
  2. Packaging - Dispose packaging material via household waste according to national requirements
  3. Products - SchureMed will take back used product or no longer in service
  4. Disposable Product - Must be handled and disposed pursuant to national regulations

Symbol Explanation

  Date of Manufacture

  Manufacturer

 Authorized Representative in European Community

  Conformity Mark

  Batch Code/Serial Number

 

IFU-800-0280  REV 3.03

Available Combo Deals

×

Developer Tools

Database Activity Repeated Calls Shipping Rates Performance Tracking Cache Storage Session Storage
schuremeddev.braveriversolutions.com
3.7420155 seconds
# Seconds Since First Hit Trace Command Type Command Text Parameters Execution Time
1. 0 DBInterface.GetDataT show StoredProcedure SiteSettings_Load - 0.0794748
2. 0.063311 DBInterface.GetDataT show StoredProcedure [dbo].[VirtualCatalogLoadBySiteDomain] @SiteDomain=schuremeddev.braveriversolutions.com
0
3. 0.0789296 DBInterface.get_oSQL show StoredProcedure [dbo].[VirtualSitePropertiesLoadBySiteID] @SiteID=1
0.0156186
4. 1.3717434 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchNameID] - 0
5. 1.5927715 DBInterface.GetDataT show Text SELECT TOP(1) '0' AS ArticleID, 0 As ID, Product.MetaTitle As PageTitle, Product.MetaDescription As show - 0.0162597
6. 1.6560478 DBInterface.GetDataT show StoredProcedure Content_LoadMiscContent - 0.0476117
7. 1.6560478 DBInterface.GetDataT show Text SELECT TOP(1) '0' AS ArticleID, 0 As ID, Product.MetaTitle As PageTitle, Product.MetaDescription As show - 0
8. 1.6716728 DBInterface.GetDataT show Text SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Alert Bar show - 0
9. 1.7193597 DBInterface.GetDataT show StoredProcedure Content_LoadPageLinks - 0.0156497
10. 1.8615269 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.11091
11. 1.8927571 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0312302
12. 1.9716215 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/schure-loc-xps.html
@Type=PRODUCT
0.0156225
13. 2.0505568 DBInterface.get_oSQL show StoredProcedure [dbo].[ProductLoadByPrimaryKey] @ProductID=182
@SiteID=1
@UserID=b4a1ee8e-4234-4448-91b5-76162aaa1b8b
0.0789353
14. 2.1130612 DBInterface.GetDataT show StoredProcedure [dbo].[CategoryListByProductId] @ProductId=182
@SiteID=1
@ShowHidden=False
0.0292893
15. 2.1771628 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @Type=CATEGORY
0.0156189
16. 2.1928025 DBInterface.GetDataT show StoredProcedure [dbo].[DocumentLoadByProductKey] @ProductID=182
0.0156397
17. 2.2084928 DBInterface.get_oSQL show StoredProcedure [dbo].[ImageLoadByProductKey] @ProductID=182
0.0156903
18. 2.2907462 DBInterface.get_oSQL show StoredProcedure [dbo].[ProductRelationshipListByProductID] @ProductID=182
@SiteID=1
@ShowHidden=False
0.0321409
19. 2.4321368 DBInterface.get_oSQL show StoredProcedure [dbo].[SKUListLoadByProductKey] @ProductID=182
@SiteID=1
@UserID=b4a1ee8e-4234-4448-91b5-76162aaa1b8b
@ShowHidden=0
0.1255662
20. 3.0035853 DBInterface.get_oSQL show StoredProcedure [dbo].[PriceListBySkuId] @SkuList=8115,10567,10564,10568,10569,10570
@UserID=b4a1ee8e-4234-4448-91b5-76162aaa1b8b
@SiteID=1
0.4582408
21. 3.0187728 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =b4a1ee8e-4234-4448-91b5-76162aaa1b8b
0.0151875
22. 3.0585125 DBInterface.GetDataT show StoredProcedure [dbo].[AttributesDistinctByProductID] @ProductId=182
0.0397397
23. 3.1843994 DBInterface.GetDataT show StoredProcedure BreadcrumbByPageUrlByUser @UserId=b4a1ee8e-4234-4448-91b5-76162aaa1b8b
@SiteID=1
@PageURL=/schure-loc-xps.html
0.1102329
24. 3.314723 DBInterface.GetDataT show StoredProcedure [dbo].[Cart_LoadByUserID] @UserID=b4a1ee8e-4234-4448-91b5-76162aaa1b8b
@SiteID=1
0.1147099
Total DB Execution Time 1.3833686
Command Hits
SELECT TOP(1) '0' AS ArticleID, 0 As ID, Product.MetaTitle As PageTitle, Product.MetaDescription As PageMetaDesc, Product.MetaKeywords As PageMetaKwords, Product.Title As PageHeading, '' As PageContent, '' As PageContent2, '' As PageContent3, '' As PageContent4, '' As PageContent5, '' As PageContent6, '' As StartDate, '' As EndDate, '' As Thumbnail, 0 As NumLatestArticles, 0 As HasArticles, '' As UserControl, 0 As PageLayout FROM PageURLs LEFT OUTER JOIN Product ON PageURLs.EntityID = Product.ProductID WHERE PageURLs.PageURL = '/schure-loc-xps.html' AND PageURLs.Type='product' 2
DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, Level INT, ParentTreeID INT, [Path] VARCHAR(2000), PageID_Path VARCHAR(2000), PageID INT NOT NULL); DECLARE @RowCount INT, @Level INT, @DelCount INT; SET NOCOUNT ON; SET @Level = 0; INSERT INTO @Tree(PageID, Level) VALUES (@StartingID, @Level); SET @RowCount = @@ROWCOUNT; UPDATE @Tree SET Path = STR(TreeID, 10, 0) + '.', PageID_Path = CAST(PageID AS VARCHAR(10)) + '\'; WHILE @RowCount > 0 BEGIN SET @Level = @Level + 1; INSERT INTO @Tree(Level, ParentTreeID, PageID) SELECT @Level, t.TreeId, PageURLs.ID FROM PageURLs LEFT OUTER JOIN @Tree t ON ISNULL(PageURLs.ParentID,0) = t.PageID AND t.Level = (@Level - 1) INNER JOIN HTMLContent ON HTMLContent.ID = PageURLs.EntityID LEFT OUTER JOIN HTMLContent_XREF ON HTMLContent.ID = HTMLContent_XREF.ContentID WHERE 1=1 AND ( 1=1 AND HTMLContent.SiteID = 1 AND PageURLs.[Type] = 'content' AND HTMLContent.IsMenuItem = 'True' AND @Level <= 20 ) ORDER BY COALESCE(OrderPriority, 1000), PageKey ; SET @RowCount = @@ROWCOUNT; UPDATE t1 SET t1.[Path] = t2.[Path] + STR(t1.TreeID, 10, 0) + '.', t1.PageID_Path = t2.PageID_Path + CAST(t1.PageID AS VARCHAR(10)) + '\' FROM @Tree t1 INNER JOIN @Tree t2 ON t1.ParentTreeID = t2.TreeID WHERE t1.Level = @Level AND t2.PageID_Path NOT LIKE '%' + CAST(t1.PageID AS VARCHAR(10)) + '\%'; DELETE FROM @Tree WHERE PageID_Path IS NULL; SET @DelCount = @@ROWCOUNT; SET @RowCount = (@RowCount - @DelCount); END; SELECT [Path], t.PageID, t.Level , (SELECT COUNT(HTMLContent_XREF1.ID) FROM HTMLContent_XREF AS HTMLContent_XREF1 LEFT JOIN HTMLArticles AS HTMLArticles1 ON HTMLContent_XREF1.ContentID = HTMLArticles1.ContentID LEFT JOIN HTMLContent AS HTMLContent1 ON HTMLContent1.ID = HTMLContent_XREF1.ContentID WHERE HTMLContent_XREF1.ParentContentID = HTMLContent.ID AND (HTMLContent1.IsMenuItem = 'True' OR HTMLContent1.ID IS NULL) AND HTMLArticles1.ID IS NULL) As NumChildren, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.IsMenuItem, HTMLContent.MenuText, HTMLContent.MenuURL, HTMLContent.PageHeading, HTMLContent.HasArticles, HTMLContent_XREF.ParentContentID FROM @Tree t INNER JOIN PageURLs ON t.PageID = PageURLs.ID INNER JOIN HTMLContent ON HTMLContent.ID = PageURLs.EntityID LEFT OUTER JOIN HTMLContent_XREF ON HTMLContent.ID = HTMLContent_XREF.ContentID WHERE 1=1 ORDER BY [Path] ; 2
[dbo].[PageUrlLoadByPrimaryKey] 2
Cache Key Cache Value
LeftMenu
  • About Us
  • Become a Rep
  • Contact Us
  • Request a Catalog
  • Request a Quote
  • Videos
  • PageManager_Cache_PageLinks
    TopMenu
  • About Us
  • Become a Rep
  • Contact Us
  • Request a Catalog
  • Request a Quote
  • Videos
  • VirtualSiteProperties-schuremeddev.braveriversolutions.com ECOM.WebForms.BRS.CMS.VirtualSiteProperties
    PageManager_Cache_MiscContent System.Collections.Generic.Dictionary`2[System.String,System.String]
    VirtualCatalogInfo-schuremeddev.braveriversolutions.com
    Session Key Session Value
    SubmissionSource -
    SubmissionLandingPage /getproduct.aspx
    AdminLastSitePage /schure-loc-xps.html
    UserId b4a1ee8e-4234-4448-91b5-76162aaa1b8b
    IsDynamicallyGeneratedUserId True
    AdminLastPage /GetProduct.aspx?PageKey=%2fschure-loc-xps.html&unq=4/25/2024 8:58:25 AM
    OrderNumber
    Section Execution Time
    DBInterface.vb 5.3077668
    MasterPage.master 2.9354112
    DeveloperTools.ascx 0.0641294
    Load Time:3.7420155s  |  Database Hits: 24