| 1. |
info: 2025-04-26 02:42:35.620 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
11ms [Parameters=[@__id_0='b2535490-d5bc-495b-3f65-5ec888bc053c', @__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]
|
| 2. |
info: 2025-04-26 02:42:35.766 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
18ms [Parameters=[@__id_0='b2535490-d5bc-495b-3f65-5ec888bc053c', @__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]
|
| 3. |
info: 2025-04-26 02:42:36.173 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
57ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='3883', @__item_Right_2='3902'], 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-26 02:42:36.320 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
478ms [Parameters=[@__id_0='b2535490-d5bc-495b-3f65-5ec888bc053c', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s5].[ScannerId], [s5].[CategoryId], [s5].[Id], [s5].[Active], [s5].[CheatSheet], [s5].[CheatSheet2], [s5].[Deleted], [s5].[FactErrors], [s5].[FactErrorsExplanation], [s5].[ParentCategory2Id], [s5].[ParentCategoryId], [s5].[ProcessorGenerateImagePrompt], [s5].[Prompt], [s5].[Reference], [s5].[ReferenceSlug], [s5].[SiteId], [s5].[SpellingErrors], [s5].[SpellingErrorsExplanation], [s5].[Summary], [s5].[Title], [s5].[TitleBackup], [s5].[TitleSlug], [s5].[TotalCards], [s5].[TotalCards2], [s5].[TotalCategories], [s5].[TotalPages], [s5].[Verified], [c].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id], [s1].[Active], [s1].[CheatSheet], [s1].[CheatSheet2], [s1].[Deleted], [s1].[FactErrors], [s1].[FactErrorsExplanation], [s1].[ParentCategory2Id], [s1].[ParentCategoryId], [s1].[ProcessorGenerateImagePrompt], [s1].[Prompt], [s1].[Reference], [s1].[ReferenceSlug], [s1].[SiteId], [s1].[SpellingErrors], [s1].[SpellingErrorsExplanation], [s1].[Summary], [s1].[Title], [s1].[TitleBackup], [s1].[TitleSlug], [s1].[TotalCards], [s1].[TotalCards2], [s1].[TotalCategories], [s1].[TotalPages], [s1].[Verified]
FROM [CategoryScanners] AS [c3]
INNER JOIN [Scanners] AS [s1] ON [c3].[ScannerId] = [s1].[Id]
WHERE [s1].[Active] = CAST(1 AS bit) AND [s1].[Deleted] = CAST(0 AS bit)
) AS [s5] ON [c].[Id] = [s5].[CategoryId]
WHERE [c].[Id] = @__id_0 AND [c].[SiteId] = @__site_Id_1 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Id], [s5].[Id], [s5].[ScannerId], [s5].[CategoryId]
|
| 5. |
info: 2025-04-26 02:42:37.141 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
36ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='5641', @__item_Right_2='5656'], 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]
|
| 6. |
info: 2025-04-26 02:42:37.209 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
37ms [Parameters=[@p7='600dcbed-83a8-433c-8d7f-b6ef851f233d', @p0='True', @p1='False', @p2='2', @p3='0cc050f5-f6bb-4bca-9015-97f1273ed5cb', @p4='135.jpg' (Size = 100), @p5='https://knowledgenest.blob.core.windows.net/scanners/0/[Matematika][Horizontai Matematika 6 klasė][Vadovėlis 2 dalis]/pages/135.jpg' (Size = 1000), @p6='""
### 3
Pateikti duomenys pagal du požymius: batų dydis ir batų spalva.
37, balti; 37, juodi; 37, rudi; 37, pilki; 38, balti; 38, juodi; 38, rudi; 38, pilki; 39, balti; 39, juodi; 39, rudi; 39, pilki; 40, balti; 40, juodi; 40, rudi; 40, pilki; 41, balti; 41, juodi; 41, rudi; 41, pilki.
Nubraižykite ir užpildykite surūšiuotų duomenų dažnių lentelę.
### 4
Nurodykite tiriamąjį objektą, požymį ir požymio reikšmes:
a) Zigmas tyrė, kiek laiko klasės draugai skiria namų darbų ruošai pirmadieniais, ir gavo tokius rezultatus: 15 min., 20 min., 25 min., 30 min., 35 min., 40 min., 45 min.;
b) apklausos būdu Alma išsiaiškino, kad šunys dažniausiai ėda sausą pašarą „Lengvučiai“, rečiau - pašarą „Trapučiai“, o rečiausiai – pašarą „Au au".
### 5
Lentelėje pateikti surūšiuoti duomenys. Pagal kokius požymius jie buvo rūšiuojami? Kas buvo tiriamieji objektai?
**Mokinių skaičius sausio 1 d.**
| Gimnazijos pavadinimas | 2021 m. | 2022 m. | 2023 m. | 2024 m. | 2025 m. |
|---|---|---|---|---|---|
| „Višakio" gimn. | 248 | 253 | 242 | 251 | 254 |
| „Šešupės" gimn. | 284 | 284 | 281 | 283 | 287 |
| „Pilvės" gimn. | 202 | 205 | 201 | 210 | 212 |
| „Novos" gimn. | 210 | 204 | 200 | 202 | 203 |
### 6
Parduotuvės analitikai, apibendrinę per mėnesį parduotų trąšų kiekį, gavo tokius duomenis ir juos išrūšiavę pateikė lentelę:
| Trąšos | Gėlėms | Uogoms | Daržovėms | Vejai |
|---|---|---|---|---|
| „Žalumas" | 30 % | 0 % | 0 % | 70 % |
| „Universalu" | 20 % | 10 % | 15 % | 10 % |
| „Uogelė" | 0 % | 75 % | 60 % | 0 % |
| „Žiedelis" | 50 % | 15 % | 25 % | 20 % |
Nurodykite tiriamuosius objektus, požymius, pagal kuriuos duomenys išrūšiuoti, ir galimas šių požymių reikšmes.
""' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
UPDATE [ScannerPages] SET [Active] = @p0, [Deleted] = @p1, [Position] = @p2, [ScannerId] = @p3, [StorageMediaName] = @p4, [StorageMediaUrl] = @p5, [Text] = @p6
OUTPUT 1
WHERE [Id] = @p7;
|
| 7. |
info: 2025-04-26 02:42:37.462 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
27ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='4606', @__item_Right_2='4607'], 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]
|
| 8. |
info: 2025-04-26 02:42:39.443 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__id_0='789be2e0-81da-6a21-6a48-006924dd6a8d', @__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]
|
| 9. |
info: 2025-04-26 02:42:39.461 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
18ms [Parameters=[@__id_0='789be2e0-81da-6a21-6a48-006924dd6a8d', @__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]
|
| 10. |
info: 2025-04-26 02:42:39.479 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
17ms [Parameters=[@__id_0='789be2e0-81da-6a21-6a48-006924dd6a8d', @__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]
|
| 11. |
info: 2025-04-26 02:42:39.489 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__id_0='789be2e0-81da-6a21-6a48-006924dd6a8d', @__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]
|
| 12. |
info: 2025-04-26 02:42:39.506 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
8ms [Parameters=[@__id_0='789be2e0-81da-6a21-6a48-006924dd6a8d', @__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]
|
| 13. |
info: 2025-04-26 02:42:39.517 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__id_0='789be2e0-81da-6a21-6a48-006924dd6a8d', @__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]
|
| 14. |
info: 2025-04-26 02:42:39.679 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
10ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='13334', @__item_Right_2='13335'], 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]
|
| 729 ms |
