| 1. |
info: 2025-04-26 06:33:56.502 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
138ms [Parameters=[@__id_0='b149813b-f2cf-c251-ba58-51cc94bc5437', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s4].[Id], [s4].[Active], [s4].[Context], [s4].[ContextBackup], [s4].[ContextStorageMediaName], [s4].[ContextStorageMediaUrl], [s4].[Deleted], [s4].[FactErrors], [s4].[FactErrorsExplanation], [s4].[Facts], [s4].[FactsBackup], [s4].[FactsStorageMediaName], [s4].[FactsStorageMediaUrl], [s4].[Position], [s4].[ProcessorGenerateImagePrompt], [s4].[Prompt], [s4].[ScannerId], [s4].[SpellingErrors], [s4].[SpellingErrorsExplanation], [s4].[StorageMediaName], [s4].[StorageMediaUrl], [s4].[Summary], [s4].[SummaryBackup], [s4].[SummaryStorageMediaName], [s4].[SummaryStorageMediaUrl], [s4].[Title], [s4].[TitleSlug], [s4].[TotalFillTheBlankSelectionQuestions], [s4].[TotalMultipleSelectionQuestions], [s4].[TotalOrderingQuestions], [s4].[TotalQuestionPoints], [s4].[TotalQuestions], [s4].[TotalShortAnswerQuestions], [s4].[TotalSingleSelectionQuestions], [s4].[TotalSources], [s4].[TotalTrueFalseQuestions], [s4].[Verified], [s4].[Version], [c].[Id], [c4].[Id], [s3].[ScannerId], [s3].[CategoryId], [s3].[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 [c4] ON [c].[Id] = [c4].[ParentId]
INNER JOIN (
SELECT [c2].[ScannerId], [c2].[CategoryId], [s].[Id]
FROM [CategoryScanners] AS [c2]
INNER JOIN [Scanners] AS [s] ON [c2].[ScannerId] = [s].[Id]
WHERE [s].[Active] = CAST(1 AS bit) AND [s].[Deleted] = CAST(0 AS bit)
) AS [s3] ON [c4].[Id] = [s3].[CategoryId]
INNER JOIN (
SELECT [s0].[Id], [s0].[Active], [s0].[Context], [s0].[ContextBackup], [s0].[ContextStorageMediaName], [s0].[ContextStorageMediaUrl], [s0].[Deleted], [s0].[FactErrors], [s0].[FactErrorsExplanation], [s0].[Facts], [s0].[FactsBackup], [s0].[FactsStorageMediaName], [s0].[FactsStorageMediaUrl], [s0].[Position], [s0].[ProcessorGenerateImagePrompt], [s0].[Prompt], [s0].[ScannerId], [s0].[SpellingErrors], [s0].[SpellingErrorsExplanation], [s0].[StorageMediaName], [s0].[StorageMediaUrl], [s0].[Summary], [s0].[SummaryBackup], [s0].[SummaryStorageMediaName], [s0].[SummaryStorageMediaUrl], [s0].[Title], [s0].[TitleSlug], [s0].[TotalFillTheBlankSelectionQuestions], [s0].[TotalMultipleSelectionQuestions], [s0].[TotalOrderingQuestions], [s0].[TotalQuestionPoints], [s0].[TotalQuestions], [s0].[TotalShortAnswerQuestions], [s0].[TotalSingleSelectionQuestions], [s0].[TotalSources], [s0].[TotalTrueFalseQuestions], [s0].[Verified], [s0].[Version]
FROM [ScannerCards] AS [s0]
WHERE [s0].[Active] = CAST(1 AS bit) AND [s0].[Deleted] = CAST(0 AS bit)
) AS [s4] ON [s3].[Id] = [s4].[ScannerId]
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], [c4].[Position], [c4].[Id], [s3].[Id], [s3].[ScannerId], [s3].[CategoryId], [s4].[TitleSlug]
|
