1. |
info: 2025-01-22 15:46:34.698 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 6ms [Parameters=[@__site_Id_0='ee693ea4-a7a7-489f-bdda-26feaf678dda', @__item_Left_1='16', @__item_Right_2='17'], 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].[TotalTags], [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 15:46:34.721 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 19ms [Parameters=[@__p_3='50', @__item_Id_0='5334d5b6-f6f4-406e-a233-fa3050415a9b', @__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].[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].[TotalTags], [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()
|