|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
1
|
(.generalselect) DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/Cart';
DECLARE @NodeAliasPath nvarchar(max) = N'/Cart';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/Cart' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)))
) AS SubData
ORDER BY CMS_P DESC @NodeSiteID (1) @DocumentUrlPath ("/Cart") @NodeAliasPath ("/Cart") @DocumentCulture ("en-US") 3.4 kB |
|
0.006
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
2
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] = N'/' AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC @NodeSiteID (1) @DocumentCulture ("en-US") 360 B |
|
0.003
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
3
|
(cms.pagetemplate.generalselect) DECLARE @PageTemplateID int = 25696;
SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID @PageTemplateID (25696) 117 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
CurrentShoppingCart
|
N/A
|
|
4
|
(om.membership.generalselect) DECLARE @RelatedID int = 65;
DECLARE @MemberType nvarchar = NULL;
SELECT [ContactID]
FROM OM_Membership
WHERE [RelatedID] = @RelatedID AND [MemberType] = @MemberType @RelatedID (65) @MemberType (CmsUser) 182 B |
|
0.000
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
5
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'general.back';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("general.back") @CultureCode ("en-US") 286 B |
|
0.006
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
6
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'general.next';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("general.next") @CultureCode ("en-US") 286 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
7
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'general.nodatafound';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("general.nodatafound") @CultureCode ("en-US") 300 B |
|
0.005
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
8
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'unigrid.filteredzerorowstext';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("unigrid.filteredzerorowstext") @CultureCode ("en-US") 318 B |
|
0.005
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
9
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'unigridpager.previouspage';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("unigridpager.previouspage") @CultureCode ("en-US") 312 B |
|
0.005
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
10
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'unigridpager.nextpage';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("unigridpager.nextpage") @CultureCode ("en-US") 304 B |
|
0.004
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
11
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'general.ok';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("general.ok") @CultureCode ("en-US") 282 B |
|
0.004
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
12
|
(cms.settingskey.generalselect) DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSStoreApplyTaxesBasedOn';
SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName @SiteID (1) @KeyName ("CMSStoreApplyTaxesBasedOn") 211 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
13
|
(cms.settingskey.generalselect) DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSStoreDefaultCountryName';
SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName @SiteID (1) @KeyName ("CMSStoreDefaultCountryName") 213 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
14
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'CMS.Country';
SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("CMS.Country") 154 B |
|
0.003
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
15
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'CMS.Country';
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("CMS.Country") 121 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
16
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1125) |
|
0.003
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
17
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1125) |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
18
|
(cms.country.generalselect) SELECT *
FROM cms_country |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
19
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'ecommerce.shoppingcartcontent.additem';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("ecommerce.shoppingcartcontent.additem") @CultureCode ("en-US") 336 B |
|
0.005
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
20
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'ecommerce.shoppingcartcontent.btnempty';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("ecommerce.shoppingcartcontent.btnempty") @CultureCode ("en-US") 338 B |
|
0.004
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
21
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'ecommerce.shoppingcartcontent.emptyconfirm';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("ecommerce.shoppingcartcontent.emptyconfirm") @CultureCode ("en-US") 346 B |
|
0.004
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
22
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'CMS.UIElement';
SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("CMS.UIElement") 158 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
23
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'CMS.UIElement';
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("CMS.UIElement") 125 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
24
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 2195) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
25
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 2195) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
26
|
(cms.uielement.generalselect) SELECT TOP 1 *
FROM CMS_UIElement
WHERE (ElementName = N'order.addorderitems' AND ElementResourceID = 111) |
|
0.004
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
27
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'general.remove';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("general.remove") @CultureCode ("en-US") 290 B |
|
0.005
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
28
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'ecommerce.shoppingcartcontent.actions';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("ecommerce.shoppingcartcontent.actions") @CultureCode ("en-US") 336 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
29
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'ecommerce.shoppingcartcontent.skuname';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("ecommerce.shoppingcartcontent.skuname") @CultureCode ("en-US") 336 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
30
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'ecommerce.shoppingcartcontent.unitdiscount';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("ecommerce.shoppingcartcontent.unitdiscount") @CultureCode ("en-US") 346 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
31
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'ecommerce.shoppingcartcontent.tax';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("ecommerce.shoppingcartcontent.tax") @CultureCode ("en-US") 328 B |
|
0.005
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
32
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'ecommerce.shoppingcartcontent.subtotal';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("ecommerce.shoppingcartcontent.subtotal") @CultureCode ("en-US") 338 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
33
|
DECLARE @cartId int = 0;
delete FROM dbo.COM_ShoppingCartSKU WHERE ShoppingCartID=@cartId AND skuid IN (SELECT SKUID FROM com_sku WHERE SKUInternalStatusID IN (SELECT InternalStatusID FROM dbo.COM_InternalStatus WHERE InternalStatusName='Bonus')) |
|
0.012
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
34
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'ecommerce.shoppingcartempty';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("ecommerce.shoppingcartempty") @CultureCode ("en-US") 316 B |
|
0.005
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
35
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'Ecommerce.MultiBuyDiscountSKU';
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("Ecommerce.MultiBuyDiscountSKU") 157 B |
|
0.003
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
36
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 4439) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
37
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'Ecommerce.MultiBuyDiscountSKU';
SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("Ecommerce.MultiBuyDiscountSKU") 190 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
38
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 4439) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
39
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'Ecommerce.MultiBuyDiscountDepartment';
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("Ecommerce.MultiBuyDiscountDepartment") 171 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
40
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 4454) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
41
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'Ecommerce.MultiBuyDiscountDepartment';
SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("Ecommerce.MultiBuyDiscountDepartment") 204 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
42
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 4454) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
43
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'Ecommerce.MultiBuyDiscount';
SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("Ecommerce.MultiBuyDiscount") 184 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
44
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'Ecommerce.MultiBuyDiscount';
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("Ecommerce.MultiBuyDiscount") 151 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
45
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 4426) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
46
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 4426) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
47
|
(ecommerce.multibuydiscount.generalselect) DECLARE @MultiBuyDiscountSiteID int = 1;
DECLARE @MultiBuyDiscountEnabled bit = 1;
DECLARE @MultiBuyDiscountValidFrom datetime2 = '1/23/2022 7:49:00 AM';
DECLARE @MultiBuyDiscountValidTo datetime2 = '1/23/2022 7:49:00 AM';
DECLARE @MultiBuyDiscountCustomerRestriction nvarchar(max) = N'All';
DECLARE @MultiBuyDiscountUsesCoupons bit = 0;
SELECT *
FROM COM_MultiBuyDiscount
WHERE [MultiBuyDiscountSiteID] = @MultiBuyDiscountSiteID AND [MultiBuyDiscountEnabled] = @MultiBuyDiscountEnabled AND ([MultiBuyDiscountValidFrom] < @MultiBuyDiscountValidFrom OR [MultiBuyDiscountValidFrom] IS NULL) AND ([MultiBuyDiscountValidTo] > @MultiBuyDiscountValidTo OR [MultiBuyDiscountValidTo] IS NULL) AND [MultiBuyDiscountCustomerRestriction] = @MultiBuyDiscountCustomerRestriction AND [MultiBuyDiscountUsesCoupons] = @MultiBuyDiscountUsesCoupons AND ([MultiBuyDiscountID] IN (
SELECT [MultiBuyDiscountID]
FROM COM_MultiBuyDiscountSKU
WHERE 0 = 1
) OR [MultiBuyDiscountID] IN (
SELECT [MultiBuyDiscountID]
FROM COM_MultiBuyDiscountDepartment
WHERE 0 = 1
))
ORDER BY MultiBuyDiscountPriority @MultiBuyDiscountSiteID (1) @MultiBuyDiscountEnabled (True) @MultiBuyDiscountValidFrom (1/23/2022 7:49:00 AM) @MultiBuyDiscountValidTo (1/23/2022 7:49:00 AM) @MultiBuyDiscountCustomerRestriction ("All") @MultiBuyDiscountUsesCoupons (False) 1.1 kB |
|
0.003
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
48
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'Ecommerce.ShippingOption';
SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("Ecommerce.ShippingOption") 180 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
49
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'Ecommerce.ShippingOption';
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("Ecommerce.ShippingOption") 147 B |
|
0.003
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
50
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1150) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
51
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1150) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
52
|
(.generalselect) DECLARE @ShippingOptionSiteID int = 1;
DECLARE @ShippingOptionEnabled bit = 1;
SELECT (COUNT(*)) AS [Count]
FROM (
SELECT TOP 2 [ShippingOptionID]
FROM COM_ShippingOption
WHERE [ShippingOptionSiteID] = @ShippingOptionSiteID AND [ShippingOptionEnabled] = @ShippingOptionEnabled
) AS SubData @ShippingOptionSiteID (1) @ShippingOptionEnabled (True) 303 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
53
|
(cms.settingskey.generalselect) DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSStoreAllowGlobalPaymentMethods';
SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName @SiteID (1) @KeyName ("CMSStoreAllowGlobalPaymentMethods") 227 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
54
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'ECommerce.PaymentOption';
SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("ECommerce.PaymentOption") 178 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
55
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'ECommerce.PaymentOption';
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("ECommerce.PaymentOption") 145 B |
|
0.003
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
56
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1144) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
57
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1144) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
58
|
(.generalselect) DECLARE @PaymentOptionSiteID int = 1;
DECLARE @PaymentOptionEnabled bit = 1;
SELECT (COUNT(*)) AS [Count]
FROM (
SELECT TOP 2 [PaymentOptionID]
FROM COM_PaymentOption
WHERE ([PaymentOptionSiteID] = @PaymentOptionSiteID OR [PaymentOptionSiteID] IS NULL) AND [PaymentOptionEnabled] = @PaymentOptionEnabled
) AS SubData @PaymentOptionSiteID (1) @PaymentOptionEnabled (True) 330 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
59
|
(ecommerce.paymentoption.generalselect) DECLARE @PaymentOptionSiteID int = 1;
DECLARE @PaymentOptionEnabled bit = 1;
SELECT *
FROM COM_PaymentOption
WHERE ([PaymentOptionSiteID] = @PaymentOptionSiteID OR [PaymentOptionSiteID] IS NULL) AND [PaymentOptionEnabled] = @PaymentOptionEnabled @PaymentOptionSiteID (1) @PaymentOptionEnabled (True) 256 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
60
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'ECommerce.Discount';
SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("ECommerce.Discount") 168 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
61
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'ECommerce.Discount';
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("ECommerce.Discount") 135 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
62
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 3690) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
63
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 3690) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
64
|
(ecommerce.discount.generalselect) DECLARE @DiscountSiteID int = 1;
DECLARE @DiscountEnabled bit = 1;
DECLARE @DiscountValidFrom datetime2 = '1/23/2022 7:49:00 AM';
DECLARE @DiscountValidTo datetime2 = '1/23/2022 7:49:00 AM';
DECLARE @DiscountCustomerRestriction nvarchar(max) = N'All';
DECLARE @DiscountUsesCoupons bit = 0;
SELECT *
FROM COM_Discount
WHERE [DiscountSiteID] = @DiscountSiteID AND [DiscountEnabled] = @DiscountEnabled AND ([DiscountValidFrom] < @DiscountValidFrom OR [DiscountValidFrom] IS NULL) AND ([DiscountValidTo] > @DiscountValidTo OR [DiscountValidTo] IS NULL) AND [DiscountCustomerRestriction] = @DiscountCustomerRestriction AND [DiscountUsesCoupons] = @DiscountUsesCoupons
ORDER BY DiscountOrder @DiscountSiteID (1) @DiscountEnabled (True) @DiscountValidFrom (1/23/2022 7:49:00 AM) @DiscountValidTo (1/23/2022 7:49:00 AM) @DiscountCustomerRestriction ("All") @DiscountUsesCoupons (False) 721 B |
|
0.003
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
65
|
(cms.user.generalselect) DECLARE @UserID int = 65;
SELECT *
FROM CMS_User
WHERE [UserID] = @UserID |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
66
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'CMS.UserSettings';
SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("CMS.UserSettings") 164 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
67
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'CMS.UserSettings';
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName @ClassName ("CMS.UserSettings") 131 B |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
68
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1768) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
69
|
(cms.query.generalselect) SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1768) |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
70
|
(cms.usersettings.generalselect) DECLARE @UserSettingsUserID int = 65;
SELECT *
FROM CMS_UserSettings
WHERE [UserSettingsUserID] = @UserSettingsUserID @UserSettingsUserID (65) 126 B |
|
0.003
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
71
|
SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_UserSettings');
|
|
0.023
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
72
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'currencyselector.general.SelectedItems';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("currencyselector.general.SelectedItems") @CultureCode ("en-US") 338 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
73
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'general.SelectedItems';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("general.SelectedItems") @CultureCode ("en-US") 304 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
74
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'currencyselector.general.AllItems';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("currencyselector.general.AllItems") @CultureCode ("en-US") 328 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
75
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'general.AllItems';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("general.AllItems") @CultureCode ("en-US") 294 B |
|
0.005
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
76
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'currencyselector.general.SelectAction';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("currencyselector.general.SelectAction") @CultureCode ("en-US") 336 B |
|
0.001
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
77
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'general.SelectAction';
DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("general.SelectAction") @CultureCode ("en-US") 302 B |
|
0.005
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
78
|
(ecommerce.currency.generalselect) SELECT TOP 51 [CurrencyDisplayName], [CurrencyID], [CurrencyEnabled]
FROM COM_Currency
WHERE ([CurrencySiteID] IS NULL AND [CurrencyEnabled] = 1)
ORDER BY CurrencyDisplayName |
|
0.002
|
|
|
|
|
N/A
|
|
|
|
|
N/A
|
|
79
|
(ecommerce.currency.generalselect) SELECT *
FROM COM_Currency
WHERE [CurrencySiteID] IS NULL |
|
0.001
|
|
|
|
|
N/A
|