| 1. |
info: 2025-01-22 22:12:08.488 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
10ms [Parameters=[@__site_Id_0='ee693ea4-a7a7-489f-bdda-26feaf678dda', @__item_Left_1='14', @__item_Right_2='15'], CommandType='Text', CommandTimeout='30']
SELECT [c].[Id], [c].[Active], [c].[Deleted], [c].[Description], [c].[Left], [c].[ParentId], [c].[Position], [c].[ProcessorGenerateImagePrompt], [c].[Right], [c].[SiteId], [c].[StorageMediaName], [c].[StorageMediaUrl], [c].[Title], [c].[TotalBadges], [c].[TotalChildren], [c].[TotalDocuments], [c].[TotalTopics]
FROM [Categories] AS [c]
WHERE [c].[SiteId] = @__site_Id_0 AND [c].[Left] <= @__item_Left_1 AND [c].[Right] >= @__item_Right_2 AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Left]
|
| 2. |
info: 2025-01-22 22:12:08.577 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
58ms [Parameters=[@__p_4='50', @__item_Id_0='02bb780b-5541-42f6-9c83-7eecf6657c5d', @__item_CategoryId_1='3ff6d04b-84ec-42cd-9f88-863e98b69662', @__level_Id_2='3442bb2c-ac6a-4947-bdf3-d8d2bcfcb250', @__site_Id_3='ee693ea4-a7a7-489f-bdda-26feaf678dda'], CommandType='Text', CommandTimeout='30']
SELECT TOP(@__p_4) [t].[Id], [t].[Active], [t].[CategoryId], [t].[Challenge], [t].[ChallengePartialPoints], [t].[ChallengePoints], [t].[ChallengeRequest], [t].[ChallengeTask], [t].[Created], [t].[Deleted], [t].[Description], [t].[DocumentId], [t].[LevelId], [t].[ProcessorGenerateImagePrompt], [t].[StorageMediaName], [t].[StorageMediaUrl], [t].[Title], [t].[TitleSlug], [t].[TotalQuestionPoints], [t].[TotalQuestions], [c].[Id], [c].[Active], [c].[Deleted], [c].[Description], [c].[Left], [c].[ParentId], [c].[Position], [c].[ProcessorGenerateImagePrompt], [c].[Right], [c].[SiteId], [c].[StorageMediaName], [c].[StorageMediaUrl], [c].[Title], [c].[TotalBadges], [c].[TotalChildren], [c].[TotalDocuments], [c].[TotalTopics]
FROM [Topics] AS [t] WITH (NOLOCK)
INNER JOIN [Categories] AS [c] ON [t].[CategoryId] = [c].[Id]
LEFT JOIN [Categories] AS [c0] ON [c].[ParentId] = [c0].[Id]
WHERE [t].[Id] <> @__item_Id_0 AND [t].[CategoryId] = @__item_CategoryId_1 AND [t].[LevelId] = @__level_Id_2 AND [c].[SiteId] = @__site_Id_3 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit) AND [c0].[Active] = CAST(1 AS bit) AND [c0].[Deleted] = CAST(0 AS bit) AND [t].[Active] = CAST(1 AS bit) AND [t].[Deleted] = CAST(0 AS bit)
ORDER BY NEWID()
|
| 3. |
info: 2025-01-22 22:12:08.665 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
1ms [Parameters=[@__site_Id_0='ee693ea4-a7a7-489f-bdda-26feaf678dda', @__id_1='aa8d6ed9-3246-44c8-a325-118306d36539'], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [t].[Id], [t].[Active], [t].[Created], [t].[Deleted], [t].[Description], [t].[Details], [t].[SiteId], [t].[Title], [t].[TitleSlug], [t].[Url], [t].[Wikipedia], [t].[WikipediaPageId], [t].[WikipediaUpdated]
FROM [Tags] AS [t]
WHERE [t].[SiteId] = @__site_Id_0 AND [t].[Id] = @__id_1 AND [t].[Active] = CAST(1 AS bit) AND [t].[Deleted] = CAST(0 AS bit)
|
| 4. |
info: 2025-01-22 22:12:08.751 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
9ms [Parameters=[@__p_3='50', @__item_Id_0='aa8d6ed9-3246-44c8-a325-118306d36539', @__level_Id_1='3442bb2c-ac6a-4947-bdf3-d8d2bcfcb250', @__site_Id_2='ee693ea4-a7a7-489f-bdda-26feaf678dda'], CommandType='Text', CommandTimeout='30']
SELECT TOP(@__p_3) [t].[Id], [t].[Active], [t].[CategoryId], [t].[Challenge], [t].[ChallengePartialPoints], [t].[ChallengePoints], [t].[ChallengeRequest], [t].[ChallengeTask], [t].[Created], [t].[Deleted], [t].[Description], [t].[DocumentId], [t].[LevelId], [t].[ProcessorGenerateImagePrompt], [t].[StorageMediaName], [t].[StorageMediaUrl], [t].[Title], [t].[TitleSlug], [t].[TotalQuestionPoints], [t].[TotalQuestions], [c].[Id], [c].[Active], [c].[Deleted], [c].[Description], [c].[Left], [c].[ParentId], [c].[Position], [c].[ProcessorGenerateImagePrompt], [c].[Right], [c].[SiteId], [c].[StorageMediaName], [c].[StorageMediaUrl], [c].[Title], [c].[TotalBadges], [c].[TotalChildren], [c].[TotalDocuments], [c].[TotalTopics], [c0].[Id]
FROM [Topics] AS [t] WITH (NOLOCK)
INNER JOIN [Categories] AS [c] ON [t].[CategoryId] = [c].[Id]
LEFT JOIN [Categories] AS [c0] ON [c].[ParentId] = [c0].[Id]
WHERE EXISTS (
SELECT 1
FROM [TagTopics] AS [t0]
WHERE [t].[Id] = [t0].[TopicId] AND [t0].[TagId] = @__item_Id_0) AND [t].[LevelId] = @__level_Id_1 AND [c].[SiteId] = @__site_Id_2 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit) AND [c0].[Active] = CAST(1 AS bit) AND [c0].[Deleted] = CAST(0 AS bit) AND [t].[Active] = CAST(1 AS bit) AND [t].[Deleted] = CAST(0 AS bit)
ORDER BY [t].[TitleSlug], [t].[Id], [c].[Id], [c0].[Id]
|
| 5. |
info: 2025-01-22 22:12:08.788 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
20ms [Parameters=[@__p_3='50', @__item_Id_0='aa8d6ed9-3246-44c8-a325-118306d36539', @__level_Id_1='3442bb2c-ac6a-4947-bdf3-d8d2bcfcb250', @__site_Id_2='ee693ea4-a7a7-489f-bdda-26feaf678dda'], CommandType='Text', CommandTimeout='30']
SELECT [t2].[TagId], [t2].[TopicId], [t2].[Id], [t2].[Active], [t2].[Created], [t2].[Deleted], [t2].[Description], [t2].[Details], [t2].[SiteId], [t2].[Title], [t2].[TitleSlug], [t2].[Url], [t2].[Wikipedia], [t2].[WikipediaPageId], [t2].[WikipediaUpdated], [t1].[Id], [t1].[Id0], [t1].[Id1]
FROM (
SELECT TOP(@__p_3) [t].[Id], [c].[Id] AS [Id0], [c0].[Id] AS [Id1], [t].[TitleSlug]
FROM [Topics] AS [t] WITH (NOLOCK)
INNER JOIN [Categories] AS [c] ON [t].[CategoryId] = [c].[Id]
LEFT JOIN [Categories] AS [c0] ON [c].[ParentId] = [c0].[Id]
WHERE EXISTS (
SELECT 1
FROM [TagTopics] AS [t0]
WHERE [t].[Id] = [t0].[TopicId] AND [t0].[TagId] = @__item_Id_0) AND [t].[LevelId] = @__level_Id_1 AND [c].[SiteId] = @__site_Id_2 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit) AND [c0].[Active] = CAST(1 AS bit) AND [c0].[Deleted] = CAST(0 AS bit) AND [t].[Active] = CAST(1 AS bit) AND [t].[Deleted] = CAST(0 AS bit)
ORDER BY [t].[TitleSlug]
) AS [t1]
INNER JOIN (
SELECT [t3].[TagId], [t3].[TopicId], [t4].[Id], [t4].[Active], [t4].[Created], [t4].[Deleted], [t4].[Description], [t4].[Details], [t4].[SiteId], [t4].[Title], [t4].[TitleSlug], [t4].[Url], [t4].[Wikipedia], [t4].[WikipediaPageId], [t4].[WikipediaUpdated]
FROM [TagTopics] AS [t3]
INNER JOIN [Tags] AS [t4] ON [t3].[TagId] = [t4].[Id]
WHERE [t4].[Active] = CAST(1 AS bit) AND [t4].[Deleted] = CAST(0 AS bit)
) AS [t2] ON [t1].[Id] = [t2].[TopicId]
ORDER BY [t1].[TitleSlug], [t1].[Id], [t1].[Id0], [t1].[Id1]
|
| 98 ms |
