| 1. |
info: 2025-04-25 15:23:06.647 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
39ms [Parameters=[@__id_0='66c30fae-e282-24aa-24a5-0ea86b23852d', @__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-25 15:23:06.648 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
126ms [Parameters=[@__id_0='27714787-4c61-b3d9-1641-11a9ba0f4f97', @__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]
|
| 3. |
info: 2025-04-25 15:23:06.668 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
21ms [Parameters=[@__id_0='66c30fae-e282-24aa-24a5-0ea86b23852d', @__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]
|
| 4. |
info: 2025-04-25 15:23:06.724 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
40ms [Parameters=[@__id_0='27714787-4c61-b3d9-1641-11a9ba0f4f97', @__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-25 15:23:06.734 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
9ms [Parameters=[@__id_0='27714787-4c61-b3d9-1641-11a9ba0f4f97', @__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-25 15:23:06.735 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
66ms [Parameters=[@__id_0='66c30fae-e282-24aa-24a5-0ea86b23852d', @__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]
|
| 7. |
info: 2025-04-25 15:23:06.763 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
29ms [Parameters=[@__id_0='27714787-4c61-b3d9-1641-11a9ba0f4f97', @__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]
|
| 8. |
info: 2025-04-25 15:23:06.805 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
20ms [Parameters=[@__id_0='66c30fae-e282-24aa-24a5-0ea86b23852d', @__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]
|
| 9. |
info: 2025-04-25 15:23:06.959 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
152ms [Parameters=[@__id_0='66c30fae-e282-24aa-24a5-0ea86b23852d', @__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]
|
| 10. |
info: 2025-04-25 15:23:06.979 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
20ms [Parameters=[@__id_0='66c30fae-e282-24aa-24a5-0ea86b23852d', @__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]
|
| 11. |
info: 2025-04-25 15:23:08.701 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
1,635ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='15754', @__item_Right_2='15755'], 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]
|
| 12. |
info: 2025-04-25 15:23:08.874 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
173ms [Parameters=[@p24='386be161-96e7-4871-9c82-905934b520cb', @p0='True', @p1='##### Anglies buvimo organinėse medžiagose įrodymas
| Bandymas | Aprašymas | Rezultatas |
| --------- | ----------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| 1 | Nedidelio kiekio krakmolo arba cukraus kaitinimas spiritinės lemputės ar dujų degiklio liepsnoje. | Medžiaga pajuoduoja, susidaro anglis ($$C$$). |
| 2 | Medinės skalelės arba balto popieriaus juostelės įmerkimas į koncentruotą sieros rūgštį ($$H_2SO_4$$). | Pamirkta dalis pajuoduoja – suanglėja (rūgštis atima vandenį). |
##### Junginių skirstymas
| Junginių tipas | Pavyzdžiai |
| --------------------- | -------------------------------------------------------------------------- |
| Neorganiniai junginiai | $$CaO$$, $$CO_2$$, $$K_2CO_3$$, $$NaCl$$, $$HNO_3$$ |
| Organiniai junginiai | $$CH_4$$, $$CH_3COOH$$, $$C_6H_{12}O_6$$, $$C_2H_5OH$$, $$CH_3Cl$$ |
##### Molekulių ir atomų skaičius viename molyje
Avogadro konstanta: $$N_A \approx 6,022 \times 10^{23}$$ mol⁻¹
| Junginys | Atomų skaičius molekulėje | Molekulių skaičius 1 molyje ($$N_A$$) | Molekulių skaičius 0,5 molio ($$0,5 \times N_A$$) | Molekulių skaičius 3 molyje ($$3 \times N_A$$) |
| --------------------- | ------------------------ | ------------------------------------- | ------------------------------------------------- | ---------------------------------------------- |
| $$CO_2$$ | 3 | $$6,022 \times 10^{23}$$ | $$3,011 \times 10^{23}$$ | $$1,8066 \times 10^{24}$$ |
| $$CH_4$$ | 5 | $$6,022 \times 10^{23}$$ | $$3,011 \times 10^{23}$$ | $$1,8066 \times 10^{24}$$ |
| $$CH_3COOH$$ | 8 | $$6,022 \times 10^{23}$$ | $$3,011 \times 10^{23}$$ | $$1,8066 \times 10^{24}$$ |
| $$C_6H_{12}O_6$$ | 24 | $$6,022 \times 10^{23}$$ | $$3,011 \times 10^{23}$$ | $$1,8066 \times 10^{24}$$ |
| $$HNO_3$$ | 5 | $$6,022 \times 10^{23}$$ | $$3,011 \times 10^{23}$$ | $$1,8066 \times 10^{24}$$ |
| $$C_2H_5OH$$ | 9 | $$6,022 \times 10^{23}$$ | $$3,011 \times 10^{23}$$ | $$1,8066 \times 10^{24}$$ |
##### Bendras atomų skaičius nurodytame medžiagos kiekyje
Skaičiavimo formulė: Bendras atomų skaičius = (medžiagos kiekis m)¶ × (atomų skaičius 1 molekulėje) × $$N_A$$
| Junginys | Atomų sk. 1 molekulėje | Atomų skaičius 2 molyje | Atomų skaičius 0,1 molio | Atomų skaičius 5 molyje |
| ---------------------------- | ----------------------- | ---------------------------------- | ---------------------------------- | ---------------------------------- |
| $$CH_4$$ (metanas) | 5 | $$6,022 \times 10^{24}$$ | $$3,011 \times 10^{23}$$ | $$1,5055 \times 10^{25}$$ |
| $$C_6H_6$$ (benzenas) | 12 | $$1,4453 \times 10^{25}$$ | $$7,2264 \times 10^{23}$$ | $$3,6132 \times 10^{25}$$ |
| $$C_{12}H_{22}O_{11}$$ (sacharozė) | 45 | $$5,4198 \times 10^{25}$$ | $$2,7099 \times 10^{24}$$ | $$1,35495 \times 10^{26}$$ |
##### Didelės organinių junginių įvairovės priežastys
| Priežastis | Aprašymas |
| -------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Anglies atomo sandara ir valentingumas | Anglies atomas turi keturis valentinius elektronus ir yra keturvalentis organiniuose junginiuose. Gali sudaryti stiprius kovalentinius ryšius su kitais atomais. |
| Anglies atomų gebėjimas jungtis tarpusavyje (katenacija) | Anglies atomai gali jungtis vienas su kitu sudarydami įvairaus ilgio ir formos grandines (tiesias, šakotas) bei žiedus (ciklines struktūras). |
| Gebėjimas sudaryti įvairius ryšius | Tarp anglies atomų gali susidaryti viengubieji ($$C-C$$), dvigubieji ($$C=C$$) ir trigubieji ($$C \equiv C$$) kovalentiniai ryšiai. |
| Izomerija | Egzistuoja junginiai (izomerai), turintys tą pačią molekulinę formulę (kokybinę ir kiekybinę sudėtį), bet skirtingą struktūrą ir savybes. |
| Kitų elementų ir funkcinių grupių įvairovė | Organinių junginių molekulėse be anglies ir vandenilio dažnai būna deguonies, azoto, sieros, fosforo, halogenų atomų. Funkcinės grupės suteikia junginiams specifinių savybių. |
##### Anglies atomų jungimosi būdai (grandinės ir ciklai)
| Struktūros tipas | Pavyzdžiai |
| ----------------------- | ---------------------------------------------------------------------------------------------------------------------------- |
| Tiesiosios nešakotosios | $$C-C-C-C$$, $$C-C=C-C$$, $$C \equiv C-C-C$$ |
| Šakotosios | $$CH_3-CH(CH_3)-CH_3$$ (2-metilpropanas, arba izobutanas), $$CH_3-C(CH_3)_2-CH_3$$ (2,2-dimetilpropanas, arba neopentanas) |
| Ciklinės (uždaros) | Ciklopropanas ($$C_3H_6$$), cikloheksanas ($$C_6H_{12}$$), benzenas ($$C_6H_6$$) |
##### Kovalentiniai ryšiai
| Ryšio tipas | Aprašymas | Pavyzdys |
| --------------- | ----------------------------------------------------- | ------------------------------- |
| Viengubasis | Viena bendra elektronų pora tarp atomų. | $$H-H$$, $$H-Cl$$, $$C-C$$, $$C-H$$ |
| Dvigubasis | Dvi bendros elektronų poros tarp atomų. | $$O=O$$, $$C=C$$, $$C=O$$ |
| Trigubasis | Trys bendros elektronų poros tarp atomų. | $$N \equiv N$$, $$C \equiv C$$ |
##### Elementų valentingumas organiniuose junginiuose
| Elementas | Įprastas valentingumas |
| ---------------- | ---------------------- |
| Anglis ($$C$$) | 4 |
| Vandenilis ($$H$$) | 1 |
| Deguonis ($$O$$) | 2 |
| Azotas ($$N$$) | 3 |
| Halogenai ($$F, Cl, Br, I$$) | 1 |
| Siera ($$S$$) | 2 (gali būti ir aukštesnis) |
##### Pagrindinės sąvokos
| Sąvoka | Apibrėžimas |
| ---------------------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| Valentingumas | Atomo savybė sudaryti tam tikrą skaičių kovalentinių ryšių. |
| Organinė chemija | Chemijos šaka, tirianti anglies junginius, jų struktūrą, savybes, sintezę ir reakcijas (išskyrus paprasčiausius anglies junginius, pvz., $$CO$$, $$CO_2$$, karbonatus, cianidus). |
| Izomerai | Junginiai, turintys tokią pačią molekulinę formulę (tą patį atomų rinkinį), bet skirtingą atomų sujungimo tvarką molekulėje arba erdvinį išsidėstymą. |
| Funkcinė grupė | Specifinė atomų grupė organinio junginio molekulėje, lemianti būdingas chemines savybes ir junginio priskyrimą tam tikrai klasei (pvz., -OH, -COOH, -$$NH_2$$). |
| Katenacija | Tos pačios rūšies atomų (ypač anglies) gebėjimas jungtis į grandines. |' (Size = -1), @p2='##### Organinių medžiagų sudėties įrodymas
| Bandymas | Aprašymas | Rezultatas / Išvada |
| :---------------------------------------------------------- | :------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | :----------------------------------------------------------------------------------------------------------------- |
| **1. Krakmolo / cukraus kaitinimas** | Nedidelis kiekis medžiagos kaitinamas liepsnoje. | Medžiaga pajuoduoja (susidaro anglis). Anglis yra trapi, netirpsta vandenyje. Įrodo anglies buvimą. |
| **2. Medinės skalelės / popieriaus reakcija su H₂SO₄ konc.** | Į koncentruotą sieros rūgštį įmerkiama medinė skalelė arba popieriaus juostelė. | Pamerkta dalis greitai pajuoduoja (suanglėja). Įrodo anglies buvimą organinėje medžiagoje (celiuliozėje). |
##### Junginių skirstymas (pavyzdžiai)
| Neorganiniai junginiai | Organiniai junginiai |
| :--------------------- | :------------------------------------------------------------------ |
| $$CaO$$ | $$CH₄$$ (metanas) |
| $$CO₂$$ | $$CH₃COOH$$ (acto rūgštis) |
| $$K₂CO₃$$ | $$C₆H₁₂O₆$$ (gliukozė) |
| $$NaCl$$ | $$C₂H₅OH$$ (etanolis) |
| $$HNO₃$$ | $$CH₃Cl$$ (chlormetanas) |
##### Molekulių sudėtis ir skaičiavimai
| Junginio formulė | Atomų skaičius molekulėje | Medžiagos kiekis | Molekulių / Atomų skaičius |
| :--------------- | :------------------------ | :--------------- | :---------------------------------------------------------------- |
| $$CO₂$$ | 3 | - | - |
| $$CH₄$$ | 5 | 2 mol | $$10 \times (6.022 \times 10^{23}) = 6.022 \times 10^{24}$$ atomų |
| $$CH₃COOH$$ | 8 | 1 mol | $$6.022 \times 10^{23}$$ molekulių |
| $$C₆H₁₂O₆$$ | 24 | 3 mol | $$3 \times (6.022 \times 10^{23}) = 1.8066 \times 10^{24}$$ molekulių |
| $$HNO₃$$ | 5 | - | - |
| $$C₂H₅OH$$ | 9 | 0.5 mol | $$0.5 \times (6.022 \times 10^{23}) = 3.011 \times 10^{23}$$ molekulių |
| $$C₆H₆$$ | 12 | 0.1 mol | $$0.1 \times 12 \times (6.022 \times 10^{23}) = 7.2264 \times 10^{23}$$ atomų |
| $$C₁₂H₂₂O₁₁$$ | 45 | 5 mol | $$5 \times 45 \times (6.022 \times 10^{23}) = 1.35495 \times 10^{26}$$ atomų |
*Pastaba: Anglies masės dalis yra didesnė metane ($$CH₄$$) nei anglies diokside ($$CO₂$$).*
##### Organinių junginių įvairovės priežastys
| Priežastis | Paaiškinimas |
| :-------------------------------------------- | :-------------------------------------------------------------------------------------------------------------------------------------- |
| **Anglies atomo sandara** | Turi 4 išorinio sluoksnio (valentinius) elektronus. |
| **Gebėjimas sudaryti kovalentinius ryšius** | Anglies atomai gali jungtis kovalentiniais ryšiais tarpusavyje ir su kitų elementų atomais. |
| **Įvairūs ryšiai tarp anglies atomų** | Gali sudaryti viengubuosius (C-C), dvigubuosius (C=C) ir trigubuosius (C≡C) ryšius. |
| **Grandininių struktūrų formavimas** | Anglies atomai gali jungtis į įvairaus ilgio ir formos grandines (linijines, šakotąsias, uždaras/ciklines). |
| **Funkcinių grupių prisijungimas** | Prie anglies atomų grandinės gali jungtis įvairios funkcinės grupės (pvz., -OH, -CHO, -COOH, -NH₂), kurios suteikia specifinių savybių. |
| **Izomerija** | Galimybė egzistuoti junginiams, turintiems tą pačią molekulinę formulę, bet skirtingą struktūrą ir savybes (tekste tiesiogiai neminima). |
##### Anglies alotropinės atmainos
| Atmaina | Aprašymas (tekste neminima, papildyta) |
| :--------- | :----------------------------------------------------------------------------------------------------- |
| Deimantas | Kiekvienas C atomas susijungęs su 4 kitais C atomais tetraedriškai. Labai kieta medžiaga. |
| Grafitas | C atomai sudaro plokščius šešianarius sluoksnius. Minkštas, laidus elektrai. |
| Karbinas | Linijinė anglies polimerinė forma. |
| Fulerenas | Tuščiavidurės sferinės, elipsoidinės ar cilindrinės struktūros iš anglies atomų (pvz., C₆₀). |
##### Anglies atomų jungimosi būdai (grandinės)
| Tipo pavadinimas | Pavyzdžiai |
| :-------------------------- | :---------------------------------------- |
| **Linijinės nešakotosios** | C-C-C, C-C-C-C-C-C, C=C-C, C≡C-C-C |
| **Šakotosios** | Atomai jungiasi ne tik grandinės galuose. |
| **Uždaros (ciklinės)** | Ciklopropanas, ciklobutanas, ciklopentanas, cikloheksanas |
##### Kovalentiniai ryšiai
| Ryšio tipas | Bendrų elektronų porų skaičius | Pavyzdžiai (ne tik organiniai) |
| :------------------ | :----------------------------- | :----------------------------- |
| **Viengubasis** | 1 | H-H, H-Cl, H-O-H, C-C, C-H |
| **Dvigubasis** | 2 | O=O, C=C, C=O |
| **Trigubasis** | 3 | N≡N, C≡C |
*Pastaba: Struktūrinėse formulėse kiekvienas anglies atomas turi turėti keturis ryšius (keturis brūkšnelius), o vandenilis – vieną.*
##### Elementų valentingumas organiniuose junginiuose
| Elementas | Įprastas valentingumas |
| :--------- | :--------------------- |
| Anglis (C) | IV (keturvalentė) |
| Vandenilis (H) | I (vienvalentis) |
| Deguonis (O) | II (dvivalentis) |
| Azotas (N) | III (trivalentis) |
| Halogenai (F, Cl, Br, I) | I (vienvalenčiai) |
##### Pagrindinės sąvokos
| Sąvoka | Apibrėžimas |
| :----------------- | :------------------------------------------------------------------------------------------------------------ |
| **Organinė chemija** | Chemijos šaka, tirianti anglies junginius, jų struktūrą, savybes, sintezę ir reakcijas. |
| **Organinis junginys** | Junginys, kurio molekulėje yra anglies atomų (išskyrus kai kurias išimtis, pvz., CO, CO₂, karbonatus, cianidus). |
| **Kovalentinis ryšys** | Cheminis ryšys, susidarantis tarp atomų, kai jie sudaro bendras elektronų poras. |
| **Alotropinės atmainos** | Skirtingos to paties cheminio elemento struktūrinės formos paprastųjų medžiagų pavidalu (pvz., anglies). |
| **Funkcinė grupė** | Specifinė atomų grupė molekulėje, lemianti būdingas junginio chemines savybes (pvz., -OH, -COOH). |
| **Valentingumas** | Elemento atomo savybė sudaryti tam tikrą skaičių kovalentinių ryšių. |' (Size = -1), @p3='False', @p4='False' (Nullable = true), @p5='' (Size = 4000), @p6=NULL (DbType = Guid), @p7='0e4f1a55-522b-b67c-1177-9e6163e7e688' (Nullable = true), @p8=NULL (Size = 4000), @p9='Sukurk dokumentą lietuvių kalba pavadinimu „Organinių junginių gausa“, kuris detaliai paaiškintų organinės chemijos pagrindus ir organinių junginių įvairovės priežastis. Dokumentas turi susidėti iš dviejų dalių: išsamios santraukos ir informacinės lentelės (cheatsheet) su pagrindinių sąvokų santraukomis lentelėse.
**Santraukos skyriai ir turinys:**
1. **Kas yra organinė chemija?** Apibrėžk organinę chemiją, nurodyk pagrindinį elementą (anglį) ir kitus dažnai pasitaikančius elementus (H, O, N, S, P, halogenus).
2. **Anglies elemento ypatumai:** Paaiškink anglies atomo elektroninę sandarą (4 valentiniai elektronai), gebėjimą sudaryti 4 kovalentinius ryšius ir katenaciją kaip pagrindinę įvairovės priežastį. Paminėk anglies alotropines atmainas (deimantą, grafitą, karbiną, fulereną).
3. **Anglies nustatymas organinėse medžiagose: eksperimentiniai metodai:** Aprašyk du metodus anglies aptikimui: kaitinimą (svilimas, pajuodavimas, anglies susidarymas) ir dehidrataciją koncentruota sieros rūgštimi (medžiagos pajuodavimas, suanglinimas), pateik pavyzdžių (mediena, miltai, cukrus, medvilnė).
4. **Organinių ir neorganinių junginių skyrimas:** Paaiškink skirtumą, pateik organinių ($$C₃H₈$$, $$CH₃OH$$, $$C₂H₄$$, $$C₆H₅COOH$$) ir neorganinių ($$H₂O$$, $$NH₃$$, $$Fe₂O₃$$, $$H₂SO₄$$) junginių pavyzdžių. Paminėk istoriškai neorganinei chemijai priskiriamus anglies junginius ($$CO$$, $$CO₂$$, karbonatus pvz., $$CaCO₃$$, cianidus pvz., $$KCN$$).
5. **Atomų skaičiaus nustatymas molekulėse:** Paaiškink, kaip rasti bendrą atomų skaičių molekulėje pagal cheminę formulę, susumuojant indeksus. Pateik pavyzdžius: $$H₂O$$, $$CH₄$$, $$C₂H₅OH$$, $$C₁₂H₂₂O₁₁$$, apskaičiuodamas bendrą atomų skaičių.
6. **Medžiagos kiekis ir dalelių skaičius: Avogadro konstanta:** Apibrėžk molį kaip medžiagos kiekio vienetą ir Avogadro konstantą ($$N_A imes 10^{23}$$ mol⁻¹). Paaiškink, kaip apskaičiuoti molekulių skaičių iš molių (pavyzdžiai: 2 mol $$CH₄$$, 0,25 mol $$C₆H₁₂O₆$$) ir kaip apskaičiuoti bendrą atomų skaičių tam tikrame medžiagos kiekyje (pavyzdys: 0,5 mol $$C₂H₅OH$$) bei konkretaus elemento atomų skaičių (pavyzdys: anglies atomai 3 mol $$CH₃COOH$$). Naudok $$N_A imes 10^{23}$$ reikšmę skaičiavimams.
7. **Anglies atomų gebėjimas jungtis tarpusavyje:** Pakartok katenacijos sąvoką ir jos svarbą, pabrėžiant stabilių grandinių ir žiedų susidarymą.
8. **Anglies atomų grandinių tipai:** Apibūdink linijines nešakotąsias, šakotąsias ir uždarąsias (ciklinius) grandines. Pateik paprastų struktūrinių fragmentų pavyzdžių.
9. **Kovalentinių ryšių įvairovė: viengubieji, dvigubieji, trigubieji ryšiai:** Apibūdink viengubąjį (C-C), dvigubąjį (C=C) ir trigubąjį (C≡C) kovalentinius ryšius tarp anglies atomų. Paminėk susijusias junginių klases (alkanus, alkenus, alkinus).
10. **Struktūrinės formulės ir jų reikšmė:** Paaiškink, ką vaizduoja struktūrinė formulė (atomų jungimosi tvarką, ryšius) ir jos svarbą atskiriant izomerus. Pateik propano ($$C₃H₈$$) ir propeno ($$C₃H₆$$) struktūrinių formulių pavyzdžius.
11. **Elementų valentingumas organiniuose junginiuose:** Nurodyk būdingą valentingumą svarbiausiems elementams: C (4), H (1), O (2), N (3), halogenams (1).
12. **Grandinės ilgis, šakotumas ir kiti elementai:** Apibendrink veiksnius, lemiančius organinių junginių įvairovę: anglies atomų skaičių, grandinės struktūrą (įskaitant izomeriją), ryšių tipą ir kitų elementų atomų buvimą.
13. **Funkcinės grupės ir jų įtaka:** Apibrėžk funkcinę grupę ir jos vaidmenį nulemiant chemines savybes ir klasifikaciją. Pateik svarbių funkcinių grupių pavyzdžius: hidroksilo (-OH, alkoholiai, pvz., $$C₂H₅OH$$), aldehido (-CHO, aldehidai, pvz., $$CH₃CHO$$), karboksilo (-COOH, karboksirūgštys, pvz., $$CH₃COOH$$), amino (-NH₂, aminai, pvz., $$CH₃NH₂$$).
**Informacinės lentelės (Cheatsheet) turinys:**
Sukurk lenteles, kurios aiškiai ir glaustai apibendrintų šias temas:
* Organinės chemijos pagrindai (apibrėžimas, elementai).
* Anglies elemento ypatumai (sandara, ryšiai, katenacija, alotropinės atmainos).
* Anglies nustatymo metodai.
* Organinių ir neorganinių junginių skirstymas (su pavyzdžiais).
* Atomų skaičiaus nustatymas (su pavyzdžiais).
* Medžiagos kiekis ir dalelių skaičius (molis, Avogadro konstanta, formulės).
* Anglies atomų grandinių tipai (su pavyzdžiais).
* Kovalentiniai ryšiai (tipai, žymėjimas, pavyzdžiai).
* Struktūrinės formulės (reikšmė).
* Elementų valentingumas.
* Organinių junginių įvairovės priežastys.
* Svarbiausios funkcinės grupės (formulė, klasė, pavyzdys).
* Pagrindinių sąvokų žodynėlis (Alotropinės atmainos, Avogadro konstanta, Funkcinė grupė, Izomerai, Katenacija, Kovalentinis ryšys, Molis, Organinė chemija, Struktūrinė formulė, Suanglinimas, Valentingumas).
Naudok LaTeX formato formules cheminėms formulėms ir lygtims žymėti (pvz., $$H₂O$$, $$N_A imes 10^{23}$$). Rašyk taisyklinga lietuvių kalba.' (Size = -1), @p10='Chemija / Chemija 10 klasė / Vadovėlis' (Size = 1000), @p11='chemija chemija 10 klase vadovelis' (Size = 1000), @p12='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @p13=NULL (DbType = Boolean), @p14=NULL (Size = 4000), @p15='# II Dalis. Organinė Chemija
## Organinių Medžiagų Sudėties Įrodymas
Norint praktiškai įrodyti anglies buvimą organinėse medžiagose, galima atlikti kelis paprastus bandymus.
**1 Bandymas:**
Nedidelį kiekį krakmolo arba cukraus pakaitinus spiritinės lemputės ar dujų degiklio liepsnoje, stebimi pokyčiai. Jei medžiagos užsidega, kaitinimas nutraukiamas. Reakcijos produktas abiem atvejais yra juodos spalvos. Atvėsusi medžiaga yra anglis, kuri pasižymi šiomis savybėmis: trapi (gali būti sutrinta grūstuvėlyje arba ant kietos plokštelės), netirpsta vandenyje.
**2 Bandymas (Demonstracinis):**
Į mėgintuvėlį įpilama 2-3 ml koncentruotos sieros rūgšties. Į ją įmerkiama medinė skalelė arba balto popieriaus juostelė. Pamerkta dalis greitai pajuoduoja – suanglėja. Šis reiškinys demonstruoja, kad organinėse medžiagose (šiuo atveju skalelėje ar popieriuje) yra anglies.
## Junginių Skirstymas
**Užduotis:** Suskirstykite junginių CaO, CH₄, CO₂, CH₃COOH, K₂CO₃, C₆H₁₂O₆, NaCl, HNO₃, C₂H₅OH, CH₃Cl formules į dvi grupes: neorganinius ir organinius junginius.
**Atsakymas:**
* **Neorganiniai junginiai:** CaO, CO₂, K₂CO₃, NaCl, HNO₃
* **Organiniai junginiai:** CH₄, CH₃COOH, C₆H₁₂O₆, C₂H₅OH, CH₃Cl
## Molekulių Sudėtis
Šių junginių molekulių atomų skaičius:
a) CO₂: 3 atomai
b) CH₄: 5 atomai
c) CH₃COOH: 8 atomai
d) C₆H₁₂O₆: 24 atomai
e) HNO₃: 5 atomai
f) C₂H₅OH: 9 atomai
## Anglies Masės Dalis
Anglies masės dalis procentais didesnė metane (CH₄).
## Molekulių ir Atomų Skaičius
a) 1 mol acto rūgšties (CH₃COOH): 6.022 x 10²³ molekulių
b) 0.5 mol etanolio (C₂H₅OH): 3.011 x 10²³ molekulių
c) 3 mol gliukozės (C₆H₁₂O₆): 1.8066 x 10²⁴ molekulių
a) 2 mol metano (CH₄): 6.022 x 10²⁴ atomų.
b) 0.1 mol benzeno (C₆H₆): 3.6132 x 10²³ atomų.
c) 5 mol cukraus (C₁₂H₂₂O₁₁): 1.35495 x 10²⁶ atomų.
## Didelės Organinių Junginių Įvairovės Priežastys
Anglies atomo sandara lemia jo savybes, ypač keturi išorinio sluoksnio (valentiniai) elektronai. Anglies atomai gali sudaryti kovalentinius ryšius ne tik su kitais elementais, bet ir tarpusavyje.
Anglies alotropinės atmainos: deimantas, grafitas, karbinas, fulerenas. Cheminiai ryšiai tarp anglies atomų gali būti viengubieji, dvigubieji ir trigubieji.
## Anglies Atomų Jungimosi Būdai
Anglies atomai jungiasi, sudarydami įvairias grandines:
* **Linijines (atviras) nešakotąsias:**
* C-C-C
* C-C-C-C-C-C
* C=C-C
* C≡C-C-C
* **Šakotąsias:**
```
C
|
C-C-C-C-C C-C-C-C-C C-C-C=C
| | |
C C C
```
* **Uždaras:** Ciklinių junginių pavyzdžiai, ciklopropanas, ciklobutanas, ciklopentanas, cikloheksanas.
## Kovalentiniai Ryšiai ir Struktūrinės Formulės
* **Viengubasis ryšys:** Viena bendra elektronų pora tarp dviejų atomų (pvz., H-H, H-Cl, H-O-H).
* **Dvigubasis ryšys:** Dvi bendros elektronų poros tarp dviejų atomų (pvz., O=O).
* **Trigubasis ryšys:** Trys bendros elektronų poros tarp dviejų atomų.
Kiekvieno anglies atomo struktūrinėje formulėje turi būti pažymėti keturi brūkšneliai, atitinkantys keturis kovalentinius ryšius. Pridedant vandenilio atomus, gaunamos pilnos struktūrinės formulės:
```
H H H H H H H H H H H H H H
| | | | | | | | | | | | | |
H-C-C-C-H H-C-C-C-C-C-C-H H-C=C-C-H H-C≡C-C-C-H
| | | | | | | | | | |
H H H H H H H H H H H
H H H H H H H H H H H H H H
| | | | | | | | | | | | | |
H-C-C-C-C-C-H H-C-C-C-C-C-C-H H-C-C-C=C-H
| | | | | | |
H H H C H H H
|
H
```
## Valentingumas
Kovalentinių ryšių skaičius nusako elemento valentingumą. Organiniuose junginiuose anglis visada yra keturvalentė, o vandenilis – vienvalentis.
## Organinių Junginių Įvairovė
Organinių junginių molekulės gali turėti labai įvairų anglies atomų skaičių, pradedant nuo vieno (pvz., metanas CH₄) iki kelių dešimčių, šimtų ar net daugiau. Ši įvairovė priklauso nuo anglies atomų jungimosi ypatumų, kitų elementų (pvz., F, Cl, Br, I) ar funkcinių grupių (pvz., -OH, -CHO, -COOH, -NH₂) skaičiaus ir išsidėstymo anglies atomų grandinėje.
Organinė chemija tiria anglies junginius.
' (Size = -1), @p16='Organinių junginių gausa' (Size = 2000), @p17='Angliavandeniliai / Kodėl tiek daug organinių junginių?' (Size = 4000), @p18='angliavandeniliai kodel tiek daug organiniu junginiu' (Size = 2000), @p19='8', @p20='0', @p21='1', @p22='0', @p23=NULL (DbType = DateTime2)], CommandType='Text', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
UPDATE [Scanners] SET [Active] = @p0, [CheatSheet] = @p1, [CheatSheet2] = @p2, [Deleted] = @p3, [FactErrors] = @p4, [FactErrorsExplanation] = @p5, [ParentCategory2Id] = @p6, [ParentCategoryId] = @p7, [ProcessorGenerateImagePrompt] = @p8, [Prompt] = @p9, [Reference] = @p10, [ReferenceSlug] = @p11, [SiteId] = @p12, [SpellingErrors] = @p13, [SpellingErrorsExplanation] = @p14, [Summary] = @p15, [Title] = @p16, [TitleBackup] = @p17, [TitleSlug] = @p18, [TotalCards] = @p19, [TotalCards2] = @p20, [TotalCategories] = @p21, [TotalPages] = @p22, [Verified] = @p23
OUTPUT 1
WHERE [Id] = @p24;
|
| 13. |
info: 2025-04-25 15:23:08.980 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
283ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='15802', @__item_Right_2='15803'], 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]
|
| 14. |
info: 2025-04-25 15:23:09.164 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
7ms [Parameters=[@__id_0='7a4c3116-3f79-f052-2c55-cc98706001ca', @__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-25 15:23:09.203 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
30ms [Parameters=[@__id_0='7a4c3116-3f79-f052-2c55-cc98706001ca', @__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-25 15:23:09.259 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
12ms [Parameters=[@__id_0='7a4c3116-3f79-f052-2c55-cc98706001ca', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [c5].[Id], [c5].[Active], [c5].[Deleted], [c5].[Description], [c5].[DescriptionBackup], [c5].[Left], [c5].[ParentId], [c5].[Position], [c5].[ProcessorGenerateImagePrompt], [c5].[Right], [c5].[SiteId], [c5].[StorageMediaName], [c5].[StorageMediaUrl], [c5].[Title], [c5].[TitleBackup], [c5].[TitleSlug], [c5].[TotalChildren], [c5].[TotalScanners], [c5].[TotalYoutubeVideos], [c].[Id], [c4].[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 [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]
FROM [Categories] AS [c1] WITH (NOLOCK)
WHERE [c1].[Active] = CAST(1 AS bit) AND [c1].[Deleted] = CAST(0 AS bit)
) AS [c5] ON [c4].[Id] = [c5].[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], [c5].[Position]
|
| 17. |
info: 2025-04-25 15:23:09.328 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
58ms [Parameters=[@__id_0='7a4c3116-3f79-f052-2c55-cc98706001ca', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s3].[ScannerId], [s3].[CategoryId], [s3].[Id], [s3].[Active], [s3].[CheatSheet], [s3].[CheatSheet2], [s3].[Deleted], [s3].[FactErrors], [s3].[FactErrorsExplanation], [s3].[ParentCategory2Id], [s3].[ParentCategoryId], [s3].[ProcessorGenerateImagePrompt], [s3].[Prompt], [s3].[Reference], [s3].[ReferenceSlug], [s3].[SiteId], [s3].[SpellingErrors], [s3].[SpellingErrorsExplanation], [s3].[Summary], [s3].[Title], [s3].[TitleBackup], [s3].[TitleSlug], [s3].[TotalCards], [s3].[TotalCards2], [s3].[TotalCategories], [s3].[TotalPages], [s3].[Verified], [c].[Id], [c4].[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], [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].[Title], [s].[TitleBackup], [s].[TitleSlug], [s].[TotalCards], [s].[TotalCards2], [s].[TotalCategories], [s].[TotalPages], [s].[Verified]
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]
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]
|
| 18. |
info: 2025-04-25 15:23:09.481 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__id_0='7a4c3116-3f79-f052-2c55-cc98706001ca', @__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]
|
| 19. |
info: 2025-04-25 15:23:09.511 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
17ms [Parameters=[@__id_0='7a4c3116-3f79-f052-2c55-cc98706001ca', @__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]
|
| 20. |
info: 2025-04-25 15:23:09.666 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
28ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='14863', @__item_Right_2='14874'], 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]
|
| 21. |
info: 2025-04-25 15:23:09.809 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
7ms [Parameters=[@__id_0='1f430354-a442-ec01-fe50-2c15aba2f234', @__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]
|
| 22. |
info: 2025-04-25 15:23:09.839 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
3ms [Parameters=[@__id_0='1f430354-a442-ec01-fe50-2c15aba2f234', @__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]
|
| 23. |
info: 2025-04-25 15:23:09.851 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
12ms [Parameters=[@__id_0='1f430354-a442-ec01-fe50-2c15aba2f234', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [c5].[Id], [c5].[Active], [c5].[Deleted], [c5].[Description], [c5].[DescriptionBackup], [c5].[Left], [c5].[ParentId], [c5].[Position], [c5].[ProcessorGenerateImagePrompt], [c5].[Right], [c5].[SiteId], [c5].[StorageMediaName], [c5].[StorageMediaUrl], [c5].[Title], [c5].[TitleBackup], [c5].[TitleSlug], [c5].[TotalChildren], [c5].[TotalScanners], [c5].[TotalYoutubeVideos], [c].[Id], [c4].[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 [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]
FROM [Categories] AS [c1] WITH (NOLOCK)
WHERE [c1].[Active] = CAST(1 AS bit) AND [c1].[Deleted] = CAST(0 AS bit)
) AS [c5] ON [c4].[Id] = [c5].[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], [c5].[Position]
|
| 24. |
info: 2025-04-25 15:23:09.926 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
36ms [Parameters=[@__id_0='1f430354-a442-ec01-fe50-2c15aba2f234', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s3].[ScannerId], [s3].[CategoryId], [s3].[Id], [s3].[Active], [s3].[CheatSheet], [s3].[CheatSheet2], [s3].[Deleted], [s3].[FactErrors], [s3].[FactErrorsExplanation], [s3].[ParentCategory2Id], [s3].[ParentCategoryId], [s3].[ProcessorGenerateImagePrompt], [s3].[Prompt], [s3].[Reference], [s3].[ReferenceSlug], [s3].[SiteId], [s3].[SpellingErrors], [s3].[SpellingErrorsExplanation], [s3].[Summary], [s3].[Title], [s3].[TitleBackup], [s3].[TitleSlug], [s3].[TotalCards], [s3].[TotalCards2], [s3].[TotalCategories], [s3].[TotalPages], [s3].[Verified], [c].[Id], [c4].[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], [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].[Title], [s].[TitleBackup], [s].[TitleSlug], [s].[TotalCards], [s].[TotalCards2], [s].[TotalCategories], [s].[TotalPages], [s].[Verified]
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]
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]
|
| 25. |
info: 2025-04-25 15:23:09.946 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
9ms [Parameters=[@__id_0='1f430354-a442-ec01-fe50-2c15aba2f234', @__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]
|
| 26. |
info: 2025-04-25 15:23:10.233 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
15ms [Parameters=[@__id_0='34890760-8fcb-6052-d3d8-bb3d0e7061a8', @__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]
|
| 27. |
info: 2025-04-25 15:23:10.237 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
40ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='7722', @__item_Right_2='8037'], 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]
|
| 28. |
info: 2025-04-25 15:23:10.245 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
12ms [Parameters=[@__id_0='34890760-8fcb-6052-d3d8-bb3d0e7061a8', @__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]
|
| 29. |
info: 2025-04-25 15:23:10.264 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
19ms [Parameters=[@__id_0='34890760-8fcb-6052-d3d8-bb3d0e7061a8', @__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]
|
| 30. |
info: 2025-04-25 15:23:10.275 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
10ms [Parameters=[@__id_0='34890760-8fcb-6052-d3d8-bb3d0e7061a8', @__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]
|
| 31. |
info: 2025-04-25 15:23:10.284 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__id_0='34890760-8fcb-6052-d3d8-bb3d0e7061a8', @__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]
|
| 32. |
info: 2025-04-25 15:23:10.325 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
40ms [Parameters=[@__id_0='34890760-8fcb-6052-d3d8-bb3d0e7061a8', @__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]
|
| 33. |
info: 2025-04-25 15:23:10.673 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
57ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='15806', @__item_Right_2='15807'], 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]
|
| 1406 ms |
