| 2. |
info: 2025-04-25 18:20:43.281 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
9ms [Parameters=[@__p_0='1'], CommandType='Text', CommandTimeout='30']
SELECT TOP(@__p_0) [t].[Id], [t].[Active], [t].[Created], [t].[Deleted], [t].[Description], [t].[Links], [t].[MediaSourceCopyright], [t].[MediaSourceUrl], [t].[ShortDescription], [t].[SiteId], [t].[StorageMediaName], [t].[StorageMediaUrl], [t].[Title], [t].[TitleSlug], [t].[Url], [t].[Wikipedia], [t].[WikipediaPageId], [t].[WikipediaUpdated]
FROM [Tags] AS [t]
WHERE [t].[WikipediaUpdated] = CAST(0 AS bit) AND [t].[Deleted] = CAST(0 AS bit)
ORDER BY [t].[Id] DESC
|
| 3. |
info: 2025-04-25 18:20:43.300 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
121ms [Parameters=[@__id_0='a444cc1e-8cf5-973a-d172-df7da995b139', @__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]
|
| 4. |
info: 2025-04-25 18:20:43.403 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
9ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='12164', @__item_Right_2='12165'], 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]
|
