{"level":30,"time":1560884873017,"type":"browser","name":"main","opts":{"_":[],"auto-updates":true,"ignore-gpu-blacklist":false,"debug":false,"trace":false,"environment":"production","env":"production","$0":"Applications/Tropy.app/Contents/MacOS/Tropy","data":"/Users/smaxson/Library/Application Support/Tropy","cache":"/Users/smaxson/Library/Caches/Tropy","logs":"/Users/smaxson/Library/Logs/Tropy"},"version":"1.5.0","msg":"main.init 1.5.0 Darwin 15.6.0 (x64)","v":1}
{"level":30,"time":1560884874544,"type":"browser","name":"main","msg":"plugins scanned: 0","v":1}
{"level":30,"time":1560884874548,"type":"browser","name":"main","msg":"app state restored","v":1}
{"level":30,"time":1560884874551,"type":"browser","name":"main","file":"/Users/smaxson/Downloads/Maxson Dissertation-fixed-fixed.tpy","msg":"open new project window","v":1}
{"level":30,"time":1560884875179,"type":"browser","name":"main","msg":"ready after 1982ms [req:368ms]","v":1}
{"level":30,"time":1560884875630,"type":"browser","name":"main","msg":"checking for updates...","v":1}
{"level":30,"time":1560884876227,"type":"browser","name":"main","msg":"updates available","v":1}
{"level":60,"time":1560884877029,"type":"browser","name":"main","msg":"GPU process crashed unexpectedly","stack":"Error: GPU process crashed unexpectedly\n    at App.<anonymous> (/Applications/Tropy.app/Contents/Resources/app.asar/lib/browser/tropy.js:713:38)\n    at App.emit (events.js:194:13)","type":"Error","v":1}
{"level":30,"time":1560884877656,"type":"renderer","name":"project","dpx":1,"opts":{"dark":false,"environment":"production","documents":"/Users/smaxson/Documents","maximizable":true,"minimizable":true,"pictures":"/Users/smaxson/Pictures","scrollbars":true,"theme":"system","file":"/Users/smaxson/Downloads/Maxson Dissertation-fixed-fixed.tpy","recent":["/Users/smaxson/Downloads/Maxson Dissertation-fixed-fixed.tpy","/Users/smaxson/Downloads/Maxson Dissertation-fixed.tpy","/Users/smaxson/Desktop/Maxson Dissertation2.tpy","/Volumes/Maxson.PhD/TROPY PROJECT/Maxson Dissertation3.tpy","/Users/smaxson/Desktop/Maxson Dissertation.tpy","/Volumes/Maxson.PhD/TROPY PROJECT/Maxson Dissertation.tpy","/Users/smaxson/Documents/Maxson Dissertation.tpy"],"data":"/Users/smaxson/Library/Application Support/Tropy","debug":true,"dev":false,"cache":"/Users/smaxson/Library/Caches/Tropy","plugins":"/Users/smaxson/Library/Application Support/Tropy/plugins","frameless":true,"level":"info","locale":"en","log":"/Users/smaxson/Library/Logs/Tropy/tropy.log","uuid":"59a95080-3eb2-11e9-a77a-3545aefeda21","update":{},"version":"1.5.0","webgl":true,"zoom":1},"msg":"project.init","v":1}
{"level":30,"time":1560884877683,"type":"renderer","name":"project","msg":"plugins scanned: 0","v":1}
{"level":30,"time":1560884877684,"type":"renderer","name":"project","msg":"plugins loaded: 0","v":1}
{"level":30,"time":1560884880822,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Library/Application Support/Tropy/ontology.db","v":1}
{"level":30,"time":1560884880831,"type":"renderer","name":"project","msg":"restoring recent@tropy","v":1}
{"level":60,"time":1560884885049,"type":"browser","name":"main","msg":"GPU process crashed unexpectedly","stack":"Error: GPU process crashed unexpectedly\n    at App.<anonymous> (/Applications/Tropy.app/Contents/Resources/app.asar/lib/browser/tropy.js:713:38)\n    at App.emit (events.js:194:13)","type":"Error","v":1}
{"level":30,"time":1560884891652,"type":"renderer","name":"project","msg":"restoring settings@tropy","v":1}
{"level":30,"time":1560884891848,"type":"renderer","name":"project","msg":"restoring ui@tropy","v":1}
{"level":40,"time":1560884891866,"type":"renderer","name":"project","stack":"TimeoutError: ResourceRequest timed out\n    at ResourceRequest._fireTimeout (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/generic-pool/lib/ResourceRequest.js:62:17)\n    at bound (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/generic-pool/lib/ResourceRequest.js:8:15)","msg":"unexpected error in *ontology","v":1}
{"level":30,"time":1560884891878,"type":"renderer","name":"project","msg":"project ready 14328ms [dom:117ms win:82ms req:14103ms]","v":1}
{"level":30,"time":1560884892180,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Downloads/Maxson Dissertation-fixed-fixed.tpy","v":1}
{"level":30,"time":1560884892368,"type":"renderer","name":"project","msg":"esper using canvas renderer","v":1}
{"level":40,"time":1560884892389,"type":"renderer","name":"project","query":"\n        DELETE\n          FROM vocabularies\n          WHERE deleted IS NOT NULL","ms":368,"msg":"SLOW: db query took 368ms","v":1}
{"level":30,"time":1560884892443,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Downloads/Maxson Dissertation-fixed-fixed.tpy","v":1}
{"level":40,"time":1560884893236,"type":"renderer","name":"project","query":"PRAGMA user_version","ms":796,"msg":"SLOW: db query took 796ms","v":1}
{"level":40,"time":1560884893487,"type":"renderer","name":"project","query":"\n        SELECT project_id AS id, name, base FROM project LIMIT 1","ms":247,"msg":"SLOW: db query took 247ms","v":1}
{"level":40,"time":1560884893753,"type":"renderer","name":"project","query":"\n        SELECT COUNT (id) AS total\n          FROM items LEFT OUTER JOIN trash USING (id)\n          WHERE deleted IS NULL","ms":505,"msg":"SLOW: db query took 505ms","v":1}
{"level":40,"time":1560884894478,"type":"renderer","name":"project","query":"\n      INSERT INTO access (uuid, version, path) VALUES (?, ?, ?)","ms":722,"msg":"SLOW: db query took 722ms","v":1}
{"level":30,"time":1560884894496,"type":"renderer","name":"project","msg":"restoring nav@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884894496,"type":"renderer","name":"project","msg":"restoring notepad@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884894496,"type":"renderer","name":"project","msg":"restoring esper@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884894498,"type":"renderer","name":"project","msg":"restoring imports@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884894498,"type":"renderer","name":"project","msg":"restoring sidebar@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884894498,"type":"renderer","name":"project","msg":"restoring panel@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884894693,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Downloads/Maxson Dissertation-fixed-fixed.tpy","v":1}
{"level":40,"time":1560884894749,"type":"renderer","name":"project","query":"\n        DELETE\n          FROM labels\n          WHERE id NOT IN (SELECT class_id FROM classes)\n            AND id NOT IN (SELECT datatype_id FROM datatypes)\n            AND id NOT IN (SELECT property_id FROM properties)","ms":2043,"msg":"SLOW: db query took 2043ms","v":1}
{"level":40,"time":1560884896085,"type":"renderer","name":"project","query":"\n        SELECT id, list_id AS list\n          FROM list_items","ms":485,"msg":"SLOW: db query took 485ms","v":1}
{"level":40,"time":1560884896137,"type":"renderer","name":"project","query":"\n        SELECT id, tag_id AS tag\n          FROM taggings","ms":1192,"msg":"SLOW: db query took 1192ms","v":1}
{"level":40,"time":1560884896171,"type":"renderer","name":"project","query":"\n        SELECT id AS photo, item_id AS id\n          FROM photos\n            LEFT OUTER JOIN trash USING (id)\n          WHERE \n            deleted IS NULL\n          ORDER BY item_id, position","ms":1212,"msg":"SLOW: db query took 1212ms","v":1}
{"level":30,"time":1560884896220,"type":"renderer","name":"project","msg":"db query took 61ms","query":"\n        SELECT id AS selection, photo_id AS id\n          FROM selections\n            LEFT OUTER JOIN trash USING (id)\n          WHERE \n            deleted IS NULL\n          ORDER BY photo_id, position","ms":61,"v":1}
{"level":40,"time":1560884896965,"type":"renderer","name":"project","msg":"SLOW: photo.load","v":1}
{"level":40,"time":1560884897245,"type":"renderer","name":"project","msg":"SLOW: metadata.load","v":1}
{"level":30,"time":1560884897365,"type":"browser","name":"main","msg":"update 1.5.1 ready","v":1}
{"level":40,"time":1560884897430,"type":"renderer","name":"project","msg":"SLOW: item.load","v":1}
{"level":40,"time":1560884897431,"type":"renderer","name":"project","query":"\n        SELECT\n            id,\n            template,\n            datetime(created, \"localtime\") AS created,\n            datetime(modified, \"localtime\") AS modified,\n            deleted\n          FROM subjects\n            JOIN items USING (id)\n            LEFT OUTER JOIN trash USING (id)","ms":1448,"msg":"SLOW: db query took 1448ms","v":1}
{"level":40,"time":1560884897431,"type":"renderer","name":"project","query":"\n        SELECT\n            id,\n            item_id AS item,\n            template,\n            datetime(created, \"localtime\") AS created,\n            datetime(modified, \"localtime\") AS modified,\n            angle,\n            mirror,\n            negative,\n            brightness,\n            contrast,\n            hue,\n            saturation,\n            sharpen,\n            width,\n            height,\n            path,\n            page,\n            size,\n            protocol,\n            mimetype,\n            checksum,\n            orientation\n          FROM subjects\n            JOIN images USING (id)\n            JOIN photos USING (id)","ms":288,"msg":"SLOW: db query took 288ms","v":1}
{"level":40,"time":1560884897431,"type":"renderer","name":"project","query":"\n      SELECT id, property, text, datatype AS type\n        FROM subjects\n          JOIN metadata USING (id)\n          JOIN metadata_values USING (value_id) ORDER BY id, metadata.created ASC","ms":704,"msg":"SLOW: db query took 704ms","v":1}
{"level":40,"time":1560884897692,"type":"renderer","name":"project","msg":"SLOW: selection.load","v":1}
{"level":40,"time":1560884897701,"type":"renderer","name":"project","msg":"SLOW: note.load","v":1}
{"level":40,"time":1560884897870,"type":"renderer","name":"project","ms":3124,"list":true,"query":"","tags":false,"trash":null,"msg":"SLOW: *search query \"\" took 3124ms","v":1}
{"level":40,"time":1560884898059,"type":"renderer","name":"project","query":"\n      \n  WITH sort(id, text) AS (\n    SELECT id, text\n    FROM metadata JOIN metadata_values USING (value_id)\n    WHERE property = $sort)\n      SELECT DISTINCT id, added\n        FROM list_items\n          LEFT OUTER JOIN sort USING (id)\n          \n          LEFT OUTER JOIN items USING (id)\n          LEFT OUTER JOIN trash USING (id)\n        WHERE\n          list_id = $list AND list_items.deleted IS NULL AND\n          \n          \n          trash.deleted IS NULL\n        \n        ORDER BY sort.text ASC, id ASC","ms":208,"msg":"SLOW: db query took 208ms","v":1}
{"level":40,"time":1560884898739,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0005.JPG'","msg":"image check failed for /Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0005.JPG","v":1}
{"level":40,"time":1560884898739,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0005.JPG'","msg":"failed to open photo 1037","v":1}
{"level":40,"time":1560884906986,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0010.JPG'","msg":"image check failed for /Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0010.JPG","v":1}
{"level":40,"time":1560884906986,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0010.JPG'","msg":"failed to open photo 1047","v":1}
{"level":30,"time":1560884921931,"type":"browser","name":"main","file":"/Users/smaxson/Documents/Maxson Dissertation.tpy","msg":"open project in current window","v":1}
{"level":30,"time":1560884921966,"type":"renderer","name":"project","msg":"persisting nav@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884921966,"type":"renderer","name":"project","msg":"persisting notepad@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884921967,"type":"renderer","name":"project","msg":"persisting esper@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884921967,"type":"renderer","name":"project","msg":"persisting imports@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884921968,"type":"renderer","name":"project","msg":"persisting sidebar@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884921968,"type":"renderer","name":"project","msg":"persisting panel@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":40,"time":1560884922240,"type":"renderer","name":"project","query":"\n      DELETE\n        FROM metadata_values\n        WHERE value_id IN (\n          SELECT v.value_id\n            FROM metadata_values v\n              LEFT OUTER JOIN metadata m\n              USING (value_id)\n            WHERE m.value_id IS NULL\n        )","ms":234,"msg":"SLOW: db query took 234ms","v":1}
{"level":30,"time":1560884922286,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Documents/Maxson Dissertation.tpy","v":1}
{"level":30,"time":1560884922337,"type":"renderer","name":"project","msg":"migrating Maxson Dissertation.tpy to #1904161246","v":1}
{"level":30,"time":1560884922553,"type":"renderer","name":"project","msg":"db query took 113ms","query":"-- Prune images\n-- ------------------------------------------------------------\nINSERT INTO trash (id, reason)\n  SELECT id, 'auto' AS reason\n    FROM images\n    WHERE id NOT IN (\n      SELECT id FROM photos UNION SELECT id FROM selections\n    );","ms":113,"v":1}
{"level":40,"time":1560884922742,"type":"renderer","name":"project","query":"PRAGMA foreign_key_check","ms":188,"msg":"SLOW: db query took 188ms","v":1}
{"level":30,"time":1560884922746,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Documents/Maxson Dissertation.tpy","v":1}
{"level":30,"time":1560884922857,"type":"renderer","name":"project","msg":"restoring nav@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884922858,"type":"renderer","name":"project","msg":"restoring notepad@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884922858,"type":"renderer","name":"project","msg":"restoring esper@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884922860,"type":"renderer","name":"project","msg":"restoring imports@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884922860,"type":"renderer","name":"project","msg":"restoring sidebar@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884922860,"type":"renderer","name":"project","msg":"restoring panel@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884922912,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Documents/Maxson Dissertation.tpy","v":1}
{"level":40,"time":1560884923233,"type":"renderer","name":"project","query":"\n        SELECT id, tag_id AS tag\n          FROM taggings","ms":279,"msg":"SLOW: db query took 279ms","v":1}
{"level":40,"time":1560884923262,"type":"renderer","name":"project","query":"\n        SELECT id, list_id AS list\n          FROM list_items","ms":279,"msg":"SLOW: db query took 279ms","v":1}
{"level":40,"time":1560884923263,"type":"renderer","name":"project","query":"\n        SELECT id AS photo, item_id AS id\n          FROM photos\n            LEFT OUTER JOIN trash USING (id)\n          WHERE \n            deleted IS NULL\n          ORDER BY item_id, position","ms":305,"msg":"SLOW: db query took 305ms","v":1}
{"level":40,"time":1560884923361,"type":"renderer","name":"project","query":"\n        SELECT\n            id,\n            template,\n            datetime(created, \"localtime\") AS created,\n            datetime(modified, \"localtime\") AS modified,\n            deleted\n          FROM subjects\n            JOIN items USING (id)\n            LEFT OUTER JOIN trash USING (id)","ms":314,"msg":"SLOW: db query took 314ms","v":1}
{"level":40,"time":1560884923891,"type":"renderer","name":"project","ms":971,"list":true,"query":"","tags":false,"trash":null,"msg":"SLOW: *search query \"\" took 971ms","v":1}
{"level":40,"time":1560884923896,"type":"renderer","name":"project","query":"\n      \n  WITH sort(id, text) AS (\n    SELECT id, text\n    FROM metadata JOIN metadata_values USING (value_id)\n    WHERE property = $sort)\n      SELECT DISTINCT id, added\n        FROM list_items\n          LEFT OUTER JOIN sort USING (id)\n          \n          LEFT OUTER JOIN items USING (id)\n          LEFT OUTER JOIN trash USING (id)\n        WHERE\n          list_id = $list AND list_items.deleted IS NULL AND\n          \n          \n          trash.deleted IS NULL\n        \n        ORDER BY sort.text ASC, id ASC","ms":428,"msg":"SLOW: db query took 428ms","v":1}
{"level":40,"time":1560884924198,"type":"renderer","name":"project","query":"\n      SELECT id, property, text, datatype AS type\n        FROM subjects\n          JOIN metadata USING (id)\n          JOIN metadata_values USING (value_id) ORDER BY id, metadata.created ASC","ms":842,"msg":"SLOW: db query took 842ms","v":1}
{"level":40,"time":1560884924239,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/MAXSON/FOR GOOGLE DRIVE/Briggies, Cato/NARA.RG15.Briggies.Cato.0010.JPG'","msg":"image check failed for /Volumes/MAXSON/FOR GOOGLE DRIVE/Briggies, Cato/NARA.RG15.Briggies.Cato.0010.JPG","v":1}
{"level":40,"time":1560884924239,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/MAXSON/FOR GOOGLE DRIVE/Briggies, Cato/NARA.RG15.Briggies.Cato.0010.JPG'","msg":"failed to open photo 1047","v":1}
{"level":30,"time":1560884942068,"type":"browser","name":"main","file":"/Users/smaxson/Downloads/Maxson Dissertation-fixed.tpy","msg":"open project in current window","v":1}
{"level":30,"time":1560884942104,"type":"renderer","name":"project","msg":"persisting nav@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942105,"type":"renderer","name":"project","msg":"persisting notepad@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942105,"type":"renderer","name":"project","msg":"persisting esper@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942106,"type":"renderer","name":"project","msg":"persisting imports@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942106,"type":"renderer","name":"project","msg":"persisting sidebar@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942106,"type":"renderer","name":"project","msg":"persisting panel@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942203,"type":"renderer","name":"project","msg":"db query took 66ms","query":"\n      DELETE\n        FROM metadata_values\n        WHERE value_id IN (\n          SELECT v.value_id\n            FROM metadata_values v\n              LEFT OUTER JOIN metadata m\n              USING (value_id)\n            WHERE m.value_id IS NULL\n        )","ms":66,"v":1}
{"level":40,"time":1560884942448,"type":"renderer","name":"project","query":"\n    DELETE FROM subjects\n      WHERE id IN (\n        SELECT id FROM trash WHERE reason = 'auto'\n      )","ms":236,"msg":"SLOW: db query took 236ms","v":1}
{"level":30,"time":1560884942483,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Downloads/Maxson Dissertation-fixed.tpy","v":1}
{"level":30,"time":1560884942485,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Downloads/Maxson Dissertation-fixed.tpy","v":1}
{"level":30,"time":1560884942555,"type":"renderer","name":"project","msg":"restoring nav@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942555,"type":"renderer","name":"project","msg":"restoring notepad@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942555,"type":"renderer","name":"project","msg":"restoring esper@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942557,"type":"renderer","name":"project","msg":"restoring imports@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942558,"type":"renderer","name":"project","msg":"restoring sidebar@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942558,"type":"renderer","name":"project","msg":"restoring panel@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884942590,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Downloads/Maxson Dissertation-fixed.tpy","v":1}
{"level":30,"time":1560884942825,"type":"renderer","name":"project","msg":"db query took 88ms","query":"\n        SELECT\n            id,\n            item_id AS item,\n            template,\n            datetime(created, \"localtime\") AS created,\n            datetime(modified, \"localtime\") AS modified,\n            angle,\n            mirror,\n            negative,\n            brightness,\n            contrast,\n            hue,\n            saturation,\n            sharpen,\n            width,\n            height,\n            path,\n            page,\n            size,\n            protocol,\n            mimetype,\n            checksum,\n            orientation\n          FROM subjects\n            JOIN images USING (id)\n            JOIN photos USING (id)","ms":88,"v":1}
{"level":40,"time":1560884943051,"type":"renderer","name":"project","query":"\n        SELECT id, tag_id AS tag\n          FROM taggings","ms":375,"msg":"SLOW: db query took 375ms","v":1}
{"level":40,"time":1560884943078,"type":"renderer","name":"project","query":"\n        SELECT id, list_id AS list\n          FROM list_items","ms":345,"msg":"SLOW: db query took 345ms","v":1}
{"level":40,"time":1560884943325,"type":"renderer","name":"project","query":"\n        SELECT id AS photo, item_id AS id\n          FROM photos\n            LEFT OUTER JOIN trash USING (id)\n          WHERE \n            deleted IS NULL\n          ORDER BY item_id, position","ms":419,"msg":"SLOW: db query took 419ms","v":1}
{"level":40,"time":1560884943325,"type":"renderer","name":"project","query":"\n        SELECT\n            id,\n            template,\n            datetime(created, \"localtime\") AS created,\n            datetime(modified, \"localtime\") AS modified,\n            deleted\n          FROM subjects\n            JOIN items USING (id)\n            LEFT OUTER JOIN trash USING (id)","ms":450,"msg":"SLOW: db query took 450ms","v":1}
{"level":30,"time":1560884943326,"type":"renderer","name":"project","msg":"db query took 140ms","query":"\n      SELECT id, property, text, datatype AS type\n        FROM subjects\n          JOIN metadata USING (id)\n          JOIN metadata_values USING (value_id) ORDER BY id, metadata.created ASC","ms":140,"v":1}
{"level":40,"time":1560884943474,"type":"renderer","name":"project","ms":878,"list":true,"query":"","tags":false,"trash":null,"msg":"SLOW: *search query \"\" took 878ms","v":1}
{"level":30,"time":1560884944064,"type":"browser","name":"main","file":"/Users/smaxson/Downloads/Maxson Dissertation-fixed-fixed.tpy","msg":"open project in current window","v":1}
{"level":30,"time":1560884944093,"type":"renderer","name":"project","msg":"persisting nav@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944093,"type":"renderer","name":"project","msg":"persisting notepad@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944094,"type":"renderer","name":"project","msg":"persisting esper@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944094,"type":"renderer","name":"project","msg":"persisting imports@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944095,"type":"renderer","name":"project","msg":"persisting sidebar@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944103,"type":"renderer","name":"project","msg":"persisting panel@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":40,"time":1560884944412,"type":"renderer","name":"project","query":"\n      DELETE\n        FROM metadata_values\n        WHERE value_id IN (\n          SELECT v.value_id\n            FROM metadata_values v\n              LEFT OUTER JOIN metadata m\n              USING (value_id)\n            WHERE m.value_id IS NULL\n        )","ms":273,"msg":"SLOW: db query took 273ms","v":1}
{"level":30,"time":1560884944449,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Downloads/Maxson Dissertation-fixed-fixed.tpy","v":1}
{"level":30,"time":1560884944454,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Downloads/Maxson Dissertation-fixed-fixed.tpy","v":1}
{"level":40,"time":1560884944668,"type":"renderer","name":"project","query":"\n      INSERT INTO access (uuid, version, path) VALUES (?, ?, ?)","ms":208,"msg":"SLOW: db query took 208ms","v":1}
{"level":30,"time":1560884944673,"type":"renderer","name":"project","msg":"restoring nav@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944674,"type":"renderer","name":"project","msg":"restoring notepad@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944674,"type":"renderer","name":"project","msg":"restoring esper@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944675,"type":"renderer","name":"project","msg":"restoring imports@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944676,"type":"renderer","name":"project","msg":"restoring sidebar@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944676,"type":"renderer","name":"project","msg":"restoring panel@78f6b0a8-7743-4d3e-b287-0588116f8fbc","v":1}
{"level":30,"time":1560884944698,"type":"renderer","name":"project","msg":"open db /Users/smaxson/Downloads/Maxson Dissertation-fixed-fixed.tpy","v":1}
{"level":40,"time":1560884945109,"type":"renderer","name":"project","query":"\n        SELECT id, tag_id AS tag\n          FROM taggings","ms":299,"msg":"SLOW: db query took 299ms","v":1}
{"level":40,"time":1560884945110,"type":"renderer","name":"project","query":"\n        SELECT id, list_id AS list\n          FROM list_items","ms":293,"msg":"SLOW: db query took 293ms","v":1}
{"level":40,"time":1560884945110,"type":"renderer","name":"project","query":"\n        SELECT id AS photo, item_id AS id\n          FROM photos\n            LEFT OUTER JOIN trash USING (id)\n          WHERE \n            deleted IS NULL\n          ORDER BY item_id, position","ms":328,"msg":"SLOW: db query took 328ms","v":1}
{"level":40,"time":1560884945110,"type":"renderer","name":"project","query":"\n        SELECT\n            id,\n            template,\n            datetime(created, \"localtime\") AS created,\n            datetime(modified, \"localtime\") AS modified,\n            deleted\n          FROM subjects\n            JOIN items USING (id)\n            LEFT OUTER JOIN trash USING (id)","ms":333,"msg":"SLOW: db query took 333ms","v":1}
{"level":40,"time":1560884945378,"type":"renderer","name":"project","ms":675,"list":true,"query":"","tags":false,"trash":null,"msg":"SLOW: *search query \"\" took 675ms","v":1}
{"level":40,"time":1560884948992,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0004.JPG'","msg":"image check failed for /Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0004.JPG","v":1}
{"level":40,"time":1560884948992,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0004.JPG'","msg":"failed to open photo 1035","v":1}
{"level":40,"time":1560884971681,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0001.JPG'","msg":"image check failed for /Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0001.JPG","v":1}
{"level":40,"time":1560884971681,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0001.JPG'","msg":"failed to open photo 1029","v":1}
{"level":40,"time":1560885120679,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0009.JPG'","msg":"image check failed for /Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0009.JPG","v":1}
{"level":40,"time":1560885120679,"type":"renderer","name":"project","stack":"Error: ENOENT: no such file or directory, stat '/Volumes/Maxson.PhD/Dissertation Research/NARA_1/RG15_Pension Files/Briggies, Cato/NARA.RG15.Briggies.Cato.0009.JPG'","msg":"failed to open photo 1045","v":1}