| Duration |
SQL |
| 265ms |
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]
|
| 244ms |
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]
|
| 228ms |
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]
|
| 169ms |
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
|
| 146ms |
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]
|
| 123ms |
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)
|
| 101ms |
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 [p].[PackageTypeID], [t].[InstallmentPriceOnCreditCard], [t].[CommitmentPrice], [t].[ListPrice], [t].[ImagePath], [p].[ID], [p].[BillFrequency], [p].[BillFrequencyType], [p].[Bundle], [p].[BundleCode], [p].[BundleDescription], [p].[BundleOffer], [p].[BundleTotalPrice], [p].[Code], [p].[DateCreated], [p].[DateModified], [p].[Description], [p].[DigiturkPackageID], [p].[GiftIconPath], [p].[HasPrecondition], [p].[HasPromotion], [p].[HeadlineImagePath], [p].[ImagePath], [p].[InstallmentNumber], [p].[InternetConnectionSpeedTypeID], [p].[IsPopularPackage], [p].[IsTeamOffer], [p].[Name], [p].[OfferFromCode], [p].[OfferFromId], [p].[OfferToCode], [p].[OfferToId], [p].[PackageContentImagePath], [p].[PackageContentMobileImagePath], [p].[PackageDetailTypeID], [p].[Precondition], [p].[PriceAmount], [p].[PriceDescription], [p].[PriceTopDescription], [p].[ProductCatalogCode], [p].[Promotion], [p].[ShortDescription], [p].[SortOrder], [p].[SpecialText], [p].[StatusID], [p].[Text], [p].[Title], [p].[TopSeller], [p].[UserCreatedID], [p].[UserModifiedID], [t].[OldInstallmentPriceOnCreditCard], [t].[OldCommitmentPrice], [t].[OldListPrice]
FROM [Content].[Tariff] AS [t]
LEFT JOIN [Content].[Package] AS [p] ON [t].[PackageID] = [p].[ID]
WHERE [t].[StatusID] <> @__DeletedStatusID_0 AND [t].[StatusID] = @__ActiveStatusID_1
ORDER BY [p].[PackageTypeID]
|
| 89ms |
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), @__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
|
| 60ms |
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]
|
| 60ms |
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]
|
| 53ms |
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]
|
| 51ms |
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)
|
| 46ms |
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]
|
| 43ms |
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
|
| 41ms |
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
|
| 38ms |
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
|
| 21ms |
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]
|
| 12ms |
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]
|
| 8ms |
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]
|
| 3ms |
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]
|
