“Classification of plant non-coding RNAs” (Liu 等, 2017, p. 2)
Referred in *circRNA
*circRNA 1 (3)(+0000001): [Better Notes for Zotero] 1 attachments found in refNotes (4)(+0000003): Beginning DB transaction 8rYe6qfX (3)(+0000002): Cloning item 6941 (4)(+0000000): Note hasn't changed (4)(+0000000): Tags haven't changed (4)(+0000000): Saving data for new item to database (4)(+0000001): INSERT INTO items (itemID, libraryID, key, clientDateModified, itemTypeID, dateAdded, dateModified) VALUES (?,?,?,?,?,?,?) [8167, 1, 'M6FNFF9T', '2024-11-18 05:11:02', 3, '2024-11-18 05:11:02', '2024-11-18 05:11:02'] (3)(+0000000): Notifier.trigger('add', 'item', [8167], {}) queued (3)(+0000001): Notifier.trigger('modify', 'item', [7021], {}) queued (4)(+0000000): INSERT INTO itemAttachments (itemID, parentItemID, linkMode, contentType, charsetID, path, syncState, storageModTime, storageHash, lastProcessedModificationTime) VALUES (?,?,?,?,NULL,?,?,NULL,NULL,NULL) [8167, 7021, 4, 'image/png', 'storage:image.png', 0] (3)(+0000001): Loading primaryData for 1 item in 我的文库 (4)(+0000000): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, createdByUserID, lastModifiedByUserID, 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 PRINTF('%s和%s', (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 PRINTF('%s和%s', (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 PRINTF('%s和%s', (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 3 THEN IAP.itemID WHEN 28 THEN INoP.itemID WHEN 1 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 3 THEN IAP.key WHEN 28 THEN INoP.key WHEN 1 THEN IAnP.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, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime, 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 itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.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 groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? AND O.itemID IN (7021) [1] (3)(+0000003): Loaded primaryData in 我的文库 in 3 ms (3)(+0000000): Loading childItems for 1 item 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=1 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (7021) ORDER BY parentItemID [1] (4)(+0000001): 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=? AND parentItemID IN (7021) ORDER BY parentItemID [1] (4)(+0000000): SELECT parentItemID, IAn.itemID, text || ' - ' || comment AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAnnotations IAn JOIN items I ON (IAn.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (7021) ORDER BY parentItemID, sortIndex [1] (4)(+0000001): SELECT itemID FROM items I WHERE libraryID=? AND itemID IN (7021) [1] (3)(+0000001): Loaded childItems in 我的文库 in 3 ms (4)(+0000000): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, createdByUserID, lastModifiedByUserID, 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 PRINTF('%s和%s', (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 PRINTF('%s和%s', (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 PRINTF('%s和%s', (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 3 THEN IAP.itemID WHEN 28 THEN INoP.itemID WHEN 1 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 3 THEN IAP.key WHEN 28 THEN INoP.key WHEN 1 THEN IAnP.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, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime, 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 itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.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 groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID=? [8167] (4)(+0000020): Committed DB transaction 8rYe6qfX (3)(+0000001): Committing notifier event queue [add-item: 1] [modify-item: 1] (3)(+0000000): Notifier.trigger('add', 'item', [8167], {"8167":{}}) called [observers: 32] (3)(+0000001): Yielding for refresh promise (3)(+0000020): Cancelling auto-sync timer (3)(+0000000): Setting auto-sync timeout to 3 seconds (3)(+0000001): Notifier.trigger('modify', 'item', [7021], {"7021":{}}) called [observers: 32] (3)(+0000001): Yielding for refresh promise (3)(+0000000): Sorting items list by title, firstCreator, date, dateAdded ascending for 1 item (3)(+0000001): Sorted 1 item in 1 ms (3)(+0000013): Yielding for select promise (3)(+0000002): Cancelling auto-sync timer (3)(+0000000): Setting auto-sync timeout to 3 seconds (3)(+0000000): [Better Notes for Zotero] updateNoteLinkRelation 7021 (3)(+0000027): Notifier.trigger('updateBNRelation', 'item', [7021,6940,7771,6374,6467,6920,6379,6381,6389,6397,6525,6582,6620,6953,7701,7708,7684,6460,6456,6433,6501,6715,6718,6483,6376,6732,6741,6753,6962,7187,7198,6412,6727,7786,6423,6635,6653,6670,7210,7179,7217,6623,6915,7759], {}) called [observers: 32] (3)(+0000000): Yielding for refresh promise (3)(+0000016): [Better Notes for Zotero] relation notify refresh graph 7021 (3)(+0000000): [Better Notes for Zotero] relation notify refresh link item [7021,6940,7771,6374,6467,6920,6379,6381,6389,6397,6525,6582,6620,6953,7701,7708,7684,6460,6456,6433,6501,6715,6718,6483,6376,6732,6741,6753,6962,7187,7198,6412,6727,7786,6423,6635,6653,6670,7210,7179,7217,6623,6915,7759] 7021 (3)(+0000001): [Better Notes for Zotero] relation notify refresh link item [7021,6940,7771,6374,6467,6920,6379,6381,6389,6397,6525,6582,6620,6953,7701,7708,7684,6460,6456,6433,6501,6715,6718,6483,6376,6732,6741,6753,6962,7187,7198,6412,6727,7786,6423,6635,6653,6670,7210,7179,7217,6623,6915,7759] 7021 (3)(+0002973): Notifier.trigger('start', 'sync', []) called [observers: 3] (3)(+0000001): Stopping full-text content processor (3)(+0000003): [ConcurrentCaller] Running function (0/4 running, 0 queued) (3)(+0000001): HTTP GET https://api.zotero.org/keys/current (3)(+0000738): HTTP GET https://api.zotero.org/keys/current succeeded with 200 (3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued) (3)(+0000001): { "userID": 11859116 "username": "Yolo_Yin" "displayName": "" "access": { "user": { "library": true "files": true "notes": true "write": true } "groups": { "all": { "library": true "write": true } } } } (4)(+0000002): Beginning DB transaction bodurgy3 (3)(+0000001): [ConcurrentCaller] All tasks are done (4)(+0000003): Committed DB transaction bodurgy3 (3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued) (3)(+0000000): HTTP GET https://api.zotero.org/users/11859116/groups?format=versions (3)(+0000252): HTTP GET https://api.zotero.org/users/11859116/groups?format=versions succeeded with 200 (3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued) (3)(+0000001): Local groups: (3)(+0000000): [] (3)(+0000000): Final libraries to sync: (3)(+0000001): [ "0": 1 ] (3)(+0000000): Starting data sync for 我的文库 (4)(+0000001): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [1] (3)(+0000001): [ConcurrentCaller] All tasks are done (3)(+0000002): No settings to upload in 我的文库 (4)(+0000001): 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)(+0000000): No collections to upload in 我的文库 (4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 1] (3)(+0000000): No collection deletions to upload in 我的文库 (4)(+0000001): 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)(+0000001): 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) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) WHERE libraryID=? AND synced=0 AND (IAn.isExternal IS NULL OR IAN.isExternal=0) [1] (4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'item'] (3)(+0000000): 1 item to upload in library 1 (4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 3] (3)(+0000000): No item deletions to upload in 我的文库 (3)(+0000000): {"item":[8167]} (4)(+0000000): Registering notifier observer 'itemsUpload_a0' for [item] (4)(+0000001): Beginning DB transaction 91WDgo3n (4)(+0000001): Committed DB transaction 91WDgo3n (3)(+0000001): UPLOAD BATCH: (3)(+0000000): [ "0": { "key": "M6FNFF9T" "version": 0 "itemType": "attachment" "parentItem": "EBJCRA3V" "linkMode": "embedded_image" "contentType": "image/png" "filename": "image.png" "dateAdded": "2024-11-18T05:11:02Z" "dateModified": "2024-11-18T05:11:02Z" } ] (3)(+0000000): Uploading 1 item (3)(+0000000): Sending If-Unmodified-Since-Version: 30338 (3)(+0000000): [ConcurrentCaller] Running function (0/4 running, 0 queued) (3)(+0000001): HTTP POST "[{"key":"M6FNFF9T","version":0,"itemType":"attachment","parentItem":"EBJCRA3V","linkMode":"embedded_image","contentType":"image/png","filename":"image.png","dateAdded":"2024-11-18T05:11:02Z","dateModified":"2024-11-18T05:11:02Z"}]" to https://api.zotero.org/users/11859116/items (3)(+0000341): HTTP POST https://api.zotero.org/users/11859116/items succeeded with 200 (3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued) (4)(+0000003): Field 'dateAdded' has not changed (4)(+0000001): Field 'dateModified' has not changed (3)(+0000001): Saving to sync cache: (3)(+0000001): [ "0": { "key": "M6FNFF9T" "version": 30339 "library": { "type": "user" "id": 11859116 "name": "Yolo_Yin" "links": { "alternate": { "href": "https://www.zotero.org/yolo_yin" "type": "text/html" } } } "links": { "self": { "href": "https://api.zotero.org/users/11859116/items/M6FNFF9T" "type": "application/json" } "alternate": { "href": "https://www.zotero.org/yolo_yin/items/M6FNFF9T" "type": "text/html" } "up": { "href": "https://api.zotero.org/users/11859116/items/EBJCRA3V" "type": "application/json" } } "meta": {} "data": { "key": "M6FNFF9T" "version": 30339 "parentItem": "EBJCRA3V" "itemType": "attachment" "linkMode": "embedded_image" "contentType": "image/png" "filename": "image.png" "md5": null "mtime": null "dateAdded": "2024-11-18T05:11:02Z" "dateModified": "2024-11-18T05:11:02Z" } } ] (4)(+0000001): INSERT OR REPLACE INTO syncCache (libraryID, key, syncObjectTypeID, version, data) VALUES (?, ?, ?, ?, ?) [1, 'M6FNFF9T', 3, 30339, '{"key":"M6FNFF9T","version":30339,"library":{"type":"user","id":11859116,"name":"Yolo_Yin","links":{"alternate":{"href":"https://www.zotero.org/yolo_yin","type":"text/html"}}},"links":{"self":{"href":"https://api.zotero.org/users/11859116/items/M6FNFF9T","type":"application/json"},"alternate":{"href":"https://www.zotero.org/yolo_yin/items/M6FNFF9T","type":"text/html"},"up":{"href":"https://api.zotero.org/users/11859116/items/EBJCRA3V","type":"application/json"}},"meta":{},"data":{"key":"M6FNFF9T","version":30339,"parentItem":"EBJCRA3V","itemType":"attachment","linkMode":"embedded_image","contentType":"image/png","filename":"image.png","md5":null,"mtime":null,"dateAdded":"2024-11-18T05:11:02Z","dateModified":"2024-11-18T05:11:02Z"}}'] (3)(+0000002): [ConcurrentCaller] All tasks are done (4)(+0000013): Beginning DB transaction Vbqo0uUa (4)(+0000002): Item 8167 has not changed (4)(+0000001): Updating database with new library data (4)(+0000000): UPDATE libraries SET version=?, storageVersion=? WHERE libraryID=? [30339, 30339, 1] (4)(+0000001): UPDATE items SET version=30339 WHERE itemID IN (?) [8167] (4)(+0000001): UPDATE items SET synced=1 WHERE itemID IN (?) [8167] (4)(+0000007): Committed DB transaction Vbqo0uUa (4)(+0000001): DELETE FROM syncCache WHERE ROWID IN (SELECT SC.ROWID FROM syncCache SC LEFT JOIN items O USING (libraryID, key, version) WHERE syncObjectTypeID=? AND SC.libraryID=? AND (O.libraryID IS NULL OR SC.version < O.version)) [3, 1] (2)(+0000005): Failed: 0 (4)(+0000000): Unregistering notifier observer in notifier with id 'itemsUpload_a0' (3)(+0000000): Done uploading items in library 1 (3)(+0000000): {} (4)(+0000000): Upload result is 1 (4)(+0000001): Updating database with new library data (4)(+0000000): Beginning DB transaction vndZnGU6 (4)(+0000000): UPDATE libraries SET lastSync=? WHERE libraryID=? [1731906666, 1] (4)(+0000006): Committed DB transaction vndZnGU6 (3)(+0000000): Done syncing 我的文库 (4)(+0000001): REPLACE INTO version (schema, version) VALUES ('lastsync', ?) [1731906667] (3)(+0000005): Starting file syncing (3)(+0000001): Done with file syncing (3)(+0000000): Starting full-text syncing (3)(+0000000): Done with full-text syncing (3)(+0000000): Done syncing (3)(+0000001): Notifier.trigger('finish', 'sync', []) called [observers: 3] (4)(+0000000): 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)(+0000000): 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)(+0000000): No feeds with auto-update