| 1. |
info: 2025-01-22 16:05:57.863 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
9ms [Parameters=[@__id_0='e751feb8-54a0-4127-a26a-c4e03b8007dc', @__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].[TotalTags], [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]
|
| 2. |
info: 2025-01-22 16:05:57.873 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
1ms [Parameters=[@__id_0='e751feb8-54a0-4127-a26a-c4e03b8007dc', @__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].[TotalTags], [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].[TotalTags], [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]
|
| 3. |
info: 2025-01-22 16:05:57.918 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
3ms [Parameters=[@__id_0='e751feb8-54a0-4127-a26a-c4e03b8007dc', @__site_Id_1='ee693ea4-a7a7-489f-bdda-26feaf678dda'], CommandType='Text', CommandTimeout='30']
SELECT [t0].[Id], [t0].[Active], [t0].[Deleted], [t0].[Description], [t0].[Left], [t0].[ParentId], [t0].[Position], [t0].[ProcessorGenerateImagePrompt], [t0].[Right], [t0].[SiteId], [t0].[StorageMediaName], [t0].[StorageMediaUrl], [t0].[Title], [t0].[TotalBadges], [t0].[TotalChildren], [t0].[TotalTags], [t0].[TotalTopics], [c].[Id], [t].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c0].[Id], [c0].[ParentId], [c0].[Position]
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]
INNER JOIN (
SELECT [c1].[Id], [c1].[Active], [c1].[Deleted], [c1].[Description], [c1].[Left], [c1].[ParentId], [c1].[Position], [c1].[ProcessorGenerateImagePrompt], [c1].[Right], [c1].[SiteId], [c1].[StorageMediaName], [c1].[StorageMediaUrl], [c1].[Title], [c1].[TotalBadges], [c1].[TotalChildren], [c1].[TotalTags], [c1].[TotalTopics]
FROM [Categories] AS [c1] WITH (NOLOCK)
WHERE [c1].[Active] = CAST(1 AS bit) AND [c1].[Deleted] = CAST(0 AS bit)
) AS [t0] ON [t].[Id] = [t0].[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], [t0].[Position]
|
| 4. |
info: 2025-01-22 16:05:57.923 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
5ms [Parameters=[@__id_0='e751feb8-54a0-4127-a26a-c4e03b8007dc', @__site_Id_1='ee693ea4-a7a7-489f-bdda-26feaf678dda'], CommandType='Text', CommandTimeout='30']
SELECT [t1].[Id], [t1].[Active], [t1].[CategoryId], [t1].[Challenge], [t1].[ChallengePartialPoints], [t1].[ChallengePoints], [t1].[ChallengeRequest], [t1].[ChallengeTask], [t1].[Created], [t1].[Deleted], [t1].[Description], [t1].[LevelId], [t1].[ProcessorGenerateImagePrompt], [t1].[StorageMediaName], [t1].[StorageMediaUrl], [t1].[Title], [t1].[TitleSlug], [t1].[TotalQuestionPoints], [t1].[TotalQuestions], [c].[Id], [t].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c0].[Id], [c0].[ParentId], [c0].[Position]
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]
INNER JOIN (
SELECT [t0].[Id], [t0].[Active], [t0].[CategoryId], [t0].[Challenge], [t0].[ChallengePartialPoints], [t0].[ChallengePoints], [t0].[ChallengeRequest], [t0].[ChallengeTask], [t0].[Created], [t0].[Deleted], [t0].[Description], [t0].[LevelId], [t0].[ProcessorGenerateImagePrompt], [t0].[StorageMediaName], [t0].[StorageMediaUrl], [t0].[Title], [t0].[TitleSlug], [t0].[TotalQuestionPoints], [t0].[TotalQuestions], [t0].[c]
FROM (
SELECT [t2].[Id], [t2].[Active], [t2].[CategoryId], [t2].[Challenge], [t2].[ChallengePartialPoints], [t2].[ChallengePoints], [t2].[ChallengeRequest], [t2].[ChallengeTask], [t2].[Created], [t2].[Deleted], [t2].[Description], [t2].[LevelId], [t2].[ProcessorGenerateImagePrompt], [t2].[StorageMediaName], [t2].[StorageMediaUrl], [t2].[Title], [t2].[TitleSlug], [t2].[TotalQuestionPoints], [t2].[TotalQuestions], ROW_NUMBER() OVER(PARTITION BY [t2].[CategoryId] ORDER BY NEWID()) AS [row], NEWID() AS [c]
FROM [Topics] AS [t2]
WHERE [t2].[Active] = CAST(1 AS bit) AND [t2].[Deleted] = CAST(0 AS bit)
) AS [t0]
WHERE [t0].[row] <= 10
) AS [t1] ON [t].[Id] = [t1].[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].[Position], [t].[Id], [t1].[CategoryId], [t1].[c]
|
| 5. |
info: 2025-01-22 16:05:57.938 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
14ms [Parameters=[@__id_0='e751feb8-54a0-4127-a26a-c4e03b8007dc', @__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]
|
| 6. |
info: 2025-01-22 16:05:57.980 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__site_Id_0='ee693ea4-a7a7-489f-bdda-26feaf678dda', @__item_Left_1='69', @__item_Right_2='82'], 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]
|
| 7. |
info: 2025-01-22 16:05:57.991 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__p_3='50', @__item_Id_0='e751feb8-54a0-4127-a26a-c4e03b8007dc', @__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()
|
| 36 ms |
