| 1. |
info: 2025-04-29 10:54:51.317 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__id_0='0a825304-fe20-187f-8885-85cd13f53fdc', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], 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].[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-04-29 10:54:51.344 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
18ms [Parameters=[@__id_0='0a825304-fe20-187f-8885-85cd13f53fdc', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [c4].[Id], [c4].[Active], [c4].[Deleted], [c4].[Description], [c4].[DescriptionBackup], [c4].[Left], [c4].[ParentId], [c4].[Position], [c4].[ProcessorGenerateImagePrompt], [c4].[Right], [c4].[SiteId], [c4].[StorageMediaName], [c4].[StorageMediaUrl], [c4].[Title], [c4].[TitleBackup], [c4].[TitleSlug], [c4].[TotalChildren], [c4].[TotalScanners], [c4].[TotalYoutubeVideos], [c].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c0].[Id], [c0].[Active], [c0].[Deleted], [c0].[Description], [c0].[DescriptionBackup], [c0].[Left], [c0].[ParentId], [c0].[Position], [c0].[ProcessorGenerateImagePrompt], [c0].[Right], [c0].[SiteId], [c0].[StorageMediaName], [c0].[StorageMediaUrl], [c0].[Title], [c0].[TitleBackup], [c0].[TitleSlug], [c0].[TotalChildren], [c0].[TotalScanners], [c0].[TotalYoutubeVideos]
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]
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]
|
| 3. |
info: 2025-04-29 10:54:51.363 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
19ms [Parameters=[@__id_0='0a825304-fe20-187f-8885-85cd13f53fdc', @__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].[Summary2], [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].[Summary2], [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]
|
| 4. |
info: 2025-04-29 10:54:51.385 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
10ms [Parameters=[@__id_0='0a825304-fe20-187f-8885-85cd13f53fdc', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s6].[Id], [s6].[Active], [s6].[Context], [s6].[ContextBackup], [s6].[ContextStorageMediaName], [s6].[ContextStorageMediaUrl], [s6].[Deleted], [s6].[FactErrors], [s6].[FactErrorsExplanation], [s6].[Facts], [s6].[FactsBackup], [s6].[FactsStorageMediaName], [s6].[FactsStorageMediaUrl], [s6].[Position], [s6].[ProcessorGenerateImagePrompt], [s6].[Prompt], [s6].[ScannerId], [s6].[SpellingErrors], [s6].[SpellingErrorsExplanation], [s6].[StorageMediaName], [s6].[StorageMediaUrl], [s6].[Summary], [s6].[SummaryBackup], [s6].[SummaryStorageMediaName], [s6].[SummaryStorageMediaUrl], [s6].[Title], [s6].[TitleSlug], [s6].[TotalFillTheBlankSelectionQuestions], [s6].[TotalMultipleSelectionQuestions], [s6].[TotalOrderingQuestions], [s6].[TotalQuestionPoints], [s6].[TotalQuestions], [s6].[TotalShortAnswerQuestions], [s6].[TotalSingleSelectionQuestions], [s6].[TotalSources], [s6].[TotalTrueFalseQuestions], [s6].[Verified], [s6].[Version], [c].[Id], [s5].[ScannerId], [s5].[CategoryId], [s5].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id]
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]
INNER JOIN (
SELECT [s2].[Id], [s2].[Active], [s2].[Context], [s2].[ContextBackup], [s2].[ContextStorageMediaName], [s2].[ContextStorageMediaUrl], [s2].[Deleted], [s2].[FactErrors], [s2].[FactErrorsExplanation], [s2].[Facts], [s2].[FactsBackup], [s2].[FactsStorageMediaName], [s2].[FactsStorageMediaUrl], [s2].[Position], [s2].[ProcessorGenerateImagePrompt], [s2].[Prompt], [s2].[ScannerId], [s2].[SpellingErrors], [s2].[SpellingErrorsExplanation], [s2].[StorageMediaName], [s2].[StorageMediaUrl], [s2].[Summary], [s2].[SummaryBackup], [s2].[SummaryStorageMediaName], [s2].[SummaryStorageMediaUrl], [s2].[Title], [s2].[TitleSlug], [s2].[TotalFillTheBlankSelectionQuestions], [s2].[TotalMultipleSelectionQuestions], [s2].[TotalOrderingQuestions], [s2].[TotalQuestionPoints], [s2].[TotalQuestions], [s2].[TotalShortAnswerQuestions], [s2].[TotalSingleSelectionQuestions], [s2].[TotalSources], [s2].[TotalTrueFalseQuestions], [s2].[Verified], [s2].[Version]
FROM [ScannerCards] AS [s2]
WHERE [s2].[Active] = CAST(1 AS bit) AND [s2].[Deleted] = CAST(0 AS bit)
) AS [s6] ON [s5].[Id] = [s6].[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], [s5].[Id], [s5].[ScannerId], [s5].[CategoryId], [s6].[TitleSlug], [s6].[Id]
|
| 5. |
info: 2025-04-29 10:54:51.404 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
10ms [Parameters=[@__id_0='0a825304-fe20-187f-8885-85cd13f53fdc', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [q0].[Id], [q0].[Active], [q0].[Created], [q0].[Deleted], [q0].[Points], [q0].[ProcessorGenerateImagePrompt], [q0].[ScannerCardId], [q0].[StorageMediaName], [q0].[StorageMediaUrl], [q0].[Title], [q0].[TotalAnswers], [q0].[Type], [c].[Id], [s5].[ScannerId], [s5].[CategoryId], [s5].[Id], [s6].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id]
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]
INNER JOIN (
SELECT [s2].[Id], [s2].[ScannerId], [s2].[TitleSlug]
FROM [ScannerCards] AS [s2]
WHERE [s2].[Active] = CAST(1 AS bit) AND [s2].[Deleted] = CAST(0 AS bit)
) AS [s6] ON [s5].[Id] = [s6].[ScannerId]
INNER JOIN (
SELECT [q].[Id], [q].[Active], [q].[Created], [q].[Deleted], [q].[Points], [q].[ProcessorGenerateImagePrompt], [q].[ScannerCardId], [q].[StorageMediaName], [q].[StorageMediaUrl], [q].[Title], [q].[TotalAnswers], [q].[Type]
FROM [Questions] AS [q]
WHERE [q].[Active] = CAST(1 AS bit) AND [q].[Deleted] = CAST(0 AS bit)
) AS [q0] ON [s6].[Id] = [q0].[ScannerCardId]
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], [s6].[TitleSlug], [s6].[Id], [q0].[Id]
|
| 6. |
info: 2025-04-29 10:54:51.415 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
10ms [Parameters=[@__id_0='0a825304-fe20-187f-8885-85cd13f53fdc', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s7].[TagId], [s7].[ScannerCardId], [s7].[Id], [s7].[Active], [s7].[Created], [s7].[Deleted], [s7].[Description], [s7].[Links], [s7].[MediaSourceCopyright], [s7].[MediaSourceUrl], [s7].[ShortDescription], [s7].[SiteId], [s7].[StorageMediaName], [s7].[StorageMediaUrl], [s7].[Title], [s7].[TitleSlug], [s7].[Url], [s7].[Wikipedia], [s7].[WikipediaPageId], [s7].[WikipediaUpdated], [c].[Id], [s5].[ScannerId], [s5].[CategoryId], [s5].[Id], [s6].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id]
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]
INNER JOIN (
SELECT [s2].[Id], [s2].[ScannerId], [s2].[TitleSlug]
FROM [ScannerCards] AS [s2]
WHERE [s2].[Active] = CAST(1 AS bit) AND [s2].[Deleted] = CAST(0 AS bit)
) AS [s6] ON [s5].[Id] = [s6].[ScannerId]
INNER JOIN (
SELECT [t].[TagId], [t].[ScannerCardId], [t0].[Id], [t0].[Active], [t0].[Created], [t0].[Deleted], [t0].[Description], [t0].[Links], [t0].[MediaSourceCopyright], [t0].[MediaSourceUrl], [t0].[ShortDescription], [t0].[SiteId], [t0].[StorageMediaName], [t0].[StorageMediaUrl], [t0].[Title], [t0].[TitleSlug], [t0].[Url], [t0].[Wikipedia], [t0].[WikipediaPageId], [t0].[WikipediaUpdated]
FROM [TagScannerCards] AS [t]
INNER JOIN [Tags] AS [t0] ON [t].[TagId] = [t0].[Id]
WHERE [t0].[Active] = CAST(1 AS bit) AND [t0].[Deleted] = CAST(0 AS bit)
) AS [s7] ON [s6].[Id] = [s7].[ScannerCardId]
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], [s6].[TitleSlug], [s6].[Id], [s7].[TitleSlug]
|
| 7. |
info: 4/29/2025 10:54:51.434 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
1ms [Parameters=[@__host_Host_0='real2.knowledgenestapp.com' (Size = 100)], CommandType='Text', CommandTimeout='30']
SELECT [s].[Id], [s].[CultureCode], [s].[Deleted], [s].[Description], [s].[Email], [s].[ProcessorGenerateImageCategoryPrompt], [s].[ProcessorGenerateImageQuestionPrompt], [s].[ProcessorGenerateImageTopicPrompt], [s].[ProcessorGenerateQuestionPrompt], [s].[ProcessorGenerateQuestionShortPrompt], [s].[ProcessorOcrTextPrompt], [s].[ProcessorOcrTextShortPrompt], [s].[ProcessorRewriteTextPrompt], [s].[ProcessorRewriteTextShortPrompt], [s].[SendGridApiKey], [s].[Title], [s].[TotalCategories], [s].[TotalHosts], [s].[WikiLanguage]
FROM [Sites] AS [s] WITH (NOLOCK)
WHERE [s].[Deleted] = CAST(0 AS bit) AND EXISTS (
SELECT 1
FROM [SiteHosts] AS [s0]
WHERE [s].[Id] = [s0].[SiteId] AND [s0].[Host] = @__host_Host_0 AND [s0].[Active] = CAST(1 AS bit) AND [s0].[Deleted] = CAST(0 AS bit))
|
| 8. |
info: 2025-04-29 10:54:51.502 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
20ms [Parameters=[@__id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[CultureCode], [s].[Deleted], [s].[Description], [s].[Email], [s].[ProcessorGenerateImageCategoryPrompt], [s].[ProcessorGenerateImageQuestionPrompt], [s].[ProcessorGenerateImageTopicPrompt], [s].[ProcessorGenerateQuestionPrompt], [s].[ProcessorGenerateQuestionShortPrompt], [s].[ProcessorOcrTextPrompt], [s].[ProcessorOcrTextShortPrompt], [s].[ProcessorRewriteTextPrompt], [s].[ProcessorRewriteTextShortPrompt], [s].[SendGridApiKey], [s].[Title], [s].[TotalCategories], [s].[TotalHosts], [s].[WikiLanguage]
FROM [Sites] AS [s] WITH (NOLOCK)
WHERE [s].[Id] = @__id_0 AND [s].[Deleted] = CAST(0 AS bit)
|
| 9. |
info: 2025-04-29 10:54:51.689 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
177ms [Parameters=[@__parent_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Scanners] AS [s] WITH (NOLOCK)
WHERE [s].[SiteId] = @__parent_Id_0 AND [s].[Deleted] = CAST(0 AS bit)
|
| 10. |
info: 2025-04-29 10:54:51.700 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
30ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='2102', @__item_Right_2='2103'], 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]
|
| 11. |
info: 2025-04-29 10:54:51.770 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
71ms [Parameters=[@__parent_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__p_1='0', @__p_2='20'], CommandType='Text', CommandTimeout='30']
SELECT [s0].[Id], [s0].[Active], [s0].[CheatSheet], [s0].[CheatSheet2], [s0].[Deleted], [s0].[FactErrors], [s0].[FactErrorsExplanation], [s0].[ParentCategory2Id], [s0].[ParentCategoryId], [s0].[ProcessorGenerateImagePrompt], [s0].[Prompt], [s0].[Reference], [s0].[ReferenceSlug], [s0].[SiteId], [s0].[SpellingErrors], [s0].[SpellingErrorsExplanation], [s0].[Summary], [s0].[Summary2], [s0].[Title], [s0].[TitleBackup], [s0].[TitleSlug], [s0].[TotalCards], [s0].[TotalCards2], [s0].[TotalCategories], [s0].[TotalPages], [s0].[Verified], [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], [c0].[Id], [c0].[Active], [c0].[Deleted], [c0].[Description], [c0].[DescriptionBackup], [c0].[Left], [c0].[ParentId], [c0].[Position], [c0].[ProcessorGenerateImagePrompt], [c0].[Right], [c0].[SiteId], [c0].[StorageMediaName], [c0].[StorageMediaUrl], [c0].[Title], [c0].[TitleBackup], [c0].[TitleSlug], [c0].[TotalChildren], [c0].[TotalScanners], [c0].[TotalYoutubeVideos], [c1].[Id], [c1].[Active], [c1].[Deleted], [c1].[Description], [c1].[DescriptionBackup], [c1].[Left], [c1].[ParentId], [c1].[Position], [c1].[ProcessorGenerateImagePrompt], [c1].[Right], [c1].[SiteId], [c1].[StorageMediaName], [c1].[StorageMediaUrl], [c1].[Title], [c1].[TitleBackup], [c1].[TitleSlug], [c1].[TotalChildren], [c1].[TotalScanners], [c1].[TotalYoutubeVideos], [c2].[Id], [c2].[Active], [c2].[Deleted], [c2].[Description], [c2].[DescriptionBackup], [c2].[Left], [c2].[ParentId], [c2].[Position], [c2].[ProcessorGenerateImagePrompt], [c2].[Right], [c2].[SiteId], [c2].[StorageMediaName], [c2].[StorageMediaUrl], [c2].[Title], [c2].[TitleBackup], [c2].[TitleSlug], [c2].[TotalChildren], [c2].[TotalScanners], [c2].[TotalYoutubeVideos]
FROM (
SELECT [s].[Id], [s].[Active], [s].[CheatSheet], [s].[CheatSheet2], [s].[Deleted], [s].[FactErrors], [s].[FactErrorsExplanation], [s].[ParentCategory2Id], [s].[ParentCategoryId], [s].[ProcessorGenerateImagePrompt], [s].[Prompt], [s].[Reference], [s].[ReferenceSlug], [s].[SiteId], [s].[SpellingErrors], [s].[SpellingErrorsExplanation], [s].[Summary], [s].[Summary2], [s].[Title], [s].[TitleBackup], [s].[TitleSlug], [s].[TotalCards], [s].[TotalCards2], [s].[TotalCategories], [s].[TotalPages], [s].[Verified]
FROM [Scanners] AS [s] WITH (NOLOCK)
WHERE [s].[SiteId] = @__parent_Id_0 AND [s].[Deleted] = CAST(0 AS bit)
ORDER BY [s].[TitleSlug], [s].[ReferenceSlug]
OFFSET @__p_1 ROWS FETCH NEXT @__p_2 ROWS ONLY
) AS [s0]
LEFT JOIN [Categories] AS [c] ON [s0].[ParentCategoryId] = [c].[Id]
LEFT JOIN [Categories] AS [c0] ON [c].[ParentId] = [c0].[Id]
LEFT JOIN [Categories] AS [c1] ON [s0].[ParentCategory2Id] = [c1].[Id]
LEFT JOIN [Categories] AS [c2] ON [c1].[ParentId] = [c2].[Id]
ORDER BY [s0].[TitleSlug], [s0].[ReferenceSlug], [s0].[Id], [c].[Id], [c0].[Id], [c1].[Id], [c2].[Id]
|
| 12. |
info: 2025-04-29 10:54:51.922 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
26ms [Parameters=[@__parent_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__p_1='0', @__p_2='20'], CommandType='Text', CommandTimeout='30']
SELECT [s2].[Id], [s2].[Active], [s2].[Deleted], [s2].[Position], [s2].[ScannerId], [s2].[StorageMediaName], [s2].[StorageMediaUrl], [s2].[Text], [s0].[Id], [c].[Id], [c0].[Id], [c1].[Id], [c2].[Id]
FROM (
SELECT [s].[Id], [s].[ParentCategory2Id], [s].[ParentCategoryId], [s].[ReferenceSlug], [s].[TitleSlug]
FROM [Scanners] AS [s] WITH (NOLOCK)
WHERE [s].[SiteId] = @__parent_Id_0 AND [s].[Deleted] = CAST(0 AS bit)
ORDER BY [s].[TitleSlug], [s].[ReferenceSlug]
OFFSET @__p_1 ROWS FETCH NEXT @__p_2 ROWS ONLY
) AS [s0]
LEFT JOIN [Categories] AS [c] ON [s0].[ParentCategoryId] = [c].[Id]
LEFT JOIN [Categories] AS [c0] ON [c].[ParentId] = [c0].[Id]
LEFT JOIN [Categories] AS [c1] ON [s0].[ParentCategory2Id] = [c1].[Id]
LEFT JOIN [Categories] AS [c2] ON [c1].[ParentId] = [c2].[Id]
INNER JOIN (
SELECT [s1].[Id], [s1].[Active], [s1].[Deleted], [s1].[Position], [s1].[ScannerId], [s1].[StorageMediaName], [s1].[StorageMediaUrl], [s1].[Text]
FROM [ScannerPages] AS [s1]
WHERE [s1].[Deleted] = CAST(0 AS bit)
) AS [s2] ON [s0].[Id] = [s2].[ScannerId]
ORDER BY [s0].[TitleSlug], [s0].[ReferenceSlug], [s0].[Id], [c].[Id], [c0].[Id], [c1].[Id], [c2].[Id], [s2].[Position]
|
| 13. |
info: 2025-04-29 10:54:52.217 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
20ms [Parameters=[@__parent_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__p_1='0', @__p_2='20'], CommandType='Text', CommandTimeout='30']
SELECT [s3].[ScannerId], [s3].[CategoryId], [s3].[Id], [s3].[Active], [s3].[Deleted], [s3].[Description], [s3].[DescriptionBackup], [s3].[Left], [s3].[ParentId], [s3].[Position], [s3].[ProcessorGenerateImagePrompt], [s3].[Right], [s3].[SiteId], [s3].[StorageMediaName], [s3].[StorageMediaUrl], [s3].[Title], [s3].[TitleBackup], [s3].[TitleSlug], [s3].[TotalChildren], [s3].[TotalScanners], [s3].[TotalYoutubeVideos], [s3].[Id0], [s3].[Active0], [s3].[Deleted0], [s3].[Description0], [s3].[DescriptionBackup0], [s3].[Left0], [s3].[ParentId0], [s3].[Position0], [s3].[ProcessorGenerateImagePrompt0], [s3].[Right0], [s3].[SiteId0], [s3].[StorageMediaName0], [s3].[StorageMediaUrl0], [s3].[Title0], [s3].[TitleBackup0], [s3].[TitleSlug0], [s3].[TotalChildren0], [s3].[TotalScanners0], [s3].[TotalYoutubeVideos0], [s3].[Id1], [s3].[Active1], [s3].[Deleted1], [s3].[Description1], [s3].[DescriptionBackup1], [s3].[Left1], [s3].[ParentId1], [s3].[Position1], [s3].[ProcessorGenerateImagePrompt1], [s3].[Right1], [s3].[SiteId1], [s3].[StorageMediaName1], [s3].[StorageMediaUrl1], [s3].[Title1], [s3].[TitleBackup1], [s3].[TitleSlug1], [s3].[TotalChildren1], [s3].[TotalScanners1], [s3].[TotalYoutubeVideos1], [s3].[Id2], [s3].[Active2], [s3].[Deleted2], [s3].[Description2], [s3].[DescriptionBackup2], [s3].[Left2], [s3].[ParentId2], [s3].[Position2], [s3].[ProcessorGenerateImagePrompt2], [s3].[Right2], [s3].[SiteId2], [s3].[StorageMediaName2], [s3].[StorageMediaUrl2], [s3].[Title2], [s3].[TitleBackup2], [s3].[TitleSlug2], [s3].[TotalChildren2], [s3].[TotalScanners2], [s3].[TotalYoutubeVideos2], [s3].[Id3], [s3].[Active3], [s3].[Deleted3], [s3].[Description3], [s3].[DescriptionBackup3], [s3].[Left3], [s3].[ParentId3], [s3].[Position3], [s3].[ProcessorGenerateImagePrompt3], [s3].[Right3], [s3].[SiteId3], [s3].[StorageMediaName3], [s3].[StorageMediaUrl3], [s3].[Title3], [s3].[TitleBackup3], [s3].[TitleSlug3], [s3].[TotalChildren3], [s3].[TotalScanners3], [s3].[TotalYoutubeVideos3], [s0].[Id], [c].[Id], [c0].[Id], [c1].[Id], [c2].[Id]
FROM (
SELECT [s].[Id], [s].[ParentCategory2Id], [s].[ParentCategoryId], [s].[ReferenceSlug], [s].[TitleSlug]
FROM [Scanners] AS [s] WITH (NOLOCK)
WHERE [s].[SiteId] = @__parent_Id_0 AND [s].[Deleted] = CAST(0 AS bit)
ORDER BY [s].[TitleSlug], [s].[ReferenceSlug]
OFFSET @__p_1 ROWS FETCH NEXT @__p_2 ROWS ONLY
) AS [s0]
LEFT JOIN [Categories] AS [c] ON [s0].[ParentCategoryId] = [c].[Id]
LEFT JOIN [Categories] AS [c0] ON [c].[ParentId] = [c0].[Id]
LEFT JOIN [Categories] AS [c1] ON [s0].[ParentCategory2Id] = [c1].[Id]
LEFT JOIN [Categories] AS [c2] ON [c1].[ParentId] = [c2].[Id]
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [c4].[Id], [c4].[Active], [c4].[Deleted], [c4].[Description], [c4].[DescriptionBackup], [c4].[Left], [c4].[ParentId], [c4].[Position], [c4].[ProcessorGenerateImagePrompt], [c4].[Right], [c4].[SiteId], [c4].[StorageMediaName], [c4].[StorageMediaUrl], [c4].[Title], [c4].[TitleBackup], [c4].[TitleSlug], [c4].[TotalChildren], [c4].[TotalScanners], [c4].[TotalYoutubeVideos], [c5].[Id] AS [Id0], [c5].[Active] AS [Active0], [c5].[Deleted] AS [Deleted0], [c5].[Description] AS [Description0], [c5].[DescriptionBackup] AS [DescriptionBackup0], [c5].[Left] AS [Left0], [c5].[ParentId] AS [ParentId0], [c5].[Position] AS [Position0], [c5].[ProcessorGenerateImagePrompt] AS [ProcessorGenerateImagePrompt0], [c5].[Right] AS [Right0], [c5].[SiteId] AS [SiteId0], [c5].[StorageMediaName] AS [StorageMediaName0], [c5].[StorageMediaUrl] AS [StorageMediaUrl0], [c5].[Title] AS [Title0], [c5].[TitleBackup] AS [TitleBackup0], [c5].[TitleSlug] AS [TitleSlug0], [c5].[TotalChildren] AS [TotalChildren0], [c5].[TotalScanners] AS [TotalScanners0], [c5].[TotalYoutubeVideos] AS [TotalYoutubeVideos0], [c6].[Id] AS [Id1], [c6].[Active] AS [Active1], [c6].[Deleted] AS [Deleted1], [c6].[Description] AS [Description1], [c6].[DescriptionBackup] AS [DescriptionBackup1], [c6].[Left] AS [Left1], [c6].[ParentId] AS [ParentId1], [c6].[Position] AS [Position1], [c6].[ProcessorGenerateImagePrompt] AS [ProcessorGenerateImagePrompt1], [c6].[Right] AS [Right1], [c6].[SiteId] AS [SiteId1], [c6].[StorageMediaName] AS [StorageMediaName1], [c6].[StorageMediaUrl] AS [StorageMediaUrl1], [c6].[Title] AS [Title1], [c6].[TitleBackup] AS [TitleBackup1], [c6].[TitleSlug] AS [TitleSlug1], [c6].[TotalChildren] AS [TotalChildren1], [c6].[TotalScanners] AS [TotalScanners1], [c6].[TotalYoutubeVideos] AS [TotalYoutubeVideos1], [c7].[Id] AS [Id2], [c7].[Active] AS [Active2], [c7].[Deleted] AS [Deleted2], [c7].[Description] AS [Description2], [c7].[DescriptionBackup] AS [DescriptionBackup2], [c7].[Left] AS [Left2], [c7].[ParentId] AS [ParentId2], [c7].[Position] AS [Position2], [c7].[ProcessorGenerateImagePrompt] AS [ProcessorGenerateImagePrompt2], [c7].[Right] AS [Right2], [c7].[SiteId] AS [SiteId2], [c7].[StorageMediaName] AS [StorageMediaName2], [c7].[StorageMediaUrl] AS [StorageMediaUrl2], [c7].[Title] AS [Title2], [c7].[TitleBackup] AS [TitleBackup2], [c7].[TitleSlug] AS [TitleSlug2], [c7].[TotalChildren] AS [TotalChildren2], [c7].[TotalScanners] AS [TotalScanners2], [c7].[TotalYoutubeVideos] AS [TotalYoutubeVideos2], [c8].[Id] AS [Id3], [c8].[Active] AS [Active3], [c8].[Deleted] AS [Deleted3], [c8].[Description] AS [Description3], [c8].[DescriptionBackup] AS [DescriptionBackup3], [c8].[Left] AS [Left3], [c8].[ParentId] AS [ParentId3], [c8].[Position] AS [Position3], [c8].[ProcessorGenerateImagePrompt] AS [ProcessorGenerateImagePrompt3], [c8].[Right] AS [Right3], [c8].[SiteId] AS [SiteId3], [c8].[StorageMediaName] AS [StorageMediaName3], [c8].[StorageMediaUrl] AS [StorageMediaUrl3], [c8].[Title] AS [Title3], [c8].[TitleBackup] AS [TitleBackup3], [c8].[TitleSlug] AS [TitleSlug3], [c8].[TotalChildren] AS [TotalChildren3], [c8].[TotalScanners] AS [TotalScanners3], [c8].[TotalYoutubeVideos] AS [TotalYoutubeVideos3]
FROM [CategoryScanners] AS [c3]
INNER JOIN [Categories] AS [c4] ON [c3].[CategoryId] = [c4].[Id]
LEFT JOIN [Categories] AS [c5] ON [c4].[ParentId] = [c5].[Id]
LEFT JOIN [Categories] AS [c6] ON [c5].[ParentId] = [c6].[Id]
LEFT JOIN [Categories] AS [c7] ON [c6].[ParentId] = [c7].[Id]
LEFT JOIN [Categories] AS [c8] ON [c7].[ParentId] = [c8].[Id]
) AS [s3] ON [s0].[Id] = [s3].[ScannerId]
ORDER BY [s0].[TitleSlug], [s0].[ReferenceSlug], [s0].[Id], [c].[Id], [c0].[Id], [c1].[Id], [c2].[Id]
|
| 14. |
info: 2025-04-29 10:54:52.632 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__id_0='8ecd938d-c6b6-cf3e-87e2-4b03a6bc4136', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], 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].[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]
|
| 15. |
info: 2025-04-29 10:54:52.634 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
1ms [Parameters=[@__id_0='8ecd938d-c6b6-cf3e-87e2-4b03a6bc4136', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [c4].[Id], [c4].[Active], [c4].[Deleted], [c4].[Description], [c4].[DescriptionBackup], [c4].[Left], [c4].[ParentId], [c4].[Position], [c4].[ProcessorGenerateImagePrompt], [c4].[Right], [c4].[SiteId], [c4].[StorageMediaName], [c4].[StorageMediaUrl], [c4].[Title], [c4].[TitleBackup], [c4].[TitleSlug], [c4].[TotalChildren], [c4].[TotalScanners], [c4].[TotalYoutubeVideos], [c].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c0].[Id], [c0].[Active], [c0].[Deleted], [c0].[Description], [c0].[DescriptionBackup], [c0].[Left], [c0].[ParentId], [c0].[Position], [c0].[ProcessorGenerateImagePrompt], [c0].[Right], [c0].[SiteId], [c0].[StorageMediaName], [c0].[StorageMediaUrl], [c0].[Title], [c0].[TitleBackup], [c0].[TitleSlug], [c0].[TotalChildren], [c0].[TotalScanners], [c0].[TotalYoutubeVideos]
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]
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]
|
| 16. |
info: 2025-04-29 10:54:52.641 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__id_0='8ecd938d-c6b6-cf3e-87e2-4b03a6bc4136', @__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].[Summary2], [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].[Summary2], [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]
|
| 17. |
info: 2025-04-29 10:54:52.644 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
1ms [Parameters=[@__id_0='8ecd938d-c6b6-cf3e-87e2-4b03a6bc4136', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s6].[Id], [s6].[Active], [s6].[Context], [s6].[ContextBackup], [s6].[ContextStorageMediaName], [s6].[ContextStorageMediaUrl], [s6].[Deleted], [s6].[FactErrors], [s6].[FactErrorsExplanation], [s6].[Facts], [s6].[FactsBackup], [s6].[FactsStorageMediaName], [s6].[FactsStorageMediaUrl], [s6].[Position], [s6].[ProcessorGenerateImagePrompt], [s6].[Prompt], [s6].[ScannerId], [s6].[SpellingErrors], [s6].[SpellingErrorsExplanation], [s6].[StorageMediaName], [s6].[StorageMediaUrl], [s6].[Summary], [s6].[SummaryBackup], [s6].[SummaryStorageMediaName], [s6].[SummaryStorageMediaUrl], [s6].[Title], [s6].[TitleSlug], [s6].[TotalFillTheBlankSelectionQuestions], [s6].[TotalMultipleSelectionQuestions], [s6].[TotalOrderingQuestions], [s6].[TotalQuestionPoints], [s6].[TotalQuestions], [s6].[TotalShortAnswerQuestions], [s6].[TotalSingleSelectionQuestions], [s6].[TotalSources], [s6].[TotalTrueFalseQuestions], [s6].[Verified], [s6].[Version], [c].[Id], [s5].[ScannerId], [s5].[CategoryId], [s5].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id]
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]
INNER JOIN (
SELECT [s2].[Id], [s2].[Active], [s2].[Context], [s2].[ContextBackup], [s2].[ContextStorageMediaName], [s2].[ContextStorageMediaUrl], [s2].[Deleted], [s2].[FactErrors], [s2].[FactErrorsExplanation], [s2].[Facts], [s2].[FactsBackup], [s2].[FactsStorageMediaName], [s2].[FactsStorageMediaUrl], [s2].[Position], [s2].[ProcessorGenerateImagePrompt], [s2].[Prompt], [s2].[ScannerId], [s2].[SpellingErrors], [s2].[SpellingErrorsExplanation], [s2].[StorageMediaName], [s2].[StorageMediaUrl], [s2].[Summary], [s2].[SummaryBackup], [s2].[SummaryStorageMediaName], [s2].[SummaryStorageMediaUrl], [s2].[Title], [s2].[TitleSlug], [s2].[TotalFillTheBlankSelectionQuestions], [s2].[TotalMultipleSelectionQuestions], [s2].[TotalOrderingQuestions], [s2].[TotalQuestionPoints], [s2].[TotalQuestions], [s2].[TotalShortAnswerQuestions], [s2].[TotalSingleSelectionQuestions], [s2].[TotalSources], [s2].[TotalTrueFalseQuestions], [s2].[Verified], [s2].[Version]
FROM [ScannerCards] AS [s2]
WHERE [s2].[Active] = CAST(1 AS bit) AND [s2].[Deleted] = CAST(0 AS bit)
) AS [s6] ON [s5].[Id] = [s6].[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], [s5].[Id], [s5].[ScannerId], [s5].[CategoryId], [s6].[TitleSlug], [s6].[Id]
|
| 18. |
info: 2025-04-29 10:54:52.653 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
1ms [Parameters=[@__id_0='8ecd938d-c6b6-cf3e-87e2-4b03a6bc4136', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [q0].[Id], [q0].[Active], [q0].[Created], [q0].[Deleted], [q0].[Points], [q0].[ProcessorGenerateImagePrompt], [q0].[ScannerCardId], [q0].[StorageMediaName], [q0].[StorageMediaUrl], [q0].[Title], [q0].[TotalAnswers], [q0].[Type], [c].[Id], [s5].[ScannerId], [s5].[CategoryId], [s5].[Id], [s6].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id]
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]
INNER JOIN (
SELECT [s2].[Id], [s2].[ScannerId], [s2].[TitleSlug]
FROM [ScannerCards] AS [s2]
WHERE [s2].[Active] = CAST(1 AS bit) AND [s2].[Deleted] = CAST(0 AS bit)
) AS [s6] ON [s5].[Id] = [s6].[ScannerId]
INNER JOIN (
SELECT [q].[Id], [q].[Active], [q].[Created], [q].[Deleted], [q].[Points], [q].[ProcessorGenerateImagePrompt], [q].[ScannerCardId], [q].[StorageMediaName], [q].[StorageMediaUrl], [q].[Title], [q].[TotalAnswers], [q].[Type]
FROM [Questions] AS [q]
WHERE [q].[Active] = CAST(1 AS bit) AND [q].[Deleted] = CAST(0 AS bit)
) AS [q0] ON [s6].[Id] = [q0].[ScannerCardId]
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], [s6].[TitleSlug], [s6].[Id], [q0].[Id]
|
| 19. |
info: 2025-04-29 10:54:52.671 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
18ms [Parameters=[@__id_0='8ecd938d-c6b6-cf3e-87e2-4b03a6bc4136', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s7].[TagId], [s7].[ScannerCardId], [s7].[Id], [s7].[Active], [s7].[Created], [s7].[Deleted], [s7].[Description], [s7].[Links], [s7].[MediaSourceCopyright], [s7].[MediaSourceUrl], [s7].[ShortDescription], [s7].[SiteId], [s7].[StorageMediaName], [s7].[StorageMediaUrl], [s7].[Title], [s7].[TitleSlug], [s7].[Url], [s7].[Wikipedia], [s7].[WikipediaPageId], [s7].[WikipediaUpdated], [c].[Id], [s5].[ScannerId], [s5].[CategoryId], [s5].[Id], [s6].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id]
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]
INNER JOIN (
SELECT [s2].[Id], [s2].[ScannerId], [s2].[TitleSlug]
FROM [ScannerCards] AS [s2]
WHERE [s2].[Active] = CAST(1 AS bit) AND [s2].[Deleted] = CAST(0 AS bit)
) AS [s6] ON [s5].[Id] = [s6].[ScannerId]
INNER JOIN (
SELECT [t].[TagId], [t].[ScannerCardId], [t0].[Id], [t0].[Active], [t0].[Created], [t0].[Deleted], [t0].[Description], [t0].[Links], [t0].[MediaSourceCopyright], [t0].[MediaSourceUrl], [t0].[ShortDescription], [t0].[SiteId], [t0].[StorageMediaName], [t0].[StorageMediaUrl], [t0].[Title], [t0].[TitleSlug], [t0].[Url], [t0].[Wikipedia], [t0].[WikipediaPageId], [t0].[WikipediaUpdated]
FROM [TagScannerCards] AS [t]
INNER JOIN [Tags] AS [t0] ON [t].[TagId] = [t0].[Id]
WHERE [t0].[Active] = CAST(1 AS bit) AND [t0].[Deleted] = CAST(0 AS bit)
) AS [s7] ON [s6].[Id] = [s7].[ScannerCardId]
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], [s6].[TitleSlug], [s6].[Id], [s7].[TitleSlug]
|
| 20. |
info: 2025-04-29 10:54:52.759 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='9366', @__item_Right_2='9367'], 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]
|
| 465 ms |
