Skip to content

Instantly share code, notes, and snippets.

@bwiernik

bwiernik/debug_startup_tags.html Secret

Created March 27, 2020 02:58
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/4cbb6a0aaf610c304222e809e2693757 to your computer and use it in GitHub Desktop.
Save bwiernik/4cbb6a0aaf610c304222e809e2693757 to your computer and use it in GitHub Desktop.
Download ZIP
Zotero startup debug
Raw
debug_startup_tags.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.86-beta.1+17d618150, platform =&gt; Win32, oscpu =&gt; Windows NT 10.0; WOW64, locale =&gt; en-US, appName =&gt; Zotero, appVersion =&gt; 5.0.86-beta.1+17d618150, 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.20, extension), Zotero LibreOffice Integration (5.0.22.SA.5.0.86-beta.1+17d618150, extension), Zotero Word for Windows Integration (5.0.14.SA.5.0.86-beta.1+17d618150, extension), ZotFile (5.0.16, extension, disabled)</div>
<div id="output"><p>(3)(+0000000): Using data directory C:\Users\brenton\Zotero</p><p>(3)(+0000011): Asynchronously opening database 'zotero'</p><p>(3)(+0000000): C:\Users\brenton\Zotero\zotero.sqlite</p><p>(4)(+0000013): PRAGMA main.locking_mode=EXCLUSIVE</p><p>(4)(+0000003): PRAGMA page_size</p><p>(4)(+0000002): PRAGMA cache_size=2000</p><p>(4)(+0000001): PRAGMA foreign_keys=true</p><p>(4)(+0000133): SELECT version FROM version WHERE schema='system'</p><p>(4)(+0000004): SELECT version FROM version WHERE schema='userdata'</p><p>(4)(+0000003): SELECT version FROM version WHERE schema='compatibility'</p><p>(3)(+0000002): Proxy not required for https://zoteroproxycheck.s3.amazonaws.com/test</p><p>(4)(+0000008): SELECT value FROM settings WHERE setting='db' AND key='integrityCheck'</p><p>(3)(+0000001): 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)(+0000005): SELECT version FROM version WHERE schema='globalSchema'</p><p>(3)(+0000001): Database is up to date with global schema version 9 -- 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)(+0000001): PRAGMA foreign_keys = false</p><p>(4)(+0000003): Beginning DB transaction zy6SEvK9</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)(+0000002): 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)(+0000005): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)</p><p>(4)(+0000003): 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)(+0000002): 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)(+0000004): 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)(+0000001): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200</p><p>(4)(+0000000): SELECT version FROM version WHERE schema='triggers'</p><p>(3)(+0000001): HTTP GET resource://zotero/schema/triggers.sql</p><p>(3)(+0000002): HTTP GET resource://zotero/schema/triggers.sql succeeded with 200</p><p>(3)(+0000000): 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)(+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)(+0000004):
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)(+0000002): 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)(+0000003): 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)(+0000014): Committed DB transaction zy6SEvK9</p><p>(4)(+0000003): PRAGMA foreign_keys = true</p><p>(4)(+0000002): Beginning DB transaction BSbEmj2u</p><p>(4)(+0000003): SELECT value FROM settings WHERE setting='client' AND key='lastVersion'</p><p>(4)(+0000003): Committed DB transaction BSbEmj2u</p><p>(4)(+0000002): SELECT key, value FROM settings WHERE setting='account'</p><p>(4)(+0000006):
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)(+0000001):
SELECT L.libraryID, L.type AS _libraryType, L.editable AS
_libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS
_libraryVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync
AS _libraryLastSync, L.archived AS _libraryArchived, (SELECT
COUNT(*)&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)(+0000010): 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)(+0000001): SELECT COALESCE(MAX(fieldID) + 1, 1) FROM fields</p><p>(4)(+0000000): SELECT COALESCE(MAX(valueID) + 1, 1) FROM itemDataValues</p><p>(4)(+0000001): SELECT COALESCE(MAX(itemTypeID) + 1, 1) FROM itemTypes</p><p>(4)(+0000002): SELECT COALESCE(MAX(itemID) + 1, 1) FROM items</p><p>(4)(+0000001): SELECT COALESCE(MAX(libraryID) + 1, 1) FROM libraries</p><p>(4)(+0000002): SELECT COALESCE(MAX(proxyID) + 1, 1) FROM proxies</p><p>(4)(+0000004): SELECT COALESCE(MAX(savedSearchID) + 1, 1) FROM savedSearches</p><p>(4)(+0000002): SELECT COALESCE(MAX(tagID) + 1, 1) FROM tags</p><p>(4)(+0000002): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined</p><p>(4)(+0000004):
SELECT itemTypeID AS id, typeName AS name, custom FROM
itemTypesCombined WHERE typeName IN ('book', 'bookSection',
'journalArticle', 'newspaperArticle', 'document')</p><p>(4)(+0000002):
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)(+0000001): 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)(+0000003): SELECT * FROM fieldFormats</p><p>(4)(+0000001): SELECT * FROM fieldsCombined</p><p>(4)(+0000003): SELECT fieldID, itemTypeID FROM itemTypeFieldsCombined</p><p>(4)(+0000015): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined</p><p>(4)(+0000020):
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)(+0000048): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined</p><p>(4)(+0000095):
SELECT itemTypeID, baseFieldID, fieldID, fieldName FROM
baseFieldMappingsCombined JOIN fieldsCombined USING (fieldID)</p><p>(4)(+0000007): SELECT DISTINCT fieldID FROM baseFieldMappingsCombined</p><p>(4)(+0000002): SELECT itemTypeID, fieldID FROM itemTypeFieldsCombined ORDER BY orderIndex</p><p>(4)(+0000019): 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)(+0000029): SELECT itemTypeID, creatorTypeID FROM itemTypeCreatorTypes WHERE primaryField=1</p><p>(4)(+0000002): SELECT fileTypeID AS id, fileType AS name FROM fileTypes</p><p>(4)(+0000002): SELECT charsetID AS id, charset AS name FROM charsets</p><p>(4)(+0000006): SELECT predicateID AS id, predicate AS name FROM relationPredicates</p><p>(3)(+0000001): Running unlock callbacks</p><p>(3)(+0000000): HTTP server listening on 127.0.0.1:23119</p><p>(4)(+0000001): ATTACH ':memory:' AS 'indexing'</p><p>(4)(+0000002): CREATE TABLE indexing.fulltextWords (word NOT NULL)</p><p>(4)(+0000005): 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)(+0000004): SELECT ROWID AS id, libraryID, key FROM collections</p><p>(3)(+0000003): Getting contents of C:\Users\brenton\Zotero\locate\engines.json</p><p>(4)(+0000015): SELECT ROWID AS id, libraryID, key FROM items</p><p>(4)(+0001888): SELECT ROWID AS id, libraryID, key FROM savedSearches</p><p>(4)(+0000021):
SELECT fieldName FROM fieldsCombined WHERE fieldName NOT IN
('accessDate', 'date', 'pages', 'section','seriesNumber','issue')</p><p>(1)(+0000009): Unknown item type 'nsfReviewer'</p><p>(1)(+0000000): Unknown item type 'nsfReviewer'</p><p>(4)(+0000011): SELECT tagID, name FROM tags</p><p>(4)(+0000128): SELECT * FROM creators</p><p>(3)(+0001451): Loading collection relations</p><p>(4)(+0000001): SELECT * FROM collectionRelations JOIN relationPredicates USING (predicateID)</p><p>(3)(+0000034): Loaded collection relations in 35 ms</p><p>(3)(+0000001): Loading item relations</p><p>(4)(+0000001): SELECT * FROM itemRelations JOIN relationPredicates USING (predicateID)</p><p>(3)(+0000715): Loaded item relations in 716 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)(+0000011): No general proxy or PAC file found -- assuming direct connection</p><p>(4)(+0000003): ALTER TABLE retractedItems ADD COLUMN flag INT DEFAULT 0</p><p>(4)(+0000012): SELECT itemID AS id, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [26]</p><p>(4)(+0003614): SELECT itemID AS id, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [22]</p><p>(1)(+0001300): Unknown item type 'dataset'</p><p>(1)(+0000036): Unknown item type 'dataset'</p><p>(1)(+0000008): Unknown item type 'article'</p><p>(1)(+0000003): Unknown item type 'article'</p><p>(1)(+0009470): Unknown item type 'dataset'</p><p>(1)(+0000002): Unknown item type 'dataset'</p><p>(1)(+0000060): Unknown item type 'musical_score'</p><p>(1)(+0000009): Unknown item type 'figure'</p><p>(1)(+0000002): Unknown item type 'figure'</p><p>(1)(+0000005): Unknown item type 'dataset'</p><p>(1)(+0000004): Unknown item type 'dataset'</p><p>(1)(+0000013): Unknown item type 'article'</p><p>(1)(+0000008): Unknown item type 'dataset'</p><p>(1)(+0000006): Unknown item type 'dataset'</p><p>(1)(+0000015): Unknown item type 'dataset'</p><p>(1)(+0001834): Unknown item type 'pamphlet'</p><p>(1)(+0000025): Unknown item type 'review-book'</p><p>(1)(+0000018): Unknown item type 'review-book'</p><p>(1)(+0000003): Unknown item type 'review'</p><p>(1)(+0000009): Unknown item type 'review'</p><p>(1)(+0000010): Unknown item type 'dataset'</p><p>(1)(+0000004): Unknown item type 'pamphlet'</p><p>(1)(+0000009): Unknown item type 'pamphlet'</p><p>(1)(+0000062): Unknown item type 'article'</p><p>(1)(+0000108): Unknown item type 'article'</p><p>(1)(+0000175): Unknown item type 'dataset'</p><p>(1)(+0000119): Unknown item type 'dataset'</p><p>(1)(+0000107): Unknown item type 'dataset'</p><p>(1)(+0000013): Unknown item type 'dataset'</p><p>(1)(+0000093): Unknown item type 'dataset'</p><p>(1)(+0000079): Unknown item type 'dataset'</p><p>(1)(+0000004): Unknown item type 'dataset'</p><p>(1)(+0000004): Unknown item type 'dataset'</p><p>(1)(+0000012): Unknown item type 'dataset'</p><p>(1)(+0000006): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000004): Unknown item type 'dataset'</p><p>(1)(+0000040): Unknown item type 'Figure'</p><p>(1)(+0000004): Unknown item type 'figure'</p><p>(1)(+0000198): Unknown item type 'dataset'</p><p>(1)(+0000005): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'entry'</p><p>(1)(+0000004): Unknown item type 'entry'</p><p>(1)(+0000004): Unknown item type 'entry'</p><p>(1)(+0000004): Unknown item type 'entry'</p><p>(1)(+0000027): Unknown item type 'dataset'</p><p>(1)(+0000039): Unknown item type 'review-book'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000008): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000011): Unknown item type 'figure'</p><p>(1)(+0000010): Unknown item type 'pamphlet'</p><p>(1)(+0000006): Unknown item type 'pamphlet'</p><p>(1)(+0000004): Unknown item type 'pamphlet'</p><p>(1)(+0000004): Unknown item type 'Figure'</p><p>(1)(+0000227): Unknown item type 'dataset'</p><p>(1)(+0000058): Unknown item type 'pamphlet'</p><p>(1)(+0000013): Unknown item type 'pamphlet'</p><p>(4)(+0000023): SELECT itemID AS id, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [22]</p><p>(3)(+0000385): Getting contents of C:\Users\brenton\AppData\Roaming\Zotero\Zotero\Profiles\6y8u1jo0.default\retractions.json</p><p>(4)(+0000063):
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)(+0000021): SELECT COUNT(*) FROM settings WHERE setting='globalSchema' AND key='migrateExtra'</p><p>(4)(+0000004): SELECT itemID, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID=? [22]</p><p>(1)(+0000941): Unknown item type 'dataset'</p><p>(1)(+0000068): Unknown item type 'dataset'</p><p>(1)(+0000022): Unknown item type 'article'</p><p>(1)(+0000006): Unknown item type 'article'</p><p>(1)(+0007525): Unknown item type 'dataset'</p><p>(1)(+0000002): Unknown item type 'dataset'</p><p>(1)(+0000065): Unknown item type 'musical_score'</p><p>(1)(+0000008): Unknown item type 'figure'</p><p>(1)(+0000002): Unknown item type 'figure'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000002): Unknown item type 'dataset'</p><p>(1)(+0000010): Unknown item type 'article'</p><p>(1)(+0000007): Unknown item type 'dataset'</p><p>(1)(+0000005): Unknown item type 'dataset'</p><p>(1)(+0000020): Unknown item type 'dataset'</p><p>(1)(+0002448): Unknown item type 'pamphlet'</p><p>(1)(+0000025): Unknown item type 'review-book'</p><p>(1)(+0000026): Unknown item type 'review-book'</p><p>(1)(+0000004): Unknown item type 'review'</p><p>(1)(+0000009): Unknown item type 'review'</p><p>(1)(+0000009): Unknown item type 'dataset'</p><p>(1)(+0000005): Unknown item type 'pamphlet'</p><p>(1)(+0000011): Unknown item type 'pamphlet'</p><p>(1)(+0000070): Unknown item type 'article'</p><p>(1)(+0000254): Unknown item type 'article'</p><p>(1)(+0000115): Unknown item type 'dataset'</p><p>(1)(+0000079): Unknown item type 'dataset'</p><p>(1)(+0000072): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000043): Unknown item type 'dataset'</p><p>(1)(+0000027): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000004): Unknown item type 'dataset'</p><p>(1)(+0000005): Unknown item type 'dataset'</p><p>(1)(+0000004): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000022): Unknown item type 'Figure'</p><p>(1)(+0000004): Unknown item type 'figure'</p><p>(1)(+0000139): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'entry'</p><p>(1)(+0000003): Unknown item type 'entry'</p><p>(1)(+0000003): Unknown item type 'entry'</p><p>(1)(+0000003): Unknown item type 'entry'</p><p>(1)(+0000032): Unknown item type 'dataset'</p><p>(1)(+0000026): Unknown item type 'review-book'</p><p>(1)(+0000004): Unknown item type 'dataset'</p><p>(1)(+0000004): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000003): Unknown item type 'dataset'</p><p>(1)(+0000005): Unknown item type 'figure'</p><p>(1)(+0000006): Unknown item type 'pamphlet'</p><p>(1)(+0000005): Unknown item type 'pamphlet'</p><p>(1)(+0000003): Unknown item type 'pamphlet'</p><p>(1)(+0000002): Unknown item type 'Figure'</p><p>(1)(+0000104): Unknown item type 'dataset'</p><p>(1)(+0000051): Unknown item type 'pamphlet'</p><p>(1)(+0000018): Unknown item type 'pamphlet'</p><p>(4)(+0000040):
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,11237,11255,11264,11273,11287,11343,11365,11367,11368,11370,11371,11372,11373,11401,11430,11435,11440,11459,20318,20319,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,40985,40986,40987,40988,40990,40991,40992,40993,40994,40995,40996,40998,40999,41075,41088,41089,41092,41093,41094,41095,41096,41097,41098,41099,41100,41101,41102,44803,44805,44809,44810,44811,44824,44828,44836,44837,44841,44843,44845,44850,44853,44864,44867,44868,44880,44882,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,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,40739,40743,51385,51393,51395,51407,40725,40742,44852,44883,40668,44816,44808,40726,44898,44869,44896,44889,40997,51454,10284,10198,10252,51545,51547,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,52322,52368,52373,52383,52382,52385,52391,52395,52401,52403,52405,52406,51919,52528,52529,52567,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,56464,56514,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,56601,58029,58030,58035,58040,58041,58046,58069,58108,58086,58091,58093,58092,58139,58127,58131,58145,58147,58148,58135,58159,58166,58179,58180,58187,58190,58205,58206,58208,58210,58211,58212,58213,58258,58259,58269,58286,58295,58301,58304,55713,57875,57662,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,58143,58168,58178,58191,58309,58310,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,59248,226,59256,59260,59264,59262,59267,59269,59270,11118,40984,40692,51627,10875,52287,52750,56440,58079,58579,59271,59275,59276,44859,58016,40699,50700,44885,44879,44858,59282,59284,59288,59294,59296,59300)</p><p>(3)(+0000412): Loaded items in 415ms</p><p>(3)(+0000012): Loading itemData for 588 items in My Library</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 (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, 11237, 11255, 11264, 11273, 11287, 11343, 11365, 11367, 11368,
11370, 11371, 11372, 11373, 11401, 11430, 11435, 11440, 11459, 50702,
50759, 50766, 10246, 10247, 4245, 10308, 2532, 4341, 10921, 10284,
10198, 10252, 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, 52322, 52368, 52373,
52385, 52391, 52395, 52401, 52403, 52405, 52406, 51919, 52528, 52529,
52567, 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, 53066, 56601, 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, 59248, 226, 59256, 59260,
59264, 59262, 59269, 59270, 11118, 51627, 10875, 52287, 52750, 56440,
59271, 59275, 59276, 58016, 50700, 59282, 59284, 59288, 59294, 59296,
59300) [1, 1]</p><p>(4)(+0000921): 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, 11237, 11255, 11264, 11273, 11287, 11343, 11365,
11367, 11368, 11370, 11371, 11372, 11373, 11401, 11430, 11435, 11440,
11459, 50702, 50759, 50766, 10246, 10247, 4245, 10308, 2532, 4341,
10921, 10284, 10198, 10252, 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, 52322,
52368, 52373, 52385, 52391, 52395, 52401, 52403, 52405, 52406, 51919,
52528, 52529, 52567, 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, 53066, 56601,
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, 59248, 226,
59256, 59260, 59264, 59262, 59269, 59270, 11118, 51627, 10875, 52287,
52750, 56440, 59271, 59275, 59276, 58016, 50700, 59282, 59284, 59288,
59294, 59296, 59300) [1]</p><p>(4)(+0000242): 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, 11237, 11255, 11264,
11273, 11287, 11343, 11365, 11367, 11368, 11370, 11371, 11372, 11373,
11401, 11430, 11435, 11440, 11459, 50702, 50759, 50766, 10246, 10247,
4245, 10308, 2532, 4341, 10921, 10284, 10198, 10252, 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, 52322, 52368, 52373, 52385, 52391, 52395, 52401,
52403, 52405, 52406, 51919, 52528, 52529, 52567, 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, 53066, 56601, 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, 59248, 226, 59256, 59260, 59264, 59262, 59269, 59270,
11118, 51627, 10875, 52287, 52750, 56440, 59271, 59275, 59276, 58016,
50700, 59282, 59284, 59288, 59294, 59296, 59300) [1]</p><p>(3)(+0000103): Loaded itemData in My Library in 1273 ms</p><p>(3)(+0000002): Loading itemData for 9 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, 20321, 20332, 20336, 20344, 20346, 20347,
20349) [3, 1]</p><p>(4)(+0000024): SELECT itemID FROM items WHERE
libraryID=? AND itemID IN (20318, 20319, 20321, 20332, 20336, 20344,
20346, 20347, 20349) [3]</p><p>(4)(+0000019): SELECT itemID, title FROM
items JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID NOT IN
(SELECT itemID FROM itemAttachments) AND itemID IN (20318, 20319, 20321,
20332, 20336, 20344, 20346, 20347, 20349) [3]</p><p>(3)(+0000020): Loaded itemData in Setup and Administration in 65 ms</p><p>(3)(+0000006): Loading itemData for 49 items in Transfer (purged regularly)</p><p>(4)(+0000005):
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)(+0000116): 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)(+0000036): 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)(+0000021): Loaded itemData in Transfer (purged regularly) in 179 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)(+0000037):
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)(+0000022): 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)(+0000032): Loaded itemData in Interests Meta in 94 ms</p><p>(3)(+0000002): Loading itemData for 20 items in Career 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 (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)(+0000032): 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)(+0000024): 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)(+0000011): Loaded itemData in Career Meta in 70 ms</p><p>(3)(+0000002): Loading itemData for 205 items in Test Items 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 (40665, 40666, 40667, 40671, 40673, 40675, 40680, 40959,
40960, 40962, 40963, 40965, 40966, 40967, 40968, 40969, 40970, 40971,
40972, 40981, 40985, 40986, 40987, 40988, 40990, 40991, 40992, 40993,
40994, 40995, 40996, 40998, 40999, 41075, 41088, 41089, 41092, 41093,
41094, 41095, 41096, 41097, 41098, 41099, 41100, 41101, 41102, 44803,
44805, 44809, 44810, 44811, 44824, 44828, 44836, 44837, 44841, 44843,
44845, 44850, 44853, 44864, 44867, 44868, 44880, 44882, 44886, 44888,
40705, 40961, 40711, 40706, 44871, 40719, 40973, 40718, 40698, 40694,
40695, 40701, 40704, 40735, 40724, 40687, 41076, 40739, 40743, 51407,
40725, 40742, 44852, 44883, 40668, 44816, 44808, 40726, 44898, 44869,
44896, 44889, 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, 58086, 58091,
58093, 58092, 58139, 58127, 58131, 58145, 58147, 58148, 58135, 58159,
58166, 58179, 58180, 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, 58143, 58168, 58178, 58191, 58309, 58310,
58610, 58203, 44804, 58090, 58615, 59036, 59070, 59267, 40984, 40692,
58079, 58579, 44859, 40699, 44885, 44879, 44858) [7, 1]</p><p>(4)(+0000137):
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, 40985, 40986,
40987, 40988, 40990, 40991, 40992, 40993, 40994, 40995, 40996, 40998,
40999, 41075, 41088, 41089, 41092, 41093, 41094, 41095, 41096, 41097,
41098, 41099, 41100, 41101, 41102, 44803, 44805, 44809, 44810, 44811,
44824, 44828, 44836, 44837, 44841, 44843, 44845, 44850, 44853, 44864,
44867, 44868, 44880, 44882, 44886, 44888, 40705, 40961, 40711, 40706,
44871, 40719, 40973, 40718, 40698, 40694, 40695, 40701, 40704, 40735,
40724, 40687, 41076, 40739, 40743, 51407, 40725, 40742, 44852, 44883,
40668, 44816, 44808, 40726, 44898, 44869, 44896, 44889, 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, 58086, 58091, 58093, 58092, 58139, 58127,
58131, 58145, 58147, 58148, 58135, 58159, 58166, 58179, 58180, 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,
58143, 58168, 58178, 58191, 58309, 58310, 58610, 58203, 44804, 58090,
58615, 59036, 59070, 59267, 40984, 40692, 58079, 58579, 44859, 40699,
44885, 44879, 44858) [7]</p><p>(4)(+0000120): 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, 40985, 40986, 40987,
40988, 40990, 40991, 40992, 40993, 40994, 40995, 40996, 40998, 40999,
41075, 41088, 41089, 41092, 41093, 41094, 41095, 41096, 41097, 41098,
41099, 41100, 41101, 41102, 44803, 44805, 44809, 44810, 44811, 44824,
44828, 44836, 44837, 44841, 44843, 44845, 44850, 44853, 44864, 44867,
44868, 44880, 44882, 44886, 44888, 40705, 40961, 40711, 40706, 44871,
40719, 40973, 40718, 40698, 40694, 40695, 40701, 40704, 40735, 40724,
40687, 41076, 40739, 40743, 51407, 40725, 40742, 44852, 44883, 40668,
44816, 44808, 40726, 44898, 44869, 44896, 44889, 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, 58086, 58091, 58093, 58092, 58139, 58127, 58131,
58145, 58147, 58148, 58135, 58159, 58166, 58179, 58180, 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, 58143,
58168, 58178, 58191, 58309, 58310, 58610, 58203, 44804, 58090, 58615,
59036, 59070, 59267, 40984, 40692, 58079, 58579, 44859, 40699, 44885,
44879, 44858) [7]</p><p>(3)(+0000031): Loading creators for 1 item in Test Items Library</p><p>(4)(+0000009):
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)(+0000026): Loaded creators in Test Items Library in 35 ms</p><p>(3)(+0000021): Loading creators for 1 item 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 (40699)
ORDER BY itemID, orderIndex [7]</p><p>(3)(+0000017): Loaded creators in Test Items Library in 20 ms</p><p>(3)(+0000017): Loading creators for 1 item in Test Items Library</p><p>(4)(+0000005):
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)(+0000026): Loaded creators in Test Items Library in 31 ms</p><p>(3)(+0000006): Loaded itemData in Test Items Library in 420 ms</p><p>(3)(+0000004): Loading itemData for 22 items in INP 6395 – Personnel</p><p>(4)(+0000006):
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)(+0000066): 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)(+0000025):
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)(+0000035): Loaded itemData in INP 6395 – Personnel in 132 ms</p><p>(3)(+0000005): Loading itemData for 14 items in INP 6395 – Individual Differences</p><p>(4)(+0000005):
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)(+0000057):
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)(+0000030): 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)(+0000016): Loaded itemData in INP 6395 – Individual Differences in 109 ms</p><p>(3)(+0000005): Loading itemData for 3 items in PPE 6058 – Personality</p><p>(4)(+0000007):
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)(+0000020): SELECT itemID FROM items WHERE libraryID=? AND itemID IN (51545, 51547, 51727) [19]</p><p>(4)(+0000027):
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)(+0000014): Loaded itemData in PPE 6058 – Personality in 70 ms</p><p>(3)(+0000004): Loading itemData for 73 items in Short Personality</p><p>(4)(+0000006):
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, 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, 57253) [23, 1]</p><p>(4)(+0000118): 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, 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, 57253)
[23]</p><p>(4)(+0000033): 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,
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, 57253) [23]</p><p>(3)(+0000039): Loaded itemData in Short Personality in 197 ms</p><p>(3)(+0000002): Loading itemData for 17 items in Bifactor commentary</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 (53331, 53356, 53358, 53407, 53430, 53707, 53708, 53709,
53703, 53675, 53338, 53396, 53610, 58508, 58510, 58471, 58513) [25, 1]</p><p>(4)(+0000027):
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)(+0000020): 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)(+0000017): Loaded itemData in Bifactor commentary in 66 ms</p><p>(3)(+0000004): Loading itemData for 2 items in Stark-Wiernik CoLab</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 (58728, 58923) [31, 1]</p><p>(4)(+0000017): SELECT itemID FROM items WHERE libraryID=? AND itemID IN (58728, 58923) [31]</p><p>(4)(+0000011):
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)(+0000010): Loaded itemData in Stark-Wiernik CoLab in 42 ms</p><p>(3)(+0000007): Loading creator for 588 items in My Library</p><p>(4)(+0000003):
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, 11237,
11255, 11264, 11273, 11287, 11343, 11365, 11367, 11368, 11370, 11371,
11372, 11373, 11401, 11430, 11435, 11440, 11459, 50702, 50759, 50766,
10246, 10247, 4245, 10308, 2532, 4341, 10921, 10284, 10198, 10252,
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, 52322, 52368, 52373, 52385, 52391,
52395, 52401, 52403, 52405, 52406, 51919, 52528, 52529, 52567, 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, 53066, 56601, 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, 59248, 226, 59256, 59260, 59264, 59262,
59269, 59270, 11118, 51627, 10875, 52287, 52750, 56440, 59271, 59275,
59276, 58016, 50700, 59282, 59284, 59288, 59294, 59296, 59300) ORDER BY
itemID, orderIndex [1]</p><p>(3)(+0000248): Loaded creator in My Library in 253 ms</p><p>(3)(+0000003): Loading creator for 9 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, 20321, 20332, 20336, 20344, 20346, 20347, 20349) ORDER BY
itemID, orderIndex [3]</p><p>(3)(+0000026): Loaded creator in Setup and Administration in 28 ms</p><p>(3)(+0000003): Loading creator for 49 items in Transfer (purged regularly)</p><p>(4)(+0000002):
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)(+0000043): Loaded creator in Transfer (purged regularly) in 46 ms</p><p>(3)(+0000002): 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)(+0000007): Loaded creator in Interests Meta in 9 ms</p><p>(3)(+0000002): 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)(+0000020): Loaded creator in Career Meta in 22 ms</p><p>(3)(+0000003): Loading creator for 205 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, 40985,
40986, 40987, 40988, 40990, 40991, 40992, 40993, 40994, 40995, 40996,
40998, 40999, 41075, 41088, 41089, 41092, 41093, 41094, 41095, 41096,
41097, 41098, 41099, 41100, 41101, 41102, 44803, 44805, 44809, 44810,
44811, 44824, 44828, 44836, 44837, 44841, 44843, 44845, 44850, 44853,
44864, 44867, 44868, 44880, 44882, 44886, 44888, 40705, 40961, 40711,
40706, 44871, 40719, 40973, 40718, 40698, 40694, 40695, 40701, 40704,
40735, 40724, 40687, 41076, 40739, 40743, 51407, 40725, 40742, 44852,
44883, 40668, 44816, 44808, 40726, 44898, 44869, 44896, 44889, 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, 58086, 58091, 58093, 58092, 58139,
58127, 58131, 58145, 58147, 58148, 58135, 58159, 58166, 58179, 58180,
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, 58143, 58168, 58178, 58191, 58309, 58310, 58610, 58203, 44804,
58090, 58615, 59036, 59070, 59267, 40984, 40692, 58079, 58579, 44859,
40699, 44885, 44879, 44858) ORDER BY itemID, orderIndex [7]</p><p>(3)(+0000053): Loaded creator in Test Items Library in 56 ms</p><p>(3)(+0000002): Loading creator for 22 items in INP 6395 – Personnel</p><p>(4)(+0000003):
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)(+0000022): Loaded creator in INP 6395 – Personnel in 25 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)(+0000017): Loaded creator in INP 6395 – Individual Differences in 19 ms</p><p>(3)(+0000002): Loading creator for 3 items in PPE 6058 – Personality</p><p>(4)(+0000002):
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)(+0000015): Loaded creator in PPE 6058 – Personality in 17 ms</p><p>(3)(+0000002): Loading creator for 73 items in Short Personality</p><p>(4)(+0000004):
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, 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, 57253) ORDER BY itemID, orderIndex [23]</p><p>(3)(+0000054): Loaded creator in Short Personality in 58 ms</p><p>(3)(+0000003): Loading creator for 17 items in Bifactor commentary</p><p>(4)(+0000003):
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)(+0000027): Loaded creator in Bifactor commentary in 30 ms</p><p>(3)(+0000004): Loading creator for 2 items in Stark-Wiernik CoLab</p><p>(4)(+0000002):
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)(+0000012): Loaded creator in Stark-Wiernik CoLab in 14 ms</p><p>(1)(+0000671): Unknown item type 'dataset'</p><p>(1)(+0000042): Unknown item type 'article'</p><p>(1)(+0000006): Error migrating Extra fields for item 1/EW8E957L</p><p>(3)(+0000002): Original Extra:
type: article</p><p>(3)(+0000001): Item Type: document</p><p>(1)(+0000007): Error: 'tags' not loaded for item (11343/1/EW8E957L)
UnloadedDataException: 'tags' not loaded for item (11343/1/EW8E957L)
Zotero.Exception.UnloadedDataException@chrome://zotero/content/xpcom/error.js:156:16
Zotero.DataObject.prototype._requireData@chrome://zotero/content/xpcom/data/dataObject.js:676:11
Zotero.Item.prototype.getTags@chrome://zotero/content/xpcom/data/item.js:3346:3
Zotero.Item.prototype.toJSON@chrome://zotero/content/xpcom/data/item.js:4552:14
Zotero.Item.prototype.migrateExtraFields@chrome://zotero/content/xpcom/data/item.js:4668:21
Zotero.Schema&lt;/this.migrateExtraFields@chrome://zotero/content/xpcom/schema.js:634: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)(+0007812): HTTP POST "version =&gt; 5.0.86-beta.1+17d61…" (71622 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