Skip to content

Instantly share code, notes, and snippets.

@bwiernik

bwiernik/debug_output_startup.html Secret

Created March 17, 2020 15:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bwiernik/ceabf6b97ce89455e2eaf1dbba277505 to your computer and use it in GitHub Desktop.
Save bwiernik/ceabf6b97ce89455e2eaf1dbba277505 to your computer and use it in GitHub Desktop.
Download ZIP
zotero_debug_startup
Raw
debug_output_startup.html
<!DOCTYPE html>
<html><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta charset="UTF-8">
<title>Debug Output</title>
<script src="Debug%20Output_files/include.js"></script>
<script src="Debug%20Output_files/debugViewer.js"></script>
<style>
body {
margin: 0;
background: white;
}
a {
text-decoration: underline;
}
header {
position: fixed;
top: 0;
background: lightgrey;
display: flex;
align-items: center;
width: calc(100% - 20px);
height: 18px;
padding: 10px;
margin-bottom: 10px;
font-family: sans-serif;
font-size: 11pt;
}
header > * {
margin-right: 10px;
}
progress {
width: 125px;
}
#debug-id {
font-weight: bold;
}
#submit-result {
line-height: 1.25em;
}
#submit-result-copy-id {
cursor: pointer;
padding-left: 2px;
}
#submit-error {
font-weight: bold;
color: red;
}
#content {
margin-top: 38px;
padding: 10px 9px;
font-family: Monaco, Consolas, Inconsolata, monospace;
font-size: 8pt;
}
#errors {
padding-bottom: 12px;
border-bottom: 1px lightgray solid;
white-space: pre-wrap;
}
/*
CSS tooltip, adapted from http://stackoverflow.com/a/25836471
*/
[data-tooltip] {
display: inline-block;
position: relative;
cursor: pointer;
padding: 2px;
}
[data-tooltip]:before {
content: attr(data-tooltip);
display: none;
position: absolute;
background: #000;
color: #fff;
padding: 4px 8px;
font-size: 12px;
font-family: sans-serif;
line-height: 1.4;
text-align: center;
border-radius: 4px;
left: 50%;
transform: translateX(-50%);
top: 100%;
margin-top: 6px;
white-space: nowrap;
}
[data-tooltip]:after {
content: '';
display: none;
position: absolute;
width: 0;
height: 0;
border-color: transparent;
border-style: solid;
left: 50%;
margin-left: -6px;
top: 100%;
border-width: 0 6px 6px;
border-bottom-color: #000;
}
/* Show the tooltip when hovering */
[data-tooltip]:hover:before,
[data-tooltip]:hover:after {
display: block;
z-index: 50;
}
</style>
</head>
<body>
<header>
<button id="submit-button" onclick="submit(this)">Submit…</button>
<button id="clear-button" onclick="clearOutput(this)">Clear</button>
<progress id="submit-progress"></progress>
<p id="submit-result" hidden="">
Submitted with Debug ID <span id="debug-id"></span>
<span id="submit-result-copy-id" onclick="copyIDToClipboard(this)">📋</span>
</p>
<p id="submit-error" hidden=""></p>
</header>
<div id="content">
<div id="errors">version =&gt; 5.0.85-beta.8+dd9ec54c3, platform =&gt; Win32, oscpu =&gt; Windows NT 10.0; WOW64, locale =&gt; en-US, appName =&gt; Zotero, appVersion =&gt; 5.0.85-beta.8+dd9ec54c3, extensions =&gt; Zotero DOI Manager (1.3.9, extension), ZoteroQuickLook (1.4.2, extension), Zutilo Utility for Zotero (3.4.0, extension), Better BibTex for Zotero (5.2.18, extension), Zotero LibreOffice Integration (5.0.22.SA.5.0.85-beta.8+dd9ec54c3, extension), Zotero Word for Windows Integration (5.0.14.SA.5.0.85-beta.8+dd9ec54c3, extension), ZotFile (5.0.16, extension, disabled)</div>
<div id="output"><p>(3)(+0000000): Using data directory C:\Users\brenton\Zotero</p><p>(3)(+0000010): Asynchronously opening database 'zotero'</p><p>(3)(+0000000): C:\Users\brenton\Zotero\zotero.sqlite</p><p>(4)(+0000011): PRAGMA main.locking_mode=EXCLUSIVE</p><p>(4)(+0000002): PRAGMA page_size</p><p>(4)(+0000003): PRAGMA cache_size=2000</p><p>(4)(+0000005): PRAGMA foreign_keys=true</p><p>(4)(+0000103): SELECT version FROM version WHERE schema='system'</p><p>(4)(+0000003): SELECT version FROM version WHERE schema='userdata'</p><p>(4)(+0000002): SELECT version FROM version WHERE schema='compatibility'</p><p>(3)(+0000001): Proxy not required for https://zoteroproxycheck.s3.amazonaws.com/test</p><p>(4)(+0000004): SELECT value FROM settings WHERE setting='db' AND key='integrityCheck'</p><p>(3)(+0000004): HTTP GET resource://zotero/schema/global/schema.json</p><p>(3)(+0000004): HTTP GET resource://zotero/schema/global/schema.json succeeded with 200</p><p>(4)(+0000004): SELECT version FROM version WHERE schema='globalSchema'</p><p>(3)(+0000001): Database is up to date with global schema version 7 -- skipping update</p><p>(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql</p><p>(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200</p><p>(4)(+0000000): PRAGMA foreign_keys = false</p><p>(4)(+0000004): Beginning DB transaction QTWJT6Cj</p><p>(3)(+0000003): HTTP GET resource://zotero/schema/system.sql</p><p>(3)(+0000002): HTTP GET resource://zotero/schema/system.sql succeeded with 200</p><p>(3)(+0000001): Updating custom tables</p><p>(4)(+0000001): DELETE FROM itemTypesCombined</p><p>(4)(+0000002): SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND tbl_name=? ['customItemTypes']</p><p>(4)(+0000003): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)</p><p>(4)(+0000007): DELETE FROM itemTypeFieldsCombined</p><p>(4)(+0000001): DELETE FROM baseFieldMappingsCombined</p><p>(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</p><p>(4)(+0000001):
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</p><p>(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</p><p>(4)(+0000002): INSERT INTO
baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM
baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID,
baseFieldID, customFieldID + 10000 AS fieldID FROM
customBaseFieldMappings</p><p>(3)(+0000005): HTTP GET resource://zotero/schema/userdata.sql</p><p>(3)(+0000003): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200</p><p>(4)(+0000001): SELECT version FROM version WHERE schema='triggers'</p><p>(3)(+0000001): HTTP GET resource://zotero/schema/triggers.sql</p><p>(3)(+0000001): HTTP GET resource://zotero/schema/triggers.sql succeeded with 200</p><p>(3)(+0000001): Updating custom tables</p><p>(4)(+0000000): DELETE FROM itemTypesCombined</p><p>(4)(+0000001): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)</p><p>(4)(+0000001): DELETE FROM itemTypeFieldsCombined</p><p>(4)(+0000000): DELETE FROM baseFieldMappingsCombined</p><p>(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</p><p>(4)(+0000001):
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</p><p>(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</p><p>(4)(+0000002): INSERT INTO
baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM
baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID,
baseFieldID, customFieldID + 10000 AS fieldID FROM
customBaseFieldMappings</p><p>(4)(+0000020): Committed DB transaction QTWJT6Cj</p><p>(4)(+0000001): PRAGMA foreign_keys = true</p><p>(4)(+0000003): Beginning DB transaction QtnGAtlQ</p><p>(4)(+0000004): SELECT value FROM settings WHERE setting='client' AND key='lastVersion'</p><p>(4)(+0000002): Committed DB transaction QtnGAtlQ</p><p>(4)(+0000001): SELECT key, value FROM settings WHERE setting='account'</p><p>(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(*)&gt;0 FROM collections C WHERE C.libraryID=L.libraryID) AS
hasCollections, (SELECT COUNT(*)&gt;0 FROM savedSearches S WHERE
S.libraryID=L.libraryID) AS hasSearches FROM libraries L WHERE type NOT
IN (?,?) ['feed', 'group']</p><p>(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(*)&gt;0 FROM collections C WHERE
C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)&gt;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)</p><p>(4)(+0000005):
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(*)&gt;0 FROM collections C WHERE C.libraryID=L.libraryID) AS
hasCollections, (SELECT COUNT(*)&gt;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)</p><p>(4)(+0000009): SELECT COALESCE(MAX(collectionID) + 1, 1) FROM collections</p><p>(4)(+0000001): SELECT COALESCE(MAX(creatorID) + 1, 1) FROM creators</p><p>(4)(+0000001): SELECT COALESCE(MAX(creatorTypeID) + 1, 1) FROM creatorTypes</p><p>(4)(+0000001): SELECT COALESCE(MAX(customFieldID) + 1, 1) FROM customFields</p><p>(4)(+0000002): SELECT COALESCE(MAX(customItemTypeID) + 1, 1) FROM customItemTypes</p><p>(4)(+0000002): SELECT COALESCE(MAX(fieldID) + 1, 1) FROM fields</p><p>(4)(+0000003): SELECT COALESCE(MAX(valueID) + 1, 1) FROM itemDataValues</p><p>(4)(+0000001): SELECT COALESCE(MAX(itemTypeID) + 1, 1) FROM itemTypes</p><p>(4)(+0000001): SELECT COALESCE(MAX(itemID) + 1, 1) FROM items</p><p>(4)(+0000002): SELECT COALESCE(MAX(libraryID) + 1, 1) FROM libraries</p><p>(4)(+0000001): SELECT COALESCE(MAX(proxyID) + 1, 1) FROM proxies</p><p>(4)(+0000001): SELECT COALESCE(MAX(savedSearchID) + 1, 1) FROM savedSearches</p><p>(4)(+0000001): SELECT COALESCE(MAX(tagID) + 1, 1) FROM tags</p><p>(4)(+0000003): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined</p><p>(4)(+0000009):
SELECT itemTypeID AS id, typeName AS name, custom FROM
itemTypesCombined WHERE typeName IN ('book', 'bookSection',
'journalArticle', 'newspaperArticle', 'document')</p><p>(4)(+0000003):
SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined
WHERE display != 0 AND display NOT IN ('book', 'bookSection',
'journalArticle', 'newspaperArticle', 'document')</p><p>(4)(+0000002): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display=0</p><p>(4)(+0000002): SELECT customItemTypeID AS id, label, icon FROM customItemTypes</p><p>(4)(+0000004): SELECT * FROM fieldFormats</p><p>(4)(+0000005): SELECT * FROM fieldsCombined</p><p>(4)(+0000004): SELECT fieldID, itemTypeID FROM itemTypeFieldsCombined</p><p>(4)(+0000019): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined</p><p>(4)(+0000021):
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)</p><p>(4)(+0000074): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined</p><p>(4)(+0000115):
SELECT itemTypeID, baseFieldID, fieldID, fieldName FROM
baseFieldMappingsCombined JOIN fieldsCombined USING (fieldID)</p><p>(4)(+0000008): SELECT DISTINCT fieldID FROM baseFieldMappingsCombined</p><p>(4)(+0000002): SELECT itemTypeID, fieldID FROM itemTypeFieldsCombined ORDER BY orderIndex</p><p>(4)(+0000021): SELECT creatorTypeID AS id, creatorType AS name FROM creatorTypes</p><p>(4)(+0000004):
SELECT itemTypeID, creatorTypeID AS id, creatorType AS name,
primaryField FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes</p><p>(4)(+0000031): SELECT itemTypeID, creatorTypeID FROM itemTypeCreatorTypes WHERE primaryField=1</p><p>(4)(+0000005): SELECT fileTypeID AS id, fileType AS name FROM fileTypes</p><p>(4)(+0000004): SELECT charsetID AS id, charset AS name FROM charsets</p><p>(4)(+0000005): SELECT predicateID AS id, predicate AS name FROM relationPredicates</p><p>(3)(+0000001): Running unlock callbacks</p><p>(3)(+0000001): HTTP server listening on 127.0.0.1:23119</p><p>(4)(+0000002): ATTACH ':memory:' AS 'indexing'</p><p>(4)(+0000002): CREATE TABLE indexing.fulltextWords (word NOT NULL)</p><p>(4)(+0000002): SELECT version FROM version WHERE schema='lastsync'</p><p>(4)(+0000002): SELECT name, syncObjectTypeID AS id FROM syncObjectTypes</p><p>(3)(+0000005): Registering URIContentListener</p><p>(4)(+0000002): SELECT * FROM proxies</p><p>(4)(+0000010): SELECT ROWID AS id, libraryID, key FROM collections</p><p>(3)(+0000007): Getting contents of C:\Users\brenton\Zotero\locate\engines.json</p><p>(4)(+0000016): SELECT ROWID AS id, libraryID, key FROM items</p><p>(4)(+0003164): SELECT ROWID AS id, libraryID, key FROM savedSearches</p><p>(4)(+0000047):
SELECT fieldName FROM fieldsCombined WHERE fieldName NOT IN
('accessDate', 'date', 'pages', 'section','seriesNumber','issue')</p><p>(1)(+0000012): Unknown item type 'nsfReviewer'</p><p>(1)(+0000001): Unknown item type 'nsfReviewer'</p><p>(4)(+0000018): SELECT tagID, name FROM tags</p><p>(4)(+0000193): SELECT * FROM creators</p><p>(3)(+0001294): Loading collection relations</p><p>(4)(+0000001): SELECT * FROM collectionRelations JOIN relationPredicates USING (predicateID)</p><p>(3)(+0000023): Loaded collection relations in 24 ms</p><p>(3)(+0000000): Loading item relations</p><p>(4)(+0000001): SELECT * FROM itemRelations JOIN relationPredicates USING (predicateID)</p><p>(3)(+0000973): Loaded item relations in 974 ms</p><p>(4)(+0000002): CREATE TABLE IF NOT EXISTS retractedItems (
itemID INTEGER PRIMARY KEY,
data TEXT,
FOREIGN KEY (itemID) REFERENCES items(itemID) ON DELETE CASCADE
);</p><p>(3)(+0000002): No general proxy or PAC file found -- assuming direct connection</p><p>(4)(+0000066): ALTER TABLE retractedItems ADD COLUMN flag INT DEFAULT 0</p><p>(4)(+0000016): SELECT itemID AS id, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [26]</p><p>(4)(+0002553): SELECT itemID AS id, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [22]</p><p>(4)(+0013461): SELECT itemID AS id, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [22]</p><p>(3)(+0000372): Getting contents of C:\Users\brenton\AppData\Roaming\Zotero\Zotero\Profiles\6y8u1jo0.default\retractions.json</p><p>(4)(+0000110):
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)</p><p>(4)(+0000033): SELECT COUNT(*) FROM settings WHERE setting='globalSchema' AND key='migrateExtra'</p><p>(4)(+0000009): SELECT itemID, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [22]</p><p>(4)(+0008449):
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) ||
' and ' || (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) ||
' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE
itemID=O.itemID AND creatorTypeID=3) WHEN 0 THEN NULL WHEN 1 THEN
(SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE
itemID=O.itemID AND creatorTypeID=3) WHEN 2 THEN (SELECT (SELECT
lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID
AND creatorTypeID=3 ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT
lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID
AND creatorTypeID=3 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT
(SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE
itemID=O.itemID AND creatorTypeID=3 ORDER BY orderIndex LIMIT 1) || ' et
al.' ) 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) || ' and ' || (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) || ' et
al.' ) 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=3) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' ||
firstName FROM itemCreators NATURAL JOIN creators WHERE
itemID=O.itemID AND creatorTypeID=3) WHEN 2 THEN (SELECT (SELECT
lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators
WHERE itemID=O.itemID AND creatorTypeID=3 ORDER BY orderIndex LIMIT 1)
|| ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators
NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=3 ORDER BY
orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' ||
firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID
AND creatorTypeID=3 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT
lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators
WHERE itemID=O.itemID AND creatorTypeID=3 ORDER BY orderIndex LIMIT 1,1)
|| ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators
NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=3 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 14 THEN IAP.itemID WHEN 1 THEN
INoP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 14 THEN IAP.key
WHEN 1 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
(256,281,2520,2521,2522,2523,2524,2525,2526,2527,2528,2639,2643,2660,2704,2728,2729,2730,2735,2806,2807,2816,2822,2823,2824,2825,2826,2827,2830,2832,2834,2835,2836,2837,2838,2839,2840,2842,2845,2848,2851,2924,2927,2931,3040,3041,3043,3047,3050,3051,3076,3077,3078,3079,3082,3166,3169,3170,3197,3205,3206,3236,3240,3243,3247,3263,3266,3268,3283,3286,3288,3291,3292,3295,3301,3311,3312,3316,3319,3327,3330,3333,3335,3336,3346,3356,3362,3365,3367,3378,3386,3388,3391,3397,3404,3414,3431,3437,3441,3447,3450,3451,3458,3459,3460,3461,3462,3466,3489,3496,3501,3503,3521,3522,3533,3643,3650,3657,3667,3703,3711,3721,3725,3736,3748,3749,3751,3752,3755,3756,3757,3758,3759,3760,3761,3764,3765,3766,3815,3817,3822,3857,3859,3868,3882,3883,3884,3886,3898,3908,3910,3932,3933,3948,3951,3954,3955,3959,3960,3964,3965,3976,3977,3978,3984,3985,3986,3987,3988,3989,3990,3992,3996,3997,3998,3999,4004,4007,4012,4016,4017,4018,4020,4021,4024,4028,4029,4033,4034,4035,4039,4040,4041,4043,4045,4050,4054,4058,4059,4063,4065,4068,4069,4070,4071,4076,4077,4080,4083,4084,4086,4088,4089,4090,4092,4097,4099,4100,4104,4109,4117,4118,4119,4120,4123,4124,4126,4129,4132,4133,4138,4139,4141,4142,4145,4146,4148,4149,4166,4174,4178,4179,4180,4185,4191,4192,4193,4194,4199,4212,4215,4219,4224,4229,4235,4238,4244,4248,4250,4252,4253,4258,4260,4262,4267,4271,4274,4285,4286,4288,4291,4292,4295,4306,4308,4310,4311,4322,4323,4324,4325,4328,4335,4342,4343,4352,4358,4359,4362,4369,4371,4381,4382,4387,4388,4395,4396,4397,4400,4405,4406,4409,4413,4415,4417,4420,4425,4426,4432,4434,4435,4436,4437,4578,5126,5829,5936,6086,6144,6170,6892,7952,8118,8148,8168,8170,8378,8379,8380,8396,8397,8410,8411,8426,8428,8459,8470,8471,8481,8490,8502,8517,8524,8721,8886,9204,9511,9568,9667,9865,9935,10043,10044,10055,10062,10064,10080,10084,10092,10093,10094,10095,10096,10097,10098,10099,10100,10101,10102,10103,10104,10105,10106,10107,10108,10109,10110,10111,10112,10113,10114,10143,10148,10202,10204,10208,10209,10227,10290,10297,10301,10302,10303,10304,10305,10306,10307,10310,10311,10389,10421,10427,10659,10730,10859,10895,10906,10942,10995,11002,11003,11033,11035,11045,11053,11057,11058,11061,11063,11071,11079,11091,11100,11114,11128,11167,11182,11219,11226,11237,11255,11264,11273,11287,11343,11365,11367,11368,11370,11371,11372,11373,11401,11430,11435,11440,11459,20318,20319,20320,20321,20332,20336,20344,20346,20347,20349,20485,20486,20487,20488,20490,20491,20528,20535,20698,20699,20700,20701,20702,20703,20704,20705,20706,20707,20708,20723,20736,20737,20738,20765,20784,20785,21108,21109,21111,21112,21113,21114,21115,21117,21118,21119,21124,21125,21292,21302,21305,23277,24582,25179,25183,25184,25186,25408,25844,26391,26537,26548,26550,26678,26750,26755,26756,26757,26759,26760,26764,26765,27084,27802,31492,37405,37407,37419,37491,37804,37805,37904,37911,37929,37936,38124,38975,39281,39282,39283,39293,39296,39297,39335,39354,40665,40666,40667,40671,40673,40675,40680,40959,40960,40962,40963,40965,40966,40967,40968,40969,40970,40971,40972,40981,40982,40983,40984,40985,40986,40987,40988,40989,40990,40991,40992,40993,40994,40995,40996,40998,40999,41075,41082,41083,41085,41088,41089,41092,41093,41094,41095,41096,41097,41098,41099,41100,41101,41102,44803,44805,44809,44810,44811,44824,44828,44829,44836,44837,44841,44843,44845,44850,44853,44858,44859,44860,44864,44865,44867,44868,44879,44880,44882,44885,44886,44888,45863,45884,45897,45899,45901,45902,45903,45904,45908,45940,45941,45958,45967,45986,46000,46037,46050,46059,46075,46079,49999,50018,50041,50158,50176,50380,50700,50702,49976,50759,50766,50786,50796,50814,10246,10247,4245,51075,51185,51213,10308,40705,40961,40711,40706,2532,4341,44871,40719,40973,40718,40698,40694,40695,40701,40704,10921,40735,40724,40687,41076,51340,51341,40683,40739,40743,51385,51393,51395,51407,40725,40742,40731,51417,44852,44883,40668,44816,44808,40726,40709,44898,44869,40699,44806,40697,40692,44896,44889,51435,40997,51454,10284,10198,10252,51545,51547,51627,51727,51738,51790,10325,10335,10327,10337,10322,10332,10324,10334,10330,10336,10331,10041,10326,10328,10323,10040,10039,10038,51852,51927,10870,4087,4002,52259,10875,52287,52322,52368,52373,52383,52382,52385,52391,52395,52401,52403,52405,52406,51919,52528,52529,52567,52750,52749,52798,52799,53054,53071,53067,53073,53075,53076,53080,53081,53091,53095,53101,10725,10329,10333,53227,53280,53293,4272,53331,53356,53358,53407,53430,53532,53539,53546,53697,53707,53708,53709,53703,53675,53338,53396,54244,54320,54325,54362,54365,54371,54374,54379,54458,54482,54499,54503,54507,54512,54568,54570,54653,54685,55056,55068,55077,55107,55108,55112,55122,55214,55359,55432,55477,55594,55626,55668,4346,55726,55735,55776,56212,56211,56215,56259,56290,56310,56311,56319,56327,56370,56440,56464,56514,54510,56638,56690,56710,56711,56714,56810,56877,56928,57003,57021,57035,57039,57165,53066,57240,57258,57262,57273,57275,57373,57375,57380,57443,57450,57452,57453,57454,57455,57459,57462,57463,57466,57467,57470,57472,57481,57515,57518,57600,57619,57681,57695,57698,57719,57762,57819,57830,57873,57894,57905,57914,57975,58012,58016,56601,58029,58030,58035,58040,58041,58046,58069,58079,58083,58084,58085,58106,58108,58086,58091,58093,58092,58138,58139,58140,58127,58131,58145,58147,58148,58132,58153,58133,58134,58135,58159,58166,58179,58180,58181,58187,58190,58205,58206,58208,58210,58211,58212,58213,58258,58259,58269,58286,58295,58301,58304,55713,57875,57662,54484,57650,57433,57007,57253,58394,58402,58403,58405,58408,58409,58410,58411,52579,53610,58508,58510,58471,58513,58535,58545,58544,58122,58550,58552,57458,58562,57456,58566,58570,58543,58073,58078,57468,58089,58578,57473,58121,58119,58579,58143,58168,58178,58191,58302,58303,58306,58309,58310,58311,58312,58610,58203,44804,58090,58615,53173,58619,58649,58728,58923,59036,59051,932,59056,59070,3529,10845,51131,10257,59128,59136,10923,59160,59159,59161,52276,59168,10863,10862,52310,10309,53057,59183,59243,59247,59248,59252,226,59256,59260,59264,59262,59267,59269,59270,11118)</p><p>(3)(+0000233): Loaded items in 235ms</p><p>(3)(+0000006): Loading itemData for 585 items in My Library</p><p>(4)(+0000002):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (256, 281, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2527,
2528, 2639, 2643, 2660, 2704, 2728, 2729, 2730, 2735, 2806, 2807, 2816,
2822, 2823, 2824, 2825, 2826, 2827, 2830, 2832, 2834, 2835, 2836, 2837,
2838, 2839, 2840, 2842, 2845, 2848, 2851, 2924, 2927, 2931, 3040, 3041,
3043, 3047, 3050, 3051, 3076, 3077, 3078, 3079, 3082, 3166, 3169, 3170,
3197, 3205, 3206, 3236, 3240, 3243, 3247, 3263, 3266, 3268, 3283, 3286,
3288, 3291, 3292, 3295, 3301, 3311, 3312, 3316, 3319, 3327, 3330, 3333,
3335, 3336, 3346, 3356, 3362, 3365, 3367, 3378, 3386, 3388, 3391, 3397,
3404, 3414, 3431, 3437, 3441, 3447, 3450, 3451, 3458, 3459, 3460, 3461,
3462, 3466, 3489, 3496, 3501, 3503, 3521, 3522, 3533, 3643, 3650, 3657,
3667, 3703, 3711, 3721, 3725, 3736, 3748, 3749, 3751, 3752, 3755, 3756,
3757, 3758, 3759, 3760, 3761, 3764, 3765, 3766, 3815, 3817, 3822, 3857,
3859, 3868, 3882, 3883, 3884, 3886, 3898, 3908, 3910, 3932, 3933, 3948,
3951, 3954, 3955, 3959, 3960, 3964, 3965, 3976, 3977, 3978, 3984, 3985,
3986, 3987, 3988, 3989, 3990, 3992, 3996, 3997, 3998, 3999, 4004, 4007,
4012, 4016, 4017, 4018, 4020, 4021, 4024, 4028, 4029, 4033, 4034, 4035,
4039, 4040, 4041, 4043, 4045, 4050, 4054, 4058, 4059, 4063, 4065, 4068,
4069, 4070, 4071, 4076, 4077, 4080, 4083, 4084, 4086, 4088, 4089, 4090,
4092, 4097, 4099, 4100, 4104, 4109, 4117, 4118, 4119, 4120, 4123, 4124,
4126, 4129, 4132, 4133, 4138, 4139, 4141, 4142, 4145, 4146, 4148, 4149,
4166, 4174, 4178, 4179, 4180, 4185, 4191, 4192, 4193, 4194, 4199, 4212,
4215, 4219, 4224, 4229, 4235, 4238, 4244, 4248, 4250, 4252, 4253, 4258,
4260, 4262, 4267, 4271, 4274, 4285, 4286, 4288, 4291, 4292, 4295, 4306,
4308, 4310, 4311, 4322, 4323, 4324, 4325, 4328, 4335, 4342, 4343, 4352,
4358, 4359, 4362, 4369, 4371, 4381, 4382, 4387, 4388, 4395, 4396, 4397,
4400, 4405, 4406, 4409, 4413, 4415, 4417, 4420, 4425, 4426, 4432, 4434,
4435, 4436, 4437, 4578, 5126, 5829, 5936, 6086, 6144, 6170, 6892, 7952,
8118, 8148, 8168, 8170, 8378, 8379, 8380, 8396, 8397, 8410, 8411, 8426,
8428, 8459, 8470, 8471, 8481, 8490, 8502, 8517, 8524, 8721, 8886, 9204,
9511, 9568, 9667, 9865, 9935, 10043, 10044, 10055, 10062, 10064, 10080,
10084, 10092, 10093, 10094, 10095, 10096, 10097, 10098, 10099, 10100,
10101, 10102, 10103, 10104, 10105, 10106, 10107, 10108, 10109, 10110,
10111, 10112, 10113, 10114, 10143, 10148, 10202, 10204, 10208, 10209,
10227, 10290, 10297, 10301, 10302, 10303, 10304, 10305, 10306, 10307,
10310, 10311, 10389, 10421, 10427, 10659, 10730, 10859, 10895, 10906,
10942, 10995, 11002, 11003, 11033, 11035, 11045, 11053, 11057, 11058,
11061, 11063, 11071, 11079, 11091, 11100, 11114, 11128, 11167, 11182,
11219, 11226, 11237, 11255, 11264, 11273, 11287, 11343, 11365, 11367,
11368, 11370, 11371, 11372, 11373, 11401, 11430, 11435, 11440, 11459,
50700, 50702, 50759, 50766, 10246, 10247, 4245, 10308, 2532, 4341,
10921, 10284, 10198, 10252, 51627, 51738, 51790, 10325, 10335, 10327,
10337, 10322, 10332, 10324, 10334, 10330, 10336, 10331, 10041, 10326,
10328, 10323, 10040, 10039, 10038, 51852, 51927, 10870, 4087, 4002,
52259, 10875, 52287, 52322, 52368, 52373, 52385, 52391, 52395, 52401,
52403, 52405, 52406, 51919, 52528, 52529, 52567, 52750, 52749, 52798,
52799, 53054, 53071, 53067, 53073, 53075, 53076, 53080, 53081, 53091,
53095, 53101, 10725, 10329, 10333, 53227, 53280, 53293, 4272, 53532,
53539, 53546, 55626, 55668, 4346, 56212, 56211, 56215, 56259, 56310,
56311, 56319, 56327, 56440, 53066, 58012, 58016, 56601, 58106, 58108,
58394, 52579, 58535, 53173, 58649, 59051, 932, 59056, 3529, 10845,
51131, 10257, 59128, 59136, 10923, 59160, 59159, 59161, 52276, 59168,
10863, 10862, 52310, 10309, 53057, 59183, 59243, 59247, 59248, 59252,
226, 59256, 59260, 59264, 59262, 59269, 59270, 11118) [1, 1]</p><p>(4)(+0000276):
SELECT itemID FROM items WHERE libraryID=? AND itemID IN (256, 281,
2520, 2521, 2522, 2523, 2524, 2525, 2526, 2527, 2528, 2639, 2643, 2660,
2704, 2728, 2729, 2730, 2735, 2806, 2807, 2816, 2822, 2823, 2824, 2825,
2826, 2827, 2830, 2832, 2834, 2835, 2836, 2837, 2838, 2839, 2840, 2842,
2845, 2848, 2851, 2924, 2927, 2931, 3040, 3041, 3043, 3047, 3050, 3051,
3076, 3077, 3078, 3079, 3082, 3166, 3169, 3170, 3197, 3205, 3206, 3236,
3240, 3243, 3247, 3263, 3266, 3268, 3283, 3286, 3288, 3291, 3292, 3295,
3301, 3311, 3312, 3316, 3319, 3327, 3330, 3333, 3335, 3336, 3346, 3356,
3362, 3365, 3367, 3378, 3386, 3388, 3391, 3397, 3404, 3414, 3431, 3437,
3441, 3447, 3450, 3451, 3458, 3459, 3460, 3461, 3462, 3466, 3489, 3496,
3501, 3503, 3521, 3522, 3533, 3643, 3650, 3657, 3667, 3703, 3711, 3721,
3725, 3736, 3748, 3749, 3751, 3752, 3755, 3756, 3757, 3758, 3759, 3760,
3761, 3764, 3765, 3766, 3815, 3817, 3822, 3857, 3859, 3868, 3882, 3883,
3884, 3886, 3898, 3908, 3910, 3932, 3933, 3948, 3951, 3954, 3955, 3959,
3960, 3964, 3965, 3976, 3977, 3978, 3984, 3985, 3986, 3987, 3988, 3989,
3990, 3992, 3996, 3997, 3998, 3999, 4004, 4007, 4012, 4016, 4017, 4018,
4020, 4021, 4024, 4028, 4029, 4033, 4034, 4035, 4039, 4040, 4041, 4043,
4045, 4050, 4054, 4058, 4059, 4063, 4065, 4068, 4069, 4070, 4071, 4076,
4077, 4080, 4083, 4084, 4086, 4088, 4089, 4090, 4092, 4097, 4099, 4100,
4104, 4109, 4117, 4118, 4119, 4120, 4123, 4124, 4126, 4129, 4132, 4133,
4138, 4139, 4141, 4142, 4145, 4146, 4148, 4149, 4166, 4174, 4178, 4179,
4180, 4185, 4191, 4192, 4193, 4194, 4199, 4212, 4215, 4219, 4224, 4229,
4235, 4238, 4244, 4248, 4250, 4252, 4253, 4258, 4260, 4262, 4267, 4271,
4274, 4285, 4286, 4288, 4291, 4292, 4295, 4306, 4308, 4310, 4311, 4322,
4323, 4324, 4325, 4328, 4335, 4342, 4343, 4352, 4358, 4359, 4362, 4369,
4371, 4381, 4382, 4387, 4388, 4395, 4396, 4397, 4400, 4405, 4406, 4409,
4413, 4415, 4417, 4420, 4425, 4426, 4432, 4434, 4435, 4436, 4437, 4578,
5126, 5829, 5936, 6086, 6144, 6170, 6892, 7952, 8118, 8148, 8168, 8170,
8378, 8379, 8380, 8396, 8397, 8410, 8411, 8426, 8428, 8459, 8470, 8471,
8481, 8490, 8502, 8517, 8524, 8721, 8886, 9204, 9511, 9568, 9667, 9865,
9935, 10043, 10044, 10055, 10062, 10064, 10080, 10084, 10092, 10093,
10094, 10095, 10096, 10097, 10098, 10099, 10100, 10101, 10102, 10103,
10104, 10105, 10106, 10107, 10108, 10109, 10110, 10111, 10112, 10113,
10114, 10143, 10148, 10202, 10204, 10208, 10209, 10227, 10290, 10297,
10301, 10302, 10303, 10304, 10305, 10306, 10307, 10310, 10311, 10389,
10421, 10427, 10659, 10730, 10859, 10895, 10906, 10942, 10995, 11002,
11003, 11033, 11035, 11045, 11053, 11057, 11058, 11061, 11063, 11071,
11079, 11091, 11100, 11114, 11128, 11167, 11182, 11219, 11226, 11237,
11255, 11264, 11273, 11287, 11343, 11365, 11367, 11368, 11370, 11371,
11372, 11373, 11401, 11430, 11435, 11440, 11459, 50700, 50702, 50759,
50766, 10246, 10247, 4245, 10308, 2532, 4341, 10921, 10284, 10198,
10252, 51627, 51738, 51790, 10325, 10335, 10327, 10337, 10322, 10332,
10324, 10334, 10330, 10336, 10331, 10041, 10326, 10328, 10323, 10040,
10039, 10038, 51852, 51927, 10870, 4087, 4002, 52259, 10875, 52287,
52322, 52368, 52373, 52385, 52391, 52395, 52401, 52403, 52405, 52406,
51919, 52528, 52529, 52567, 52750, 52749, 52798, 52799, 53054, 53071,
53067, 53073, 53075, 53076, 53080, 53081, 53091, 53095, 53101, 10725,
10329, 10333, 53227, 53280, 53293, 4272, 53532, 53539, 53546, 55626,
55668, 4346, 56212, 56211, 56215, 56259, 56310, 56311, 56319, 56327,
56440, 53066, 58012, 58016, 56601, 58106, 58108, 58394, 52579, 58535,
53173, 58649, 59051, 932, 59056, 3529, 10845, 51131, 10257, 59128,
59136, 10923, 59160, 59159, 59161, 52276, 59168, 10863, 10862, 52310,
10309, 53057, 59183, 59243, 59247, 59248, 59252, 226, 59256, 59260,
59264, 59262, 59269, 59270, 11118) [1]</p><p>(4)(+0000101): SELECT
itemID, title FROM items JOIN itemNotes USING (itemID) WHERE libraryID=?
AND itemID NOT IN (SELECT itemID FROM itemAttachments) AND itemID IN
(256, 281, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2527, 2528, 2639,
2643, 2660, 2704, 2728, 2729, 2730, 2735, 2806, 2807, 2816, 2822, 2823,
2824, 2825, 2826, 2827, 2830, 2832, 2834, 2835, 2836, 2837, 2838, 2839,
2840, 2842, 2845, 2848, 2851, 2924, 2927, 2931, 3040, 3041, 3043, 3047,
3050, 3051, 3076, 3077, 3078, 3079, 3082, 3166, 3169, 3170, 3197, 3205,
3206, 3236, 3240, 3243, 3247, 3263, 3266, 3268, 3283, 3286, 3288, 3291,
3292, 3295, 3301, 3311, 3312, 3316, 3319, 3327, 3330, 3333, 3335, 3336,
3346, 3356, 3362, 3365, 3367, 3378, 3386, 3388, 3391, 3397, 3404, 3414,
3431, 3437, 3441, 3447, 3450, 3451, 3458, 3459, 3460, 3461, 3462, 3466,
3489, 3496, 3501, 3503, 3521, 3522, 3533, 3643, 3650, 3657, 3667, 3703,
3711, 3721, 3725, 3736, 3748, 3749, 3751, 3752, 3755, 3756, 3757, 3758,
3759, 3760, 3761, 3764, 3765, 3766, 3815, 3817, 3822, 3857, 3859, 3868,
3882, 3883, 3884, 3886, 3898, 3908, 3910, 3932, 3933, 3948, 3951, 3954,
3955, 3959, 3960, 3964, 3965, 3976, 3977, 3978, 3984, 3985, 3986, 3987,
3988, 3989, 3990, 3992, 3996, 3997, 3998, 3999, 4004, 4007, 4012, 4016,
4017, 4018, 4020, 4021, 4024, 4028, 4029, 4033, 4034, 4035, 4039, 4040,
4041, 4043, 4045, 4050, 4054, 4058, 4059, 4063, 4065, 4068, 4069, 4070,
4071, 4076, 4077, 4080, 4083, 4084, 4086, 4088, 4089, 4090, 4092, 4097,
4099, 4100, 4104, 4109, 4117, 4118, 4119, 4120, 4123, 4124, 4126, 4129,
4132, 4133, 4138, 4139, 4141, 4142, 4145, 4146, 4148, 4149, 4166, 4174,
4178, 4179, 4180, 4185, 4191, 4192, 4193, 4194, 4199, 4212, 4215, 4219,
4224, 4229, 4235, 4238, 4244, 4248, 4250, 4252, 4253, 4258, 4260, 4262,
4267, 4271, 4274, 4285, 4286, 4288, 4291, 4292, 4295, 4306, 4308, 4310,
4311, 4322, 4323, 4324, 4325, 4328, 4335, 4342, 4343, 4352, 4358, 4359,
4362, 4369, 4371, 4381, 4382, 4387, 4388, 4395, 4396, 4397, 4400, 4405,
4406, 4409, 4413, 4415, 4417, 4420, 4425, 4426, 4432, 4434, 4435, 4436,
4437, 4578, 5126, 5829, 5936, 6086, 6144, 6170, 6892, 7952, 8118, 8148,
8168, 8170, 8378, 8379, 8380, 8396, 8397, 8410, 8411, 8426, 8428, 8459,
8470, 8471, 8481, 8490, 8502, 8517, 8524, 8721, 8886, 9204, 9511, 9568,
9667, 9865, 9935, 10043, 10044, 10055, 10062, 10064, 10080, 10084,
10092, 10093, 10094, 10095, 10096, 10097, 10098, 10099, 10100, 10101,
10102, 10103, 10104, 10105, 10106, 10107, 10108, 10109, 10110, 10111,
10112, 10113, 10114, 10143, 10148, 10202, 10204, 10208, 10209, 10227,
10290, 10297, 10301, 10302, 10303, 10304, 10305, 10306, 10307, 10310,
10311, 10389, 10421, 10427, 10659, 10730, 10859, 10895, 10906, 10942,
10995, 11002, 11003, 11033, 11035, 11045, 11053, 11057, 11058, 11061,
11063, 11071, 11079, 11091, 11100, 11114, 11128, 11167, 11182, 11219,
11226, 11237, 11255, 11264, 11273, 11287, 11343, 11365, 11367, 11368,
11370, 11371, 11372, 11373, 11401, 11430, 11435, 11440, 11459, 50700,
50702, 50759, 50766, 10246, 10247, 4245, 10308, 2532, 4341, 10921,
10284, 10198, 10252, 51627, 51738, 51790, 10325, 10335, 10327, 10337,
10322, 10332, 10324, 10334, 10330, 10336, 10331, 10041, 10326, 10328,
10323, 10040, 10039, 10038, 51852, 51927, 10870, 4087, 4002, 52259,
10875, 52287, 52322, 52368, 52373, 52385, 52391, 52395, 52401, 52403,
52405, 52406, 51919, 52528, 52529, 52567, 52750, 52749, 52798, 52799,
53054, 53071, 53067, 53073, 53075, 53076, 53080, 53081, 53091, 53095,
53101, 10725, 10329, 10333, 53227, 53280, 53293, 4272, 53532, 53539,
53546, 55626, 55668, 4346, 56212, 56211, 56215, 56259, 56310, 56311,
56319, 56327, 56440, 53066, 58012, 58016, 56601, 58106, 58108, 58394,
52579, 58535, 53173, 58649, 59051, 932, 59056, 3529, 10845, 51131,
10257, 59128, 59136, 10923, 59160, 59159, 59161, 52276, 59168, 10863,
10862, 52310, 10309, 53057, 59183, 59243, 59247, 59248, 59252, 226,
59256, 59260, 59264, 59262, 59269, 59270, 11118) [1]</p><p>(3)(+0000060): Loaded itemData in My Library in 440 ms</p><p>(3)(+0000002): Loading itemData for 10 items in Setup and Administration</p><p>(4)(+0000002):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (20318, 20319, 20320, 20321, 20332, 20336, 20344, 20346,
20347, 20349) [3, 1]</p><p>(4)(+0000015): SELECT itemID FROM items WHERE
libraryID=? AND itemID IN (20318, 20319, 20320, 20321, 20332, 20336,
20344, 20346, 20347, 20349) [3]</p><p>(4)(+0000018): SELECT itemID,
title FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? AND
itemID NOT IN (SELECT itemID FROM itemAttachments) AND itemID IN (20318,
20319, 20320, 20321, 20332, 20336, 20344, 20346, 20347, 20349) [3]</p><p>(3)(+0000006): Loaded itemData in Setup and Administration in 41 ms</p><p>(3)(+0000002): Loading itemData for 49 items in Transfer (purged regularly)</p><p>(4)(+0000003):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (20485, 20486, 20487, 20488, 20490, 20491, 20528, 20535,
20698, 20699, 20700, 20701, 20702, 20703, 20704, 20705, 20706, 20707,
20708, 20723, 20736, 20737, 20738, 20765, 20784, 20785, 21108, 21109,
21111, 21112, 21113, 21114, 21115, 21117, 21118, 21119, 21124, 21125,
21292, 21302, 21305, 50158, 50176, 50380, 51075, 51185, 51213, 51385,
58619) [4, 1]</p><p>(4)(+0000067): SELECT itemID FROM items WHERE
libraryID=? AND itemID IN (20485, 20486, 20487, 20488, 20490, 20491,
20528, 20535, 20698, 20699, 20700, 20701, 20702, 20703, 20704, 20705,
20706, 20707, 20708, 20723, 20736, 20737, 20738, 20765, 20784, 20785,
21108, 21109, 21111, 21112, 21113, 21114, 21115, 21117, 21118, 21119,
21124, 21125, 21292, 21302, 21305, 50158, 50176, 50380, 51075, 51185,
51213, 51385, 58619) [4]</p><p>(4)(+0000025): SELECT itemID, title FROM
items JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID NOT IN
(SELECT itemID FROM itemAttachments) AND itemID IN (20485, 20486, 20487,
20488, 20490, 20491, 20528, 20535, 20698, 20699, 20700, 20701, 20702,
20703, 20704, 20705, 20706, 20707, 20708, 20723, 20736, 20737, 20738,
20765, 20784, 20785, 21108, 21109, 21111, 21112, 21113, 21114, 21115,
21117, 21118, 21119, 21124, 21125, 21292, 21302, 21305, 50158, 50176,
50380, 51075, 51185, 51213, 51385, 58619) [4]</p><p>(3)(+0000016): Loaded itemData in Transfer (purged regularly) in 111 ms</p><p>(3)(+0000005): Loading itemData for 24 items in Interests Meta</p><p>(4)(+0000003):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (23277, 24582, 25179, 25183, 25184, 25186, 25408, 25844,
26391, 26537, 26548, 26550, 26678, 26750, 26755, 26756, 26757, 26759,
26760, 26764, 26765, 27084, 27802, 31492) [5, 1]</p><p>(4)(+0000033):
SELECT itemID FROM items WHERE libraryID=? AND itemID IN (23277, 24582,
25179, 25183, 25184, 25186, 25408, 25844, 26391, 26537, 26548, 26550,
26678, 26750, 26755, 26756, 26757, 26759, 26760, 26764, 26765, 27084,
27802, 31492) [5]</p><p>(4)(+0000021): SELECT itemID, title FROM items
JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID NOT IN
(SELECT itemID FROM itemAttachments) AND itemID IN (23277, 24582, 25179,
25183, 25184, 25186, 25408, 25844, 26391, 26537, 26548, 26550, 26678,
26750, 26755, 26756, 26757, 26759, 26760, 26764, 26765, 27084, 27802,
31492) [5]</p><p>(3)(+0000023): Loaded itemData in Interests Meta in 81 ms</p><p>(3)(+0000002): Loading itemData for 20 items in Career Meta</p><p>(4)(+0000002):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (37405, 37407, 37419, 37491, 37804, 37805, 37904, 37911,
37929, 37936, 38124, 38975, 39281, 39282, 39283, 39293, 39296, 39297,
39335, 39354) [6, 1]</p><p>(4)(+0000024): SELECT itemID FROM items WHERE
libraryID=? AND itemID IN (37405, 37407, 37419, 37491, 37804, 37805,
37904, 37911, 37929, 37936, 38124, 38975, 39281, 39282, 39283, 39293,
39296, 39297, 39335, 39354) [6]</p><p>(4)(+0000016): SELECT itemID,
title FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? AND
itemID NOT IN (SELECT itemID FROM itemAttachments) AND itemID IN (37405,
37407, 37419, 37491, 37804, 37805, 37904, 37911, 37929, 37936, 38124,
38975, 39281, 39282, 39283, 39293, 39296, 39297, 39335, 39354) [6]</p><p>(3)(+0000010): Loaded itemData in Career Meta in 52 ms</p><p>(3)(+0000003): Loading itemData for 237 items in Test Items Library</p><p>(4)(+0000003):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (40665, 40666, 40667, 40671, 40673, 40675, 40680, 40959,
40960, 40962, 40963, 40965, 40966, 40967, 40968, 40969, 40970, 40971,
40972, 40981, 40982, 40983, 40984, 40985, 40986, 40987, 40988, 40989,
40990, 40991, 40992, 40993, 40994, 40995, 40996, 40998, 40999, 41075,
41082, 41083, 41085, 41088, 41089, 41092, 41093, 41094, 41095, 41096,
41097, 41098, 41099, 41100, 41101, 41102, 44803, 44805, 44809, 44810,
44811, 44824, 44828, 44829, 44836, 44837, 44841, 44843, 44845, 44850,
44853, 44858, 44859, 44860, 44864, 44865, 44867, 44868, 44879, 44880,
44882, 44885, 44886, 44888, 40705, 40961, 40711, 40706, 44871, 40719,
40973, 40718, 40698, 40694, 40695, 40701, 40704, 40735, 40724, 40687,
41076, 40683, 40739, 40743, 51407, 40725, 40742, 40731, 51417, 44852,
44883, 40668, 44816, 44808, 40726, 40709, 44898, 44869, 40699, 44806,
40697, 40692, 44896, 44889, 51435, 40997, 53697, 57443, 57450, 57452,
57453, 57454, 57455, 57459, 57462, 57463, 57466, 57467, 57470, 57472,
57481, 57681, 57695, 57698, 58029, 58030, 58035, 58040, 58041, 58046,
58069, 58079, 58083, 58084, 58085, 58086, 58091, 58093, 58092, 58138,
58139, 58140, 58127, 58131, 58145, 58147, 58148, 58132, 58153, 58133,
58134, 58135, 58159, 58166, 58179, 58180, 58181, 58187, 58190, 58205,
58206, 58208, 58210, 58211, 58212, 58213, 58258, 58259, 58269, 58286,
58295, 58301, 58304, 58402, 58403, 58405, 58408, 58409, 58410, 58411,
58545, 58544, 58122, 58550, 58552, 57458, 58562, 57456, 58566, 58570,
58543, 58073, 58078, 57468, 58089, 58578, 57473, 58121, 58119, 58579,
58143, 58168, 58178, 58191, 58302, 58303, 58306, 58309, 58310, 58311,
58312, 58610, 58203, 44804, 58090, 58615, 59036, 59070, 59267) [7, 1]</p><p>(4)(+0000107):
SELECT itemID FROM items WHERE libraryID=? AND itemID IN (40665, 40666,
40667, 40671, 40673, 40675, 40680, 40959, 40960, 40962, 40963, 40965,
40966, 40967, 40968, 40969, 40970, 40971, 40972, 40981, 40982, 40983,
40984, 40985, 40986, 40987, 40988, 40989, 40990, 40991, 40992, 40993,
40994, 40995, 40996, 40998, 40999, 41075, 41082, 41083, 41085, 41088,
41089, 41092, 41093, 41094, 41095, 41096, 41097, 41098, 41099, 41100,
41101, 41102, 44803, 44805, 44809, 44810, 44811, 44824, 44828, 44829,
44836, 44837, 44841, 44843, 44845, 44850, 44853, 44858, 44859, 44860,
44864, 44865, 44867, 44868, 44879, 44880, 44882, 44885, 44886, 44888,
40705, 40961, 40711, 40706, 44871, 40719, 40973, 40718, 40698, 40694,
40695, 40701, 40704, 40735, 40724, 40687, 41076, 40683, 40739, 40743,
51407, 40725, 40742, 40731, 51417, 44852, 44883, 40668, 44816, 44808,
40726, 40709, 44898, 44869, 40699, 44806, 40697, 40692, 44896, 44889,
51435, 40997, 53697, 57443, 57450, 57452, 57453, 57454, 57455, 57459,
57462, 57463, 57466, 57467, 57470, 57472, 57481, 57681, 57695, 57698,
58029, 58030, 58035, 58040, 58041, 58046, 58069, 58079, 58083, 58084,
58085, 58086, 58091, 58093, 58092, 58138, 58139, 58140, 58127, 58131,
58145, 58147, 58148, 58132, 58153, 58133, 58134, 58135, 58159, 58166,
58179, 58180, 58181, 58187, 58190, 58205, 58206, 58208, 58210, 58211,
58212, 58213, 58258, 58259, 58269, 58286, 58295, 58301, 58304, 58402,
58403, 58405, 58408, 58409, 58410, 58411, 58545, 58544, 58122, 58550,
58552, 57458, 58562, 57456, 58566, 58570, 58543, 58073, 58078, 57468,
58089, 58578, 57473, 58121, 58119, 58579, 58143, 58168, 58178, 58191,
58302, 58303, 58306, 58309, 58310, 58311, 58312, 58610, 58203, 44804,
58090, 58615, 59036, 59070, 59267) [7]</p><p>(4)(+0000059): SELECT
itemID, title FROM items JOIN itemNotes USING (itemID) WHERE libraryID=?
AND itemID NOT IN (SELECT itemID FROM itemAttachments) AND itemID IN
(40665, 40666, 40667, 40671, 40673, 40675, 40680, 40959, 40960, 40962,
40963, 40965, 40966, 40967, 40968, 40969, 40970, 40971, 40972, 40981,
40982, 40983, 40984, 40985, 40986, 40987, 40988, 40989, 40990, 40991,
40992, 40993, 40994, 40995, 40996, 40998, 40999, 41075, 41082, 41083,
41085, 41088, 41089, 41092, 41093, 41094, 41095, 41096, 41097, 41098,
41099, 41100, 41101, 41102, 44803, 44805, 44809, 44810, 44811, 44824,
44828, 44829, 44836, 44837, 44841, 44843, 44845, 44850, 44853, 44858,
44859, 44860, 44864, 44865, 44867, 44868, 44879, 44880, 44882, 44885,
44886, 44888, 40705, 40961, 40711, 40706, 44871, 40719, 40973, 40718,
40698, 40694, 40695, 40701, 40704, 40735, 40724, 40687, 41076, 40683,
40739, 40743, 51407, 40725, 40742, 40731, 51417, 44852, 44883, 40668,
44816, 44808, 40726, 40709, 44898, 44869, 40699, 44806, 40697, 40692,
44896, 44889, 51435, 40997, 53697, 57443, 57450, 57452, 57453, 57454,
57455, 57459, 57462, 57463, 57466, 57467, 57470, 57472, 57481, 57681,
57695, 57698, 58029, 58030, 58035, 58040, 58041, 58046, 58069, 58079,
58083, 58084, 58085, 58086, 58091, 58093, 58092, 58138, 58139, 58140,
58127, 58131, 58145, 58147, 58148, 58132, 58153, 58133, 58134, 58135,
58159, 58166, 58179, 58180, 58181, 58187, 58190, 58205, 58206, 58208,
58210, 58211, 58212, 58213, 58258, 58259, 58269, 58286, 58295, 58301,
58304, 58402, 58403, 58405, 58408, 58409, 58410, 58411, 58545, 58544,
58122, 58550, 58552, 57458, 58562, 57456, 58566, 58570, 58543, 58073,
58078, 57468, 58089, 58578, 57473, 58121, 58119, 58579, 58143, 58168,
58178, 58191, 58302, 58303, 58306, 58309, 58310, 58311, 58312, 58610,
58203, 44804, 58090, 58615, 59036, 59070, 59267) [7]</p><p>(3)(+0000008): Loading creators for 1 item in Test Items Library</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (40701)
ORDER BY itemID, orderIndex [7]</p><p>(3)(+0000015): Loaded creators in Test Items Library in 17 ms</p><p>(3)(+0000010): Loading creators for 1 item in Test Items Library</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (40699)
ORDER BY itemID, orderIndex [7]</p><p>(3)(+0000007): Loaded creators in Test Items Library in 9 ms</p><p>(3)(+0000011): Loading creators for 1 item in Test Items Library</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (58301)
ORDER BY itemID, orderIndex [7]</p><p>(3)(+0000013): Loaded creators in Test Items Library in 15 ms</p><p>(3)(+0000002): Loaded itemData in Test Items Library in 242 ms</p><p>(3)(+0000002): Loading itemData for 22 items in INP 6395 – Personnel</p><p>(4)(+0000002):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (45863, 45884, 45897, 45899, 45901, 45902, 45903, 45904,
45908, 45940, 45941, 45958, 45967, 45986, 46000, 46037, 46050, 46059,
46075, 46079, 55068, 55214) [8, 1]</p><p>(4)(+0000027): SELECT itemID
FROM items WHERE libraryID=? AND itemID IN (45863, 45884, 45897, 45899,
45901, 45902, 45903, 45904, 45908, 45940, 45941, 45958, 45967, 45986,
46000, 46037, 46050, 46059, 46075, 46079, 55068, 55214) [8]</p><p>(4)(+0000016):
SELECT itemID, title FROM items JOIN itemNotes USING (itemID) WHERE
libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments) AND
itemID IN (45863, 45884, 45897, 45899, 45901, 45902, 45903, 45904,
45908, 45940, 45941, 45958, 45967, 45986, 46000, 46037, 46050, 46059,
46075, 46079, 55068, 55214) [8]</p><p>(3)(+0000010): Loaded itemData in INP 6395 – Personnel in 56 ms</p><p>(3)(+0000004): Loading itemData for 14 items in INP 6395 – Individual Differences</p><p>(4)(+0000004):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (49999, 50018, 50041, 49976, 50786, 50796, 50814, 51340,
51341, 51393, 51395, 51454, 52383, 52382) [11, 1]</p><p>(4)(+0000015):
SELECT itemID FROM items WHERE libraryID=? AND itemID IN (49999, 50018,
50041, 49976, 50786, 50796, 50814, 51340, 51341, 51393, 51395, 51454,
52383, 52382) [11]</p><p>(4)(+0000018): SELECT itemID, title FROM items
JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID NOT IN
(SELECT itemID FROM itemAttachments) AND itemID IN (49999, 50018, 50041,
49976, 50786, 50796, 50814, 51340, 51341, 51393, 51395, 51454, 52383,
52382) [11]</p><p>(3)(+0000009): Loaded itemData in INP 6395 – Individual Differences in 46 ms</p><p>(3)(+0000003): Loading itemData for 3 items in PPE 6058 – Personality</p><p>(4)(+0000004):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (51545, 51547, 51727) [19, 1]</p><p>(4)(+0000009): SELECT itemID FROM items WHERE libraryID=? AND itemID IN (51545, 51547, 51727) [19]</p><p>(4)(+0000013):
SELECT itemID, title FROM items JOIN itemNotes USING (itemID) WHERE
libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments) AND
itemID IN (51545, 51547, 51727) [19]</p><p>(3)(+0000009): Loaded itemData in PPE 6058 – Personality in 36 ms</p><p>(3)(+0000003): Loading itemData for 78 items in Short Personality</p><p>(4)(+0000002):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (54244, 54320, 54325, 54362, 54365, 54371, 54374, 54379,
54458, 54482, 54499, 54503, 54507, 54512, 54568, 54570, 54653, 54685,
55056, 55077, 55107, 55108, 55112, 55122, 55359, 55432, 55477, 55594,
55726, 55735, 55776, 56290, 56370, 56464, 56514, 54510, 56638, 56690,
56710, 56711, 56714, 56810, 56877, 56928, 57003, 57021, 57035, 57039,
57165, 57240, 57258, 57262, 57273, 57275, 57373, 57375, 57380, 57515,
57518, 57600, 57619, 57719, 57762, 57819, 57830, 57873, 57894, 57905,
57914, 57975, 55713, 57875, 57662, 54484, 57650, 57433, 57007, 57253)
[23, 1]</p><p>(4)(+0000067): SELECT itemID FROM items WHERE libraryID=?
AND itemID IN (54244, 54320, 54325, 54362, 54365, 54371, 54374, 54379,
54458, 54482, 54499, 54503, 54507, 54512, 54568, 54570, 54653, 54685,
55056, 55077, 55107, 55108, 55112, 55122, 55359, 55432, 55477, 55594,
55726, 55735, 55776, 56290, 56370, 56464, 56514, 54510, 56638, 56690,
56710, 56711, 56714, 56810, 56877, 56928, 57003, 57021, 57035, 57039,
57165, 57240, 57258, 57262, 57273, 57275, 57373, 57375, 57380, 57515,
57518, 57600, 57619, 57719, 57762, 57819, 57830, 57873, 57894, 57905,
57914, 57975, 55713, 57875, 57662, 54484, 57650, 57433, 57007, 57253)
[23]</p><p>(4)(+0000030): SELECT itemID, title FROM items JOIN itemNotes
USING (itemID) WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM
itemAttachments) AND itemID IN (54244, 54320, 54325, 54362, 54365,
54371, 54374, 54379, 54458, 54482, 54499, 54503, 54507, 54512, 54568,
54570, 54653, 54685, 55056, 55077, 55107, 55108, 55112, 55122, 55359,
55432, 55477, 55594, 55726, 55735, 55776, 56290, 56370, 56464, 56514,
54510, 56638, 56690, 56710, 56711, 56714, 56810, 56877, 56928, 57003,
57021, 57035, 57039, 57165, 57240, 57258, 57262, 57273, 57275, 57373,
57375, 57380, 57515, 57518, 57600, 57619, 57719, 57762, 57819, 57830,
57873, 57894, 57905, 57914, 57975, 55713, 57875, 57662, 54484, 57650,
57433, 57007, 57253) [23]</p><p>(3)(+0000024): Loaded itemData in Short Personality in 124 ms</p><p>(3)(+0000002): Loading itemData for 17 items in Bifactor commentary</p><p>(4)(+0000003):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (53331, 53356, 53358, 53407, 53430, 53707, 53708, 53709,
53703, 53675, 53338, 53396, 53610, 58508, 58510, 58471, 58513) [25, 1]</p><p>(4)(+0000022):
SELECT itemID FROM items WHERE libraryID=? AND itemID IN (53331, 53356,
53358, 53407, 53430, 53707, 53708, 53709, 53703, 53675, 53338, 53396,
53610, 58508, 58510, 58471, 58513) [25]</p><p>(4)(+0000014): SELECT
itemID, title FROM items JOIN itemNotes USING (itemID) WHERE libraryID=?
AND itemID NOT IN (SELECT itemID FROM itemAttachments) AND itemID IN
(53331, 53356, 53358, 53407, 53430, 53707, 53708, 53709, 53703, 53675,
53338, 53396, 53610, 58508, 58510, 58471, 58513) [25]</p><p>(3)(+0000014): Loaded itemData in Bifactor commentary in 53 ms</p><p>(3)(+0000002): Loading itemData for 2 items in Stark-Wiernik CoLab</p><p>(4)(+0000002):
SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID)
JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=?
AND itemID IN (58728, 58923) [31, 1]</p><p>(4)(+0000011): SELECT itemID FROM items WHERE libraryID=? AND itemID IN (58728, 58923) [31]</p><p>(4)(+0000009):
SELECT itemID, title FROM items JOIN itemNotes USING (itemID) WHERE
libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments) AND
itemID IN (58728, 58923) [31]</p><p>(3)(+0000002): Loaded itemData in Stark-Wiernik CoLab in 24 ms</p><p>(3)(+0000021): Loading creator for 585 items in My Library</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (256,
281, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2527, 2528, 2639, 2643,
2660, 2704, 2728, 2729, 2730, 2735, 2806, 2807, 2816, 2822, 2823, 2824,
2825, 2826, 2827, 2830, 2832, 2834, 2835, 2836, 2837, 2838, 2839, 2840,
2842, 2845, 2848, 2851, 2924, 2927, 2931, 3040, 3041, 3043, 3047, 3050,
3051, 3076, 3077, 3078, 3079, 3082, 3166, 3169, 3170, 3197, 3205, 3206,
3236, 3240, 3243, 3247, 3263, 3266, 3268, 3283, 3286, 3288, 3291, 3292,
3295, 3301, 3311, 3312, 3316, 3319, 3327, 3330, 3333, 3335, 3336, 3346,
3356, 3362, 3365, 3367, 3378, 3386, 3388, 3391, 3397, 3404, 3414, 3431,
3437, 3441, 3447, 3450, 3451, 3458, 3459, 3460, 3461, 3462, 3466, 3489,
3496, 3501, 3503, 3521, 3522, 3533, 3643, 3650, 3657, 3667, 3703, 3711,
3721, 3725, 3736, 3748, 3749, 3751, 3752, 3755, 3756, 3757, 3758, 3759,
3760, 3761, 3764, 3765, 3766, 3815, 3817, 3822, 3857, 3859, 3868, 3882,
3883, 3884, 3886, 3898, 3908, 3910, 3932, 3933, 3948, 3951, 3954, 3955,
3959, 3960, 3964, 3965, 3976, 3977, 3978, 3984, 3985, 3986, 3987, 3988,
3989, 3990, 3992, 3996, 3997, 3998, 3999, 4004, 4007, 4012, 4016, 4017,
4018, 4020, 4021, 4024, 4028, 4029, 4033, 4034, 4035, 4039, 4040, 4041,
4043, 4045, 4050, 4054, 4058, 4059, 4063, 4065, 4068, 4069, 4070, 4071,
4076, 4077, 4080, 4083, 4084, 4086, 4088, 4089, 4090, 4092, 4097, 4099,
4100, 4104, 4109, 4117, 4118, 4119, 4120, 4123, 4124, 4126, 4129, 4132,
4133, 4138, 4139, 4141, 4142, 4145, 4146, 4148, 4149, 4166, 4174, 4178,
4179, 4180, 4185, 4191, 4192, 4193, 4194, 4199, 4212, 4215, 4219, 4224,
4229, 4235, 4238, 4244, 4248, 4250, 4252, 4253, 4258, 4260, 4262, 4267,
4271, 4274, 4285, 4286, 4288, 4291, 4292, 4295, 4306, 4308, 4310, 4311,
4322, 4323, 4324, 4325, 4328, 4335, 4342, 4343, 4352, 4358, 4359, 4362,
4369, 4371, 4381, 4382, 4387, 4388, 4395, 4396, 4397, 4400, 4405, 4406,
4409, 4413, 4415, 4417, 4420, 4425, 4426, 4432, 4434, 4435, 4436, 4437,
4578, 5126, 5829, 5936, 6086, 6144, 6170, 6892, 7952, 8118, 8148, 8168,
8170, 8378, 8379, 8380, 8396, 8397, 8410, 8411, 8426, 8428, 8459, 8470,
8471, 8481, 8490, 8502, 8517, 8524, 8721, 8886, 9204, 9511, 9568, 9667,
9865, 9935, 10043, 10044, 10055, 10062, 10064, 10080, 10084, 10092,
10093, 10094, 10095, 10096, 10097, 10098, 10099, 10100, 10101, 10102,
10103, 10104, 10105, 10106, 10107, 10108, 10109, 10110, 10111, 10112,
10113, 10114, 10143, 10148, 10202, 10204, 10208, 10209, 10227, 10290,
10297, 10301, 10302, 10303, 10304, 10305, 10306, 10307, 10310, 10311,
10389, 10421, 10427, 10659, 10730, 10859, 10895, 10906, 10942, 10995,
11002, 11003, 11033, 11035, 11045, 11053, 11057, 11058, 11061, 11063,
11071, 11079, 11091, 11100, 11114, 11128, 11167, 11182, 11219, 11226,
11237, 11255, 11264, 11273, 11287, 11343, 11365, 11367, 11368, 11370,
11371, 11372, 11373, 11401, 11430, 11435, 11440, 11459, 50700, 50702,
50759, 50766, 10246, 10247, 4245, 10308, 2532, 4341, 10921, 10284,
10198, 10252, 51627, 51738, 51790, 10325, 10335, 10327, 10337, 10322,
10332, 10324, 10334, 10330, 10336, 10331, 10041, 10326, 10328, 10323,
10040, 10039, 10038, 51852, 51927, 10870, 4087, 4002, 52259, 10875,
52287, 52322, 52368, 52373, 52385, 52391, 52395, 52401, 52403, 52405,
52406, 51919, 52528, 52529, 52567, 52750, 52749, 52798, 52799, 53054,
53071, 53067, 53073, 53075, 53076, 53080, 53081, 53091, 53095, 53101,
10725, 10329, 10333, 53227, 53280, 53293, 4272, 53532, 53539, 53546,
55626, 55668, 4346, 56212, 56211, 56215, 56259, 56310, 56311, 56319,
56327, 56440, 53066, 58012, 58016, 56601, 58106, 58108, 58394, 52579,
58535, 53173, 58649, 59051, 932, 59056, 3529, 10845, 51131, 10257,
59128, 59136, 10923, 59160, 59159, 59161, 52276, 59168, 10863, 10862,
52310, 10309, 53057, 59183, 59243, 59247, 59248, 59252, 226, 59256,
59260, 59264, 59262, 59269, 59270, 11118) ORDER BY itemID, orderIndex
[1]</p><p>(3)(+0000143): Loaded creator in My Library in 146 ms</p><p>(3)(+0000001): Loading creator for 10 items in Setup and Administration</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (20318,
20319, 20320, 20321, 20332, 20336, 20344, 20346, 20347, 20349) ORDER BY
itemID, orderIndex [3]</p><p>(3)(+0000010): Loaded creator in Setup and Administration in 12 ms</p><p>(3)(+0000002): Loading creator for 49 items in Transfer (purged regularly)</p><p>(4)(+0000001):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (20485,
20486, 20487, 20488, 20490, 20491, 20528, 20535, 20698, 20699, 20700,
20701, 20702, 20703, 20704, 20705, 20706, 20707, 20708, 20723, 20736,
20737, 20738, 20765, 20784, 20785, 21108, 21109, 21111, 21112, 21113,
21114, 21115, 21117, 21118, 21119, 21124, 21125, 21292, 21302, 21305,
50158, 50176, 50380, 51075, 51185, 51213, 51385, 58619) ORDER BY itemID,
orderIndex [4]</p><p>(3)(+0000030): Loaded creator in Transfer (purged regularly) in 31 ms</p><p>(3)(+0000001): Loading creator for 24 items in Interests Meta</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (23277,
24582, 25179, 25183, 25184, 25186, 25408, 25844, 26391, 26537, 26548,
26550, 26678, 26750, 26755, 26756, 26757, 26759, 26760, 26764, 26765,
27084, 27802, 31492) ORDER BY itemID, orderIndex [5]</p><p>(3)(+0000016): Loaded creator in Interests Meta in 17 ms</p><p>(3)(+0000001): Loading creator for 20 items in Career Meta</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (37405,
37407, 37419, 37491, 37804, 37805, 37904, 37911, 37929, 37936, 38124,
38975, 39281, 39282, 39283, 39293, 39296, 39297, 39335, 39354) ORDER BY
itemID, orderIndex [6]</p><p>(3)(+0000013): Loaded creator in Career Meta in 15 ms</p><p>(3)(+0000003): Loading creator for 237 items in Test Items Library</p><p>(4)(+0000003):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (40665,
40666, 40667, 40671, 40673, 40675, 40680, 40959, 40960, 40962, 40963,
40965, 40966, 40967, 40968, 40969, 40970, 40971, 40972, 40981, 40982,
40983, 40984, 40985, 40986, 40987, 40988, 40989, 40990, 40991, 40992,
40993, 40994, 40995, 40996, 40998, 40999, 41075, 41082, 41083, 41085,
41088, 41089, 41092, 41093, 41094, 41095, 41096, 41097, 41098, 41099,
41100, 41101, 41102, 44803, 44805, 44809, 44810, 44811, 44824, 44828,
44829, 44836, 44837, 44841, 44843, 44845, 44850, 44853, 44858, 44859,
44860, 44864, 44865, 44867, 44868, 44879, 44880, 44882, 44885, 44886,
44888, 40705, 40961, 40711, 40706, 44871, 40719, 40973, 40718, 40698,
40694, 40695, 40701, 40704, 40735, 40724, 40687, 41076, 40683, 40739,
40743, 51407, 40725, 40742, 40731, 51417, 44852, 44883, 40668, 44816,
44808, 40726, 40709, 44898, 44869, 40699, 44806, 40697, 40692, 44896,
44889, 51435, 40997, 53697, 57443, 57450, 57452, 57453, 57454, 57455,
57459, 57462, 57463, 57466, 57467, 57470, 57472, 57481, 57681, 57695,
57698, 58029, 58030, 58035, 58040, 58041, 58046, 58069, 58079, 58083,
58084, 58085, 58086, 58091, 58093, 58092, 58138, 58139, 58140, 58127,
58131, 58145, 58147, 58148, 58132, 58153, 58133, 58134, 58135, 58159,
58166, 58179, 58180, 58181, 58187, 58190, 58205, 58206, 58208, 58210,
58211, 58212, 58213, 58258, 58259, 58269, 58286, 58295, 58301, 58304,
58402, 58403, 58405, 58408, 58409, 58410, 58411, 58545, 58544, 58122,
58550, 58552, 57458, 58562, 57456, 58566, 58570, 58543, 58073, 58078,
57468, 58089, 58578, 57473, 58121, 58119, 58579, 58143, 58168, 58178,
58191, 58302, 58303, 58306, 58309, 58310, 58311, 58312, 58610, 58203,
44804, 58090, 58615, 59036, 59070, 59267) ORDER BY itemID, orderIndex
[7]</p><p>(3)(+0000043): Loaded creator in Test Items Library in 47 ms</p><p>(3)(+0000003): Loading creator for 22 items in INP 6395 – Personnel</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (45863,
45884, 45897, 45899, 45901, 45902, 45903, 45904, 45908, 45940, 45941,
45958, 45967, 45986, 46000, 46037, 46050, 46059, 46075, 46079, 55068,
55214) ORDER BY itemID, orderIndex [8]</p><p>(3)(+0000014): Loaded creator in INP 6395 – Personnel in 17 ms</p><p>(3)(+0000002): Loading creator for 14 items in INP 6395 – Individual Differences</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (49999,
50018, 50041, 49976, 50786, 50796, 50814, 51340, 51341, 51393, 51395,
51454, 52383, 52382) ORDER BY itemID, orderIndex [11]</p><p>(3)(+0000021): Loaded creator in INP 6395 – Individual Differences in 24 ms</p><p>(3)(+0000004): Loading creator for 3 items in PPE 6058 – Personality</p><p>(4)(+0000004):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (51545,
51547, 51727) ORDER BY itemID, orderIndex [19]</p><p>(3)(+0000010): Loaded creator in PPE 6058 – Personality in 14 ms</p><p>(3)(+0000002): Loading creator for 78 items in Short Personality</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (54244,
54320, 54325, 54362, 54365, 54371, 54374, 54379, 54458, 54482, 54499,
54503, 54507, 54512, 54568, 54570, 54653, 54685, 55056, 55077, 55107,
55108, 55112, 55122, 55359, 55432, 55477, 55594, 55726, 55735, 55776,
56290, 56370, 56464, 56514, 54510, 56638, 56690, 56710, 56711, 56714,
56810, 56877, 56928, 57003, 57021, 57035, 57039, 57165, 57240, 57258,
57262, 57273, 57275, 57373, 57375, 57380, 57515, 57518, 57600, 57619,
57719, 57762, 57819, 57830, 57873, 57894, 57905, 57914, 57975, 55713,
57875, 57662, 54484, 57650, 57433, 57007, 57253) ORDER BY itemID,
orderIndex [23]</p><p>(3)(+0000041): Loaded creator in Short Personality in 43 ms</p><p>(3)(+0000002): Loading creator for 17 items in Bifactor commentary</p><p>(4)(+0000002):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (53331,
53356, 53358, 53407, 53430, 53707, 53708, 53709, 53703, 53675, 53338,
53396, 53610, 58508, 58510, 58471, 58513) ORDER BY itemID, orderIndex
[25]</p><p>(3)(+0000011): Loaded creator in Bifactor commentary in 13 ms</p><p>(3)(+0000003): Loading creator for 2 items in Stark-Wiernik CoLab</p><p>(4)(+0000004):
SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT
JOIN itemCreators USING (itemID) WHERE libraryID=? AND itemID IN (58728,
58923) ORDER BY itemID, orderIndex [31]</p><p>(3)(+0000011): Loaded creator in Stark-Wiernik CoLab in 15 ms</p><p>(1)(+0000460): Error: No creator exists at position 1
Error: No creator exists at position 1
Zotero.Item.prototype.removeCreator@chrome://zotero/content/xpcom/data/item.js:1103:11
Zotero.Item.prototype.setType@chrome://zotero/content/xpcom/data/item.js:505:11
Zotero.Item.prototype.migrateExtraFields@chrome://zotero/content/xpcom/data/item.js:4632:5
Zotero.Schema&lt;/this.migrateExtraFields@chrome://zotero/content/xpcom/schema.js:633:21
From previous event:
ZoteroService@file:///C:/Program%20Files%20(x86)/Zotero/components/zotero-service.js:352:7
@chrome://zotero/content/include.js:4:14</p><p>(3)(+0006829): HTTP POST "version =&gt; 5.0.85-beta.8+dd9ec…" (67039 chars) to https://repo.zotero.org/repo/report?debug=1</p></div>
</div>
</body></html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment