{"level":"info","message":"logger initialized at level debug","label":"project","timestamp":"2017-12-02T09:12:42.037Z"}
{"level":"debug","message":"init db C:\\Users\\Nicolas\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2017-12-02T09:12:46.108Z"}
{"level":"verbose","message":"opening db C:\\Users\\Nicolas\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2017-12-02T09:12:46.108Z"}
{"level":"verbose","message":"restoring settings@tropy...","label":"project","timestamp":"2017-12-02T09:12:46.118Z"}
{"level":"verbose","message":"restoring ui@tropy...","label":"project","timestamp":"2017-12-02T09:12:46.128Z"}
{"level":"verbose","message":"settings.restore #1","label":"project","timestamp":"2017-12-02T09:12:46.128Z"}
{"level":"verbose","message":"ui.restore #2","label":"project","timestamp":"2017-12-02T09:12:46.128Z"}
{"level":"verbose","message":"settings.update #3","label":"project","timestamp":"2017-12-02T09:12:46.144Z"}
{"level":"verbose","message":"project ready after 4328.91ms (26.085ms)","label":"project","timestamp":"2017-12-02T09:12:46.168Z"}
{"level":"verbose","message":"keymap.update #4","label":"project","timestamp":"2017-12-02T09:12:46.192Z"}
{"level":"verbose","message":"intl.update #5","label":"project","timestamp":"2017-12-02T09:12:46.199Z"}
{"level":"verbose","message":"project.open #6","label":"project","timestamp":"2017-12-02T09:12:46.199Z"}
{"level":"debug","message":"init db D:\\Données\\Herculanum\\GS\\GSE.tpy","label":"project","timestamp":"2017-12-02T09:12:46.199Z"}
{"level":"verbose","message":"opening db D:\\Données\\Herculanum\\GS\\GSE.tpy","label":"project","timestamp":"2017-12-02T09:12:46.209Z"}
{"query":"\n      SELECT count(*) AS count FROM sqlite_master","time":379,"level":"debug","message":"db query took 379ms","label":"project","timestamp":"2017-12-02T09:12:46.623Z"}
{"level":"verbose","message":"opening db C:\\Users\\Nicolas\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2017-12-02T09:12:46.635Z"}
{"level":"verbose","message":"opening db C:\\Users\\Nicolas\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2017-12-02T09:12:46.637Z"}
{"level":"verbose","message":"opening db C:\\Users\\Nicolas\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2017-12-02T09:12:46.638Z"}
{"query":"PRAGMA user_version","time":18,"level":"debug","message":"db query took 18ms","label":"project","timestamp":"2017-12-02T09:12:46.643Z"}
{"level":"verbose","message":"opening db D:\\Données\\Herculanum\\GS\\GSE.tpy","label":"project","timestamp":"2017-12-02T09:12:46.646Z"}
{"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":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:12:46.650Z"}
{"query":"PRAGMA user_version","time":6,"level":"debug","message":"db query took 6ms","label":"project","timestamp":"2017-12-02T09:12:46.653Z"}
{"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":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:12:46.660Z"}
{"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)\n          WHERE (language = ? OR language IS NULL) AND deleted is NULL","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:12:46.663Z"}
{"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)\n          WHERE (language = ? OR language IS NULL) AND deleted is NULL","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:12:46.663Z"}
{"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)\n          WHERE (language = ? OR language IS NULL) AND deleted is NULL","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:12:46.663Z"}
{"query":"\n        SELECT project_id AS id, name FROM project LIMIT 1","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:12:46.663Z"}
{"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":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:12:46.671Z"}
{"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":"2017-12-02T09:12:46.672Z"}
{"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":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:12:46.672Z"}
{"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":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:12:46.672Z"}
{"query":"\n        SELECT COUNT (id) AS total\n          FROM items LEFT OUTER JOIN trash USING (id)\n          WHERE deleted IS NULL","time":3,"level":"debug","message":"db query took 3ms","label":"project","timestamp":"2017-12-02T09:12:46.673Z"}
{"level":"verbose","message":"ontology.load #7","label":"project","timestamp":"2017-12-02T09:12:46.742Z"}
{"query":"\n          SELECT\n              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\n              LEFT OUTER JOIN field_labels USING (field_id)\n            WHERE (language IS NULL OR language = ?)\n            ORDER BY position, field_id","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:12:46.757Z"}
{"query":"\n      INSERT INTO access (uuid, version, path) VALUES (?, ?, ?)","time":17,"level":"debug","message":"db query took 17ms","label":"project","timestamp":"2017-12-02T09:12:46.757Z"}
{"level":"verbose","message":"project.opened #8","label":"project","timestamp":"2017-12-02T09:12:46.760Z"}
{"level":"verbose","message":"restoring nav@4c889513-9c0d-4cb6-a870-055b5d7255bf...","label":"project","timestamp":"2017-12-02T09:12:46.774Z"}
{"level":"verbose","message":"restoring columns@4c889513-9c0d-4cb6-a870-055b5d7255bf...","label":"project","timestamp":"2017-12-02T09:12:46.777Z"}
{"level":"verbose","message":"restoring imports@4c889513-9c0d-4cb6-a870-055b5d7255bf...","label":"project","timestamp":"2017-12-02T09:12:46.777Z"}
{"level":"verbose","message":"nav.restore #9","label":"project","timestamp":"2017-12-02T09:12:46.778Z"}
{"level":"verbose","message":"columns.restore #10","label":"project","timestamp":"2017-12-02T09:12:46.832Z"}
{"level":"verbose","message":"imports.restore #11","label":"project","timestamp":"2017-12-02T09:12:46.838Z"}
{"level":"verbose","message":"history.drop #12","label":"project","timestamp":"2017-12-02T09:12:46.850Z"}
{"level":"verbose","message":"list.load #13","label":"project","timestamp":"2017-12-02T09:12:46.854Z"}
{"level":"verbose","message":"tag.load #14","label":"project","timestamp":"2017-12-02T09:12:46.885Z"}
{"level":"verbose","message":"item.load #15","label":"project","timestamp":"2017-12-02T09:12:46.896Z"}
{"level":"verbose","message":"opening db D:\\Données\\Herculanum\\GS\\GSE.tpy","label":"project","timestamp":"2017-12-02T09:12:46.918Z"}
{"level":"verbose","message":"photo.load #16","label":"project","timestamp":"2017-12-02T09:12:46.919Z"}
{"level":"verbose","message":"opening db D:\\Données\\Herculanum\\GS\\GSE.tpy","label":"project","timestamp":"2017-12-02T09:12:46.926Z"}
{"level":"verbose","message":"metadata.load #17","label":"project","timestamp":"2017-12-02T09:12:46.927Z"}
{"level":"verbose","message":"selection.load #18","label":"project","timestamp":"2017-12-02T09:12:46.933Z"}
{"level":"verbose","message":"note.load #19","label":"project","timestamp":"2017-12-02T09:12:46.937Z"}
{"level":"verbose","message":"list.load #20(13) Δ104ms","label":"project","timestamp":"2017-12-02T09:12:46.958Z"}
{"query":"\n      SELECT l1.list_id AS id, l1.name, l1.parent_list_id AS parent,\n        group_concat(l2.position || ':' || l2.list_id) AS children\n      FROM lists l1 LEFT OUTER JOIN lists l2 ON l2.parent_list_id = l1.list_id\n      GROUP BY l1.list_id","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:12:46.962Z"}
{"level":"verbose","message":"tag.load #21(14) Δ78ms","label":"project","timestamp":"2017-12-02T09:12:46.964Z"}
{"query":"\n      SELECT tag_id AS id, name, color, created, modified\n        FROM tags","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:12:46.973Z"}
{"query":"\n        SELECT id, tag_id AS tag\n          FROM taggings","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:12:46.991Z"}
{"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":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:12:46.991Z"}
{"query":"\n        SELECT id, list_id AS list\n          FROM list_items","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:12:46.992Z"}
{"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":10,"level":"debug","message":"db query took 10ms","label":"project","timestamp":"2017-12-02T09:12:46.992Z"}
{"level":"verbose","message":"metadata.load #22(17) Δ79ms","label":"project","timestamp":"2017-12-02T09:12:47.006Z"}
{"level":"verbose","message":"item.load #23(15) Δ120ms","label":"project","timestamp":"2017-12-02T09:12:47.017Z"}
{"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":"2017-12-02T09:12:47.040Z"}
{"query":"\n        SELECT id, note_id AS note\n          FROM notes\n          WHERE  deleted IS NULL\n          ORDER BY id, created","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:12:47.040Z"}
{"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            width,\n            height,\n            path,\n            size,\n            protocol,\n            mimetype,\n            checksum,\n            orientation\n          FROM subjects\n            JOIN images USING (id)\n            JOIN photos USING (id)","time":5,"level":"debug","message":"db query took 5ms","label":"project","timestamp":"2017-12-02T09:12:47.040Z"}
{"level":"verbose","message":"photo.load #24(16) Δ121ms","label":"project","timestamp":"2017-12-02T09:12:47.040Z"}
{"query":"\n          SELECT\n              id,\n              photo_id AS photo,\n              x,\n              y,\n              width,\n              height,\n              angle,\n              mirror,\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":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:12:47.081Z"}
{"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":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:12:47.081Z"}
{"level":"verbose","message":"selection.load #25(18) Δ151ms","label":"project","timestamp":"2017-12-02T09:12:47.084Z"}
{"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":7,"level":"debug","message":"db query took 7ms","label":"project","timestamp":"2017-12-02T09:12:47.094Z"}
{"level":"verbose","message":"note.load #26(19) Δ188ms","label":"project","timestamp":"2017-12-02T09:12:47.125Z"}
{"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":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:12:47.135Z"}
{"level":"verbose","message":"*search query took 193ms","label":"project","timestamp":"2017-12-02T09:12:47.136Z"}
{"level":"verbose","message":"qr.update #27","label":"project","timestamp":"2017-12-02T09:12:47.136Z"}
{"query":"\n      WITH \n  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\n          FROM items\n            LEFT OUTER JOIN sort USING (id)\n            LEFT OUTER JOIN trash USING (id)\n          WHERE\n            id IN (365,367,369,371,373,375,377,379,381,383,385,387,389,391,393,395,397,399,401,403,405,407,409,411,413,415,417,419,421,423,425,427,429,431,433,435,437,439,441,443,445,447) AND deleted IS NULL\n            \n          ORDER BY sort.text ASC, id ASC","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:12:47.251Z"}
{"level":"verbose","message":"item.import #29","label":"project","timestamp":"2017-12-02T09:14:18.449Z"}
{"level":"verbose","message":"item.import #30","label":"project","timestamp":"2017-12-02T09:14:59.894Z"}
{"query":"\n      SELECT p.id, item_id AS item\n        FROM photos p\n          LEFT OUTER JOIN trash tp USING (id)\n          LEFT OUTER JOIN trash ti ON (ti.id = item_id)\n        WHERE checksum = ?\n          AND tp.deleted IS NULL\n          AND ti.deleted IS NULL","time":21,"level":"debug","message":"db query took 21ms","label":"project","timestamp":"2017-12-02T09:15:00.698Z"}
{"query":"\n      SELECT p.id, item_id AS item\n        FROM photos p\n          LEFT OUTER JOIN trash tp USING (id)\n          LEFT OUTER JOIN trash ti ON (ti.id = item_id)\n        WHERE checksum = ?\n          AND tp.deleted IS NULL\n          AND ti.deleted IS NULL","time":19,"level":"debug","message":"db query took 19ms","label":"project","timestamp":"2017-12-02T09:15:09.037Z"}
{"query":"\n      SELECT p.id, item_id AS item\n        FROM photos p\n          LEFT OUTER JOIN trash tp USING (id)\n          LEFT OUTER JOIN trash ti ON (ti.id = item_id)\n        WHERE checksum = ?\n          AND tp.deleted IS NULL\n          AND ti.deleted IS NULL","time":13,"level":"debug","message":"db query took 13ms","label":"project","timestamp":"2017-12-02T09:15:10.821Z"}
{"level":"verbose","message":"item.import #31(30) Δ12s","label":"project","timestamp":"2017-12-02T09:15:11.934Z"}
{"level":"verbose","message":"*search query took 17ms","label":"project","timestamp":"2017-12-02T09:15:11.955Z"}
{"level":"verbose","message":"qr.update #32","label":"project","timestamp":"2017-12-02T09:15:11.956Z"}
{"query":"\n      WITH \n  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\n          FROM items\n            LEFT OUTER JOIN sort USING (id)\n            LEFT OUTER JOIN trash USING (id)\n          WHERE\n            id IN (365,367,369,371,373,375,377,379,381,383,385,387,389,391,393,395,397,399,401,403,405,407,409,411,413,415,417,419,421,423,425,427,429,431,433,435,437,439,441,443,445,447) AND deleted IS NULL\n            \n          ORDER BY sort.text ASC, id ASC","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:15:11.964Z"}
{"level":"verbose","message":"item.import #33(29) Δ57s","label":"project","timestamp":"2017-12-02T09:15:15.530Z"}
{"level":"verbose","message":"*search query took 3ms","label":"project","timestamp":"2017-12-02T09:15:15.539Z"}
{"level":"verbose","message":"qr.update #34","label":"project","timestamp":"2017-12-02T09:15:15.539Z"}
{"query":"\n      WITH \n  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\n          FROM items\n            LEFT OUTER JOIN sort USING (id)\n            LEFT OUTER JOIN trash USING (id)\n          WHERE\n            id IN (365,367,369,371,373,375,377,379,381,383,385,387,389,391,393,395,397,399,401,403,405,407,409,411,413,415,417,419,421,423,425,427,429,431,433,435,437,439,441,443,445,447) AND deleted IS NULL\n            \n          ORDER BY sort.text ASC, id ASC","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:15:15.543Z"}