点击空格后，quicklook无反应

gistfile1.txt

version => 5.0.89, platform => Win32, oscpu => Windows NT 10.0; WOW64, locale => zh-CN, appName => Zotero, appVersion => 5.0.89, extensions => Zutilo Zotero 工具箱 (3.4.0, extension), ZotFile (5.0.16, extension), Zotero DOI Manager (1.3.9, extension), Zotero LibreOffice Integration (5.0.23.SA.5.0.89, extension), Zotero Word for Windows Integration (5.0.16.SA.5.0.89, extension), ZoteroQuickLook (1.4.2, extension)

(3)(+0000000): Using data directory D:\[01]Files\Zotero Storage

(3)(+0000012): Asynchronously opening database 'zotero'

(3)(+0000000): D:\[01]Files\Zotero Storage\zotero.sqlite

(4)(+0000010): PRAGMA main.locking_mode=EXCLUSIVE

(4)(+0000002): PRAGMA page_size

(4)(+0000001): PRAGMA cache_size=2000

(4)(+0000000): PRAGMA foreign_keys=true

(4)(+0000059): SELECT version FROM version WHERE schema='system'

(4)(+0000004): SELECT version FROM version WHERE schema='userdata'

(4)(+0000001): SELECT version FROM version WHERE schema='compatibility'

(3)(+0000000): Proxy required for https://zoteroproxycheck.s3.amazonaws.com/test -- making HEAD request to trigger auth prompt

(3)(+0000001): HTTP HEAD https://zoteroproxycheck.s3.amazonaws.com/test

(4)(+0000002): SELECT value FROM settings WHERE setting='db' AND key='integrityCheck'

(3)(+0000000): HTTP GET resource://zotero/schema/global/schema.json

(3)(+0000003): HTTP GET resource://zotero/schema/global/schema.json succeeded with 200

(4)(+0000004): SELECT version FROM version WHERE schema='globalSchema'

(3)(+0000006): Database is up to date with global schema version 11 -- skipping update

(3)(+0000000): HTTP GET resource://zotero/schema/userdata.sql

(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200

(4)(+0000000): PRAGMA foreign_keys = false

(4)(+0000002): Beginning DB transaction Me6U0NV3

(3)(+0000001): HTTP GET resource://zotero/schema/system.sql

(3)(+0000001): HTTP GET resource://zotero/schema/system.sql succeeded with 200

(3)(+0000001): Updating custom tables

(4)(+0000001): DELETE FROM itemTypesCombined

(4)(+0000001): SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND tbl_name=? ['customItemTypes']

(4)(+0000008): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)

(4)(+0000001): DELETE FROM itemTypeFieldsCombined

(4)(+0000001): DELETE FROM baseFieldMappingsCombined

(4)(+0000001): INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypes

(4)(+0000000): INSERT OR IGNORE INTO fieldsCombined SELECT fieldID, fieldName, NULL AS label, fieldFormatID, 0 AS custom FROM fields UNION SELECT customFieldID + 10000 AS fieldID, fieldName, label, NULL, 1 AS custom FROM customFields

(4)(+0000001): INSERT INTO itemTypeFieldsCombined SELECT itemTypeID, fieldID, hide, orderIndex FROM itemTypeFields UNION SELECT customItemTypeID + 10000 AS itemTypeID, COALESCE(fieldID, customFieldID + 10000) AS fieldID, hide, orderIndex FROM customItemTypeFields

(4)(+0000002): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings

(3)(+0000002): HTTP GET resource://zotero/schema/userdata.sql

(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200

(4)(+0000000): SELECT version FROM version WHERE schema='triggers'

(3)(+0000001): HTTP GET resource://zotero/schema/triggers.sql

(3)(+0000004): HTTP GET resource://zotero/schema/triggers.sql succeeded with 200

(3)(+0000001): Updating custom tables

(4)(+0000000): DELETE FROM itemTypesCombined

(4)(+0000001): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)

(4)(+0000001): DELETE FROM itemTypeFieldsCombined

(4)(+0000000): DELETE FROM baseFieldMappingsCombined

(4)(+0000001): INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypes

(4)(+0000000): INSERT OR IGNORE INTO fieldsCombined SELECT fieldID, fieldName, NULL AS label, fieldFormatID, 0 AS custom FROM fields UNION SELECT customFieldID + 10000 AS fieldID, fieldName, label, NULL, 1 AS custom FROM customFields

(4)(+0000001): INSERT INTO itemTypeFieldsCombined SELECT itemTypeID, fieldID, hide, orderIndex FROM itemTypeFields UNION SELECT customItemTypeID + 10000 AS itemTypeID, COALESCE(fieldID, customFieldID + 10000) AS fieldID, hide, orderIndex FROM customItemTypeFields

(4)(+0000001): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings

(4)(+0000004): Committed DB transaction Me6U0NV3

(4)(+0000001): PRAGMA foreign_keys = true

(4)(+0000001): Beginning DB transaction Ez8Zrtq5

(4)(+0000002): SELECT value FROM settings WHERE setting='client' AND key='lastVersion'

(4)(+0000002): Committed DB transaction Ez8Zrtq5

(4)(+0000002): SELECT key, value FROM settings WHERE setting='account'

(4)(+0000001): SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches FROM libraries L WHERE type NOT IN (?,?) ['feed', 'group']

(4)(+0000002): SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches, F.name AS _feedName, F.url AS _feedUrl, F.lastUpdate AS _feedLastUpdate, F.lastCheck AS _feedLastCheck, F.lastCheckError AS _feedLastCheckError, F.cleanupUnreadAfter AS _feedCleanupUnreadAfter, F.cleanupReadAfter AS _feedCleanupReadAfter, F.refreshInterval AS _feedRefreshInterval, (SELECT COUNT(*) FROM items I JOIN feedItems FI USING (itemID) WHERE I.libraryID=F.libraryID AND FI.readTime IS NULL) AS _feedUnreadCount FROM feeds F JOIN libraries L USING (libraryID)

(4)(+0000001): SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches, G.groupID, G.name AS _groupName, G.description AS _groupDescription, G.version AS _groupVersion FROM groups G JOIN libraries L USING (libraryID)

(4)(+0000002): SELECT COALESCE(MAX(collectionID) + 1, 1) FROM collections

(4)(+0000000): SELECT COALESCE(MAX(creatorID) + 1, 1) FROM creators

(4)(+0000001): SELECT COALESCE(MAX(creatorTypeID) + 1, 1) FROM creatorTypes

(4)(+0000000): SELECT COALESCE(MAX(customFieldID) + 1, 1) FROM customFields

(4)(+0000001): SELECT COALESCE(MAX(customItemTypeID) + 1, 1) FROM customItemTypes

(4)(+0000000): SELECT COALESCE(MAX(fieldID) + 1, 1) FROM fields

(4)(+0000001): SELECT COALESCE(MAX(valueID) + 1, 1) FROM itemDataValues

(4)(+0000000): SELECT COALESCE(MAX(itemTypeID) + 1, 1) FROM itemTypes

(4)(+0000001): SELECT COALESCE(MAX(itemID) + 1, 1) FROM items

(4)(+0000000): SELECT COALESCE(MAX(libraryID) + 1, 1) FROM libraries

(4)(+0000001): SELECT COALESCE(MAX(proxyID) + 1, 1) FROM proxies

(4)(+0000000): SELECT COALESCE(MAX(savedSearchID) + 1, 1) FROM savedSearches

(4)(+0000004): SELECT COALESCE(MAX(tagID) + 1, 1) FROM tags

(4)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined

(4)(+0000002): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE typeName IN ('book', 'bookSection', 'journalArticle', 'newspaperArticle', 'document')

(4)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display != 0 AND display NOT IN ('book', 'bookSection', 'journalArticle', 'newspaperArticle', 'document')

(4)(+0000000): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display=0

(4)(+0000001): SELECT customItemTypeID AS id, label, icon FROM customItemTypes

(4)(+0000001): SELECT * FROM fieldFormats

(4)(+0000000): SELECT * FROM fieldsCombined

(4)(+0000001): SELECT fieldID, itemTypeID FROM itemTypeFieldsCombined

(4)(+0000009): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined

(4)(+0000005): SELECT IT.itemTypeID, F.fieldID AS baseFieldID, BFM.fieldID FROM itemTypesCombined IT LEFT JOIN fieldsCombined F LEFT JOIN baseFieldMappingsCombined BFM ON (IT.itemTypeID=BFM.itemTypeID AND F.fieldID=BFM.baseFieldID)

(4)(+0000021): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined

(4)(+0000042): SELECT itemTypeID, baseFieldID, fieldID, fieldName FROM baseFieldMappingsCombined JOIN fieldsCombined USING (fieldID)

(4)(+0000002): SELECT DISTINCT fieldID FROM baseFieldMappingsCombined

(4)(+0000001): SELECT itemTypeID, fieldID FROM itemTypeFieldsCombined ORDER BY orderIndex

(4)(+0000006): SELECT creatorTypeID AS id, creatorType AS name FROM creatorTypes

(4)(+0000001): SELECT itemTypeID, creatorTypeID AS id, creatorType AS name, primaryField FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes

(4)(+0000012): SELECT itemTypeID, creatorTypeID FROM itemTypeCreatorTypes WHERE primaryField=1

(4)(+0000003): SELECT fileTypeID AS id, fileType AS name FROM fileTypes

(4)(+0000001): SELECT charsetID AS id, charset AS name FROM charsets

(4)(+0000001): SELECT predicateID AS id, predicate AS name FROM relationPredicates

(3)(+0000001): Running unlock callbacks

(3)(+0000000): HTTP server listening on 127.0.0.1:23119

(4)(+0000001): ATTACH ':memory:' AS 'indexing'

(4)(+0000001): CREATE TABLE indexing.fulltextWords (word NOT NULL)

(4)(+0000002): SELECT version FROM version WHERE schema='lastsync'

(4)(+0000001): SELECT name, syncObjectTypeID AS id FROM syncObjectTypes

(3)(+0000002): Registering auto-sync idle observer

(3)(+0000001): Registering URIContentListener

(4)(+0000000): SELECT * FROM proxies

(4)(+0000002): SELECT ROWID AS id, libraryID, key FROM collections

(4)(+0000002): SELECT ROWID AS id, libraryID, key FROM items

(3)(+0000000): Getting contents of D:\[01]Files\Zotero Storage\locate\engines.json

(4)(+0000017): SELECT ROWID AS id, libraryID, key FROM savedSearches

(4)(+0000003): SELECT fieldName FROM fieldsCombined WHERE fieldName NOT IN ('accessDate', 'date', 'pages', 'section','seriesNumber','issue')

(1)(+0000002): Unknown item type 'nsfReviewer'

(1)(+0000000): Unknown item type 'nsfReviewer'

(4)(+0000006): SELECT tagID, name FROM tags

(4)(+0000013): SELECT * FROM creators

(3)(+0000015): Loading collection relations

(4)(+0000000): SELECT * FROM collectionRelations JOIN relationPredicates USING (predicateID)

(3)(+0000002): Loaded collection relations in 2 ms

(3)(+0000000): Loading item relations

(4)(+0000000): SELECT * FROM itemRelations JOIN relationPredicates USING (predicateID)

(3)(+0000002): Loaded item relations in 2 ms

(4)(+0000000): CREATE TABLE IF NOT EXISTS retractedItems ( itemID INTEGER PRIMARY KEY, data TEXT, FOREIGN KEY (itemID) REFERENCES items(itemID) ON DELETE CASCADE );

(4)(+0000001): ALTER TABLE retractedItems ADD COLUMN flag INT DEFAULT 0

(4)(+0000002): SELECT itemID AS id, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [58]

(4)(+0000013): SELECT itemID AS id, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [16]

(4)(+0000084): SELECT itemID AS id, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [16]

(3)(+0000013): Getting contents of C:\Users\Huawei\AppData\Roaming\Zotero\Zotero\Profiles\lzv3qtf8.default\retractions.json

(4)(+0000030): SELECT libraryID, itemID, DI.itemID IS NOT NULL AS deleted, RI.flag FROM items JOIN retractedItems RI USING (itemID) LEFT JOIN deletedItems DI USING (itemID)

(4)(+0000001): SELECT COUNT(*) FROM settings WHERE setting='globalSchema' AND key='migrateExtra'

(3)(+0000001): Loading synced settings for library 1

(4)(+0000000): SELECT setting, value, synced, version FROM syncedSettings WHERE libraryID=? [1]

(3)(+0000004): Loading all collections in 我的文库

(3)(+0000001): Loading primaryData for collections in 我的文库

(4)(+0000001): SELECT O.collectionID, O.collectionName AS name, O.libraryID, O.key, O.version, O.synced, O.parentCollectionID AS parentID, CP.key AS parentKey, (SELECT COUNT(*) FROM collections WHERE parentCollectionID=O.collectionID) != 0 AS hasChildCollections, (SELECT COUNT(*) FROM collectionItems WHERE collectionID=O.collectionID) != 0 AS hasChildItems FROM collections O LEFT JOIN collections CP ON (O.parentCollectionID=CP.collectionID) WHERE 1 AND O.libraryID=? [1]

(3)(+0000003): Loaded primaryData in 我的文库 in 4 ms

(3)(+0000001): Loading childCollections for collections in 我的文库

(4)(+0000000): SELECT C1.collectionID, C2.collectionID AS childCollectionID FROM collections C1 LEFT JOIN collections C2 ON (C1.collectionID=C2.parentCollectionID) WHERE C1.libraryID=? [1]

(3)(+0000001): Loaded childCollections in 我的文库 in 1 ms

(3)(+0000001): Loading childItems for collections in 我的文库

(4)(+0000000): SELECT collectionID, itemID FROM collections LEFT JOIN collectionItems USING (collectionID) WHERE libraryID=? [1]

(3)(+0000003): Loaded childItems in 我的文库 in 3 ms

(3)(+0000001): Loading relations for collections in 我的文库

(4)(+0000000): SELECT collectionID, predicate, object FROM collections LEFT JOIN collectionRelations USING (collectionID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [1]

(3)(+0000002): Loaded relations in 我的文库 in 2 ms

(3)(+0000000): Loaded collections in 我的文库 in 14 ms

(3)(+0000001): Loading all searches in 我的文库

(3)(+0000000): Loading primaryData for searches in 我的文库

(4)(+0000001): SELECT O.savedSearchID, O.savedSearchName AS name, O.libraryID, O.key, O.version, O.synced FROM savedSearches O WHERE 1 AND O.libraryID=? [1]

(3)(+0000001): Loaded primaryData in 我的文库 in 2 ms

(3)(+0000000): Loading conditions for searches in 我的文库

(4)(+0000001): SELECT savedSearchID, searchConditionID, condition, operator, value, required FROM savedSearches LEFT JOIN savedSearchConditions USING (savedSearchID) WHERE libraryID=?ORDER BY savedSearchID, searchConditionID [1]

(3)(+0000001): Loaded conditions in 我的文库 in 2 ms

(3)(+0000000): Loaded searches in 我的文库 in 5 ms

(3)(+0000000): Loading synced settings for library 2

(4)(+0000000): SELECT setting, value, synced, version FROM syncedSettings WHERE libraryID=? [2]

(3)(+0000001): Loading all collections in Accept

(3)(+0000001): Loading primaryData for collections in Accept

(4)(+0000000): SELECT O.collectionID, O.collectionName AS name, O.libraryID, O.key, O.version, O.synced, O.parentCollectionID AS parentID, CP.key AS parentKey, (SELECT COUNT(*) FROM collections WHERE parentCollectionID=O.collectionID) != 0 AS hasChildCollections, (SELECT COUNT(*) FROM collectionItems WHERE collectionID=O.collectionID) != 0 AS hasChildItems FROM collections O LEFT JOIN collections CP ON (O.parentCollectionID=CP.collectionID) WHERE 1 AND O.libraryID=? [2]

(3)(+0000000): Loaded primaryData in Accept in 1 ms

(3)(+0000001): Loading childCollections for collections in Accept

(4)(+0000000): SELECT C1.collectionID, C2.collectionID AS childCollectionID FROM collections C1 LEFT JOIN collections C2 ON (C1.collectionID=C2.parentCollectionID) WHERE C1.libraryID=? [2]

(3)(+0000000): Loaded childCollections in Accept in 0 ms

(3)(+0000001): Loading childItems for collections in Accept

(4)(+0000000): SELECT collectionID, itemID FROM collections LEFT JOIN collectionItems USING (collectionID) WHERE libraryID=? [2]

(3)(+0000001): Loaded childItems in Accept in 1 ms

(3)(+0000000): Loading relations for collections in Accept

(4)(+0000000): SELECT collectionID, predicate, object FROM collections LEFT JOIN collectionRelations USING (collectionID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [2]

(3)(+0000001): Loaded relations in Accept in 1 ms

(3)(+0000000): Loaded collections in Accept in 5 ms

(3)(+0000000): Loading all searches in Accept

(3)(+0000001): Loading primaryData for searches in Accept

(4)(+0000000): SELECT O.savedSearchID, O.savedSearchName AS name, O.libraryID, O.key, O.version, O.synced FROM savedSearches O WHERE 1 AND O.libraryID=? [2]

(3)(+0000001): Loaded primaryData in Accept in 1 ms

(3)(+0000000): Loading conditions for searches in Accept

(4)(+0000000): SELECT savedSearchID, searchConditionID, condition, operator, value, required FROM savedSearches LEFT JOIN savedSearchConditions USING (savedSearchID) WHERE libraryID=?ORDER BY savedSearchID, searchConditionID [2]

(3)(+0000001): Loaded conditions in Accept in 1 ms

(3)(+0000000): Loaded searches in Accept in 3 ms

(3)(+0000000): Initializing Quick Copy

(3)(+0000001): Running initialization callbacks

(3)(+0000000): Triggering "zotero-loaded" event

(3)(+0000002): Initializing Zotero pane

(3)(+0000005): Creating collections view with id 0t8dzROG

(3)(+0000001): Refreshing collections pane

(4)(+0000001): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [1]

(3)(+0000041): Rendering tag selector

(3)(+0000003): Rendering tag list

(3)(+0000021): LibreOfficePlugin: Communication server listening on 127.0.0.1:23116

(3)(+0000000): LibreOfficePlugin: Registering shutdown listener

(4)(+0000032): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID=? [1]

(4)(+0000007): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 和 ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 等。' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 和 ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 等。' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 和 ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 等。' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 2 THEN IAP.itemID WHEN 26 THEN INoP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID IN (2800,2109,2822,2150,1449,2814,2779,2053,2107,2170,2145,2732,2738,2147,2167,2785,2795,2812,1507,2727)

(3)(+0000010): Loaded items in 10ms

(4)(+0000001): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [2]

(4)(+0000005): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID=? [2]

(3)(+0000004): Creating items view with id M1U1KEIB

(3)(+0000000): Waiting for items to load for library 1

(3)(+0000001): Loading all items in 我的文库

(3)(+0000000): Loading primaryData for items in 我的文库

(4)(+0000002): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 和 ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 等。' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 和 ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 等。' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 和 ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 等。' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 2 THEN IAP.itemID WHEN 26 THEN INoP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? [1]

(3)(+0000085): Loaded primaryData in 我的文库 in 87 ms

(3)(+0000000): Loading creators for items in 我的文库

(4)(+0000000): SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT JOIN itemCreators USING (itemID) WHERE libraryID=? ORDER BY itemID, orderIndex [1]

(3)(+0000002): Rendering tag selector

(3)(+0000001): Rendering tag list

(3)(+0000004): Tag selector updated

(3)(+0000027): Loaded creators in 我的文库 in 34 ms

(3)(+0000000): Loading itemData for items in 我的文库

(4)(+0000001): SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID) JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=? [1, 26]

(4)(+0000098): SELECT itemID FROM items WHERE libraryID=? [1]

(3)(+0000002): PluginInstaller: fetching addon info

(3)(+0000001): PluginInstaller: addon info fetched

(4)(+0000030): SELECT itemID, title FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments) [1]

(3)(+0000011): Loaded itemData in 我的文库 in 143 ms

(3)(+0000000): Loading note for items in 我的文库

(4)(+0000001): SELECT itemID, note FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? [1]

(4)(+0000007): SELECT itemID FROM items WHERE libraryID=? AND itemTypeID IN (?, ?) AND itemID NOT IN (SELECT itemID FROM itemNotes) [1, 26, 2]

(3)(+0000003): Loaded note in 我的文库 in 11 ms

(3)(+0000000): Loading childItems for items in 我的文库

(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [1]

(4)(+0000005): SELECT parentItemID, N.itemID, title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemNotes N JOIN items I ON (N.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [1]

(4)(+0000002): SELECT itemID FROM items I WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments UNION SELECT itemID FROM itemNotes) [1]

(3)(+0000003): Loaded childItems in 我的文库 in 10 ms

(3)(+0000000): Loading tags for items in 我的文库

(4)(+0000001): SELECT itemID, name, type FROM items LEFT JOIN itemTags USING (itemID) LEFT JOIN tags USING (tagID) WHERE libraryID=? [1]

(3)(+0000026): Loaded tags in 我的文库 in 27 ms

(3)(+0000000): Loading collections for items in 我的文库

(4)(+0000000): SELECT itemID, collectionID FROM items LEFT JOIN collectionItems USING (itemID) WHERE libraryID=? [1]

(3)(+0000007): Loaded collections in 我的文库 in 7 ms

(3)(+0000000): Loading relations for items in 我的文库

(4)(+0000000): SELECT itemID, predicate, object FROM items LEFT JOIN itemRelations USING (itemID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [1]

(3)(+0000009): Loaded relations in 我的文库 in 9 ms

(3)(+0000000): Loaded items in 我的文库 in 328 ms

(3)(+0000001): Setting tree for C46 items view M1U1KEIB

(3)(+0000001): Refreshing items list for M1U1KEIB

(4)(+0000007): CREATE TEMPORARY TABLE tmpSearchResults_mwcO3smW AS SELECT itemID FROM items WHERE (itemID NOT IN (SELECT itemID FROM deletedItems) AND itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems))) AND (itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL)) AND itemID IN (SELECT itemID FROM items WHERE (libraryID=?)) AND itemID IN (SELECT itemID FROM collectionItems WHERE (collectionID IN (46))) [1]

(4)(+0000005): CREATE INDEX tmpSearchResults_mwcO3smW_itemID ON tmpSearchResults_mwcO3smW(itemID)

(4)(+0000001): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT itemID FROM items WHERE (itemID NOT IN (SELECT itemID FROM deletedItems) AND itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems))) AND itemID IN (SELECT itemID FROM items WHERE (libraryID=?))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_mwcO3smW) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_mwcO3smW)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_mwcO3smW))) [1]

(4)(+0000002): DROP TABLE IF EXISTS tmpSearchResults_mwcO3smW

(3)(+0000003): Sorting items list by dateAdded, firstCreator, date, title descending for 12 items

(3)(+0000003): Sorted 12 items in 3 ms

(3)(+0000000): Refreshed open parents in 0 ms

(3)(+0000003): Rendering tag selector

(3)(+0000001): Rendering tag list

(3)(+0000004): Tag selector updated

(3)(+0000000): Updating tag selector from current view

(3)(+0000000): Creating tmpSearchResults_nlyNmOJp with 23 items

(3)(+0000004): Set tree for items view M1U1KEIB in 34 ms

(3)(+0000001): User interface ready in 1606 ms

(3)(+0000012): Connecting to streaming server at wss://stream.zotero.org/

(4)(+0000047): CREATE UNIQUE INDEX tmpSearchResults_nlyNmOJp_itemID ON tmpSearchResults_nlyNmOJp(itemID)

(4)(+0000007): SELECT DISTINCT tagID || ':' || type FROM itemTags JOIN tags USING (tagID) WHERE 1 AND itemID IN (SELECT itemID FROM tmpSearchResults_nlyNmOJp) ORDER BY name COLLATE NOCASE

(3)(+0000005): Sorted tags in 2 ms

(3)(+0000001): Rendering tag selector

(3)(+0000006): Rendering tag list

(3)(+0000025): Tag selector updated

(3)(+0002638): HTTP HEAD https://zoteroproxycheck.s3.amazonaws.com/test succeeded with 200

(3)(+0000006): Notifier.trigger('start', 'sync', []) called [observers: 2]

(4)(+0000004): Beginning DB transaction zGO15BQI

(4)(+0000002): Committed DB transaction zGO15BQI

(4)(+0000001): Beginning DB transaction vqdVMLD0

(4)(+0000006): CREATE TEMPORARY TABLE tagDelete AS SELECT tagID FROM tags WHERE tagID NOT IN (SELECT tagID FROM itemTags)

(4)(+0000002): CREATE INDEX tagDelete_tagID ON tagDelete(tagID)

(4)(+0000000): SELECT tagID AS id, name FROM tagDelete JOIN tags USING (tagID)

(4)(+0000001): DROP TABLE tagDelete

(4)(+0000001): Committed DB transaction vqdVMLD0

(4)(+0000001): Beginning DB transaction 4hWr4ktv

(4)(+0000001): Committed DB transaction 4hWr4ktv

(3)(+0000000): Purged data tables in 15 ms

(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)

(3)(+0000001): HTTP GET https://api.zotero.org/keys/current

(3)(+0000921): WebSocket connection opened

(3)(+0000001): WebSocket message: {"event":"connected","retry":10000}

(3)(+0000008): WebSocket message send: {"action":"createSubscriptions","subscriptions":[{"apiKey":"********"},{"topics":["styles","translators"]}]}

(3)(+0000044): Updating bundled files

(3)(+0000001): Initializing translators

(4)(+0000000): SELECT rowid, fileName, metadataJSON, lastModifiedTime FROM translatorCache

(3)(+0000165): Cached 546 translators in 165 ms

(3)(+0000004): HTTP GET resource://zotero/schema/repotime.txt

(3)(+0000000): HTTP GET resource://zotero/schema/repotime.txt succeeded with 200

(4)(+0000002): SELECT version FROM version WHERE schema='delete'

(3)(+0000001): Getting contents of input stream

(4)(+0000002): SELECT version FROM version WHERE schema=? ['translators']

(3)(+0000001): Installed translators are up-to-date with XPI

(3)(+0000001): Initializing styles

(3)(+0000003): Getting contents of D:\[01]Files\Zotero Storage\styles\american-chemical-society.csl

(3)(+0000004): Getting contents of D:\[01]Files\Zotero Storage\styles\american-medical-association.csl

(3)(+0000002): Getting contents of D:\[01]Files\Zotero Storage\styles\american-political-science-association.csl

(3)(+0000001): Getting contents of D:\[01]Files\Zotero Storage\styles\american-sociological-association.csl

(3)(+0000003): Getting contents of D:\[01]Files\Zotero Storage\styles\apa.csl

(3)(+0000006): Getting contents of D:\[01]Files\Zotero Storage\styles\chicago-author-date.csl

(3)(+0000003): Getting contents of D:\[01]Files\Zotero Storage\styles\chicago-fullnote-bibliography.csl

(3)(+0000005): Getting contents of D:\[01]Files\Zotero Storage\styles\chicago-note-bibliography.csl

(3)(+0000004): Getting contents of D:\[01]Files\Zotero Storage\styles\elsevier-harvard.csl

(3)(+0000002): Getting contents of D:\[01]Files\Zotero Storage\styles\harvard-cite-them-right.csl

(3)(+0000003): Getting contents of D:\[01]Files\Zotero Storage\styles\ieee-transactions-on-electron-devices.csl

(3)(+0000002): Getting contents of D:\[01]Files\Zotero Storage\styles\ieee.csl

(3)(+0000002): Getting contents of D:\[01]Files\Zotero Storage\styles\modern-humanities-research-association.csl

(3)(+0000002): Getting contents of D:\[01]Files\Zotero Storage\styles\modern-language-association.csl

(3)(+0000003): Getting contents of D:\[01]Files\Zotero Storage\styles\nature.csl

(3)(+0000002): Getting contents of D:\[01]Files\Zotero Storage\styles\vancouver.csl

(3)(+0000003): Cached 16 styles in 50 ms

(3)(+0000000): HTTP GET chrome://zotero/content/locale/csl/locales.json

(3)(+0000001): HTTP GET chrome://zotero/content/locale/csl/locales.json succeeded with 200

(3)(+0000001): HTTP GET resource://zotero/schema/renamed-styles.json

(3)(+0000000): HTTP GET resource://zotero/schema/renamed-styles.json succeeded with 200

(3)(+0000004): HTTP GET resource://zotero/schema/repotime.txt

(3)(+0000000): HTTP GET resource://zotero/schema/repotime.txt succeeded with 200

(4)(+0000002): SELECT version FROM version WHERE schema='delete'

(3)(+0000001): Getting contents of input stream

(3)(+0000001): HTTP GET https://api.zotero.org/keys/current succeeded with 200

(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued)

(3)(+0000003): { "userID": 6773622 "username": "beckeet_buaa" "access": { "user": { "library": true "files": true "notes": true "write": true } "groups": { "all": { "library": true "write": true } } } }

(4)(+0000001): Beginning DB transaction hBFqNzi1

(4)(+0000002): SELECT version FROM version WHERE schema=? ['styles']

(3)(+0000000): [ConcurrentCaller] All tasks are done

(4)(+0000001): Committed DB transaction hBFqNzi1

(3)(+0000003): [ConcurrentCaller] Running function (0/4 running, 0 queued)

(3)(+0000000): HTTP GET https://api.zotero.org/users/6773622/groups?format=versions

(3)(+0000002): Installed styles are up-to-date with XPI

(3)(+0000001): HTTP GET https://api.zotero.org/retractions/list

(3)(+0000210): WebSocket message: {"event":"subscriptionsCreated","subscriptions":[{"apiKey":"********","topics":["/users/6773622","/users/6773622/publications","/groups/2539681"]},{"topics":["styles","translators"]}],"errors":[]}

(3)(+0000154): HTTP GET https://api.zotero.org/users/6773622/groups?format=versions succeeded with 200

(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued)

(3)(+0000002): Adding group library 2 to sync

(3)(+0000000): Local groups:

(3)(+0000000): [ "0": 2539681 ]

(3)(+0000000): Final libraries to sync:

(3)(+0000000): [ "0": 1 "1": 2 ]

(3)(+0000001): Loading all items in Accept

(3)(+0000000): Loading primaryData for items in Accept

(4)(+0000001): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 和 ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 等。' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 和 ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 等。' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 和 ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 等。' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 2 THEN IAP.itemID WHEN 26 THEN INoP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? [2]

(3)(+0000001): [ConcurrentCaller] All tasks are done

(3)(+0000001): Loaded primaryData in Accept in 3 ms

(3)(+0000000): Loading creators for items in Accept

(4)(+0000000): SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT JOIN itemCreators USING (itemID) WHERE libraryID=? ORDER BY itemID, orderIndex [2]

(3)(+0000001): Loaded creators in Accept in 1 ms

(3)(+0000000): Loading itemData for items in Accept

(4)(+0000001): SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID) JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=? [2, 26]

(4)(+0000000): SELECT itemID FROM items WHERE libraryID=? [2]

(4)(+0000001): SELECT itemID, title FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments) [2]

(3)(+0000000): Loaded itemData in Accept in 2 ms

(3)(+0000001): Loading note for items in Accept

(4)(+0000000): SELECT itemID, note FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? [2]

(4)(+0000000): SELECT itemID FROM items WHERE libraryID=? AND itemTypeID IN (?, ?) AND itemID NOT IN (SELECT itemID FROM itemNotes) [2, 26, 2]

(3)(+0000001): Loaded note in Accept in 1 ms

(3)(+0000000): Loading childItems for items in Accept

(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [2]

(4)(+0000002): SELECT parentItemID, N.itemID, title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemNotes N JOIN items I ON (N.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [2]

(4)(+0000000): SELECT itemID FROM items I WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments UNION SELECT itemID FROM itemNotes) [2]

(3)(+0000001): Loaded childItems in Accept in 3 ms

(3)(+0000000): Loading tags for items in Accept

(4)(+0000000): SELECT itemID, name, type FROM items LEFT JOIN itemTags USING (itemID) LEFT JOIN tags USING (tagID) WHERE libraryID=? [2]

(3)(+0000001): Loaded tags in Accept in 1 ms

(3)(+0000000): Loading collections for items in Accept

(4)(+0000000): SELECT itemID, collectionID FROM items LEFT JOIN collectionItems USING (itemID) WHERE libraryID=? [2]

(3)(+0000001): Loaded collections in Accept in 1 ms

(3)(+0000000): Loading relations for items in Accept

(4)(+0000000): SELECT itemID, predicate, object FROM items LEFT JOIN itemRelations USING (itemID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [2]

(3)(+0000001): Loaded relations in Accept in 1 ms

(3)(+0000000): Loaded items in Accept in 14 ms

(3)(+0000001): Starting data sync for 我的文库

(4)(+0000000): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [1]

(3)(+0000001): No settings to upload in 我的文库

(4)(+0000000): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [1]

(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'collection']

(3)(+0000001): No collections to upload in 我的文库

(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 1]

(3)(+0000001): No collection deletions to upload in 我的文库

(4)(+0000000): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [1]

(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'search']

(3)(+0000000): No searches to upload in 我的文库

(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 4]

(3)(+0000001): No search deletions to upload in 我的文库

(4)(+0000000): SELECT O.itemID FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) WHERE libraryID=? AND synced=0 ORDER BY COALESCE(IA.parentItemID, INo.parentItemID) [1]

(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'item']

(3)(+0000000): No items to upload in 我的文库

(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 3]

(3)(+0000001): No item deletions to upload in 我的文库

(4)(+0000001): Upload result is 2

(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)

(3)(+0000000): HTTP GET https://api.zotero.org/users/6773622/settings?since=645

(3)(+0000337): HTTP GET https://api.zotero.org/users/6773622/settings?since=645 succeeded with 304

(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued)

(4)(+0000003): SELECT key, lastCheck, tries FROM syncQueue WHERE libraryID=? [1]

(3)(+0000000): [ConcurrentCaller] All tasks are done

(3)(+0000001): Library 1 hasn't been modified -- skipping further object downloads

(4)(+0000000): Download result is 3

(4)(+0000001): Updating database with new library data

(4)(+0000000): Beginning DB transaction BmNxIeiz

(4)(+0000001): UPDATE libraries SET lastSync=? WHERE libraryID=? [1597121530, 1]

(4)(+0000011): Committed DB transaction BmNxIeiz

(3)(+0000000): Done syncing 我的文库

(3)(+0000001): Starting data sync for Accept

(4)(+0000000): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [2]

(3)(+0000001): No settings to upload in Accept

(4)(+0000000): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [2]

(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [2, 'collection']

(3)(+0000001): No collections to upload in Accept

(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [2, 1]

(3)(+0000001): No collection deletions to upload in Accept

(4)(+0000000): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [2]

(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [2, 'search']

(3)(+0000000): No searches to upload in Accept

(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [2, 4]

(3)(+0000001): No search deletions to upload in Accept

(4)(+0000000): SELECT O.itemID FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) WHERE libraryID=? AND synced=0 ORDER BY COALESCE(IA.parentItemID, INo.parentItemID) [2]

(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [2, 'item']

(3)(+0000000): No items to upload in Accept

(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [2, 3]

(3)(+0000001): No item deletions to upload in Accept

(4)(+0000000): Upload result is 2

(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)

(3)(+0000000): HTTP GET https://api.zotero.org/groups/2539681/settings?since=61

(3)(+0000193): HTTP GET https://api.zotero.org/retractions/list succeeded with 304

(3)(+0000000): Retraction list is up to date

(4)(+0000002): SELECT version FROM version WHERE schema='repository'

(3)(+0000001): Checking repository for translator and style updates

(3)(+0000002): HTTP POST "styles=%5B%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-chemical-society%22%2C%22updated%22%3A1583882370%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-chemical-society%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-medical-association%22%2C%22updated%22%3A1588472596%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-medical-association%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-political-science-association%22%2C%22updated%22%3A1448384762%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-political-science-association%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-sociological-association%22%2C%22updated%22%3A1582084687%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-sociological-association%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fapa%22%2C%22updated%22%3A1594610023%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fap…" (3194 chars) to https://repo.zotero.org/repo/updated?last=1597121178&version=5.0.89&m=3

(3)(+0000117): HTTP GET https://api.zotero.org/groups/2539681/settings?since=61 succeeded with 304

(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued)

(4)(+0000004): SELECT key, lastCheck, tries FROM syncQueue WHERE libraryID=? [2]

(3)(+0000001): [ConcurrentCaller] All tasks are done

(3)(+0000001): Library 2 hasn't been modified -- skipping further object downloads

(4)(+0000000): Download result is 3

(4)(+0000001): Updating database with new group data

(4)(+0000000): Beginning DB transaction ARw2RcYt

(4)(+0000006): UPDATE libraries SET lastSync=? WHERE libraryID=? [1597121530, 2]

(5)(+0000001): Group data did not change for group 2539681

(4)(+0000006): Committed DB transaction ARw2RcYt

(3)(+0000000): Done syncing Accept

(4)(+0000001): REPLACE INTO version (schema, version) VALUES ('lastsync', ?) [1597121531]

(3)(+0000002): Starting file syncing

(3)(+0000002): File sync is not enabled for 我的文库

(3)(+0000001): File sync is not enabled for Accept

(3)(+0000000): Done with file syncing

(3)(+0000001): Starting full-text syncing

(3)(+0000000): Starting full-text sync for 我的文库

(4)(+0000000): SELECT version FROM version WHERE schema=? ['fulltext_1']

(3)(+0000003): Library version hasn't changed -- skipping full-text download

(3)(+0000000): Uploading full-text content for 我的文库

(4)(+0000001): SELECT itemID, indexedChars, totalChars, indexedPages, totalPages FROM fulltextItems FI JOIN items I USING (itemID) WHERE libraryID=? AND FI.synced=? AND I.synced=1 ORDER BY itemID [1, 0]

(3)(+0000000): Starting full-text sync for Accept

(4)(+0000001): SELECT version FROM version WHERE schema=? ['fulltext_2']

(3)(+0000000): Library version hasn't changed -- skipping full-text download

(3)(+0000000): Uploading full-text content for Accept

(4)(+0000000): SELECT itemID, indexedChars, totalChars, indexedPages, totalPages FROM fulltextItems FI JOIN items I USING (itemID) WHERE libraryID=? AND FI.synced=? AND I.synced=1 ORDER BY itemID [2, 0]

(3)(+0000001): Done with full-text syncing

(3)(+0000001): Done syncing

(3)(+0000000): Notifier.trigger('finish', 'sync', []) called [observers: 2]

(3)(+0001306): HTTP POST https://repo.zotero.org/repo/updated?last=1597121178&version=5.0.89&m=3 succeeded with 200

(4)(+0000001): Beginning DB transaction Xbetsi9t

(4)(+0000005): REPLACE INTO version (schema,version) VALUES (?,?) ['repository', 1597121530]

(4)(+0000002): REPLACE INTO version (schema,version) VALUES (?,?) ['lastcheck', 1597121532]

(4)(+0000005): Committed DB transaction Xbetsi9t

(3)(+0000001): All translators and styles are up-to-date

(3)(+0000001): ZoteroQuickLook: starts init

(3)(+0000000): ZoteroQuickLook: Script location is undefined

(3)(+0000000): ZoteroQuickLook: finished init

(3)(+0000000): ZoteroQuickLook loaded

(3)(+0000000): Initializing DB backup idle observer

(4)(+0000003): Beginning DB transaction LBZsCraP

(4)(+0000005): SELECT key AS domainPath, value AS format FROM settings WHERE setting='quickCopySite'

(4)(+0000006): Committed DB transaction LBZsCraP

(4)(+0000001): Beginning DB transaction 6ka1vhkn

(4)(+0000001): CREATE TEMPORARY TABLE tagDelete AS SELECT tagID FROM tags WHERE tagID NOT IN (SELECT tagID FROM itemTags)

(4)(+0000002): CREATE INDEX tagDelete_tagID ON tagDelete(tagID)

(4)(+0000001): SELECT tagID AS id, name FROM tagDelete JOIN tags USING (tagID)

(4)(+0000001): DROP TABLE tagDelete

(4)(+0000009): Committed DB transaction 6ka1vhkn

(4)(+0000001): Beginning DB transaction 05pjmCCs

(4)(+0000001): Committed DB transaction 05pjmCCs

(3)(+0000001): Purged data tables in 30 ms

(4)(+0003064): SELECT COUNT(*) FROM settings WHERE setting='mImport' AND key='cleanup'

(3)(+0001908): Scheduling next feed update

(4)(+0000001): SELECT ( CASE WHEN lastCheck IS NULL THEN 0 ELSE strftime('%s', lastCheck) + refreshInterval * 60 - strftime('%s', 'now') END ) AS nextCheck FROM feeds WHERE refreshInterval IS NOT NULL ORDER BY nextCheck ASC LIMIT 1

(3)(+0000003): No feeds with auto-update

(4)(+0000002): SELECT libraryID AS id FROM feeds WHERE refreshInterval IS NOT NULL AND ( lastCheck IS NULL OR (julianday(lastCheck, 'utc') + (refreshInterval/1440.0) - julianday('now', 'utc')) <= 0 )

(3)(+0000003): Running update for feeds:

(3)(+0000001): All feed updates done

(3)(+0000001): Scheduling next feed update

(4)(+0000000): SELECT ( CASE WHEN lastCheck IS NULL THEN 0 ELSE strftime('%s', lastCheck) + refreshInterval * 60 - strftime('%s', 'now') END ) AS nextCheck FROM feeds WHERE refreshInterval IS NOT NULL ORDER BY nextCheck ASC LIMIT 1

(3)(+0000002): No feeds with auto-update