1. |
info: 2025-04-25 18:25:40.059 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
835ms [Parameters=[@__item_Id_0='4ec59249-642a-4fdc-a934-e1ff406309b4'], CommandType='Text', CommandTimeout='30']
SELECT MAX([s0].[Position])
FROM (
SELECT 1 AS empty
) AS [e]
LEFT JOIN (
SELECT [s].[Position]
FROM [ScannerCards] AS [s]
WHERE [s].[ScannerId] = @__item_Id_0 AND [s].[Deleted] = CAST(0 AS bit)
) AS [s0] ON 1 = 1
|
2. |
info: 2025-04-25 18:25:40.070 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
12ms [Parameters=[@__id_0='dcd8e340-8a68-998a-e1d0-59ce58e64d08', @__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]
|
3. |
info: 2025-04-25 18:25:40.078 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
7ms [Parameters=[@__id_0='dcd8e340-8a68-998a-e1d0-59ce58e64d08', @__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 18:25:40.081 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__id_0='dcd8e340-8a68-998a-e1d0-59ce58e64d08', @__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-25 18:25:40.145 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
36ms [Parameters=[@__id_0='dcd8e340-8a68-998a-e1d0-59ce58e64d08', @__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]
|
6. |
info: 2025-04-25 18:25:40.158 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
90ms [Parameters=[@p0='0156e5bf-662e-4f3a-b6ab-271c526a4469', @p1='True', @p2='Judėjimo uždaviniuose nagrinėjamas objektų judėjimas pastoviu greičiu. Pagrindinis ryšys tarp kelio (\(s\)), greičio (\(v\)) ir laiko (\(t\)) yra \(s = vt\). Judant upe, greitis pasroviui yra savojo greičio ir upės tėkmės greičio suma (\(v_{pasroviui} = v_{savas} + v_{upės}\)), o prieš srovę – skirtumas (\(v_{prieš srovę} = v_{savas} - v_{upės}\)). Kai objektai juda vienas priešais kitą, jų suartėjimo greitis yra greičių suma. Lygtys sudaromos remiantis nuvažiuotu atstumu arba sugaištu laiku.' (Size = 4000), @p3=NULL (Size = 4000), @p4=NULL (Size = 100), @p5=NULL (Size = 1000), @p6='False', @p7=NULL (DbType = Boolean), @p8=NULL (Size = 4000), @p9='- Pagrindinė formulė: kelias \(s = vt\) (greitis \(v\), laikas \(t\)).
- Laiko apskaičiavimas: \(t = s/v\).
- Greičio apskaičiavimas: \(v = s/t\).
- Greitis pasroviui: \(v_{pasroviui} = v_{savas} + v_{upės}\).
- Greitis prieš srovę: \(v_{prieš srovę} = v_{savas} - v_{upės}\).
- Objektų suartėjimo greitis (judant priešpriešais): \(v_{bendras} = v_1 + v_2\).' (Size = 4000), @p10=NULL (Size = 4000), @p11=NULL (Size = 100), @p12=NULL (Size = 1000), @p13='6', @p14=NULL (Size = 4000), @p15=NULL (Size = 4000), @p16='4ec59249-642a-4fdc-a934-e1ff406309b4', @p17=NULL (DbType = Boolean), @p18=NULL (Size = 4000), @p19=NULL (Size = 100), @p20=NULL (Size = 1000), @p21='Matematinis judėjimo modeliavimas leidžia apskaičiuoti svarbius judėjimo parametrus (greitį, laiką, atstumą) realiose situacijose.' (Size = 4000), @p22=NULL (Size = 4000), @p23=NULL (Size = 100), @p24=NULL (Size = 1000), @p25='Judėjimo uždaviniai' (Size = 2000), @p26='judejimo uzdaviniai' (Size = 2000), @p27='0', @p28='0', @p29='0', @p30='0', @p31='0', @p32='0', @p33='0', @p34='0', @p35='0', @p36=NULL (DbType = DateTime2), @p37='1', @p38='5d679770-6acb-4ca8-9c91-be70b1cba882', @p39='True', @p40='Tekstiniai uždaviniai sprendžiami realią situaciją paverčiant matematiniu modeliu – lygtimi arba lygčių sistema. Pirmiausia įvedami nežinomieji dydžiai (pvz., \(x\), \(y\)). Remiantis uždavinio sąlygomis, sudaromos lygtys, siejančios nežinomuosius. Išsprendus lygtį ar lygčių sistemą, randamos nežinomųjų reikšmės. Gautus sprendinius būtina patikrinti, ar jie atitinka uždavinio prasmę (pvz., greitis negali būti neigiamas).' (Size = 4000), @p41=NULL (Size = 4000), @p42=NULL (Size = 100), @p43=NULL (Size = 1000), @p44='False', @p45=NULL (DbType = Boolean), @p46=NULL (Size = 4000), @p47='- Nežinomų dydžių žymėjimas kintamaisiais (\(x\), \(y\), ...).
- Uždavinio sąlygų vertimas į matematines lygtis.
- Dažniausiai susiduriama su tiesinių ir trupmeninių lygčių sistemomis.
- Galimybė spręsti sudarant vieną lygtį arba lygčių sistemą.
- Būtinybė patikrinti sprendinių atitiktį uždavinio kontekstui.' (Size = 4000), @p48=NULL (Size = 4000), @p49=NULL (Size = 100), @p50=NULL (Size = 1000), @p51='4', @p52=NULL (Size = 4000), @p53=NULL (Size = 4000), @p54='4ec59249-642a-4fdc-a934-e1ff406309b4', @p55=NULL (DbType = Boolean), @p56=NULL (Size = 4000), @p57=NULL (Size = 100), @p58=NULL (Size = 1000), @p59='Gebėjimas versti žodines problemas į matematinių lygčių kalbą yra esminis įgūdis, leidžiantis struktūrizuotai analizuoti ir spręsti įvairias praktines bei teorines problemas.' (Size = 4000), @p60=NULL (Size = 4000), @p61=NULL (Size = 100), @p62=NULL (Size = 1000), @p63='Tekstinių uždavinių sprendimas sudarant lygtis' (Size = 2000), @p64='tekstiniu uzdaviniu sprendimas sudarant lygtis' (Size = 2000), @p65='0', @p66='0', @p67='0', @p68='0', @p69='0', @p70='0', @p71='0', @p72='0', @p73='0', @p74=NULL (DbType = DateTime2), @p75='1', @p76='8c0da063-be77-4e72-9e2f-64b8aa07043f', @p77='True', @p78='Darbo uždaviniuose visas darbas (\(A\)) dažnai laikomas lygiu vienetui (\(A=1\)). Darbo našumas (sparta) yra darbo dalis, atliekama per laiko vienetą. Jei visas darbas atliekamas per laiką \(t\), našumas yra \(1/t\). Kai keli objektai dirba kartu, jų našumai sudedami. Bendra darbo sparta yra atskirų spartų suma: \(1/t_{bendras} = 1/t_1 + 1/t_2\). Lygtys sudaromos remiantis sąryšiais tarp darbo laiko, našumo ir atlikto darbo dalių.' (Size = 4000), @p79=NULL (Size = 4000), @p80=NULL (Size = 100), @p81=NULL (Size = 1000), @p82='False', @p83=NULL (DbType = Boolean), @p84=NULL (Size = 4000), @p85='- Visas darbas dažniausiai žymimas \(A=1\).
- Darbo našumas (sparta) = Darbas / Laikas. Jei \(A=1\), našumas yra \(1/t\).
- Bendra darbo sparta (dirbant kartu): \(1/t_{bendras} = 1/t_1 + 1/t_2 + ... + 1/t_n\).
- Atlikto darbo dalis = Našumas × Laikas.' (Size = 4000), @p86=NULL (Size = 4000), @p87=NULL (Size = 100), @p88=NULL (Size = 1000), @p89='7', @p90=NULL (Size = 4000), @p91=NULL (Size = 4000), @p92='4ec59249-642a-4fdc-a934-e1ff406309b4', @p93=NULL (DbType = Boolean), @p94=NULL (Size = 4000), @p95=NULL (Size = 100), @p96=NULL (Size = 1000), @p97='Šie uždaviniai moko kiekybiškai įvertinti darbo efektyvumą ir bendradarbiavimo naudą, taikant algebrinius sąryšius tarp laiko ir našumo.' (Size = 4000), @p98=NULL (Size = 4000), @p99=NULL (Size = 100), @p100=NULL (Size = 1000), @p101='Darbo našumo uždaviniai' (Size = 2000), @p102='darbo nasumo uzdaviniai' (Size = 2000), @p103='0', @p104='0', @p105='0', @p106='0', @p107='0', @p108='0', @p109='0', @p110='0', @p111='0', @p112=NULL (DbType = DateTime2), @p113='1', @p114='8da73ead-be78-499f-a13e-77dd9fa54c36', @p115='True', @p116='Skaičių teorijos uždaviniuose ieškomi skaičiai (natūralieji, sveikieji, trupmeniniai), tenkinantys nurodytas sąlygas, pvz., apie jų sumą, skirtumą, sandaugą, santykį. Sprendžiant trupmenų uždavinius, nežinomaisiais \(x\) ir \(y\) žymimi skaitiklis ir vardiklis. Remiantis sąlygomis (pvz., skaitiklio ir vardiklio suma \(x+y=S\)), sudaromos lygtys arba lygčių sistemos.' (Size = 4000), @p117=NULL (Size = 4000), @p118=NULL (Size = 100), @p119=NULL (Size = 1000), @p120='False', @p121=NULL (DbType = Boolean), @p122=NULL (Size = 4000), @p123='- Nežinomieji – ieškomi skaičiai arba trupmenos dalys (skaitiklis, vardiklis).
- Lygtys sudaromos pagal sąlygas: suma (\(x+y=a\)), skirtumas (\(x-y=b\)), santykis (\(x/y=c\)), atvirkštinių skaičių ryšys (\(1/x + 1/y = d\)).
- Sprendžiant svarbu atsižvelgti į skaičių tipą (natūralieji, teigiami ir pan.).' (Size = 4000), @p124=NULL (Size = 4000), @p125=NULL (Size = 100), @p126=NULL (Size = 1000), @p127='5', @p128=NULL (Size = 4000), @p129=NULL (Size = 4000), @p130='4ec59249-642a-4fdc-a934-e1ff406309b4', @p131=NULL (DbType = Boolean), @p132=NULL (Size = 4000), @p133=NULL (Size = 100), @p134=NULL (Size = 1000), @p135='Šie uždaviniai lavina gebėjimą algebriškai aprašyti sąryšius tarp skaičių ir taikyti lygčių sprendimo metodus ieškant konkrečių skaitinių reikšmių.' (Size = 4000), @p136=NULL (Size = 4000), @p137=NULL (Size = 100), @p138=NULL (Size = 1000), @p139='Skaičių teorijos uždaviniai' (Size = 2000), @p140='skaiciu teorijos uzdaviniai' (Size = 2000), @p141='0', @p142='0', @p143='0', @p144='0', @p145='0', @p146='0', @p147='0', @p148='0', @p149='0', @p150=NULL (DbType = DateTime2), @p151='1'], CommandType='Text', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [ScannerCards] ([Id], [Active], [Context], [ContextBackup], [ContextStorageMediaName], [ContextStorageMediaUrl], [Deleted], [FactErrors], [FactErrorsExplanation], [Facts], [FactsBackup], [FactsStorageMediaName], [FactsStorageMediaUrl], [Position], [ProcessorGenerateImagePrompt], [Prompt], [ScannerId], [SpellingErrors], [SpellingErrorsExplanation], [StorageMediaName], [StorageMediaUrl], [Summary], [SummaryBackup], [SummaryStorageMediaName], [SummaryStorageMediaUrl], [Title], [TitleSlug], [TotalFillTheBlankSelectionQuestions], [TotalMultipleSelectionQuestions], [TotalOrderingQuestions], [TotalQuestionPoints], [TotalQuestions], [TotalShortAnswerQuestions], [TotalSingleSelectionQuestions], [TotalSources], [TotalTrueFalseQuestions], [Verified], [Version])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37),
(@p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75),
(@p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106, @p107, @p108, @p109, @p110, @p111, @p112, @p113),
(@p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, @p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, @p139, @p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148, @p149, @p150, @p151);
|
7. |
info: 2025-04-25 18:25:40.177 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
21ms [Parameters=[@__id_0='dcd8e340-8a68-998a-e1d0-59ce58e64d08', @__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]
|
8. |
info: 2025-04-25 18:25:40.196 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__8__locals1_sub_Id_0='4ec59249-642a-4fdc-a934-e1ff406309b4'], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [ScannerCards] AS [s]
WHERE [s].[ScannerId] = @__8__locals1_sub_Id_0 AND [s].[Deleted] = CAST(0 AS bit)
|
9. |
info: 2025-04-25 18:25:40.226 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__p_0='4ec59249-642a-4fdc-a934-e1ff406309b4' (Nullable = true)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[Active], [s].[CheatSheet], [s].[CheatSheet2], [s].[Deleted], [s].[FactErrors], [s].[FactErrorsExplanation], [s].[ParentCategory2Id], [s].[ParentCategoryId], [s].[ProcessorGenerateImagePrompt], [s].[Prompt], [s].[Reference], [s].[ReferenceSlug], [s].[SiteId], [s].[SpellingErrors], [s].[SpellingErrorsExplanation], [s].[Summary], [s].[Title], [s].[TitleBackup], [s].[TitleSlug], [s].[TotalCards], [s].[TotalCards2], [s].[TotalCategories], [s].[TotalPages], [s].[Verified]
FROM [Scanners] AS [s]
WHERE [s].[Id] = @__p_0
|
10. |
info: 2025-04-25 18:25:40.244 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
67ms [Parameters=[@__id_0='dcd8e340-8a68-998a-e1d0-59ce58e64d08', @__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 18:25:40.504 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
18ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='3704', @__item_Right_2='3705'], 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]
|
1092 ms |