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

SchureMed
Innovative Solutions in Advanced Surgical Positioning

Harloff

SchureMed is now distributing Harloff’s widest variety of medication and health care carts in the industry. They are pleased to be well recognized as providing the highest quality medical carts available. 

Designed from the ground up, this line offered many innovative features that have become industry standards, such as ball-bearing drawer slides and easily customizable configurations. They now offer a comprehensive array of crash carts, medication carts and other specialty carts for hospitals, nursing homes, clinics and surgery centers.

Harloff's Return Policy includes: 25% Restock Fee on all Non-Warranty or Miss-Shipment returns except for Narcotic Carts which have a 50% Restocking Fee. Returns need to be in its original packaging and returned within 30 days from ship date. Return shipping is paid by the customer.
×

Developer Tools

Database Activity Repeated Calls Shipping Rates Performance Tracking Cache Storage Session Storage
schuremeddev.braveriversolutions.com
0.1093771 seconds
# Seconds Since First Hit Trace Command Type Command Text Parameters Execution Time
1. 0 DBInterface.GetDataT show StoredProcedure [dbo].[VirtualCatalogLoadBySiteDomain] @SiteDomain=schuremeddev.braveriversolutions.com
0
2. 0 DBInterface.get_oSQL show StoredProcedure [dbo].[VirtualSitePropertiesLoadBySiteID] @SiteID=1
0
3. 0.0156314 DBInterface.GetDataT show Text SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName show - 0.0156314
4. 0.0156314 DBInterface.GetDataT show Text SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName show - 0
5. 0.0156314 DBInterface.GetDataT show Text SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Alert Bar show - 0
6. 0.0312763 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0156449
7. 0.0468853 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.015609
8. 0.0468853 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =9037d050-7af9-48be-a784-86ddca8a928e
0
9. 0.0468853 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/medical-carts-and-cabinets/default.aspx
@Type=CATEGORY
0
10. 0.0468853 DBInterface.get_oSQL show StoredProcedure [dbo].[CategoryLoadByPrimaryKey] @CategoryId=110
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
0
11. 0.0468853 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =9037d050-7af9-48be-a784-86ddca8a928e
0
12. 0.0468853 DBInterface.GetDataT show StoredProcedure [dbo].[CategoryListByParentKey] @CategoryID=110
@SiteID=1
@ShowHidden=False
0
13. 0.0781365 DBInterface.GetDataT show StoredProcedure BreadcrumbByPageUrlByUser @UserId=9037d050-7af9-48be-a784-86ddca8a928e
@SiteID=1
@PageURL=/medical-carts-and-cabinets/default.aspx
0.0156372
14. 0.0937574 DBInterface.GetDataT show StoredProcedure [dbo].[Cart_LoadByUserID] @UserID=9037d050-7af9-48be-a784-86ddca8a928e
@SiteID=1
0.0156209
Total DB Execution Time 0.0781434
Command Hits
SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName ELSE Category.MetaTitle END As PageTitle, Category.MetaDescription As PageMetaDesc, Category.MetaKeywords As PageMetaKwords, Category.CategoryName 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 Category ON PageURLs.EntityID = Category.CategoryID WHERE PageURLs.PageURL = '/medical-carts-and-cabinets/default.aspx' AND PageURLs.Type='category' 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].[DefaultSearchAttributeGetByUserID] 2
Cache Key Cache Value
VirtualCatalogInfo-schuremeddev.braveriversolutions.com
CategoryMenu_1
PageManager_Cache_PageLinks
LeftMenu
  • 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]
    TopMenu
  • About Us
  • Become a Rep
  • Contact Us
  • Request a Catalog
  • Request a Quote
  • Videos
  • Session Key Session Value
    SubmissionSource -
    SubmissionLandingPage /getcategory.aspx
    AdminLastSitePage /medical-carts-and-cabinets/default.aspx
    UserId 9037d050-7af9-48be-a784-86ddca8a928e
    IsDynamicallyGeneratedUserId True
    AdminLastPage /GetCategory.aspx?PageKey=%2fmedical-carts-and-cabinets%2fdefault.aspx&unq=12/2/2021 2:32:33 PM
    OrderNumber
    Section Execution Time
    DBInterface.vb 0
    MasterPage.master 0.0781365
    DeveloperTools.ascx 0
    Load Time:0.1093771s  |  Database Hits: 14