| Duration |
SQL |
| 338ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
| 300ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
| 288ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__code_1='?' (Size = 25...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__code_1='?' (Size = 255)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[ID]
FROM [Content].[Page] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[Code] = @__code_1
ORDER BY [p].[Name], [p].[SortOrder]
|
| 247ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
| 232ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
| 190ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Communication].[PushNotification] AS [p]
LEFT JOIN [Communication].[PushNotificationTemplate] AS [p0] ON [p].[PushNotificationTemplateID] = [p0].[ID]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1 AND [p0].[Code] = N'NotLoggedIn' AND [p].[SendDesktopPushNotification] = CAST(1 AS bit)
|
| 184ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbT...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[URL]
FROM [Content].[Page] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[ID] = @__request_ID_1
ORDER BY [p].[Name], [p].[SortOrder]
|
| 152ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
| 119ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
| 97ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
| 95ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
| 88ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbT...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[URL]
FROM [Content].[Page] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[ID] = @__request_ID_1
ORDER BY [p].[Name], [p].[SortOrder]
|
| 69ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
| 63ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_Data_ID_1='?'...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_Data_ID_1='?' (DbType = Int64), @__ActiveStatusID_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[Description], [t0].[ID], [t2].[ID], [t4].[Title], [t4].[Code], [t4].[URL], [t4].[ID], [t5].[PackageID], [t5].[StandardPackagePriceWithInvoice], [t5].[AdvantagePackagePriceWithInvoice], [t5].[AdvantagePackagePriceWithCreditCard], [t5].[PackageGift], [t5].[ID], [t0].[Title], [t0].[SubTitle], [t0].[Description], [t0].[ImagePath], [t0].[c], [t2].[Title], [t2].[Description], [t6].[ID], [w0].[Description], [w0].[IconPath], [w0].[Title], [w0].[ID], [t2].[c], [t6].[ImagePath], [t6].[LogoPath], [t6].[c]
FROM (
SELECT TOP(1) [a].[ID], [a].[Description], [a].[StatusID]
FROM [Content].[Advantage] AS [a]
WHERE [a].[StatusID] <> @__DeletedStatusID_0 AND [a].[ID] = @__request_Data_ID_1
ORDER BY [a].[StatusID] DESC, [a].[ID] DESC
) AS [t]
LEFT JOIN (
SELECT [t1].[Title], [t1].[SubTitle], [t1].[Description], [t1].[ImagePath], [t1].[c], [t1].[ID], [t1].[AdvantageID]
FROM (
SELECT [h].[Title], [h].[SubTitle], [h].[Description], [h].[ImagePath], 1 AS [c], [h].[ID], [h].[AdvantageID], ROW_NUMBER() OVER(PARTITION BY [h].[AdvantageID] ORDER BY [h].[ID]) AS [row]
FROM [Content].[Headline] AS [h]
) AS [t1]
WHERE [t1].[row] <= 1
) AS [t0] ON [t].[ID] = [t0].[AdvantageID]
LEFT JOIN (
SELECT [t3].[Title], [t3].[Description], [t3].[c], [t3].[ID], [t3].[AdvantageID]
FROM (
SELECT [w].[Title], [w].[Description], 1 AS [c], [w].[ID], [w].[AdvantageID], ROW_NUMBER() OVER(PARTITION BY [w].[AdvantageID] ORDER BY [w].[ID]) AS [row]
FROM [Content].[Widget] AS [w]
) AS [t3]
WHERE [t3].[row] <= 1
) AS [t2] ON [t].[ID] = [t2].[AdvantageID]
LEFT JOIN (
SELECT [b].[Title], [b].[Code], [b].[URL], [b].[ID], [b].[AdvantageID]
FROM [Content].[Button] AS [b]
WHERE [b].[StatusID] = @__ActiveStatusID_2
) AS [t4] ON [t].[ID] = [t4].[AdvantageID]
LEFT JOIN (
SELECT [a0].[PackageID], [a0].[StandardPackagePriceWithInvoice], [a0].[AdvantagePackagePriceWithInvoice], [a0].[AdvantagePackagePriceWithCreditCard], [a0].[PackageGift], [a0].[ID], [a0].[AdvantageID]
FROM [Content].[AdvantagePackage] AS [a0]
WHERE [a0].[StatusID] = @__ActiveStatusID_2
) AS [t5] ON [t].[ID] = [t5].[AdvantageID]
LEFT JOIN (
SELECT [t7].[ImagePath], [t7].[LogoPath], [t7].[c], [t7].[ID], [t7].[HeadlineID]
FROM (
SELECT [h0].[ImagePath], [h0].[LogoPath], 1 AS [c], [h0].[ID], [h0].[HeadlineID], ROW_NUMBER() OVER(PARTITION BY [h0].[HeadlineID] ORDER BY [h0].[ID]) AS [row]
FROM [Content].[HeadlineItem] AS [h0]
) AS [t7]
WHERE [t7].[row] <= 1
) AS [t6] ON [t0].[ID] = [t6].[HeadlineID]
LEFT JOIN [Content].[WidgetContent] AS [w0] ON [t2].[ID] = [w0].[WidgetID]
ORDER BY [t].[StatusID] DESC, [t].[ID] DESC, [t0].[ID], [t2].[ID], [t4].[ID], [t5].[ID], [t6].[ID]
|
| 61ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbT...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[URL]
FROM [Content].[Page] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[ID] = @__request_ID_1
ORDER BY [p].[Name], [p].[SortOrder]
|
| 36ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
| 34ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
| 15ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Communication].[PushNotification] AS [p]
LEFT JOIN [Communication].[PushNotificationTemplate] AS [p0] ON [p].[PushNotificationTemplateID] = [p0].[ID]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1 AND [p0].[Code] = N'NotLoggedIn' AND [p].[SendDesktopPushNotification] = CAST(1 AS bit)
|
| 11ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[DataValue], [t].[DateCreated], [t].[DateModified], [t].[EmailBody], [t].[EmailSubject], [t].[EntityID], [t].[EntityType], [t].[LanguageID], [t].[MobilePushNotificationText], [t].[MobilePushNotificationTitle], [t].[MobilePushNotificationType], [t].[PushNotificationTemplateID], [t].[SMSText], [t].[SendDesktopPushNotification], [t].[SendEmail], [t].[SendMobilePushNotification], [t].[SendSMS], [t].[StatusID], [t].[SubEntityID], [t].[SubEntityType], [t].[UserCreatedID], [t].[UserModifiedID], [t].[WebPushNotificationURL], [l].[ID], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated], [l].[DateModified], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID], [l].[UserCreatedID], [l].[UserModifiedID], [t].[ID0], [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[EmailBody], [p1].[EmailSubject], [p1].[LanguageID], [p1].[MobilePushNotificationText], [p1].[MobilePushNotificationTitle], [p1].[PushNotificationID], [p1].[SMSText], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID], [t].[Code], [t].[DateCreated0], [t].[DateModified0], [t].[EmailBody0], [t].[EmailSubject0], [t].[MobilePushNotificationText0], [t].[MobilePushNotificationTitle0], [t].[MobilePushNotificationType0], [t].[SMSText0], [t].[SendEmail0], [t].[SendSMS0], [t].[SendToDesktopPushNotification], [t].[SendToMobilePushNotification], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t].[WebPushNotificationURL0], [p2].[ID], [p2].[DateCreated], [p2].[DateModified], [p2].[EmailBody], [p2].[EmailSubject], [p2].[LanguageID], [p2].[MobilePushNotificationText], [p2].[MobilePushNotificationTitle], [p2].[MobilePushNotificationType], [p2].[PushNotificationTemplateID], [p2].[SMSText], [p2].[StatusID], [p2].[UserCreatedID], [p2].[UserModifiedID]
FROM (
SELECT [p].[ID], [p].[DataValue], [p].[DateCreated], [p].[DateModified], [p].[EmailBody], [p].[EmailSubject], [p].[EntityID], [p].[EntityType], [p].[LanguageID], [p].[MobilePushNotificationText], [p].[MobilePushNotificationTitle], [p].[MobilePushNotificationType], [p].[PushNotificationTemplateID], [p].[SMSText], [p].[SendDesktopPushNotification], [p].[SendEmail], [p].[SendMobilePushNotification], [p].[SendSMS], [p].[StatusID], [p].[SubEntityID], [p].[SubEntityType], [p].[UserCreatedID], [p].[UserModifiedID], [p].[WebPushNotificationURL], [p0].[ID] AS [ID0], [p0].[Code], [p0].[DateCreated] AS [DateCreated0], [p0].[DateModified] AS [DateModified0], [p0].[EmailBody] AS [EmailBody0], [p0].[EmailSubject] AS [EmailSubject0], [p0].[MobilePushNotificationText] AS [MobilePushNotificationText0], [p0].[MobilePushNotificationTitle] AS [MobilePushNotificationTitle0], [p0].[MobilePushNotificationType] AS [MobilePushNotificationType0], [p0].[SMSText] AS [SMSText0], [p0].[SendEmail] AS [SendEmail0], [p0].[SendSMS] AS [SendSMS0], [p0].[SendToDesktopPushNotification], [p0].[SendToMobilePushNotification], [p0].[StatusID] AS [StatusID0], [p0].[UserCreatedID] AS [UserCreatedID0], [p0].[UserModifiedID] AS [UserModifiedID0], [p0].[WebPushNotificationURL] AS [WebPushNotificationURL0]
FROM [Communication].[PushNotification] AS [p]
LEFT JOIN [Communication].[PushNotificationTemplate] AS [p0] ON [p].[PushNotificationTemplateID] = [p0].[ID]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1 AND [p0].[Code] = N'NotLoggedIn' AND [p].[SendDesktopPushNotification] = CAST(1 AS bit)
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
INNER JOIN [Definition].[Language] AS [l] ON [t].[LanguageID] = [l].[ID]
LEFT JOIN [Communication].[PushNotification_i18n] AS [p1] ON [t].[ID] = [p1].[PushNotificationID]
LEFT JOIN [Communication].[PushNotificationTemplate_i18n] AS [p2] ON [t].[ID0] = [p2].[PushNotificationTemplateID]
ORDER BY [t].[ID] DESC, [t].[ID0], [l].[ID], [p1].[ID]
|
| 9ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[DataValue], [t].[DateCreated], [t].[DateModified], [t].[EmailBody], [t].[EmailSubject], [t].[EntityID], [t].[EntityType], [t].[LanguageID], [t].[MobilePushNotificationText], [t].[MobilePushNotificationTitle], [t].[MobilePushNotificationType], [t].[PushNotificationTemplateID], [t].[SMSText], [t].[SendDesktopPushNotification], [t].[SendEmail], [t].[SendMobilePushNotification], [t].[SendSMS], [t].[StatusID], [t].[SubEntityID], [t].[SubEntityType], [t].[UserCreatedID], [t].[UserModifiedID], [t].[WebPushNotificationURL], [l].[ID], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated], [l].[DateModified], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID], [l].[UserCreatedID], [l].[UserModifiedID], [t].[ID0], [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[EmailBody], [p1].[EmailSubject], [p1].[LanguageID], [p1].[MobilePushNotificationText], [p1].[MobilePushNotificationTitle], [p1].[PushNotificationID], [p1].[SMSText], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID], [t].[Code], [t].[DateCreated0], [t].[DateModified0], [t].[EmailBody0], [t].[EmailSubject0], [t].[MobilePushNotificationText0], [t].[MobilePushNotificationTitle0], [t].[MobilePushNotificationType0], [t].[SMSText0], [t].[SendEmail0], [t].[SendSMS0], [t].[SendToDesktopPushNotification], [t].[SendToMobilePushNotification], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t].[WebPushNotificationURL0], [p2].[ID], [p2].[DateCreated], [p2].[DateModified], [p2].[EmailBody], [p2].[EmailSubject], [p2].[LanguageID], [p2].[MobilePushNotificationText], [p2].[MobilePushNotificationTitle], [p2].[MobilePushNotificationType], [p2].[PushNotificationTemplateID], [p2].[SMSText], [p2].[StatusID], [p2].[UserCreatedID], [p2].[UserModifiedID]
FROM (
SELECT [p].[ID], [p].[DataValue], [p].[DateCreated], [p].[DateModified], [p].[EmailBody], [p].[EmailSubject], [p].[EntityID], [p].[EntityType], [p].[LanguageID], [p].[MobilePushNotificationText], [p].[MobilePushNotificationTitle], [p].[MobilePushNotificationType], [p].[PushNotificationTemplateID], [p].[SMSText], [p].[SendDesktopPushNotification], [p].[SendEmail], [p].[SendMobilePushNotification], [p].[SendSMS], [p].[StatusID], [p].[SubEntityID], [p].[SubEntityType], [p].[UserCreatedID], [p].[UserModifiedID], [p].[WebPushNotificationURL], [p0].[ID] AS [ID0], [p0].[Code], [p0].[DateCreated] AS [DateCreated0], [p0].[DateModified] AS [DateModified0], [p0].[EmailBody] AS [EmailBody0], [p0].[EmailSubject] AS [EmailSubject0], [p0].[MobilePushNotificationText] AS [MobilePushNotificationText0], [p0].[MobilePushNotificationTitle] AS [MobilePushNotificationTitle0], [p0].[MobilePushNotificationType] AS [MobilePushNotificationType0], [p0].[SMSText] AS [SMSText0], [p0].[SendEmail] AS [SendEmail0], [p0].[SendSMS] AS [SendSMS0], [p0].[SendToDesktopPushNotification], [p0].[SendToMobilePushNotification], [p0].[StatusID] AS [StatusID0], [p0].[UserCreatedID] AS [UserCreatedID0], [p0].[UserModifiedID] AS [UserModifiedID0], [p0].[WebPushNotificationURL] AS [WebPushNotificationURL0]
FROM [Communication].[PushNotification] AS [p]
LEFT JOIN [Communication].[PushNotificationTemplate] AS [p0] ON [p].[PushNotificationTemplateID] = [p0].[ID]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1 AND [p0].[Code] = N'NotLoggedIn' AND [p].[SendDesktopPushNotification] = CAST(1 AS bit)
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
INNER JOIN [Definition].[Language] AS [l] ON [t].[LanguageID] = [l].[ID]
LEFT JOIN [Communication].[PushNotification_i18n] AS [p1] ON [t].[ID] = [p1].[PushNotificationID]
LEFT JOIN [Communication].[PushNotificationTemplate_i18n] AS [p2] ON [t].[ID0] = [p2].[PushNotificationTemplateID]
ORDER BY [t].[ID] DESC, [t].[ID0], [l].[ID], [p1].[ID]
|
| 9ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
