| 1. |
info: 2025-04-25 18:50:24.456 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
355ms [Parameters=[@__id_0='d1ce1423-5b1e-ba39-ffc1-13e7e0b91a24', @__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]
|
| 2. |
info: 2025-04-25 18:50:24.477 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
22ms [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Tags] AS [t]
WHERE [t].[WikipediaUpdated] = CAST(0 AS bit) AND [t].[Deleted] = CAST(0 AS bit)
|
| 3. |
info: 2025-04-25 18:50:24.495 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
10ms [Parameters=[@__p_0='1'], CommandType='Text', CommandTimeout='30']
SELECT TOP(@__p_0) [t].[Id], [t].[Active], [t].[Created], [t].[Deleted], [t].[Description], [t].[Links], [t].[MediaSourceCopyright], [t].[MediaSourceUrl], [t].[ShortDescription], [t].[SiteId], [t].[StorageMediaName], [t].[StorageMediaUrl], [t].[Title], [t].[TitleSlug], [t].[Url], [t].[Wikipedia], [t].[WikipediaPageId], [t].[WikipediaUpdated]
FROM [Tags] AS [t]
WHERE [t].[WikipediaUpdated] = CAST(0 AS bit) AND [t].[Deleted] = CAST(0 AS bit)
ORDER BY [t].[Id] DESC
|
| 4. |
info: 2025-04-25 18:50:24.600 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
40ms [Parameters=[@__id_0='d1ce1423-5b1e-ba39-ffc1-13e7e0b91a24', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s5].[ScannerId], [s5].[CategoryId], [s5].[Id], [s5].[Active], [s5].[CheatSheet], [s5].[CheatSheet2], [s5].[Deleted], [s5].[FactErrors], [s5].[FactErrorsExplanation], [s5].[ParentCategory2Id], [s5].[ParentCategoryId], [s5].[ProcessorGenerateImagePrompt], [s5].[Prompt], [s5].[Reference], [s5].[ReferenceSlug], [s5].[SiteId], [s5].[SpellingErrors], [s5].[SpellingErrorsExplanation], [s5].[Summary], [s5].[Title], [s5].[TitleBackup], [s5].[TitleSlug], [s5].[TotalCards], [s5].[TotalCards2], [s5].[TotalCategories], [s5].[TotalPages], [s5].[Verified], [c].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id], [s1].[Active], [s1].[CheatSheet], [s1].[CheatSheet2], [s1].[Deleted], [s1].[FactErrors], [s1].[FactErrorsExplanation], [s1].[ParentCategory2Id], [s1].[ParentCategoryId], [s1].[ProcessorGenerateImagePrompt], [s1].[Prompt], [s1].[Reference], [s1].[ReferenceSlug], [s1].[SiteId], [s1].[SpellingErrors], [s1].[SpellingErrorsExplanation], [s1].[Summary], [s1].[Title], [s1].[TitleBackup], [s1].[TitleSlug], [s1].[TotalCards], [s1].[TotalCards2], [s1].[TotalCategories], [s1].[TotalPages], [s1].[Verified]
FROM [CategoryScanners] AS [c3]
INNER JOIN [Scanners] AS [s1] ON [c3].[ScannerId] = [s1].[Id]
WHERE [s1].[Active] = CAST(1 AS bit) AND [s1].[Deleted] = CAST(0 AS bit)
) AS [s5] ON [c].[Id] = [s5].[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], [s5].[Id], [s5].[ScannerId], [s5].[CategoryId]
|
| 5. |
info: 2025-04-25 18:50:24.715 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='3841', @__item_Right_2='3862'], CommandType='Text', CommandTimeout='30']
SELECT [c].[Id], [c].[Active], [c].[Deleted], [c].[Description], [c].[DescriptionBackup], [c].[Left], [c].[ParentId], [c].[Position], [c].[ProcessorGenerateImagePrompt], [c].[Right], [c].[SiteId], [c].[StorageMediaName], [c].[StorageMediaUrl], [c].[Title], [c].[TitleBackup], [c].[TitleSlug], [c].[TotalChildren], [c].[TotalScanners], [c].[TotalYoutubeVideos]
FROM [Categories] AS [c] WITH (NOLOCK)
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]
|
| 435 ms |
