| 2. |
info: 2025-04-29 08:08:18.071 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
47ms [Parameters=[@__p_0='1'], CommandType='Text', CommandTimeout='30']
SELECT [s2].[Id], [s2].[Active], [s2].[CheatSheet], [s2].[CheatSheet2], [s2].[Deleted], [s2].[FactErrors], [s2].[FactErrorsExplanation], [s2].[ParentCategory2Id], [s2].[ParentCategoryId], [s2].[ProcessorGenerateImagePrompt], [s2].[Prompt], [s2].[Reference], [s2].[ReferenceSlug], [s2].[SiteId], [s2].[SpellingErrors], [s2].[SpellingErrorsExplanation], [s2].[Summary], [s2].[Summary2], [s2].[Title], [s2].[TitleBackup], [s2].[TitleSlug], [s2].[TotalCards], [s2].[TotalCards2], [s2].[TotalCategories], [s2].[TotalPages], [s2].[Verified], [s1].[Id], [s1].[CultureCode], [s1].[Deleted], [s1].[Description], [s1].[Email], [s1].[ProcessorGenerateImageCategoryPrompt], [s1].[ProcessorGenerateImageQuestionPrompt], [s1].[ProcessorGenerateImageTopicPrompt], [s1].[ProcessorGenerateQuestionPrompt], [s1].[ProcessorGenerateQuestionShortPrompt], [s1].[ProcessorOcrTextPrompt], [s1].[ProcessorOcrTextShortPrompt], [s1].[ProcessorRewriteTextPrompt], [s1].[ProcessorRewriteTextShortPrompt], [s1].[SendGridApiKey], [s1].[Title], [s1].[TotalCategories], [s1].[TotalHosts], [s1].[WikiLanguage], [s4].[Id], [s4].[Active], [s4].[Deleted], [s4].[Position], [s4].[ScannerId], [s4].[StorageMediaName], [s4].[StorageMediaUrl], [s4].[Text]
FROM (
SELECT TOP(@__p_0) [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]
WHERE ([s].[Summary] IS NULL OR [s].[Summary] LIKE N'') AND 0 <> [s].[TotalPages] AND EXISTS (
SELECT 1
FROM [ScannerPages] AS [s0]
WHERE [s].[Id] = [s0].[ScannerId] AND [s0].[Deleted] = CAST(0 AS bit)) AND [s].[Deleted] = CAST(0 AS bit)
ORDER BY [s].[Id] DESC
) AS [s2]
INNER JOIN [Sites] AS [s1] ON [s2].[SiteId] = [s1].[Id]
LEFT JOIN (
SELECT [s3].[Id], [s3].[Active], [s3].[Deleted], [s3].[Position], [s3].[ScannerId], [s3].[StorageMediaName], [s3].[StorageMediaUrl], [s3].[Text]
FROM [ScannerPages] AS [s3]
WHERE [s3].[Text] IS NOT NULL AND [s3].[Text] NOT LIKE N'' AND [s3].[Deleted] = CAST(0 AS bit)
) AS [s4] ON [s2].[Id] = [s4].[ScannerId]
ORDER BY [s2].[Id] DESC, [s1].[Id], [s4].[Position]
|
| 3. |
info: 2025-04-29 08:08:18.134 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
103ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='10032', @__item_Right_2='10033'], 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]
|
