Dibbes 445 Posted March 13, 2020 Posted March 13, 2020 (edited) I dont think this is necessary -> plugin dont do any long running tasks to track but very short repeated mostly on library change in few minutes intervals. Nevertheless I plan to add diagnostics logs. @@saladin Just wondering if there was something like this already... I'd really like to know what the plugin is doing when it's locking the database and using up other resources... Edited March 13, 2020 by Dibbes
zetetic 5 Posted March 16, 2020 Posted March 16, 2020 Hi all, I am new to Emby so please let me know if I am doing something wrong. Smart playlists was my only reason for holding back on Emby as my main music player so I really want to take part in this testing. I have my server on a Synology NAS, I put the dll in the plugins fiolder and gave it the same permissions as another one that was already in there. I have restarted and I see no option under advanced for Smart Playlists management. I couldnt find any definitive instructions for manual installation of plugins. Thanks
PenkethBoy 2066 Posted March 16, 2020 Posted March 16, 2020 which server and which dll versions did you try?
zetetic 5 Posted March 17, 2020 Posted March 17, 2020 I have only tried SmartPlaylist v1.3.0.0.zip on Emby Server 4.3.1.0 on Synolgy NAS DSM 6.1.7-15284 Update 3 Thanks
PenkethBoy 2066 Posted March 17, 2020 Posted March 17, 2020 wrong dll version thats for beta server go back to post one and d/l the version for stable
mchammer 3 Posted March 18, 2020 Posted March 18, 2020 Can't get it to work, when I click "add new smartplaylist" it just shows a blank screen also there's a typo it says add new samrtplaylist
zetetic 5 Posted March 20, 2020 Posted March 20, 2020 Got it working, thanks for the help. As mentioned above I get a blank screen sometimes when I first select "Add new samrtplaylist", I then go back and the second time it works. It would be good to have more ID3 metadata fields added for music smartlists, for example I have made extensive use of the 'Grouping' field, adding codes for guest artists and using it to keep track of my kids fave tracks using codes. I have doubled this information in the comment field because some other players I have trialed do not use Grouping in smart lists. Having the Last Played date is awesome, I have made many playlists using that in Itunes in the past. Thanks for this plugin.
jdewoody71 8 Posted March 20, 2020 Posted March 20, 2020 Sorry to bother but I'm currently using Emby beta server and I've tried both v1.3.0.0 & v1.2.0.0, neither show up anywhere. Can someone provide a suggestion where I should look?
PenkethBoy 2066 Posted March 20, 2020 Posted March 20, 2020 bottom left of dashboard - in advanced section works fine as long as you put it in the correct directory and you have rebooted your emby server for it to be picked up
jdewoody71 8 Posted March 20, 2020 Posted March 20, 2020 bottom left of dashboard - in advanced section works fine as long as you put it in the correct directory and you have rebooted your emby server for it to be picked up Thanks for the reply. I'm familiar with the plug ins section of the server but it's not there. I've put them in the plugins directory on the server, which I believed to be the correct location.
PenkethBoy 2066 Posted March 20, 2020 Posted March 20, 2020 nope wrong location - those are "backup" copies and will be removed on an update put the smartplaylist plugin in the correct location programdata\plugins - reboot emby server and you will see it in the dashboard 1
jdewoody71 8 Posted March 20, 2020 Posted March 20, 2020 nope wrong location - those are "backup" copies and will be removed on an update put the smartplaylist plugin in the correct location programdata\plugins - reboot emby server and you will see it in the dashboard Thank you very much. Moved the file, now it works.
mchammer 3 Posted March 21, 2020 Posted March 21, 2020 Got it to work but it only works on the local network, if I use it remotely it just shows a blank window and doesn't change.
sampsonight 4 Posted March 22, 2020 Posted March 22, 2020 I installed this and added 2 simple music smart playlists (favorite, and range of years). Worked awesome! Great work!
ginjaninja 571 Posted March 22, 2020 Posted March 22, 2020 I now have recently watched for episodes, thank you Maybe oneday the server will allow for individual playlists to be added as a ribbon to home screen, heres hoping.
ginjaninja 571 Posted March 22, 2020 Posted March 22, 2020 Update Type=Live Limit =10 Played Date Descending MediaType is Movie recently watched for movies is showing an issue for me, Content which i watched last night in Theatre and is marked as played, is not showing on this list Content which i have previously watched and markeed as unwatched is showing on the list* *dont quite know how played/unplayed and media play dates are stored in the database/their intended design/use and what "played date" on your plugin is actually keying against, maybe this content is right to show up as it was 'played' at one point in time.
PuffyToesToo 337 Posted March 22, 2020 Posted March 22, 2020 Is there something I'm missing with regard to 'shuffle daily' vs llive'? I have several of my playlists set to shuffle daily, but they are not doing that. Thank you.
Dibbes 445 Posted March 22, 2020 Posted March 22, 2020 Is there something I'm missing with regard to 'shuffle daily' vs llive'? I have several of my playlists set to shuffle daily, but they are not doing that. Thank you. It doesn't work for me either... I think @@saladin went on holidays or in quarantine or something though... haven't seen anything from him for a few weeks now
saladin 41 Posted March 22, 2020 Author Posted March 22, 2020 It doesn't work for me either... I think @@saladin went on holidays or in quarantine or something though... haven't seen anything from him for a few weeks now I just have to much work lately -> maybe in next week I could find some free time to release new version. Is there something I'm missing with regard to 'shuffle daily' vs llive'? I have several of my playlists set to shuffle daily, but they are not doing that. Thank you. Shuffle doesn't work right now -> I made mistake in code that need to be fixed. Update Type=Live Limit =10 Played Date Descending MediaType is Movie recently watched for movies is showing an issue for me, Content which i watched last night in Theatre and is marked as played, is not showing on this list Content which i have previously watched and markeed as unwatched is showing on the list* *dont quite know how played/unplayed and media play dates are stored in the database/their intended design/use and what "played date" on your plugin is actually keying against, maybe this content is right to show up as it was 'played' at one point in time. "Played date" sorts items only by "LastPlayedDate". But marked movie as played should also update "LastPlayedDate" and place movie on top of the list -> could you do for me a simple test? -> create new smartplaylist with "Movie Name" contains <name of this movie> and check if it shows up on the list. 1
Dibbes 445 Posted March 22, 2020 Posted March 22, 2020 I just have to much work lately -> maybe in next week I could find some free time to release new version. I was joking, mate... I hope all is well! Most of us IT people have a whole bunch of work making sure stuff keeps up and running and people can actually work from home instead of offices... In my case I'm trying to keep the provincial government and some other customers up and running, or at least their servers... Good luck and stay healthy!
ginjaninja 571 Posted March 22, 2020 Posted March 22, 2020 I just have to much work lately -> maybe in next week I could find some free time to release new version. Shuffle doesn't work right now -> I made mistake in code that need to be fixed. "Played date" sorts items only by "LastPlayedDate". But marked movie as played should also update "LastPlayedDate" and place movie on top of the list -> could you do for me a simple test? -> create new smartplaylist with "Movie Name" contains <name of this movie> and check if it shows up on the list. searching by name does show my missing movie so the plugin can see it. i will add additional conditions to try and work out what is going on and where its falling over. i have since played other movies and they are showing..toy story 4 shows twice for some reason. Sent from my SM-G955F using Tapatalk
PuffyToesToo 337 Posted March 23, 2020 Posted March 23, 2020 I'm not sure if anyone else is seeing this issue since the Emby update yesterday, but my smart playlists are mostly gone. Just posting to see if it happened to anyone else?
gillmacca01 179 Posted March 25, 2020 Posted March 25, 2020 Great plugin. Works almost perfectly for me. Just a couple of questions: 1.....I have a playlist for marvel tv/movies. Currently I have it listing all the tv shows and movies (long list as you can imagine), but was wondering if there was a way to tell it to show, for example, all movies/tv shows containing 'Hulk' (all under 1 entry rather than 2). This is just for making things look tidier. 2.....Is there a way to exclude stuff. I have a playlist for latest movies released in the last 6 months. This works, but I have a library containing WWE PPV's, which Emby classes as movies, and I would like to be able to exclude these from the playlist
ginjaninja 571 Posted March 25, 2020 Posted March 25, 2020 (edited) Creating a single simple live playlist which amounts to "search by name" seems to hog the server (spinning circle) for 30 seconds..anyone else seeing this (every time i press save on the smart playlist config)? 2020-03-25 17:52:53.760 Debug SqliteItemRepository: GetItems query time (slow): 2056ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 2020-03-25 17:52:56.751 Debug SqliteItemRepository: GetItems query time (slow): 2855ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 10000 2020-03-25 17:53:00.243 Debug SqliteItemRepository: GetItems query time (slow): 3366ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 20000 2020-03-25 17:53:03.984 Debug SqliteItemRepository: GetItems query time (slow): 3615ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 30000 2020-03-25 17:53:07.812 Debug SqliteItemRepository: GetItems query time (slow): 3703ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 40000 2020-03-25 17:53:11.878 Debug SqliteItemRepository: GetItems query time (slow): 3930ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 50000 2020-03-25 17:53:16.243 Debug SqliteItemRepository: GetItems query time (slow): 4239ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 60000 2020-03-25 17:53:20.655 Debug SqliteItemRepository: GetItems query time (slow): 4283ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 70000 2020-03-25 17:53:25.218 Debug SqliteItemRepository: GetItems query time (slow): 4439ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 80000 2020-03-25 17:53:29.833 Debug SqliteItemRepository: GetItems query time (slow): 4493ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 90000 2020-03-25 17:53:34.498 Debug SqliteItemRepository: GetItems query time (slow): 4543ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 100000 Edited March 25, 2020 by ginjaninja
Recommended Posts