{"level":"info","message":"logger initialized at level debug","label":"project","timestamp":"2019-01-04T15:50:24.947Z"}
{"level":"verbose","message":"initializing project window...","label":"project","timestamp":"2019-01-04T15:50:25.151Z"}
{"level":"debug","message":"init db C:\\Users\\chloe\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2019-01-04T15:50:27.245Z"}
{"level":"verbose","message":"opening db C:\\Users\\chloe\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2019-01-04T15:50:27.247Z"}
{"level":"verbose","message":"restoring recent@tropy...","label":"project","timestamp":"2019-01-04T15:50:27.251Z"}
{"level":"verbose","message":"restoring settings@tropy...","label":"project","timestamp":"2019-01-04T15:50:27.253Z"}
{"level":"verbose","message":"restoring ui@tropy...","label":"project","timestamp":"2019-01-04T15:50:27.253Z"}
{"level":"verbose","message":"recent.restore \u001b[90m#1\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.255Z"}
{"level":"verbose","message":"settings.restore \u001b[90m#2\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.255Z"}
{"level":"verbose","message":"ui.restore \u001b[90m#3\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.255Z"}
{"level":"debug","message":"open resource C:\\Users\\chloe\\AppData\\Local\\tropy\\app-1.3.2\\resources\\app.asar\\res\\strings\\renderer.fr.yml","label":"project","timestamp":"2019-01-04T15:50:27.257Z"}
{"level":"debug","message":"open resource C:\\Users\\chloe\\AppData\\Local\\tropy\\app-1.3.2\\resources\\app.asar\\res\\keymaps\\project.fr.yml","label":"project","timestamp":"2019-01-04T15:50:27.257Z"}
{"level":"debug","message":"open resource C:\\Users\\chloe\\AppData\\Local\\tropy\\app-1.3.2\\resources\\app.asar\\res\\keymaps\\project.en.yml","label":"project","timestamp":"2019-01-04T15:50:27.259Z"}
{"level":"verbose","message":"project ready after 2442.3ms (2102.6ms)","label":"project","timestamp":"2019-01-04T15:50:27.262Z"}
{"level":"verbose","message":"keymap.update \u001b[90m#4\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.302Z"}
{"level":"verbose","message":"intl.update \u001b[90m#5\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.321Z"}
{"level":"verbose","message":"project.open \u001b[90m#6\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.322Z"}
{"level":"debug","message":"init db C:\\Users\\chloe\\Documents\\9 Doctorat\\THESE\\These.tpy","label":"project","timestamp":"2019-01-04T15:50:27.323Z"}
{"level":"verbose","message":"opening db C:\\Users\\chloe\\Documents\\9 Doctorat\\THESE\\These.tpy","label":"project","timestamp":"2019-01-04T15:50:27.323Z"}
{"query":"\n      SELECT count(*) AS count FROM sqlite_master","time":19,"level":"debug","message":"db query took 19ms","label":"project","timestamp":"2019-01-04T15:50:27.690Z"}
{"level":"verbose","message":"opening db C:\\Users\\chloe\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2019-01-04T15:50:27.767Z"}
{"level":"verbose","message":"opening db C:\\Users\\chloe\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2019-01-04T15:50:27.767Z"}
{"level":"verbose","message":"opening db C:\\Users\\chloe\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2019-01-04T15:50:27.768Z"}
{"level":"verbose","message":"plugins scanned: 0","label":"project","timestamp":"2019-01-04T15:50:27.775Z"}
{"level":"verbose","message":"plugins loaded: 0","label":"project","timestamp":"2019-01-04T15:50:27.775Z"}
{"query":"PRAGMA user_version","time":80,"level":"debug","message":"db query took 80ms","label":"project","timestamp":"2019-01-04T15:50:27.776Z"}
{"query":"\n        SELECT\n            vocabulary_id AS id,\n            prefix,\n            title,\n            description,\n            comment,\n            see_also AS seeAlso,\n            protected AS isProtected\n          FROM vocabularies\n          WHERE deleted is NULL","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:27.843Z"}
{"level":"verbose","message":"opening db C:\\Users\\chloe\\Documents\\9 Doctorat\\THESE\\These.tpy","label":"project","timestamp":"2019-01-04T15:50:27.848Z"}
{"query":"PRAGMA user_version","time":23,"level":"debug","message":"db query took 23ms","label":"project","timestamp":"2019-01-04T15:50:27.851Z"}
{"query":"\n        SELECT\n            template_id AS id,\n            template_type AS type,\n            name,\n            version,\n            creator,\n            description,\n            protected AS isProtected,\n            created\n          FROM templates\n          ","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2019-01-04T15:50:27.856Z"}
{"query":"PRAGMA busy_timeout = 2000;","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:27.856Z"}
{"query":"PRAGMA foreign_keys = on;","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:27.856Z"}
{"query":"\n        SELECT\n          datatype_id AS id,\n          vocabulary_id AS vocabulary,\n          dt.description,\n          dt.comment,\n          label\n          FROM datatypes dt\n            JOIN vocabularies v USING (vocabulary_id)\n            LEFT OUTER JOIN labels ON (datatype_id = id AND language = ?)\n          WHERE deleted is NULL","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2019-01-04T15:50:27.857Z"}
{"query":"\n        SELECT\n          class_id AS id,\n          vocabulary_id AS vocabulary,\n          c.description,\n          c.comment,\n          label\n          FROM classes c\n            JOIN vocabularies v USING (vocabulary_id)\n            LEFT JOIN labels ON (class_id = id AND language = ?)\n          WHERE deleted is NULL","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2019-01-04T15:50:27.857Z"}
{"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","time":5,"level":"debug","message":"db query took 5ms","label":"project","timestamp":"2019-01-04T15:50:27.864Z"}
{"query":"\n        SELECT project_id AS id, name, base FROM project LIMIT 1","time":4,"level":"debug","message":"db query took 4ms","label":"project","timestamp":"2019-01-04T15:50:27.864Z"}
{"query":"\n          SELECT vocabulary_id AS id, class_id AS klass\n            FROM classes JOIN vocabularies USING (vocabulary_id)\n            WHERE deleted is NULL","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:27.867Z"}
{"query":"\n          SELECT vocabulary_id AS id, property_id AS prop\n            FROM properties JOIN vocabularies USING (vocabulary_id)\n            WHERE deleted is NULL","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:27.868Z"}
{"query":"\n          SELECT vocabulary_id AS id, datatype_id AS datatype\n            FROM datatypes JOIN vocabularies USING (vocabulary_id)\n            WHERE deleted is NULL","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:27.869Z"}
{"query":"\n          SELECT class_id AS klass, template_id AS tpl\n            FROM domains\n            \n            ORDER BY position","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:27.870Z"}
{"query":"\n        SELECT COUNT (id) AS total\n          FROM items LEFT OUTER JOIN trash USING (id)\n          WHERE deleted IS NULL","time":5,"level":"debug","message":"db query took 5ms","label":"project","timestamp":"2019-01-04T15:50:27.871Z"}
{"level":"verbose","message":"ontology.load \u001b[90m#7\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.879Z"}
{"query":"\n          SELECT\n              f.field_id AS id,\n              template_id AS tpl,\n              property_id AS property,\n              label,\n              datatype_id AS datatype,\n              required AS isRequired,\n              hint,\n              value,\n              constant AS isConstant\n            FROM fields f\n              LEFT OUTER JOIN field_labels l\n                ON (f.field_id = l.field_id AND language = ?)\n            \n            ORDER BY position, f.field_id","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2019-01-04T15:50:27.927Z"}
{"query":"\n      INSERT INTO access (uuid, version, path) VALUES (?, ?, ?)","time":45,"level":"debug","message":"db query took 45ms","label":"project","timestamp":"2019-01-04T15:50:27.929Z"}
{"level":"verbose","message":"project.opened \u001b[90m#8\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.930Z"}
{"level":"verbose","message":"restoring nav@abe7f73f-1ee7-4d98-970a-817b6a05a3d8...","label":"project","timestamp":"2019-01-04T15:50:27.943Z"}
{"level":"verbose","message":"restoring notepad@abe7f73f-1ee7-4d98-970a-817b6a05a3d8...","label":"project","timestamp":"2019-01-04T15:50:27.944Z"}
{"level":"verbose","message":"restoring esper@abe7f73f-1ee7-4d98-970a-817b6a05a3d8...","label":"project","timestamp":"2019-01-04T15:50:27.944Z"}
{"level":"verbose","message":"restoring imports@abe7f73f-1ee7-4d98-970a-817b6a05a3d8...","label":"project","timestamp":"2019-01-04T15:50:27.949Z"}
{"level":"verbose","message":"restoring sidebar@abe7f73f-1ee7-4d98-970a-817b6a05a3d8...","label":"project","timestamp":"2019-01-04T15:50:27.950Z"}
{"level":"verbose","message":"nav.restore \u001b[90m#9\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.950Z"}
{"level":"verbose","message":"notepad.restore \u001b[90m#10\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.975Z"}
{"level":"verbose","message":"esper.restore \u001b[90m#11\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.978Z"}
{"level":"verbose","message":"imports.restore \u001b[90m#12\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.997Z"}
{"level":"verbose","message":"sidebar.restore \u001b[90m#13\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:27.999Z"}
{"level":"verbose","message":"history.drop \u001b[90m#14\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.001Z"}
{"level":"verbose","message":"list.load \u001b[90m#15\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.016Z"}
{"level":"verbose","message":"tag.load \u001b[90m#16\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.021Z"}
{"level":"verbose","message":"item.load \u001b[90m#17\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.030Z"}
{"level":"verbose","message":"opening db C:\\Users\\chloe\\Documents\\9 Doctorat\\THESE\\These.tpy","label":"project","timestamp":"2019-01-04T15:50:28.032Z"}
{"level":"verbose","message":"photo.load \u001b[90m#18\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.033Z"}
{"level":"verbose","message":"opening db C:\\Users\\chloe\\Documents\\9 Doctorat\\THESE\\These.tpy","label":"project","timestamp":"2019-01-04T15:50:28.036Z"}
{"level":"verbose","message":"metadata.load \u001b[90m#19\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.036Z"}
{"level":"verbose","message":"selection.load \u001b[90m#20\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.042Z"}
{"level":"verbose","message":"note.load \u001b[90m#21\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.049Z"}
{"level":"verbose","message":"tag.load \u001b[90m#22(16) Δ56ms\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.078Z"}
{"level":"verbose","message":"list.load \u001b[90m#23(15) Δ100ms\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.117Z"}
{"query":"SELECT list_id AS id, parent_list_id AS parent, name FROM lists ORDER BY parent, position","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:28.136Z"}
{"query":"\n      SELECT tag_id AS id, name, color, created, modified\n        FROM tags","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:28.136Z"}
{"level":"verbose","message":"item.load \u001b[90m#24(17) Δ203ms\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.233Z"}
{"query":"\n        SELECT id, tag_id AS tag\n          FROM taggings","time":12,"level":"debug","message":"db query took 12ms","label":"project","timestamp":"2019-01-04T15:50:28.280Z"}
{"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)","time":12,"level":"debug","message":"db query took 12ms","label":"project","timestamp":"2019-01-04T15:50:28.280Z"}
{"query":"\n        SELECT id, list_id AS list\n          FROM list_items","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:28.280Z"}
{"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","time":16,"level":"debug","message":"db query took 16ms","label":"project","timestamp":"2019-01-04T15:50:28.280Z"}
{"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","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2019-01-04T15:50:28.397Z"}
{"query":"\n        SELECT id, note_id AS note\n          FROM notes\n          WHERE  deleted IS NULL\n          ORDER BY id, created","time":40,"level":"debug","message":"db query took 40ms","label":"project","timestamp":"2019-01-04T15:50:28.397Z"}
{"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            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)","time":84,"level":"debug","message":"db query took 84ms","label":"project","timestamp":"2019-01-04T15:50:28.397Z"}
{"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              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)","time":8,"level":"debug","message":"db query took 8ms","label":"project","timestamp":"2019-01-04T15:50:28.398Z"}
{"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","time":24,"level":"debug","message":"db query took 24ms","label":"project","timestamp":"2019-01-04T15:50:28.398Z"}
{"level":"verbose","message":"photo.load \u001b[90m#25(18) Δ368ms\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.401Z"}
{"level":"verbose","message":"metadata.load \u001b[90m#26(19) Δ471ms\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.507Z"}
{"level":"verbose","message":"selection.load \u001b[90m#27(20) Δ486ms\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.528Z"}
{"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","time":107,"level":"debug","message":"db query took 107ms","label":"project","timestamp":"2019-01-04T15:50:28.559Z"}
{"level":"verbose","message":"note.load \u001b[90m#28(21) Δ610ms\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.659Z"}
{"query":"\n        SELECT\n            note_id AS note,\n            photos.id AS photo,\n            selections.id AS selection,\n            state,\n            text,\n            language,\n            datetime(modified, \"localtime\") AS modified\n          FROM notes\n            LEFT OUTER JOIN photos USING (id)\n            LEFT OUTER JOIN selections USING (id)\n          WHERE deleted IS NULL\n          ORDER BY created ASC","time":40,"level":"debug","message":"db query took 40ms","label":"project","timestamp":"2019-01-04T15:50:28.726Z"}
{"level":"verbose","message":"*search query took 708ms","label":"project","timestamp":"2019-01-04T15:50:28.761Z"}
{"level":"verbose","message":"qr.update \u001b[90m#29\u001b[39m","label":"project","timestamp":"2019-01-04T15:50:28.762Z"}
{"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","time":14,"level":"debug","message":"db query took 14ms","label":"project","timestamp":"2019-01-04T15:50:28.897Z"}
{"level":"verbose","message":"nav.column.resize \u001b[90m#31\u001b[39m","label":"project","timestamp":"2019-01-04T15:52:23.767Z"}
{"level":"verbose","message":"idle.idle \u001b[90m#32\u001b[39m","label":"project","timestamp":"2019-01-04T15:59:00.163Z"}
{"level":"verbose","message":"cache.prune \u001b[90m#33\u001b[39m","label":"project","timestamp":"2019-01-04T15:59:00.165Z"}
{"level":"info","message":"pruning cache abe7f73f-1ee7-4d98-970a-817b6a05a3d8","label":"project","timestamp":"2019-01-04T15:59:00.176Z"}
{"level":"verbose","message":"cache.purge \u001b[90m#34\u001b[39m","label":"project","timestamp":"2019-01-04T15:59:00.177Z"}
{"level":"debug","message":"*setup terminated","label":"project","timestamp":"2019-01-04T15:59:00.182Z"}
{"level":"info","message":"purging cache C:\\Users\\chloe\\AppData\\Roaming\\Tropy\\cache","label":"project","timestamp":"2019-01-04T15:59:00.188Z"}
{"level":"verbose","message":"cache.prune \u001b[90m#35(33) Δ55ms\u001b[39m","label":"project","timestamp":"2019-01-04T15:59:00.220Z"}
{"level":"verbose","message":"cache.purge \u001b[90m#36(34) Δ62ms\u001b[39m","label":"project","timestamp":"2019-01-04T15:59:00.239Z"}
{"level":"verbose","message":"idle.active \u001b[90m#37\u001b[39m","label":"project","timestamp":"2019-01-04T16:01:15.163Z"}
{"level":"verbose","message":"idle.idle \u001b[90m#38\u001b[39m","label":"project","timestamp":"2019-01-04T16:14:50.165Z"}
{"level":"verbose","message":"idle.active \u001b[90m#39\u001b[39m","label":"project","timestamp":"2019-01-04T19:32:50.156Z"}