| 1. |
info: 2025-01-22 19:18:13.155 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
17ms [Parameters=[@__id_0='b487cde1-293b-4098-9ec8-7f391fb21255', @__level_Id_1='3442bb2c-ac6a-4947-bdf3-d8d2bcfcb250', @__site_Id_2='ee693ea4-a7a7-489f-bdda-26feaf678dda'], CommandType='Text', CommandTimeout='30']
SELECT [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 [t].[Id] = @__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]
|
| 2. |
info: 2025-01-22 19:18:13.166 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
11ms [Parameters=[@__id_0='b487cde1-293b-4098-9ec8-7f391fb21255', @__level_Id_1='3442bb2c-ac6a-4947-bdf3-d8d2bcfcb250', @__site_Id_2='ee693ea4-a7a7-489f-bdda-26feaf678dda'], CommandType='Text', CommandTimeout='30']
SELECT [t1].[TagId], [t1].[TopicId], [t1].[Id], [t1].[Active], [t1].[Created], [t1].[Deleted], [t1].[Description], [t1].[Details], [t1].[SiteId], [t1].[Title], [t1].[TitleSlug], [t1].[Url], [t1].[Wikipedia], [t1].[WikipediaPageId], [t1].[WikipediaUpdated], [t].[Id], [c].[Id], [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]
INNER JOIN (
SELECT [t0].[TagId], [t0].[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]
FROM [TagTopics] AS [t0]
INNER JOIN [Tags] AS [t2] ON [t0].[TagId] = [t2].[Id]
WHERE [t2].[Active] = CAST(1 AS bit) AND [t2].[Deleted] = CAST(0 AS bit)
) AS [t1] ON [t].[Id] = [t1].[TopicId]
WHERE [t].[Id] = @__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]
|
| 3. |
info: 2025-01-22 19:18:13.175 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
7ms [Parameters=[@__site_Id_0='ee693ea4-a7a7-489f-bdda-26feaf678dda', @__item_Id_1='b487cde1-293b-4098-9ec8-7f391fb21255'], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [q].[Id], [q].[Active], [q].[AnswerPartialPoints], [q].[AnswerPoints], [q].[Created], [q].[Deleted], [q].[PartialPoints], [q].[Points], [q].[ProcessorGenerateImagePrompt], [q].[StorageMediaName], [q].[StorageMediaUrl], [q].[Title], [q].[TopicId], [q].[TotalAnswers], [q].[TotalHints], [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 [Questions] AS [q] WITH (NOLOCK)
INNER JOIN [Topics] AS [t] ON [q].[TopicId] = [t].[Id]
INNER JOIN [Categories] AS [c] ON [t].[CategoryId] = [c].[Id]
WHERE [c].[SiteId] = @__site_Id_0 AND [q].[TopicId] = @__item_Id_1 AND [q].[Active] = CAST(1 AS bit) AND [q].[Deleted] = CAST(0 AS bit)
ORDER BY [q].[Created], [q].[Id], [t].[Id], [c].[Id]
|
| 4. |
info: 2025-01-22 19:18:13.214 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
39ms [Parameters=[@__site_Id_0='ee693ea4-a7a7-489f-bdda-26feaf678dda', @__item_Id_1='b487cde1-293b-4098-9ec8-7f391fb21255'], CommandType='Text', CommandTimeout='30']
SELECT [t1].[Id], [t1].[Active], [t1].[Correct], [t1].[Deleted], [t1].[QuestionId], [t1].[StorageMediaName], [t1].[StorageMediaUrl], [t1].[Title], [t0].[Id], [t0].[Id0], [t0].[Id1]
FROM (
SELECT TOP(1) [q].[Id], [t].[Id] AS [Id0], [c].[Id] AS [Id1], [q].[Created]
FROM [Questions] AS [q] WITH (NOLOCK)
INNER JOIN [Topics] AS [t] ON [q].[TopicId] = [t].[Id]
INNER JOIN [Categories] AS [c] ON [t].[CategoryId] = [c].[Id]
WHERE [c].[SiteId] = @__site_Id_0 AND [q].[TopicId] = @__item_Id_1 AND [q].[Active] = CAST(1 AS bit) AND [q].[Deleted] = CAST(0 AS bit)
ORDER BY [q].[Created]
) AS [t0]
INNER JOIN (
SELECT [q0].[Id], [q0].[Active], [q0].[Correct], [q0].[Deleted], [q0].[QuestionId], [q0].[StorageMediaName], [q0].[StorageMediaUrl], [q0].[Title], NEWID() AS [c]
FROM [QuestionAnswers] AS [q0]
WHERE [q0].[Active] = CAST(1 AS bit) AND [q0].[Deleted] = CAST(0 AS bit)
) AS [t1] ON [t0].[Id] = [t1].[QuestionId]
ORDER BY [t0].[Created], [t0].[Id], [t0].[Id0], [t0].[Id1], [t1].[c]
|
| 5. |
info: 2025-01-22 19:18:13.379 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
164ms [Parameters=[@__site_Id_0='ee693ea4-a7a7-489f-bdda-26feaf678dda', @__item_Left_1='20', @__item_Right_2='21'], 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]
|
| 6. |
info: 2025-01-22 19:18:13.399 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
3ms [Parameters=[@__p_4='50', @__item_Id_0='b487cde1-293b-4098-9ec8-7f391fb21255', @__item_CategoryId_1='b0066e1c-8b50-4c96-9c48-440cfae98197', @__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()
|
| 7. |
info: 2025-01-22 19:18:13.457 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__id_0='5990f308-2c3f-48a7-a9c7-9fbfdf8387d8', @__site_Id_1='ee693ea4-a7a7-489f-bdda-26feaf678dda'], 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] WITH (NOLOCK)
WHERE [c].[Id] = @__id_0 AND [c].[SiteId] = @__site_Id_1 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Id]
|
| 8. |
info: 2025-01-22 19:18:13.460 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__id_0='5990f308-2c3f-48a7-a9c7-9fbfdf8387d8', @__site_Id_1='ee693ea4-a7a7-489f-bdda-26feaf678dda'], CommandType='Text', CommandTimeout='30']
SELECT [t].[Id], [t].[Active], [t].[Deleted], [t].[Description], [t].[Left], [t].[ParentId], [t].[Position], [t].[ProcessorGenerateImagePrompt], [t].[Right], [t].[SiteId], [t].[StorageMediaName], [t].[StorageMediaUrl], [t].[Title], [t].[TotalBadges], [t].[TotalChildren], [t].[TotalDocuments], [t].[TotalTopics], [c].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c0].[Id], [c0].[Active], [c0].[Deleted], [c0].[Description], [c0].[Left], [c0].[ParentId], [c0].[Position], [c0].[ProcessorGenerateImagePrompt], [c0].[Right], [c0].[SiteId], [c0].[StorageMediaName], [c0].[StorageMediaUrl], [c0].[Title], [c0].[TotalBadges], [c0].[TotalChildren], [c0].[TotalDocuments], [c0].[TotalTopics]
FROM [Categories] AS [c0] WITH (NOLOCK)
WHERE [c0].[Active] = CAST(1 AS bit) AND [c0].[Deleted] = CAST(0 AS bit)
) AS [t] ON [c].[Id] = [t].[ParentId]
WHERE [c].[Id] = @__id_0 AND [c].[SiteId] = @__site_Id_1 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Id], [t].[Position], [t].[Id]
|
| 9. |
info: 2025-01-22 19:18:13.468 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__id_0='5990f308-2c3f-48a7-a9c7-9fbfdf8387d8', @__site_Id_1='ee693ea4-a7a7-489f-bdda-26feaf678dda'], CommandType='Text', CommandTimeout='30']
SELECT [t].[Id], [t].[Active], [t].[CategoryId], [t].[Deleted], [t].[Description], [t].[From], [t].[StorageMediaName], [t].[StorageMediaUrl], [t].[Title], [t].[To], [c].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [b].[Id], [b].[Active], [b].[CategoryId], [b].[Deleted], [b].[Description], [b].[From], [b].[StorageMediaName], [b].[StorageMediaUrl], [b].[Title], [b].[To]
FROM [Badges] AS [b]
WHERE [b].[Active] = CAST(1 AS bit) AND [b].[Deleted] = CAST(0 AS bit)
) AS [t] ON [c].[Id] = [t].[CategoryId]
WHERE [c].[Id] = @__id_0 AND [c].[SiteId] = @__site_Id_1 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Id], [t].[From], [t].[To]
|
| 10. |
info: 2025-01-22 19:18:13.501 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__site_Id_0='ee693ea4-a7a7-489f-bdda-26feaf678dda', @__item_Left_1='18', @__item_Right_2='19'], 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]
|
| 11. |
info: 2025-01-22 19:18:13.592 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
11ms [Parameters=[@__p_3='50', @__item_Id_0='5990f308-2c3f-48a7-a9c7-9fbfdf8387d8', @__site_Id_1='ee693ea4-a7a7-489f-bdda-26feaf678dda', @__level_Id_2='3442bb2c-ac6a-4947-bdf3-d8d2bcfcb250'], 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]
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].[CategoryId] = @__item_Id_0 AND [c].[SiteId] = @__site_Id_1 AND [t].[LevelId] = @__level_Id_2 AND 0 <> [t].[TotalQuestions] 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()
|
| 266 ms |
