{"level":30,"time":1733768187821,"type":"browser","name":"main","args":[],"opts":{"env":"production","autoUpdates":true,"contextIsolation":true,"webgl":false,"verbose":false,"trace":false,"data":"/Users/charliefenton/Library/Application Support/Tropy","cache":"/Users/charliefenton/Library/Caches/Tropy","logs":"/Users/charliefenton/Library/Logs/Tropy"},"version":"1.16.2","msg":"main.init 1.16.2 Darwin 24.1.0 (x64)"}
{"level":30,"time":1733768188097,"type":"browser","name":"main","msg":"plugins scanned: 0"}
{"level":30,"time":1733768188103,"type":"browser","name":"main","msg":"app state restored"}
{"level":30,"time":1733768188110,"type":"browser","name":"main","file":"/Users/charliefenton/Documents/PhD.tpy","msg":"open new project window"}
{"level":30,"time":1733768188646,"type":"browser","name":"main","msg":"switch to \"system\" theme"}
{"level":30,"time":1733768188658,"type":"browser","name":"main","msg":"checking for updates..."}
{"level":30,"time":1733768188873,"type":"browser","name":"main","msg":"no updates available"}
{"level":30,"time":1733768192362,"type":"renderer","name":"project","dpx":2,"args":{"frameless":true,"locale":"en","webgl":true,"zoom":1},"msg":"project.init"}
{"level":30,"time":1733768192607,"type":"renderer","name":"project","msg":"plugins scanned: 0"}
{"level":30,"time":1733768192608,"type":"renderer","name":"project","msg":"plugins loaded: 0"}
{"level":30,"time":1733768192695,"type":"browser","name":"main","msg":"ready after 1857.98095703125ms"}
{"level":30,"time":1733768193380,"type":"renderer","name":"project","msg":"restoring projectFiles@tropy"}
{"level":30,"time":1733768193395,"type":"renderer","name":"project","msg":"restoring recent@tropy"}
{"level":30,"time":1733768193400,"type":"renderer","name":"project","msg":"restoring settings@tropy"}
{"level":30,"time":1733768193401,"type":"renderer","name":"project","msg":"restoring ui@tropy"}
{"level":30,"time":1733768193415,"type":"renderer","name":"project","mode":"w+","msg":"open db /Users/charliefenton/Library/Application Support/Tropy/ontology.db"}
{"level":30,"time":1733768193571,"type":"renderer","name":"project","msg":"project ready 5092ms [dom:3965ms init:275ms load:692ms]"}
{"level":30,"time":1733768194509,"type":"renderer","name":"project","mode":"webgl","resolution":2,"msg":"Esper.instance created with webgl renderer"}
{"level":30,"time":1733768194850,"type":"renderer","name":"project","mode":"w","msg":"open db /Users/charliefenton/Documents/PhD.tpy"}
{"level":40,"time":1733768195803,"type":"renderer","name":"project","query":"VACUUM","ms":569,"msg":"SLOW: db query took 569ms"}
{"level":40,"time":1733768196186,"type":"renderer","name":"project","query":"PRAGMA integrity_check(10)","ms":381,"msg":"SLOW: db query took 381ms"}
{"level":30,"time":1733768196290,"type":"renderer","name":"project","msg":"restoring project.watch@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768196291,"type":"renderer","name":"project","msg":"db query took 103ms","query":"PRAGMA foreign_key_check","ms":103}
{"level":30,"time":1733768196295,"type":"renderer","name":"project","msg":"restoring project.watch@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768196296,"type":"renderer","name":"project","msg":"restoring nav@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768196296,"type":"renderer","name":"project","msg":"restoring notepad@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768196296,"type":"renderer","name":"project","msg":"restoring esper@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768196302,"type":"renderer","name":"project","msg":"restoring imports@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768196303,"type":"renderer","name":"project","msg":"restoring sidebar@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768196304,"type":"renderer","name":"project","msg":"restoring panel@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768196351,"type":"renderer","name":"project","mode":"w","msg":"open db /Users/charliefenton/Documents/PhD.tpy"}
{"level":30,"time":1733768196352,"type":"renderer","name":"project","mode":"w","msg":"open db /Users/charliefenton/Documents/PhD.tpy"}
{"level":30,"time":1733768197081,"type":"renderer","name":"project","msg":"db query took 164ms","query":"\n        SELECT id, list_id AS list\n          FROM list_items","ms":164}
{"level":40,"time":1733768198866,"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":1063,"msg":"SLOW: db query took 1063ms"}
{"level":40,"time":1733768198866,"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":1162,"msg":"SLOW: db query took 1162ms"}
{"level":40,"time":1733768198866,"type":"renderer","name":"project","query":"\n        SELECT\n            id,\n            template,\n            strftime(\"%Y-%m-%dT%H:%M:%f\", created, \"localtime\") AS created,\n            strftime(\"%Y-%m-%dT%H:%M:%f\", modified, \"localtime\") AS modified,\n            deleted\n          FROM subjects\n            JOIN items USING (id)\n            LEFT OUTER JOIN trash USING (id)","ms":1417,"msg":"SLOW: db query took 1417ms"}
{"level":40,"time":1733768198866,"type":"renderer","name":"project","query":"\n      SELECT\n          id,\n          item_id AS item,\n          template,\n          strftime(\"%Y-%m-%dT%H:%M:%f\", created, \"localtime\") AS created,\n          strftime(\"%Y-%m-%dT%H:%M:%f\", modified, \"localtime\") AS modified,\n          angle,\n          color,\n          density,\n          mirror,\n          negative,\n          brightness,\n          contrast,\n          hue,\n          saturation,\n          sharpen,\n          width,\n          height,\n          path,\n          filename,\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":1521,"msg":"SLOW: db query took 1521ms"}
{"level":40,"time":1733768198867,"type":"renderer","name":"project","msg":"SLOW: metadata.load#21"}
{"level":40,"time":1733768198904,"type":"renderer","name":"project","msg":"SLOW: item.load#19"}
{"level":40,"time":1733768198917,"type":"renderer","name":"project","msg":"SLOW: photo.load#20"}
{"level":40,"time":1733768198990,"type":"renderer","name":"project","ms":2637,"list":56,"query":"","tags":false,"trash":null,"msg":"SLOW: *search query \"\" took 2637ms"}
{"level":40,"time":1733768199257,"type":"renderer","name":"project","msg":"SLOW: note.load#23"}
{"level":40,"time":1733768199269,"type":"renderer","name":"project","msg":"SLOW: selection.load#22"}
{"level":30,"time":1733768303933,"type":"renderer","name":"project","msg":"persisting nav@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768303937,"type":"renderer","name":"project","msg":"persisting notepad@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768303937,"type":"renderer","name":"project","msg":"persisting esper@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768303946,"type":"renderer","name":"project","msg":"persisting imports@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768303946,"type":"renderer","name":"project","msg":"persisting sidebar@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768303946,"type":"renderer","name":"project","msg":"persisting panel@e12827df-5bf2-4491-9bac-5316c3410049"}
{"level":30,"time":1733768304034,"type":"renderer","name":"project","msg":"restoring project.watch@e12827df-5bf2-4491-9bac-5316c3410049"}