{"level":30,"time":1595186474803,"type":"browser","name":"main","opts":{"_":[],"environment":"production","env":"production","auto-updates":true,"ignore-gpu-blacklist":false,"debug":false,"trace":false,"port":null,"p":null,"$0":"tropy.exe","data":"C:\\Users\\steven\\AppData\\Roaming\\Tropy","cache":"C:\\Users\\steven\\AppData\\Roaming\\Tropy\\cache","logs":"C:\\Users\\steven\\AppData\\Roaming\\Tropy\\log"},"version":"1.8.0","msg":"main.init 1.8.0 Windows_NT 10.0.18363 (x64)"}
{"level":30,"time":1595186475051,"type":"browser","name":"main","msg":"plugins scanned: 0"}
{"level":30,"time":1595186475153,"type":"browser","name":"main","msg":"app state restored"}
{"level":30,"time":1595186475177,"type":"browser","name":"main","file":"G:\\My Drive\\Academic\\Tropy\\Archivio di stato di Genova.tpy","msg":"open new project window"}
{"level":30,"time":1595186475264,"type":"browser","name":"main","msg":"ready after 683ms [req:164ms]"}
{"level":30,"time":1595186485549,"type":"renderer","name":"project","dpx":1,"opts":{"aqua":false,"contrast":false,"dark":false,"environment":"production","documents":"C:\\Users\\steven\\Documents","maximizable":true,"minimizable":true,"pictures":"C:\\Users\\steven\\Pictures","scrollbars":true,"theme":"light","file":"G:\\My Drive\\Academic\\Tropy\\Archivio di stato di Genova.tpy","recent":["G:\\My Drive\\Academic\\Tropy\\Archivio di stato di Genova.tpy","G:\\My Drive\\Academic\\Tropy\\Genoese notarial deeds.tpy","C:\\Users\\steven\\Documents\\Notai antichi.tpy"],"data":"C:\\Users\\steven\\AppData\\Roaming\\Tropy","debug":true,"dev":false,"cache":"C:\\Users\\steven\\AppData\\Roaming\\Tropy\\cache","plugins":"C:\\Users\\steven\\AppData\\Roaming\\Tropy\\plugins","fontSize":"13px","frameless":false,"level":"info","locale":"en","log":"C:\\Users\\steven\\AppData\\Roaming\\Tropy\\log\\tropy.log","uuid":"1ea3df30-fb9e-11e7-bcf2-f5136d623301","update":{},"version":"1.8.0","webgl":true,"zoom":1},"msg":"project.init"}
{"level":30,"time":1595186487118,"type":"renderer","name":"project","msg":"plugins scanned: 0"}
{"level":30,"time":1595186487119,"type":"renderer","name":"project","msg":"plugins loaded: 0"}
{"level":30,"time":1595186497874,"type":"renderer","name":"project","mode":"w+","msg":"open db C:\\Users\\steven\\AppData\\Roaming\\Tropy\\ontology.db"}
{"level":30,"time":1595186497955,"type":"renderer","name":"project","msg":"restoring recent@tropy"}
{"level":30,"time":1595186498389,"type":"renderer","name":"project","msg":"restoring settings@tropy"}
{"level":30,"time":1595186498389,"type":"renderer","name":"project","msg":"restoring ui@tropy"}
{"level":30,"time":1595186498765,"type":"renderer","name":"project","msg":"project ready 13369ms [dom:621ms win:1102ms req:11388ms]"}
{"level":30,"time":1595186500616,"type":"renderer","name":"project","msg":"Esper.instance created using webgl renderer"}
{"level":30,"time":1595186500995,"type":"renderer","name":"project","mode":"w","msg":"open db G:\\My Drive\\Academic\\Tropy\\Archivio di stato di Genova.tpy"}
{"level":40,"time":1595186501015,"type":"renderer","name":"project","query":"\n      SELECT count(*) AS count FROM sqlite_master","ms":2218,"msg":"SLOW: db query took 2218ms"}
{"level":30,"time":1595186501245,"type":"renderer","name":"project","msg":"db query took 116ms","query":"\n        SELECT\n          property_id AS id,\n          vocabulary_id AS vocabulary,\n          p.description,\n          p.comment,\n          label\n          FROM properties p\n            JOIN vocabularies v USING (vocabulary_id)\n            LEFT JOIN labels ON (property_id = id AND language = ?)\n          WHERE deleted is NULL","ms":116}
{"level":40,"time":1595186501659,"type":"renderer","name":"project","query":"PRAGMA user_version","ms":455,"msg":"SLOW: db query took 455ms"}
{"level":30,"time":1595186501661,"type":"renderer","name":"project","mode":"w","msg":"open db G:\\My Drive\\Academic\\Tropy\\Archivio di stato di Genova.tpy"}
{"level":40,"time":1595186501971,"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":271,"msg":"SLOW: db query took 271ms"}
{"level":30,"time":1595186535155,"type":"browser","name":"main","msg":"checking for updates..."}
{"level":30,"time":1595186539123,"type":"browser","name":"main","msg":"no updates available"}
{"level":40,"time":1595186571163,"type":"renderer","name":"project","query":"PRAGMA integrity_check(10)","ms":69191,"msg":"SLOW: db query took 69191ms"}
{"level":40,"time":1595186574143,"type":"renderer","name":"project","query":"PRAGMA foreign_key_check","ms":2977,"msg":"SLOW: db query took 2977ms"}
{"level":30,"time":1595186574204,"type":"renderer","name":"project","msg":"restoring nav@89ce8d4b-345c-4db7-ba0a-814d6f3df603"}
{"level":30,"time":1595186574205,"type":"renderer","name":"project","msg":"restoring notepad@89ce8d4b-345c-4db7-ba0a-814d6f3df603"}
{"level":30,"time":1595186574205,"type":"renderer","name":"project","msg":"restoring esper@89ce8d4b-345c-4db7-ba0a-814d6f3df603"}
{"level":30,"time":1595186574206,"type":"renderer","name":"project","msg":"restoring imports@89ce8d4b-345c-4db7-ba0a-814d6f3df603"}
{"level":30,"time":1595186574206,"type":"renderer","name":"project","msg":"restoring sidebar@89ce8d4b-345c-4db7-ba0a-814d6f3df603"}
{"level":30,"time":1595186574207,"type":"renderer","name":"project","msg":"restoring panel@89ce8d4b-345c-4db7-ba0a-814d6f3df603"}
{"level":30,"time":1595186574289,"type":"renderer","name":"project","mode":"w","msg":"open db G:\\My Drive\\Academic\\Tropy\\Archivio di stato di Genova.tpy"}
{"level":40,"time":1595186583001,"type":"renderer","name":"project","query":"\n        SELECT id, tag_id AS tag\n          FROM taggings","ms":8614,"msg":"SLOW: db query took 8614ms"}
{"level":40,"time":1595186585335,"type":"renderer","name":"project","query":"\n        SELECT id, list_id AS list\n          FROM list_items","ms":9301,"msg":"SLOW: db query took 9301ms"}
{"level":40,"time":1595186585336,"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":9581,"msg":"SLOW: db query took 9581ms"}
{"level":40,"time":1595186585336,"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":9621,"msg":"SLOW: db query took 9621ms"}
{"level":40,"time":1595186585338,"type":"renderer","name":"project","query":"\n        SELECT id, note_id AS note\n          FROM notes JOIN photos using (id)\n          WHERE  deleted IS NULL\n          ORDER BY id, created","ms":471,"msg":"SLOW: db query took 471ms"}
{"level":40,"time":1595186585341,"type":"renderer","name":"project","msg":"SLOW: item.load#18"}
{"level":40,"time":1595186585618,"type":"renderer","name":"project","action":"note.load","meta":{"done":true,"rel":22,"was":1595186574304,"seq":26,"now":1595186585618},"msg":"note.load failed: ResourceRequest timed out","stack":"TimeoutError: ResourceRequest timed out\n    at ResourceRequest._fireTimeout (C:\\Users\\steven\\AppData\\Local\\tropy\\app-1.8.0\\resources\\app.asar\\node_modules\\generic-pool\\lib\\ResourceRequest.js:62:17)\n    at bound (C:\\Users\\steven\\AppData\\Local\\tropy\\app-1.8.0\\resources\\app.asar\\node_modules\\generic-pool\\lib\\ResourceRequest.js:8:15)"}
{"level":40,"time":1595186585627,"type":"renderer","name":"project","list":true,"query":"","tags":false,"stack":"TimeoutError: ResourceRequest timed out\n    at ResourceRequest._fireTimeout (C:\\Users\\steven\\AppData\\Local\\tropy\\app-1.8.0\\resources\\app.asar\\node_modules\\generic-pool\\lib\\ResourceRequest.js:62:17)\n    at bound (C:\\Users\\steven\\AppData\\Local\\tropy\\app-1.8.0\\resources\\app.asar\\node_modules\\generic-pool\\lib\\ResourceRequest.js:8:15)","trash":null,"msg":"*search failed"}
{"level":30,"time":1595186585882,"type":"renderer","name":"project","msg":"db query took 186ms","query":"\n          SELECT id, note_id AS note\n            FROM notes JOIN selections USING (id)\n            WHERE \n              deleted IS NULL\n            ORDER BY id, created","ms":186}
{"level":40,"time":1595186586991,"type":"renderer","name":"project","query":"\n          SELECT\n              id,\n              photo_id AS photo,\n              x,\n              y,\n              width,\n              height,\n              angle,\n              mirror,\n              negative,\n              brightness,\n              contrast,\n              hue,\n              saturation,\n              sharpen,\n              template,\n              datetime(created, \"localtime\") AS created,\n              datetime(modified, \"localtime\") AS modified\n            FROM subjects\n              JOIN images USING (id)\n              JOIN selections USING (id)","ms":1339,"msg":"SLOW: db query took 1339ms"}
{"level":40,"time":1595186586992,"type":"renderer","name":"project","msg":"SLOW: selection.load#21"}
{"level":40,"time":1595186604451,"type":"renderer","name":"project","msg":"SLOW: metadata.load#20"}
{"level":40,"time":1595186606515,"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":17021,"msg":"SLOW: db query took 17021ms"}
{"level":40,"time":1595186636091,"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            color,\n            density,\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":53084,"msg":"SLOW: db query took 53084ms"}
{"level":40,"time":1595186636094,"type":"renderer","name":"project","msg":"SLOW: photo.load#19"}
{"level":40,"time":1595186664061,"type":"renderer","name":"project","ms":743,"list":true,"query":"","tags":false,"trash":null,"msg":"SLOW: *search query \"\" took 743ms"}
{"level":40,"time":1595186668325,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1570,"msg":"SLOW: db query took 1570ms"}
{"level":40,"time":1595186669322,"type":"renderer","name":"project","query":"INSERT INTO access (path, uuid, version) VALUES (?,?,?)","ms":993,"msg":"SLOW: db query took 993ms"}
{"level":40,"time":1595186669338,"type":"renderer","name":"project","query":"UPDATE images SET width = $new_width, height = $new_height WHERE id = $id","ms":1010,"msg":"SLOW: db query took 1010ms"}
{"level":40,"time":1595186671564,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":930,"msg":"SLOW: db query took 930ms"}
{"level":40,"time":1595186673512,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":875,"msg":"SLOW: db query took 875ms"}
{"level":40,"time":1595186675594,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":898,"msg":"SLOW: db query took 898ms"}
{"level":40,"time":1595186677598,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":964,"msg":"SLOW: db query took 964ms"}
{"level":40,"time":1595186679646,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":922,"msg":"SLOW: db query took 922ms"}
{"level":40,"time":1595186682569,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1723,"msg":"SLOW: db query took 1723ms"}
{"level":40,"time":1595186685950,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1770,"msg":"SLOW: db query took 1770ms"}
{"level":40,"time":1595186688031,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":970,"msg":"SLOW: db query took 970ms"}
{"level":40,"time":1595186690478,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1181,"msg":"SLOW: db query took 1181ms"}
{"level":40,"time":1595186693350,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1778,"msg":"SLOW: db query took 1778ms"}
{"level":40,"time":1595186697164,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":2225,"msg":"SLOW: db query took 2225ms"}
{"level":40,"time":1595186700285,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1599,"msg":"SLOW: db query took 1599ms"}
{"level":40,"time":1595186702432,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":936,"msg":"SLOW: db query took 936ms"}
{"level":40,"time":1595186704450,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":896,"msg":"SLOW: db query took 896ms"}
{"level":40,"time":1595186706890,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1338,"msg":"SLOW: db query took 1338ms"}
{"level":40,"time":1595186709628,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1600,"msg":"SLOW: db query took 1600ms"}
{"level":40,"time":1595186711899,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":976,"msg":"SLOW: db query took 976ms"}
{"level":40,"time":1595186714163,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1138,"msg":"SLOW: db query took 1138ms"}
{"level":40,"time":1595186717107,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1359,"msg":"SLOW: db query took 1359ms"}
{"level":40,"time":1595186719249,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":922,"msg":"SLOW: db query took 922ms"}
{"level":40,"time":1595186721228,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":937,"msg":"SLOW: db query took 937ms"}
{"level":40,"time":1595186723829,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1348,"msg":"SLOW: db query took 1348ms"}
{"level":40,"time":1595186726645,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1522,"msg":"SLOW: db query took 1522ms"}
{"level":40,"time":1595186728952,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1181,"msg":"SLOW: db query took 1181ms"}
{"level":40,"time":1595186731107,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":909,"msg":"SLOW: db query took 909ms"}
{"level":40,"time":1595186733208,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":910,"msg":"SLOW: db query took 910ms"}
{"level":40,"time":1595186735471,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1199,"msg":"SLOW: db query took 1199ms"}
{"level":40,"time":1595186737741,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":956,"msg":"SLOW: db query took 956ms"}
{"level":40,"time":1595186739976,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1025,"msg":"SLOW: db query took 1025ms"}
{"level":40,"time":1595186743301,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1628,"msg":"SLOW: db query took 1628ms"}
{"level":40,"time":1595186745345,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":966,"msg":"SLOW: db query took 966ms"}
{"level":40,"time":1595186749137,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":2607,"msg":"SLOW: db query took 2607ms"}
{"level":40,"time":1595186751393,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1087,"msg":"SLOW: db query took 1087ms"}
{"level":40,"time":1595186753989,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1110,"msg":"SLOW: db query took 1110ms"}
{"level":40,"time":1595186756129,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":980,"msg":"SLOW: db query took 980ms"}
{"level":40,"time":1595186758375,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":978,"msg":"SLOW: db query took 978ms"}
{"level":40,"time":1595186760326,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":897,"msg":"SLOW: db query took 897ms"}
{"level":40,"time":1595186762534,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1041,"msg":"SLOW: db query took 1041ms"}
{"level":40,"time":1595186764624,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":911,"msg":"SLOW: db query took 911ms"}
{"level":40,"time":1595186766836,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1138,"msg":"SLOW: db query took 1138ms"}
{"level":40,"time":1595186769791,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1806,"msg":"SLOW: db query took 1806ms"}
{"level":40,"time":1595186771997,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1111,"msg":"SLOW: db query took 1111ms"}
{"level":40,"time":1595186774408,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1186,"msg":"SLOW: db query took 1186ms"}
{"level":40,"time":1595186774442,"type":"renderer","name":"project","msg":"SLOW: photo.consolidate#78"}
{"level":30,"time":1595186923168,"type":"renderer","name":"project","msg":"db query took 108ms","query":"\n      \n      SELECT DISTINCT id, added\n        FROM list_items\n          JOIN subjects 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 list_items.added ASC, id ASC","ms":108}
{"level":40,"time":1595186933760,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1164,"msg":"SLOW: db query took 1164ms"}
{"level":40,"time":1595186936191,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1052,"msg":"SLOW: db query took 1052ms"}
{"level":40,"time":1595186938350,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":939,"msg":"SLOW: db query took 939ms"}
{"level":40,"time":1595186940706,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1129,"msg":"SLOW: db query took 1129ms"}
{"level":40,"time":1595186943042,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1185,"msg":"SLOW: db query took 1185ms"}
{"level":40,"time":1595186945212,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1044,"msg":"SLOW: db query took 1044ms"}
{"level":40,"time":1595186947843,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1459,"msg":"SLOW: db query took 1459ms"}
{"level":40,"time":1595186949888,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":967,"msg":"SLOW: db query took 967ms"}
{"level":40,"time":1595186951938,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":894,"msg":"SLOW: db query took 894ms"}
{"level":40,"time":1595186953964,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":978,"msg":"SLOW: db query took 978ms"}
{"level":40,"time":1595186956230,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1032,"msg":"SLOW: db query took 1032ms"}
{"level":40,"time":1595186958414,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1063,"msg":"SLOW: db query took 1063ms"}
{"level":40,"time":1595186960616,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1029,"msg":"SLOW: db query took 1029ms"}
{"level":40,"time":1595186962800,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":989,"msg":"SLOW: db query took 989ms"}
{"level":40,"time":1595186964979,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":989,"msg":"SLOW: db query took 989ms"}
{"level":40,"time":1595186967852,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1743,"msg":"SLOW: db query took 1743ms"}
{"level":40,"time":1595186970003,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1049,"msg":"SLOW: db query took 1049ms"}
{"level":40,"time":1595186972431,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1086,"msg":"SLOW: db query took 1086ms"}
{"level":40,"time":1595186974679,"type":"renderer","name":"project","query":"UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, page = $new_page, path = $new_path, protocol = $new_protocol, size = $new_size WHERE id = $id","ms":1086,"msg":"SLOW: db query took 1086ms"}