For the restore list oddity, you could set --unencrypted-database (if necessary for your database browser) and see if the Fileset table gets an entry. In case something else is upsetting listing, I did SQL comparison:
web UI restore initial web page build
2018-09-17 07:39:32 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Controller-RunList]: Starting - Running List
2018-09-17 07:39:32 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteScalarInt64]: Starting - ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES ("List", 1537184372); SELECT last_insert_rowid();
2018-09-17 07:39:32 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteScalarInt64]: ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES ("List", 1537184372); SELECT last_insert_rowid(); took 0:00:00:00.091
2018-09-17 07:39:32 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
2018-09-17 07:39:32 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 0:00:00:00.000
2018-09-17 07:39:32 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" AS SELECT DISTINCT "ID" AS "FilesetID", "Timestamp" AS "Timestamp" FROM "Fileset" WHERE "Timestamp" <= 1536864403
2018-09-17 07:39:32 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: CREATE TEMPORARY TABLE "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" AS SELECT DISTINCT "ID" AS "FilesetID", "Timestamp" AS "Timestamp" FROM "Fileset" WHERE "Timestamp" <= 1536864403 took 0:00:00:00.000
2018-09-17 07:39:32 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: CREATE INDEX "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F_FilesetIDTimestampIndex" ON "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" ("FilesetID", "Timestamp" DESC)
2018-09-17 07:39:32 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: CREATE INDEX "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F_FilesetIDTimestampIndex" ON "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" ("FilesetID", "Timestamp" DESC) took 0:00:00:00.000
2018-09-17 07:39:32 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: DELETE FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" WHERE "FilesetID" NOT IN (SELECT "FilesetID" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" ORDER BY "Timestamp" DESC LIMIT 1 )
2018-09-17 07:39:32 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: DELETE FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" WHERE "FilesetID" NOT IN (SELECT "FilesetID" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" ORDER BY "Timestamp" DESC LIMIT 1 ) took 0:00:00:00.000
2018-09-17 07:39:32 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: Starting - ExecuteReader: SELECT DISTINCT "A"."FilesetID", "B"."FileCount", "B"."FileSizes" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" A LEFT OUTER JOIN ( SELECT "A"."FilesetID" AS "FilesetID", COUNT(*) AS "FileCount", SUM("C"."Length") AS "FileSizes" FROM "FilesetEntry" A, "File" B, "Blockset" C WHERE "A"."FileID" = "B"."ID" AND "B"."BlocksetID" = "C"."ID" AND "A"."FilesetID" IN (SELECT DISTINCT "FilesetID" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F") GROUP BY "A"."FilesetID" ) B ON "A"."FilesetID" = "B"."FilesetID" ORDER BY "A"."Timestamp" DESC
2018-09-17 07:39:32 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: ExecuteReader: SELECT DISTINCT "A"."FilesetID", "B"."FileCount", "B"."FileSizes" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" A LEFT OUTER JOIN ( SELECT "A"."FilesetID" AS "FilesetID", COUNT(*) AS "FileCount", SUM("C"."Length") AS "FileSizes" FROM "FilesetEntry" A, "File" B, "Blockset" C WHERE "A"."FileID" = "B"."ID" AND "B"."BlocksetID" = "C"."ID" AND "A"."FilesetID" IN (SELECT DISTINCT "FilesetID" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F") GROUP BY "A"."FilesetID" ) B ON "A"."FilesetID" = "B"."FilesetID" ORDER BY "A"."Timestamp" DESC took 0:00:00:00.008
2018-09-17 07:39:32 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "Filenames-F22B356E6D9F8440BD0B572E8C95EB55" ("Path" TEXT NOT NULL)
2018-09-17 07:39:32 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: CREATE TEMPORARY TABLE "Filenames-F22B356E6D9F8440BD0B572E8C95EB55" ("Path" TEXT NOT NULL) took 0:00:00:00.000
2018-09-17 07:39:32 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: INSERT INTO "Filenames-F22B356E6D9F8440BD0B572E8C95EB55" SELECT DISTINCT "Path" FROM "File" WHERE "Path" LIKE "C:\USERS\TED\%"
2018-09-17 07:39:33 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: INSERT INTO "Filenames-F22B356E6D9F8440BD0B572E8C95EB55" SELECT DISTINCT "Path" FROM "File" WHERE "Path" LIKE "C:\USERS\TED\%" took 0:00:00:00.009
2018-09-17 07:39:33 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: DELETE FROM "Filenames-F22B356E6D9F8440BD0B572E8C95EB55" WHERE "Path" NOT IN (SELECT DISTINCT "Path" FROM "File", "FilesetEntry" WHERE "FilesetEntry"."FileID" = "File"."ID" AND "FilesetEntry"."FilesetID" IN (SELECT "FilesetID" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F") )
2018-09-17 07:39:33 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: DELETE FROM "Filenames-F22B356E6D9F8440BD0B572E8C95EB55" WHERE "Path" NOT IN (SELECT DISTINCT "Path" FROM "File", "FilesetEntry" WHERE "FilesetEntry"."FileID" = "File"."ID" AND "FilesetEntry"."FilesetID" IN (SELECT "FilesetID" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F") ) took 0:00:00:00.058
2018-09-17 07:39:33 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "Filenames-7131D1FA921E16459307B54FF71542E2" ("Path" TEXT NOT NULL)
2018-09-17 07:39:33 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: CREATE TEMPORARY TABLE "Filenames-7131D1FA921E16459307B54FF71542E2" ("Path" TEXT NOT NULL) took 0:00:00:00.000
2018-09-17 07:39:33 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: Starting - ExecuteReader: SELECT DISTINCT "Path" FROM "Filenames-F22B356E6D9F8440BD0B572E8C95EB55"
2018-09-17 07:39:33 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: ExecuteReader: SELECT DISTINCT "Path" FROM "Filenames-F22B356E6D9F8440BD0B572E8C95EB55" took 0:00:00:00.000
2018-09-17 07:39:33 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: CREATE INDEX "Filenames-7131D1FA921E16459307B54FF71542E2_PathIndex" ON "Filenames-7131D1FA921E16459307B54FF71542E2" ("Path")
2018-09-17 07:39:33 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: CREATE INDEX "Filenames-7131D1FA921E16459307B54FF71542E2_PathIndex" ON "Filenames-7131D1FA921E16459307B54FF71542E2" ("Path") took 0:00:00:00.000
2018-09-17 07:39:33 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: Starting - ExecuteReader: SELECT "C"."Path", "D"."Length", "C"."FilesetID" FROM (SELECT "A"."Path", "B"."FilesetID" FROM "Filenames-7131D1FA921E16459307B54FF71542E2" A, (SELECT "FilesetID", "Timestamp" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" ORDER BY "Timestamp" DESC) B ORDER BY "A"."Path" ASC, "B"."Timestamp" DESC) C LEFT OUTER JOIN (SELECT "Length", "FilesetEntry"."FilesetID", "File"."Path" FROM "Blockset", "FilesetEntry", "File" WHERE "File"."BlocksetID" = "Blockset"."ID" AND "FilesetEntry"."FileID" = "File"."ID" AND FilesetEntry."FilesetID" IN (SELECT DISTINCT "FilesetID" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F") ) D ON "C"."FilesetID" = "D"."FilesetID" AND "C"."Path" = "D"."Path"
2018-09-17 07:39:33 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: ExecuteReader: SELECT "C"."Path", "D"."Length", "C"."FilesetID" FROM (SELECT "A"."Path", "B"."FilesetID" FROM "Filenames-7131D1FA921E16459307B54FF71542E2" A, (SELECT "FilesetID", "Timestamp" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" ORDER BY "Timestamp" DESC) B ORDER BY "A"."Path" ASC, "B"."Timestamp" DESC) C LEFT OUTER JOIN (SELECT "Length", "FilesetEntry"."FilesetID", "File"."Path" FROM "Blockset", "FilesetEntry", "File" WHERE "File"."BlocksetID" = "Blockset"."ID" AND "FilesetEntry"."FileID" = "File"."ID" AND FilesetEntry."FilesetID" IN (SELECT DISTINCT "FilesetID" FROM "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F") ) D ON "C"."FilesetID" = "D"."FilesetID" AND "C"."Path" = "D"."Path" took 0:00:00:00.037
2018-09-17 07:39:33 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "Filenames-F22B356E6D9F8440BD0B572E8C95EB55"
2018-09-17 07:39:33 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: DROP TABLE IF EXISTS "Filenames-F22B356E6D9F8440BD0B572E8C95EB55" took 0:00:00:00.000
2018-09-17 07:39:33 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "Filenames-7131D1FA921E16459307B54FF71542E2"
2018-09-17 07:39:33 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: DROP TABLE IF EXISTS "Filenames-7131D1FA921E16459307B54FF71542E2" took 0:00:00:00.000
2018-09-17 07:39:33 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F"
2018-09-17 07:39:33 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: DROP TABLE IF EXISTS "Filesets-CAC30430AA7F2F4881D06CEBC079FD5F" took 0:00:00:00.000
2018-09-17 07:39:33 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Controller-RunList]: Running List took 0:00:00:00.263
Commandline list, no filename
Usage: find <storage-URL> ["<filename>"] [<options>]
Finds specific files in specific backups. If <filename> is specified, all
occurrences of <filename> in the backup are listed. <filename> can contain
* and ? as wildcards. File names in [brackets] are interpreted as regular
expression. Latest backup is searched by default. If entire path is
specified, all available versions of the file are listed. If no <filename>
is specified, a list of all available backups is shown.
2018-09-17 07:43:58 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Controller-RunList]: Starting - Running List
2018-09-17 07:43:58 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteScalarInt64]: Starting - ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES ("List", 1537184638); SELECT last_insert_rowid();
2018-09-17 07:43:58 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteScalarInt64]: ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES ("List", 1537184638); SELECT last_insert_rowid(); took 0:00:00:00.074
2018-09-17 07:43:58 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
2018-09-17 07:43:58 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 0:00:00:00.000
2018-09-17 07:43:58 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8" AS SELECT DISTINCT "ID" AS "FilesetID", "Timestamp" AS "Timestamp" FROM "Fileset"
2018-09-17 07:43:58 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: CREATE TEMPORARY TABLE "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8" AS SELECT DISTINCT "ID" AS "FilesetID", "Timestamp" AS "Timestamp" FROM "Fileset" took 0:00:00:00.000
2018-09-17 07:43:58 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: CREATE INDEX "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8_FilesetIDTimestampIndex" ON "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8" ("FilesetID", "Timestamp" DESC)
2018-09-17 07:43:58 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: CREATE INDEX "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8_FilesetIDTimestampIndex" ON "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8" ("FilesetID", "Timestamp" DESC) took 0:00:00:00.000
2018-09-17 07:43:58 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: Starting - ExecuteReader: SELECT DISTINCT "A"."FilesetID", "B"."FileCount", "B"."FileSizes" FROM "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8" A LEFT OUTER JOIN ( SELECT "A"."FilesetID" AS "FilesetID", COUNT(*) AS "FileCount", SUM("C"."Length") AS "FileSizes" FROM "FilesetEntry" A, "File" B, "Blockset" C WHERE "A"."FileID" = "B"."ID" AND "B"."BlocksetID" = "C"."ID" AND "A"."FilesetID" IN (SELECT DISTINCT "FilesetID" FROM "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8") GROUP BY "A"."FilesetID" ) B ON "A"."FilesetID" = "B"."FilesetID" ORDER BY "A"."Timestamp" DESC
2018-09-17 07:43:59 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: ExecuteReader: SELECT DISTINCT "A"."FilesetID", "B"."FileCount", "B"."FileSizes" FROM "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8" A LEFT OUTER JOIN ( SELECT "A"."FilesetID" AS "FilesetID", COUNT(*) AS "FileCount", SUM("C"."Length") AS "FileSizes" FROM "FilesetEntry" A, "File" B, "Blockset" C WHERE "A"."FileID" = "B"."ID" AND "B"."BlocksetID" = "C"."ID" AND "A"."FilesetID" IN (SELECT DISTINCT "FilesetID" FROM "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8") GROUP BY "A"."FilesetID" ) B ON "A"."FilesetID" = "B"."FilesetID" ORDER BY "A"."Timestamp" DESC took 0:00:00:00.152
2018-09-17 07:43:59 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8"
2018-09-17 07:43:59 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: DROP TABLE IF EXISTS "Filesets-A95CCE2BD58BB644B3FD68954F5A96C8" took 0:00:00:00.000
2018-09-17 07:43:59 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Controller-RunList]: Running List took 0:00:00:00.271
Commandline list, no filename, and with --list-sets-only
--list-sets-only (Boolean): List only filesets
Use this option to only list filesets and avoid traversing file names and
other metadata which slows down the process
* default value: false
2018-09-17 07:36:04 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Controller-RunList]: Starting - Running List
2018-09-17 07:36:04 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteScalarInt64]: Starting - ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES ("List", 1537184164); SELECT last_insert_rowid();
2018-09-17 07:36:04 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteScalarInt64]: ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES ("List", 1537184164); SELECT last_insert_rowid(); took 0:00:00:00.307
2018-09-17 07:36:04 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
2018-09-17 07:36:04 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 0:00:00:00.000
2018-09-17 07:36:04 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "Filesets-F7B41C5513744440932872D9CDBC7852" AS SELECT DISTINCT "ID" AS "FilesetID", "Timestamp" AS "Timestamp" FROM "Fileset"
2018-09-17 07:36:04 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: CREATE TEMPORARY TABLE "Filesets-F7B41C5513744440932872D9CDBC7852" AS SELECT DISTINCT "ID" AS "FilesetID", "Timestamp" AS "Timestamp" FROM "Fileset" took 0:00:00:00.000
2018-09-17 07:36:04 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: CREATE INDEX "Filesets-F7B41C5513744440932872D9CDBC7852_FilesetIDTimestampIndex" ON "Filesets-F7B41C5513744440932872D9CDBC7852" ("FilesetID", "Timestamp" DESC)
2018-09-17 07:36:04 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: CREATE INDEX "Filesets-F7B41C5513744440932872D9CDBC7852_FilesetIDTimestampIndex" ON "Filesets-F7B41C5513744440932872D9CDBC7852" ("FilesetID", "Timestamp" DESC) took 0:00:00:00.000
2018-09-17 07:36:04 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: Starting - ExecuteReader: SELECT DISTINCT "ID" FROM "Fileset" ORDER BY "Timestamp" DESC <-- (NOTE: this SQL got simpler)
2018-09-17 07:36:04 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteReader]: ExecuteReader: SELECT DISTINCT "ID" FROM "Fileset" ORDER BY "Timestamp" DESC took 0:00:00:00.000
2018-09-17 07:36:04 -04 - [Profiling-Timer.Begin-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "Filesets-F7B41C5513744440932872D9CDBC7852"
2018-09-17 07:36:04 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Database.ExtensionMethods-ExecuteNonQuery]: ExecuteNonQuery: DROP TABLE IF EXISTS "Filesets-F7B41C5513744440932872D9CDBC7852" took 0:00:00:00.000
2018-09-17 07:36:04 -04 - [Profiling-Timer.Finished-Duplicati.Library.Main.Controller-RunList]: Running List took 0:00:00:00.320
Each one gets less ambitious than the one before it. Maybe at some point your missing version will show up, however if you chose to peek at the database, and saw nothing added, no simplified SQL is going to show it.