Carmine's 30 Years
Carmine's Trip Advisor

Carmine's Italian Restaurant

Store

Your Cart


Your shopping cart is empty.
Legal Privacy Site Map © 2022 Carmine's Broadway Feast, Inc.
Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> WebFarmSyncHandlers.StartWebFarmThreads
> URLRewritingHandlers.BeginRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData
7 >>> TypeInfo(cms.document).Events.GetData
8 >> TypeInfo(cms.pagetemplate).Events.GetData
9 >> URLRewritingEvents.ProcessRewritingResult
10 RequestEvents.PostMapRequestHandler.Execute
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.SetCampaign
> URLRewritingHandlers.PostMapRequestHandler
11 ApplicationEvents.SessionStart.Execute
> MembershipHandlers.SessionStart
12 RequestEvents.AcquireRequestState.Execute
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
13 RequestEvents.PostAcquireRequestState.Execute
> MembershipHandlers.UpdateSession
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsServiceScriptsRenderer.b__0
14 TypeInfo(om.membershipuser).Events.GetData CurrentShoppingCart
15 TypeInfo(cms.resourcestring).Events.GetData
16 TypeInfo(cms.resourcestring).Events.GetData
17 TypeInfo(cms.resourcestring).Events.GetData
18 TypeInfo(cms.resourcestring).Events.GetData
19 TypeInfo(cms.resourcestring).Events.GetData
20 TypeInfo(cms.resourcestring).Events.GetData
21 TypeInfo(cms.resourcestring).Events.GetData
22 TypeInfo(cms.settingskey).Events.GetData
23 TypeInfo(cms.settingskey).Events.GetData
24 TypeInfo(cms.country).Events.GetData
25 TypeInfo(cms.class).Events.GetData
26 TypeInfo(cms.class).Events.GetData
27 TypeInfo(cms.query).Events.GetData
28 TypeInfo(cms.query).Events.GetData
29 TypeInfo(cms.resourcestring).Events.GetData
30 TypeInfo(cms.resourcestring).Events.GetData
31 TypeInfo(cms.resourcestring).Events.GetData
32 TypeInfo(cms.uielement).Events.GetData
33 TypeInfo(cms.class).Events.GetData
34 TypeInfo(cms.class).Events.GetData
35 TypeInfo(cms.query).Events.GetData
36 TypeInfo(cms.query).Events.GetData
37 TypeInfo(cms.resourcestring).Events.GetData
38 TypeInfo(cms.resourcestring).Events.GetData
39 TypeInfo(cms.resourcestring).Events.GetData
40 TypeInfo(cms.resourcestring).Events.GetData
41 TypeInfo(cms.resourcestring).Events.GetData
42 TypeInfo(cms.resourcestring).Events.GetData
43 TypeInfo(cms.resourcestring).Events.GetData
44 TypeInfo(cms.class).Events.GetData
45 TypeInfo(cms.query).Events.GetData
46 TypeInfo(cms.class).Events.GetData
47 TypeInfo(cms.query).Events.GetData
48 TypeInfo(cms.class).Events.GetData
49 TypeInfo(cms.query).Events.GetData
50 TypeInfo(cms.class).Events.GetData
51 TypeInfo(cms.query).Events.GetData
52 TypeInfo(ecommerce.multibuydiscount).Events.GetData
53 TypeInfo(cms.class).Events.GetData
54 TypeInfo(cms.class).Events.GetData
55 TypeInfo(cms.query).Events.GetData
56 TypeInfo(cms.query).Events.GetData
57 TypeInfo(cms.class).Events.GetData
58 TypeInfo(cms.class).Events.GetData
59 TypeInfo(cms.query).Events.GetData
60 TypeInfo(cms.query).Events.GetData
61 TypeInfo(cms.settingskey).Events.GetData
62 TypeInfo(cms.class).Events.GetData
63 TypeInfo(cms.class).Events.GetData
64 TypeInfo(cms.query).Events.GetData
65 TypeInfo(cms.query).Events.GetData
66 TypeInfo(ecommerce.paymentoption).Events.GetData
67 TypeInfo(ecommerce.discount).Events.GetData
68 TypeInfo(cms.class).Events.GetData
69 TypeInfo(cms.class).Events.GetData
70 TypeInfo(cms.query).Events.GetData
71 TypeInfo(cms.query).Events.GetData
72 TypeInfo(cms.user).Events.GetData
73 TypeInfo(cms.usersettings).Events.GetData
74 TypeInfo(cms.class).Events.GetData
75 TypeInfo(cms.class).Events.GetData
76 TypeInfo(cms.query).Events.GetData
77 TypeInfo(cms.query).Events.GetData
78 TypeInfo(cms.resourcestring).Events.GetData
79 TypeInfo(cms.resourcestring).Events.GetData
80 TypeInfo(cms.resourcestring).Events.GetData
81 TypeInfo(cms.resourcestring).Events.GetData
82 TypeInfo(cms.resourcestring).Events.GetData
83 TypeInfo(cms.resourcestring).Events.GetData
84 TypeInfo(ecommerce.currency).Events.GetData
85 TypeInfo(ecommerce.currency).Events.GetData
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_PortalEngine/WebpartProperties/plus.png Local
2 EXISTS
~/App_Themes/Default/Images/Images.zip Local
3 READ
2 B (2)
 
~/App_Themes/Default/Images/Images.zip Local
4 CLOSE
~/App_Themes/Default/Images/Images.zip Local
5 CLOSE
~/App_Themes/Default/Images/Images.zip Local
6 CLOSE
~/App_Themes/Default/Images/Images.zip Local
7 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_PortalEngine/WebpartProperties/plus.png Zip
8 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_PortalEngine/WebpartProperties/minus.png Local
9 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_PortalEngine/WebpartProperties/minus.png Zip
10 DIREXISTS
~/content/img/favicon.ico Local
11 EXISTS
~/App_Themes/Design/Debug.css Local
12 EXISTS
~/App_Themes/Design/Debug.css Local
13 EXISTS
~/App_Themes/Design/Debug.css Local
14 EXISTS
~/App_Themes/Design/Debug.css Local
     
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|carmines|/cart|en-us|/cart|true
template|25696
nodeid|6
2 ADD pageinfobyurl|carmines|http://carmines.securetree.com/cart|en-us||true|true
template|25696
nodeid|6
3 ADD currentshoppingcart|41c593a9-ce83-4864-8624-4a7f6986e451
ecommerce.shoppingcart|byid|0
CurrentShoppingCart
4 GET customdatasource|listnmpromos
5 GET customdatasource|listnmpromos
6 GET customdatasource|listnmpromos
7 GET scriptfile|dialogs/modaldialog.js
8 ADD currencyinfoprovider|currenciesbycodeforsite|1
ecommerce.currency|all
9 GET currencyinfoprovider|currenciesbycodeforsite|1
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /Cart/ 0.000
0.012
 
2 PathRewritten ~/CMSTemplates/Main/Cart.aspx 0.012
0.016
 
3 > OnPreInit 0.028
0.010
 
4 > OnInit 0.038
0.000
 
5 > OnLoad 0.038
0.602
 
6 > OnPreRender 0.640
N/A
    0.640  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookiepWS7sSvo4TKTy5x8r38WBoXW3RrrnNGRWJ3fC5EU
3 ASP.NET_SessionIdcejnggxgrjphreqmow2l205j
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US1/23/2023 7:49:00 AM
2 CMSCsrfCookiepWS7sSvo4TKTy5x8r38WBoXW3RrrnNGRWJ3fC5EU 
3 ASP.NET_SessionIdcejnggxgrjphreqmow2l205j 
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress172.30.101.55
5 UserLanguagesen-US;en;q=0.5
6 UserName 
7 SessionIDcejnggxgrjphreqmow2l205j
8 ServerNameGCWEB6
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
N/A
OpenConnection()
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
 
Table (1 [65], 343 B)
 
0.006
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [161], 791 B)
 
0.003
 
CloseConnection()
N/A
OpenConnection()
N/A
3
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25696;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (25696)
117 B
 
Table (1 [33], 201 B)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [2], 2.3 kB)
 
0.003
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [55], 7.5 kB)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
16
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1125)
0.003
 
CloseConnection()
N/A
OpenConnection()
N/A
17
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1125)
0.001
 
CloseConnection()
N/A
OpenConnection()
N/A
18
(cms.country.generalselect)
SELECT *
FROM cms_country
Table (247 [7], 17.6 kB)
 
0.001
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [2], 6.1 kB)
 
0.001
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [55], 26 kB)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
24
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 2195)
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
25
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 2195)
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
26
(cms.uielement.generalselect)
SELECT TOP 1 *
FROM CMS_UIElement
WHERE (ElementName = N'order.addorderitems' AND ElementResourceID = 111)
Table (1 [28], 298 B)
 
0.004
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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'))
@cartId (0)
253 B
 
0
 
0.012
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [55], 1.8 kB)
 
0.003
 
CloseConnection()
N/A
OpenConnection()
N/A
36
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 4439)
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [2], 968 B)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
38
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 4439)
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [55], 2.2 kB)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
40
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 4454)
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [2], 1003 B)
 
0.001
 
CloseConnection()
N/A
OpenConnection()
N/A
42
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 4454)
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [2], 3.8 kB)
 
0.001
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [55], 11.5 kB)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
45
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 4426)
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
46
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 4426)
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [2], 2.8 kB)
 
0.001
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [55], 9.5 kB)
 
0.003
 
CloseConnection()
N/A
OpenConnection()
N/A
50
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1150)
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
51
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1150)
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [1], 4 B)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [2], 3.6 kB)
 
0.001
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [55], 13.4 kB)
 
0.003
 
CloseConnection()
N/A
OpenConnection()
N/A
56
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1144)
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
57
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1144)
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [1], 4 B)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [15], 99 B)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [2], 4.2 kB)
 
0.001
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [55], 19.5 kB)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
62
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 3690)
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
63
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 3690)
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
N/A
65
(cms.user.generalselect)
DECLARE @UserID int = 65;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (65)
82 B
 
Table (1 [29], 133 B)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [2], 10.8 kB)
 
0.001
 
CloseConnection()
N/A
OpenConnection()
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
 
Table (1 [55], 27 kB)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
68
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1768)
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
69
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1768)
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
70
(cms.usersettings.generalselect)
DECLARE @UserSettingsUserID int = 65;

SELECT *
FROM CMS_UserSettings
WHERE [UserSettingsUserID] = @UserSettingsUserID
@UserSettingsUserID (65)
126 B
 
Table (1 [49], 206 B)
 
0.003
 
CloseConnection()
N/A
OpenConnection()
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');
Table (1 [1], 14 B)
 
0.023
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
 
CloseConnection()
N/A
OpenConnection()
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
Table (1 [3], 16 B)
 
0.002
 
CloseConnection()
N/A
OpenConnection()
N/A
79
(ecommerce.currency.generalselect)
SELECT *
FROM COM_Currency
WHERE [CurrencySiteID] IS NULL
Table (1 [11], 88 B)
 
0.001
 
CloseConnection()
N/A
  79 queries, 19.9 kB write, 174 kB read   0.220
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% (documentpagetitle=="") ? pagetitle_orelse_name + " | Carmine's": documentpagetitle %} Cart | Carmine's 0.000
> (documentpagetitle=="") ? pagetitle_orelse_name + " | Carmine's": documentpagetitle Cart | Carmine's 0.000
2 {% CurrencyDisplayName %} U.S. Dollar 0.000
> CurrencyDisplayName U.S. Dollar 0.000
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 Head1
litAnalytics
No
Text = "
<script>
var analyticsConfig = {};
</script>
" (70 B)
70 B
 
2 Head1
N/A
No
No
name = "viewport" (8 B)
content = "width=device-width, initial-scale=1" (35 B)
43 B
 
3 Head1
N/A
No
No
No
rel = "icon" (4 B)
type = "image/png" (9 B)
href = "/content/img/favicon.ico" (24 B)
37 B
 
4 Head1
N/A
No
No
rel = "stylesheet" (10 B)
href = "//cdnjs.cloudflare.com/ajax/libs/pickadate.js/3.6.2/themes/default.css" (70 B)
80 B
 
5 Head1
N/A
No
No
rel = "stylesheet" (10 B)
href = "//cdnjs.cloudflare.com/ajax/libs/pickadate.js/3.6.2/themes/default.date.css" (75 B)
85 B
 
6 Head1
N/A
No
No
rel = "stylesheet" (10 B)
href = "//cdnjs.cloudflare.com/ajax/libs/pickadate.js/3.6.2/themes/default.time.css" (75 B)
85 B
 
7 Head1
N/A
No
No
rel = "stylesheet" (10 B)
href = "https://use.typekit.net/rif1pui.css" (35 B)
45 B
 
8 Head1
N/A
No
No
href = "https://fonts.googleapis.com/css?family=Arvo:400,700|Nunito+Sans:400,700&display=swap" (85 B)
rel = "stylesheet" (10 B)
95 B
 
9 Head1
N/A
No
No
No
No
rel = "stylesheet" (10 B)
href = "https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" (69 B)
integrity = "sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" (71 B)
crossorigin = "anonymous" (9 B)
159 B
 
10 Head1
N/A
No
No
rel = "stylesheet" (10 B)
href = "/Content/css/nmCore.css?v=17" (28 B)
38 B
 
11 form1 Yes
action = "/Cart/" (6 B)
6 B
 
12 Header
N/A
No
No
data-logout = "1" (1 B)
style = "display:none" (12 B)
13 B
 
13 Header
N/A
No
No
data-logout = "1" (1 B)
style = "display:none" (12 B)
13 B
 
14 ContentPlaceHolder1
cartElem
pnlShoppingCart
No
CssClass = "CartStepWrap" (12 B)
12 B
 
15 cartElem
pnlShoppingCart
plcCartStep
No
CssClass = "CartStepPanel" (13 B)
13 B
 
16 plcCartStep
CheckoutNav
hCheckoutStep
No
Value = "ShoppingCartContent" (19 B)
19 B
 
17 pnlShoppingCart
plcCartStep
pnlCartStepInner
No
CssClass = "CartStepInnerPanel" (18 B)
18 B
 
18 pnlCartStepInner
wzdStep0
pnlCartContent
No
CssClass = "CartStepInnerPanelContent" (25 B)
25 B
 
19 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes