| 1. |
info: 2025-04-29 08:23:36.016 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__id_0='77274c13-64c7-430f-8041-c81fba3509f9'], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [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], [s0].[Id], [s0].[CultureCode], [s0].[Deleted], [s0].[Description], [s0].[Email], [s0].[ProcessorGenerateImageCategoryPrompt], [s0].[ProcessorGenerateImageQuestionPrompt], [s0].[ProcessorGenerateImageTopicPrompt], [s0].[ProcessorGenerateQuestionPrompt], [s0].[ProcessorGenerateQuestionShortPrompt], [s0].[ProcessorOcrTextPrompt], [s0].[ProcessorOcrTextShortPrompt], [s0].[ProcessorRewriteTextPrompt], [s0].[ProcessorRewriteTextShortPrompt], [s0].[SendGridApiKey], [s0].[Title], [s0].[TotalCategories], [s0].[TotalHosts], [s0].[WikiLanguage]
FROM [Scanners] AS [s] WITH (NOLOCK)
INNER JOIN [Sites] AS [s0] ON [s].[SiteId] = [s0].[Id]
WHERE [s].[Id] = @__id_0 AND [s].[Deleted] = CAST(0 AS bit)
|
| 2. |
info: 2025-04-29 08:23:36.056 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
31ms [Parameters=[@__parent_Id_0='77274c13-64c7-430f-8041-c81fba3509f9'], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [ScannerPages] AS [s] WITH (NOLOCK)
WHERE [s].[ScannerId] = @__parent_Id_0 AND [s].[Deleted] = CAST(0 AS bit)
|
| 3. |
info: 2025-04-29 08:23:36.065 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
18ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='1728', @__item_Right_2='1729'], 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]
|
| 4. |
info: 2025-04-29 08:23:36.066 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
10ms [Parameters=[@__parent_Id_0='77274c13-64c7-430f-8041-c81fba3509f9', @__p_1='0', @__p_2='20'], CommandType='Text', CommandTimeout='30']
SELECT [s1].[Id], [s1].[Active], [s1].[Deleted], [s1].[Position], [s1].[ScannerId], [s1].[StorageMediaName], [s1].[StorageMediaUrl], [s1].[Text], [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]
FROM (
SELECT [s].[Id], [s].[Active], [s].[Deleted], [s].[Position], [s].[ScannerId], [s].[StorageMediaName], [s].[StorageMediaUrl], [s].[Text]
FROM [ScannerPages] AS [s] WITH (NOLOCK)
WHERE [s].[ScannerId] = @__parent_Id_0 AND [s].[Deleted] = CAST(0 AS bit)
ORDER BY [s].[Position]
OFFSET @__p_1 ROWS FETCH NEXT @__p_2 ROWS ONLY
) AS [s1]
INNER JOIN [Scanners] AS [s0] ON [s1].[ScannerId] = [s0].[Id]
ORDER BY [s1].[Position]
|
| 67 ms |
