Photoprism: Difference in count of photos

[totti4ever]

I have a photo count of 894 stated at _Photos_ and 45 at _Review_, are the latter part of the former? Additionally a count of 57 videos is shown. Library --> Original says 1054.

Then in the database I have 951 rows in the photos table

And running find (inside the container) against the _original_ folder, it finds 870 jpg files and 53 movies.

How do these numbers belong together or where would I get more insight why they differ?
And why is the path in the files details of every video ending on jpg, therefore showing the preview?

[lastzero]

Short videos < 4s are shown as live photos, so probably 4 videos are this short? Photos includes those in review, but not in archive. Not sure why there are additional rows in the database if you only have 923 files. Maybe there are hidden files? Also files can be stacked, but then it would be less photos than files. Impossible to know exactly from where I sit.

[lastzero]

See #564 and #560

[totti4ever]

Okay, I could dig a bit deeper. What I don't understand is that I have a couple of duplicates, ending on .~1~ and so on (coming from mv operations). Some of them can be found in the files table, other cannot be found there. Permissions are the same. Those having own entries are shown in the library view as distinct files, linked to the same photo, which seems right.

How can I get more details on why others are not shown? Please understand I am quite picky; I just want to make sure all files are considered before using photoprism as single point of photo view! :-)

_Edit:_
Oh, I came to the idea to reindex that folder and have a closer view on the logs, sorry o_O

photoprism | time="2020-11-15T13:35:30+01:00" level=info msg="index: skipped duplicate related jpg file 20200618_075411_IMG.jpg.~1~"

photoprism | time="2020-11-15T13:48:37+01:00" level=info msg="index: updated related jpg file 20200912_163117_IMG_Olympus.jpg.~1~"

And I digged even deeper --> the "missing" one is a 100% dupicate, i.e. same sha256 checksum, while the others apparently somehow differ, at least they don't share the same checksum!