{"level":"info","message":"logger initialized at level debug","label":"project","timestamp":"2017-12-02T09:37:05.209Z"} {"level":"debug","message":"init db C:\\Users\\Nicolas\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2017-12-02T09:37:09.258Z"} {"level":"verbose","message":"opening db C:\\Users\\Nicolas\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2017-12-02T09:37:09.258Z"} {"level":"verbose","message":"restoring settings@tropy...","label":"project","timestamp":"2017-12-02T09:37:09.278Z"} {"level":"verbose","message":"restoring ui@tropy...","label":"project","timestamp":"2017-12-02T09:37:09.278Z"} {"level":"verbose","message":"settings.restore #1","label":"project","timestamp":"2017-12-02T09:37:09.278Z"} {"level":"verbose","message":"ui.restore #2","label":"project","timestamp":"2017-12-02T09:37:09.278Z"} {"level":"verbose","message":"settings.update #3","label":"project","timestamp":"2017-12-02T09:37:09.304Z"} {"level":"verbose","message":"project ready after 4284.235ms (28.455ms)","label":"project","timestamp":"2017-12-02T09:37:09.328Z"} {"level":"verbose","message":"intl.update #4","label":"project","timestamp":"2017-12-02T09:37:09.366Z"} {"level":"verbose","message":"keymap.update #5","label":"project","timestamp":"2017-12-02T09:37:09.370Z"} {"level":"verbose","message":"project.open #6","label":"project","timestamp":"2017-12-02T09:37:09.370Z"} {"level":"debug","message":"init db D:\\Données\\Herculanum\\GS\\GSE.tpy","label":"project","timestamp":"2017-12-02T09:37:09.380Z"} {"level":"verbose","message":"opening db D:\\Données\\Herculanum\\GS\\GSE.tpy","label":"project","timestamp":"2017-12-02T09:37:09.380Z"} {"query":"\n SELECT count(*) AS count FROM sqlite_master","time":347,"level":"debug","message":"db query took 347ms","label":"project","timestamp":"2017-12-02T09:37:09.758Z"} {"level":"verbose","message":"opening db C:\\Users\\Nicolas\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2017-12-02T09:37:09.774Z"} {"level":"verbose","message":"opening db C:\\Users\\Nicolas\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2017-12-02T09:37:09.775Z"} {"level":"verbose","message":"opening db C:\\Users\\Nicolas\\AppData\\Roaming\\Tropy\\ontology.db","label":"project","timestamp":"2017-12-02T09:37:09.776Z"} {"query":"PRAGMA user_version","time":21,"level":"debug","message":"db query took 21ms","label":"project","timestamp":"2017-12-02T09:37:09.783Z"} {"level":"verbose","message":"opening db D:\\Données\\Herculanum\\GS\\GSE.tpy","label":"project","timestamp":"2017-12-02T09:37:09.786Z"} {"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:37:09.791Z"} {"query":"PRAGMA user_version","time":6,"level":"debug","message":"db query took 6ms","label":"project","timestamp":"2017-12-02T09:37:09.794Z"} {"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":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:37:09.801Z"} {"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:37:09.801Z"} {"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:37:09.802Z"} {"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":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:37:09.802Z"} {"query":"\n SELECT project_id AS id, name FROM project LIMIT 1","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:37:09.803Z"} {"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:37:09.811Z"} {"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:37:09.812Z"} {"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":"2017-12-02T09:37:09.812Z"} {"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:37:09.812Z"} {"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:37:09.812Z"} {"level":"verbose","message":"ontology.load #7","label":"project","timestamp":"2017-12-02T09:37:09.817Z"} {"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":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:37:09.828Z"} {"query":"\n INSERT INTO access (uuid, version, path) VALUES (?, ?, ?)","time":20,"level":"debug","message":"db query took 20ms","label":"project","timestamp":"2017-12-02T09:37:09.846Z"} {"level":"verbose","message":"project.opened #8","label":"project","timestamp":"2017-12-02T09:37:09.850Z"} {"level":"verbose","message":"restoring nav@4c889513-9c0d-4cb6-a870-055b5d7255bf...","label":"project","timestamp":"2017-12-02T09:37:09.859Z"} {"level":"verbose","message":"restoring columns@4c889513-9c0d-4cb6-a870-055b5d7255bf...","label":"project","timestamp":"2017-12-02T09:37:09.860Z"} {"level":"verbose","message":"restoring imports@4c889513-9c0d-4cb6-a870-055b5d7255bf...","label":"project","timestamp":"2017-12-02T09:37:09.860Z"} {"level":"verbose","message":"nav.restore #9","label":"project","timestamp":"2017-12-02T09:37:09.861Z"} {"level":"verbose","message":"columns.restore #10","label":"project","timestamp":"2017-12-02T09:37:09.900Z"} {"level":"verbose","message":"imports.restore #11","label":"project","timestamp":"2017-12-02T09:37:09.903Z"} {"level":"verbose","message":"history.drop #12","label":"project","timestamp":"2017-12-02T09:37:09.912Z"} {"level":"verbose","message":"list.load #13","label":"project","timestamp":"2017-12-02T09:37:09.925Z"} {"level":"verbose","message":"tag.load #14","label":"project","timestamp":"2017-12-02T09:37:09.941Z"} {"level":"verbose","message":"item.load #15","label":"project","timestamp":"2017-12-02T09:37:09.986Z"} {"level":"verbose","message":"opening db D:\\Données\\Herculanum\\GS\\GSE.tpy","label":"project","timestamp":"2017-12-02T09:37:09.992Z"} {"level":"verbose","message":"photo.load #16","label":"project","timestamp":"2017-12-02T09:37:09.993Z"} {"level":"verbose","message":"opening db D:\\Données\\Herculanum\\GS\\GSE.tpy","label":"project","timestamp":"2017-12-02T09:37:09.998Z"} {"level":"verbose","message":"metadata.load #17","label":"project","timestamp":"2017-12-02T09:37:09.999Z"} {"level":"verbose","message":"selection.load #18","label":"project","timestamp":"2017-12-02T09:37:10.007Z"} {"level":"verbose","message":"note.load #19","label":"project","timestamp":"2017-12-02T09:37:10.011Z"} {"level":"verbose","message":"list.load #20(13) Δ110ms","label":"project","timestamp":"2017-12-02T09:37:10.035Z"} {"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:37:10.041Z"} {"level":"verbose","message":"tag.load #21(14) Δ102ms","label":"project","timestamp":"2017-12-02T09:37:10.043Z"} {"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:37:10.052Z"} {"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:37:10.066Z"} {"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:37:10.067Z"} {"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":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:37:10.067Z"} {"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":5,"level":"debug","message":"db query took 5ms","label":"project","timestamp":"2017-12-02T09:37:10.067Z"} {"level":"verbose","message":"item.load #22(15) Δ95ms","label":"project","timestamp":"2017-12-02T09:37:10.081Z"} {"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:37:10.105Z"} {"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:37:10.105Z"} {"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":6,"level":"debug","message":"db query took 6ms","label":"project","timestamp":"2017-12-02T09:37:10.105Z"} {"level":"verbose","message":"photo.load #23(16) Δ113ms","label":"project","timestamp":"2017-12-02T09:37:10.106Z"} {"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:37:10.148Z"} {"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:37:10.148Z"} {"level":"verbose","message":"selection.load #24(18) Δ142ms","label":"project","timestamp":"2017-12-02T09:37:10.149Z"} {"level":"verbose","message":"metadata.load #25(17) Δ167ms","label":"project","timestamp":"2017-12-02T09:37:10.167Z"} {"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:37:10.174Z"} {"level":"verbose","message":"note.load #26(19) Δ195ms","label":"project","timestamp":"2017-12-02T09:37:10.205Z"} {"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":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:37:10.214Z"} {"level":"verbose","message":"*search query took 197ms","label":"project","timestamp":"2017-12-02T09:37:10.215Z"} {"level":"verbose","message":"qr.update #27","label":"project","timestamp":"2017-12-02T09:37:10.216Z"} {"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":4,"level":"debug","message":"db query took 4ms","label":"project","timestamp":"2017-12-02T09:37:10.335Z"} {"level":"verbose","message":"*search query took 73ms","label":"project","timestamp":"2017-12-02T09:37:15.288Z"} {"level":"verbose","message":"qr.update #30","label":"project","timestamp":"2017-12-02T09:37:15.288Z"} {"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 JOIN trash USING (id)\n LEFT OUTER JOIN sort USING (id)\n WHERE\n \n reason = 'user'\n ORDER BY sort.text ASC, id ASC","time":3,"level":"debug","message":"db query took 3ms","label":"project","timestamp":"2017-12-02T09:37:15.460Z"} {"level":"verbose","message":"*search query took 53ms","label":"project","timestamp":"2017-12-02T09:37:17.983Z"} {"level":"verbose","message":"qr.update #32","label":"project","timestamp":"2017-12-02T09:37:17.984Z"} {"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:37:18.114Z"} {"level":"verbose","message":"item.import #33","label":"project","timestamp":"2017-12-02T09:38:15.254Z"} {"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:38:42.344Z"} {"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":18,"level":"debug","message":"db query took 18ms","label":"project","timestamp":"2017-12-02T09:38:49.015Z"} {"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":16,"level":"debug","message":"db query took 16ms","label":"project","timestamp":"2017-12-02T09:38:51.199Z"} {"level":"verbose","message":"item.import #34(33) Δ37s","label":"project","timestamp":"2017-12-02T09:38:52.409Z"} {"level":"verbose","message":"*search query took 4ms","label":"project","timestamp":"2017-12-02T09:38:52.425Z"} {"level":"verbose","message":"qr.update #35","label":"project","timestamp":"2017-12-02T09:38:52.427Z"} {"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:38:52.436Z"} {"level":"verbose","message":"item.import #36","label":"project","timestamp":"2017-12-02T09:39:53.131Z"} {"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":15,"level":"debug","message":"db query took 15ms","label":"project","timestamp":"2017-12-02T09:40:01.888Z"} {"query":"BEGIN IMMEDIATE TRANSACTION","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.889Z"} {"query":"\n INSERT INTO subjects (template) VALUES (?)","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:03.891Z"} {"query":"\n INSERT INTO items (id) VALUES (?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.891Z"} {"query":"\n DELETE FROM metadata WHERE id IN (452) AND property IN (\"http://purl.org/dc/elements/1.1/title\")","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.893Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:03.894Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (452,\"http://purl.org/dc/elements/1.1/title\",406,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.895Z"} {"query":"\n SELECT id AS photo, item_id AS id\n FROM photos\n LEFT OUTER JOIN trash USING (id)\n WHERE item_id IN (452) AND\n deleted IS NULL\n ORDER BY item_id, position","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.895Z"} {"query":"\n SELECT id, list_id AS list\n FROM list_items WHERE id IN (452)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.895Z"} {"query":"\n SELECT id, tag_id AS tag\n FROM taggings WHERE id IN (452)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.896Z"} {"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) WHERE id IN (452)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.896Z"} {"query":"\n INSERT INTO subjects (template) VALUES (?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.898Z"} {"query":"\n INSERT INTO images (id, width, height) VALUES (?,?,?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.902Z"} {"query":"\n INSERT INTO photos (\n id,\n item_id,\n path,\n size,\n checksum,\n mimetype,\n orientation,\n position\n ) VALUES (?,?,?,?,?,?,?,?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.903Z"} {"query":"\n DELETE FROM metadata WHERE id IN (453) AND property IN (\"http://purl.org/dc/elements/1.1/title\",\"http://purl.org/dc/elements/1.1/date\")","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:03.903Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.904Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (453,\"http://purl.org/dc/elements/1.1/title\",406,NULL)","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:03.904Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.905Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (453,\"http://purl.org/dc/elements/1.1/date\",407,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.905Z"} {"query":"\n SELECT id AS selection, photo_id AS id\n FROM selections\n LEFT OUTER JOIN trash USING (id)\n WHERE photo_id IN (453) AND\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:40:03.906Z"} {"query":"\n SELECT id, note_id AS note\n FROM notes\n WHERE id IN (453) AND deleted IS NULL\n ORDER BY id, created","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:03.906Z"} {"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) WHERE id IN (453)","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:03.906Z"} {"query":"COMMIT TRANSACTION","time":22,"level":"debug","message":"db query took 22ms","label":"project","timestamp":"2017-12-02T09:40:04.094Z"} {"level":"verbose","message":"metadata.load #37","label":"project","timestamp":"2017-12-02T09:40:04.318Z"} {"level":"verbose","message":"item.insert #38","label":"project","timestamp":"2017-12-02T09:40:04.351Z"} {"level":"verbose","message":"photo.insert #39","label":"project","timestamp":"2017-12-02T09:40:04.370Z"} {"level":"verbose","message":"activity.update #40(36) Δ11s","label":"project","timestamp":"2017-12-02T09:40:04.407Z"} {"level":"verbose","message":"metadata.load #41(37) Δ106ms","label":"project","timestamp":"2017-12-02T09:40:04.424Z"} {"query":"\n SELECT id, property, text, datatype AS type\n FROM subjects\n JOIN metadata USING (id)\n JOIN metadata_values USING (value_id) WHERE id IN (452,453) ORDER BY id, metadata.created ASC","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:04.431Z"} {"level":"verbose","message":"*search query took 63ms","label":"project","timestamp":"2017-12-02T09:40:04.432Z"} {"level":"verbose","message":"qr.update #42","label":"project","timestamp":"2017-12-02T09:40:04.432Z"} {"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:40:04.437Z"} {"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":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:40:04.995Z"} {"query":"BEGIN IMMEDIATE TRANSACTION","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.258Z"} {"query":"\n INSERT INTO subjects (template) VALUES (?)","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:40:06.260Z"} {"query":"\n INSERT INTO items (id) VALUES (?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.261Z"} {"query":"\n DELETE FROM metadata WHERE id IN (454) AND property IN (\"http://purl.org/dc/elements/1.1/title\")","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.262Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.263Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (454,\"http://purl.org/dc/elements/1.1/title\",408,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.263Z"} {"query":"\n SELECT id AS photo, item_id AS id\n FROM photos\n LEFT OUTER JOIN trash USING (id)\n WHERE item_id IN (454) AND\n deleted IS NULL\n ORDER BY item_id, position","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.264Z"} {"query":"\n SELECT id, tag_id AS tag\n FROM taggings WHERE id IN (454)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.264Z"} {"query":"\n SELECT id, list_id AS list\n FROM list_items WHERE id IN (454)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.266Z"} {"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) WHERE id IN (454)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.271Z"} {"query":"\n INSERT INTO subjects (template) VALUES (?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.274Z"} {"query":"\n INSERT INTO images (id, width, height) VALUES (?,?,?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.275Z"} {"query":"\n INSERT INTO photos (\n id,\n item_id,\n path,\n size,\n checksum,\n mimetype,\n orientation,\n position\n ) VALUES (?,?,?,?,?,?,?,?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.276Z"} {"query":"\n DELETE FROM metadata WHERE id IN (455) AND property IN (\"http://purl.org/dc/elements/1.1/title\",\"http://purl.org/dc/elements/1.1/date\")","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.277Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:06.278Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (455,\"http://purl.org/dc/elements/1.1/title\",408,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.278Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.279Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (455,\"http://purl.org/dc/elements/1.1/date\",409,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.280Z"} {"query":"\n SELECT id, note_id AS note\n FROM notes\n WHERE id IN (455) AND deleted IS NULL\n ORDER BY id, created","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.281Z"} {"query":"\n SELECT id AS selection, photo_id AS id\n FROM selections\n LEFT OUTER JOIN trash USING (id)\n WHERE photo_id IN (455) AND\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:40:06.282Z"} {"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) WHERE id IN (455)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:06.282Z"} {"query":"COMMIT TRANSACTION","time":19,"level":"debug","message":"db query took 19ms","label":"project","timestamp":"2017-12-02T09:40:06.453Z"} {"level":"verbose","message":"metadata.load #43","label":"project","timestamp":"2017-12-02T09:40:06.688Z"} {"level":"verbose","message":"item.insert #44","label":"project","timestamp":"2017-12-02T09:40:06.696Z"} {"level":"verbose","message":"photo.insert #45","label":"project","timestamp":"2017-12-02T09:40:06.702Z"} {"level":"verbose","message":"activity.update #46(36) Δ14s","label":"project","timestamp":"2017-12-02T09:40:06.721Z"} {"level":"verbose","message":"metadata.load #47(43) Δ51ms","label":"project","timestamp":"2017-12-02T09:40:06.739Z"} {"query":"\n SELECT id, property, text, datatype AS type\n FROM subjects\n JOIN metadata USING (id)\n JOIN metadata_values USING (value_id) WHERE id IN (454,455) ORDER BY id, metadata.created ASC","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:40:06.744Z"} {"level":"verbose","message":"*search query took 45ms","label":"project","timestamp":"2017-12-02T09:40:06.746Z"} {"level":"verbose","message":"qr.update #48","label":"project","timestamp":"2017-12-02T09:40:06.746Z"} {"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:40:06.749Z"} {"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":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:07.247Z"} {"query":"BEGIN IMMEDIATE TRANSACTION","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:08.223Z"} {"query":"\n INSERT INTO subjects (template) VALUES (?)","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:40:08.225Z"} {"query":"\n INSERT INTO items (id) VALUES (?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.226Z"} {"query":"\n DELETE FROM metadata WHERE id IN (456) AND property IN (\"http://purl.org/dc/elements/1.1/title\")","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.227Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.228Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (456,\"http://purl.org/dc/elements/1.1/title\",410,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.228Z"} {"query":"\n SELECT id AS photo, item_id AS id\n FROM photos\n LEFT OUTER JOIN trash USING (id)\n WHERE item_id IN (456) AND\n deleted IS NULL\n ORDER BY item_id, position","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.229Z"} {"query":"\n SELECT id, tag_id AS tag\n FROM taggings WHERE id IN (456)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.230Z"} {"query":"\n SELECT id, list_id AS list\n FROM list_items WHERE id IN (456)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.230Z"} {"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) WHERE id IN (456)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.230Z"} {"query":"\n INSERT INTO subjects (template) VALUES (?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.231Z"} {"query":"\n INSERT INTO images (id, width, height) VALUES (?,?,?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.232Z"} {"query":"\n INSERT INTO photos (\n id,\n item_id,\n path,\n size,\n checksum,\n mimetype,\n orientation,\n position\n ) VALUES (?,?,?,?,?,?,?,?)","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:08.233Z"} {"query":"\n DELETE FROM metadata WHERE id IN (457) AND property IN (\"http://purl.org/dc/elements/1.1/title\",\"http://purl.org/dc/elements/1.1/date\")","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.233Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.234Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (457,\"http://purl.org/dc/elements/1.1/title\",410,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.234Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:40:08.238Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (457,\"http://purl.org/dc/elements/1.1/date\",411,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.239Z"} {"query":"\n SELECT id, note_id AS note\n FROM notes\n WHERE id IN (457) AND deleted IS NULL\n ORDER BY id, created","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.243Z"} {"query":"\n SELECT id AS selection, photo_id AS id\n FROM selections\n LEFT OUTER JOIN trash USING (id)\n WHERE photo_id IN (457) AND\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:40:08.243Z"} {"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) WHERE id IN (457)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.244Z"} {"query":"COMMIT TRANSACTION","time":20,"level":"debug","message":"db query took 20ms","label":"project","timestamp":"2017-12-02T09:40:08.415Z"} {"level":"verbose","message":"metadata.load #49","label":"project","timestamp":"2017-12-02T09:40:08.631Z"} {"level":"verbose","message":"item.insert #50","label":"project","timestamp":"2017-12-02T09:40:08.640Z"} {"level":"verbose","message":"photo.insert #51","label":"project","timestamp":"2017-12-02T09:40:08.645Z"} {"level":"verbose","message":"activity.update #52(36) Δ16s","label":"project","timestamp":"2017-12-02T09:40:08.664Z"} {"level":"verbose","message":"item.import #53(36) Δ16s","label":"project","timestamp":"2017-12-02T09:40:08.667Z"} {"level":"verbose","message":"history.tick #54","label":"project","timestamp":"2017-12-02T09:40:08.672Z"} {"level":"verbose","message":"metadata.load #55(49) Δ83ms","label":"project","timestamp":"2017-12-02T09:40:08.714Z"} {"query":"\n SELECT id, property, text, datatype AS type\n FROM subjects\n JOIN metadata USING (id)\n JOIN metadata_values USING (value_id) WHERE id IN (456,457) ORDER BY id, metadata.created ASC","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:40:08.721Z"} {"level":"verbose","message":"*search query took 77ms","label":"project","timestamp":"2017-12-02T09:40:08.723Z"} {"level":"verbose","message":"qr.update #56","label":"project","timestamp":"2017-12-02T09:40:08.723Z"} {"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:40:08.728Z"} {"level":"verbose","message":"*search query took 58ms","label":"project","timestamp":"2017-12-02T09:40:08.729Z"} {"level":"verbose","message":"qr.update #57","label":"project","timestamp":"2017-12-02T09:40:08.729Z"} {"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 (452,454,456) 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:40:08.754Z"} {"level":"verbose","message":"*search query took 15ms","label":"project","timestamp":"2017-12-02T09:40:13.734Z"} {"level":"verbose","message":"qr.update #59","label":"project","timestamp":"2017-12-02T09:40:13.735Z"} {"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 \n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n \n \n 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:40:13.867Z"} {"level":"verbose","message":"edit.start #64","label":"project","timestamp":"2017-12-02T09:40:59.550Z"} {"level":"verbose","message":"metadata.save #65","label":"project","timestamp":"2017-12-02T09:41:06.109Z"} {"level":"verbose","message":"metadata.update #66","label":"project","timestamp":"2017-12-02T09:41:06.111Z"} {"level":"verbose","message":"edit.cancel #67","label":"project","timestamp":"2017-12-02T09:41:06.113Z"} {"query":"BEGIN IMMEDIATE TRANSACTION","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:41:06.189Z"} {"query":"\n DELETE FROM metadata WHERE id IN (449) AND property IN (\"http://purl.org/dc/elements/1.1/title\")","time":3,"level":"debug","message":"db query took 3ms","label":"project","timestamp":"2017-12-02T09:41:06.193Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:41:06.194Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (449,\"http://purl.org/dc/elements/1.1/title\",406,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:41:06.194Z"} {"query":"\n UPDATE subjects\n SET modified = datetime(?)\n WHERE id IN (449)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:41:06.196Z"} {"query":"COMMIT TRANSACTION","time":22,"level":"debug","message":"db query took 22ms","label":"project","timestamp":"2017-12-02T09:41:06.218Z"} {"level":"verbose","message":"metadata.save #68(65) Δ110ms","label":"project","timestamp":"2017-12-02T09:41:06.219Z"} {"level":"verbose","message":"history.tick #69","label":"project","timestamp":"2017-12-02T09:41:06.228Z"} {"level":"verbose","message":"*search query took 5ms","label":"project","timestamp":"2017-12-02T09:41:06.233Z"} {"level":"verbose","message":"qr.update #70","label":"project","timestamp":"2017-12-02T09:41:06.234Z"} {"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 \n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n \n \n deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","time":3,"level":"debug","message":"db query took 3ms","label":"project","timestamp":"2017-12-02T09:41:06.245Z"} {"level":"verbose","message":"edit.start #75","label":"project","timestamp":"2017-12-02T09:41:10.854Z"} {"level":"verbose","message":"metadata.save #76","label":"project","timestamp":"2017-12-02T09:41:13.426Z"} {"level":"verbose","message":"metadata.update #77","label":"project","timestamp":"2017-12-02T09:41:13.427Z"} {"level":"verbose","message":"edit.cancel #78","label":"project","timestamp":"2017-12-02T09:41:13.428Z"} {"query":"BEGIN IMMEDIATE TRANSACTION","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:41:13.477Z"} {"query":"\n DELETE FROM metadata WHERE id IN (450) AND property IN (\"http://purl.org/dc/elements/1.1/title\")","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:41:13.480Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:41:13.481Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (450,\"http://purl.org/dc/elements/1.1/title\",408,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:41:13.481Z"} {"query":"\n UPDATE subjects\n SET modified = datetime(?)\n WHERE id IN (450)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:41:13.483Z"} {"level":"verbose","message":"metadata.save #79(76) Δ72ms","label":"project","timestamp":"2017-12-02T09:41:13.498Z"} {"level":"verbose","message":"history.tick #80","label":"project","timestamp":"2017-12-02T09:41:13.509Z"} {"query":"COMMIT TRANSACTION","time":14,"level":"debug","message":"db query took 14ms","label":"project","timestamp":"2017-12-02T09:41:13.510Z"} {"level":"verbose","message":"*search query took 9ms","label":"project","timestamp":"2017-12-02T09:41:13.517Z"} {"level":"verbose","message":"qr.update #81","label":"project","timestamp":"2017-12-02T09:41:13.518Z"} {"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 \n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n \n \n deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","time":3,"level":"debug","message":"db query took 3ms","label":"project","timestamp":"2017-12-02T09:41:13.541Z"} {"level":"verbose","message":"edit.start #85","label":"project","timestamp":"2017-12-02T09:41:16.094Z"} {"level":"verbose","message":"edit.cancel #86","label":"project","timestamp":"2017-12-02T09:41:17.683Z"} {"level":"verbose","message":"edit.start #89","label":"project","timestamp":"2017-12-02T09:41:20.142Z"} {"level":"verbose","message":"metadata.save #90","label":"project","timestamp":"2017-12-02T09:41:24.992Z"} {"level":"verbose","message":"metadata.update #91","label":"project","timestamp":"2017-12-02T09:41:24.993Z"} {"level":"verbose","message":"edit.cancel #92","label":"project","timestamp":"2017-12-02T09:41:24.994Z"} {"query":"BEGIN IMMEDIATE TRANSACTION","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:41:25.041Z"} {"query":"\n DELETE FROM metadata WHERE id IN (451) AND property IN (\"http://purl.org/dc/elements/1.1/title\")","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:41:25.046Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:41:25.047Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (451,\"http://purl.org/dc/elements/1.1/title\",410,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:41:25.049Z"} {"query":"\n UPDATE subjects\n SET modified = datetime(?)\n WHERE id IN (451)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:41:25.051Z"} {"level":"verbose","message":"metadata.save #93(90) Δ75ms","label":"project","timestamp":"2017-12-02T09:41:25.067Z"} {"level":"verbose","message":"history.tick #94","label":"project","timestamp":"2017-12-02T09:41:25.075Z"} {"query":"COMMIT TRANSACTION","time":14,"level":"debug","message":"db query took 14ms","label":"project","timestamp":"2017-12-02T09:41:25.076Z"} {"level":"verbose","message":"*search query took 9ms","label":"project","timestamp":"2017-12-02T09:41:25.083Z"} {"level":"verbose","message":"qr.update #95","label":"project","timestamp":"2017-12-02T09:41:25.083Z"} {"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 \n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n \n \n 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:41:25.096Z"} {"level":"verbose","message":"edit.start #101","label":"project","timestamp":"2017-12-02T09:42:57.242Z"} {"level":"verbose","message":"edit.cancel #102","label":"project","timestamp":"2017-12-02T09:42:59.379Z"} {"level":"verbose","message":"context.show #107","label":"project","timestamp":"2017-12-02T09:44:22.046Z"} {"level":"verbose","message":"item.merge #108","label":"project","timestamp":"2017-12-02T09:44:25.648Z"} {"query":"BEGIN IMMEDIATE TRANSACTION","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:25.655Z"} {"query":"\n UPDATE photos\n SET item_id = ?, position = CASE id\n WHEN ? THEN 2 WHEN ? THEN 3\n END\n WHERE id IN (455,457)","time":2,"level":"debug","message":"db query took 2ms","label":"project","timestamp":"2017-12-02T09:44:25.659Z"} {"query":"\n INSERT INTO list_items (list_id, id, position, added)\n SELECT list_id, 452 AS id, position, added\n FROM list_items li\n WHERE list_id IN ()\n AND li.id IN (454,456)\n AND deleted IS NULL\n GROUP BY list_id","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:25.659Z"} {"query":"\n DELETE FROM metadata WHERE id IN (452) AND property IN (\"http://purl.org/dc/elements/1.1/title\")","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:25.659Z"} {"query":"\n INSERT INTO trash (id, reason)\n VALUES (454, $reason),(456, $reason)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:25.659Z"} {"query":"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:25.660Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n VALUES (452,\"http://purl.org/dc/elements/1.1/title\",406,NULL)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:25.660Z"} {"level":"verbose","message":"photo.bulk.update #109","label":"project","timestamp":"2017-12-02T09:44:25.677Z"} {"level":"verbose","message":"metadata.insert #110","label":"project","timestamp":"2017-12-02T09:44:25.708Z"} {"level":"verbose","message":"item.merge #112(108) Δ130ms","label":"project","timestamp":"2017-12-02T09:44:25.778Z"} {"level":"verbose","message":"history.tick #113","label":"project","timestamp":"2017-12-02T09:44:25.793Z"} {"query":"COMMIT TRANSACTION","time":15,"level":"debug","message":"db query took 15ms","label":"project","timestamp":"2017-12-02T09:44:25.794Z"} {"level":"verbose","message":"*search query took 54ms","label":"project","timestamp":"2017-12-02T09:44:25.846Z"} {"level":"verbose","message":"qr.update #114","label":"project","timestamp":"2017-12-02T09:44:25.846Z"} {"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 \n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n \n \n deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","time":3,"level":"debug","message":"db query took 3ms","label":"project","timestamp":"2017-12-02T09:44:25.853Z"} {"level":"verbose","message":"context.show #116","label":"project","timestamp":"2017-12-02T09:44:28.807Z"} {"level":"verbose","message":"item.explode #117","label":"project","timestamp":"2017-12-02T09:44:31.772Z"} {"query":"BEGIN IMMEDIATE TRANSACTION","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.783Z"} {"query":"\n INSERT INTO subjects (template)\n SELECT template FROM subjects WHERE id = ?","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:44:31.785Z"} {"query":"\n INSERT INTO items (id) VALUES (?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.786Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n SELECT 458 AS id, property, value_id, language\n FROM metadata\n WHERE id = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.787Z"} {"query":"\n INSERT INTO list_items (list_id, id, position, added)\n SELECT list_id, 458 AS id, position, added\n FROM list_items WHERE id = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.788Z"} {"query":"\n INSERT INTO taggings (tag_id, id)\n SELECT tag_id, 458 AS id\n FROM taggings WHERE id = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.788Z"} {"query":"\n SELECT id, list_id AS list\n FROM list_items WHERE id IN (458)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.789Z"} {"query":"\n SELECT id, tag_id AS tag\n FROM taggings WHERE id IN (458)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.789Z"} {"query":"\n SELECT id AS photo, item_id AS id\n FROM photos\n LEFT OUTER JOIN trash USING (id)\n WHERE item_id IN (458) AND\n deleted IS NULL\n ORDER BY item_id, position","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.790Z"} {"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) WHERE id IN (458)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.791Z"} {"query":"\n UPDATE photos SET item_id = ? WHERE id in (455)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.791Z"} {"query":"\n INSERT INTO subjects (template)\n SELECT template FROM subjects WHERE id = ?","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:44:31.792Z"} {"query":"\n INSERT INTO items (id) VALUES (?)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.792Z"} {"query":"\n INSERT INTO metadata (id, property, value_id, language)\n SELECT 459 AS id, property, value_id, language\n FROM metadata\n WHERE id = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.793Z"} {"query":"\n INSERT INTO taggings (tag_id, id)\n SELECT tag_id, 459 AS id\n FROM taggings WHERE id = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.794Z"} {"query":"\n INSERT INTO list_items (list_id, id, position, added)\n SELECT list_id, 459 AS id, position, added\n FROM list_items WHERE id = ?","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.794Z"} {"query":"\n SELECT id AS photo, item_id AS id\n FROM photos\n LEFT OUTER JOIN trash USING (id)\n WHERE item_id IN (459) AND\n deleted IS NULL\n ORDER BY item_id, position","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.794Z"} {"query":"\n SELECT id, list_id AS list\n FROM list_items WHERE id IN (459)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.794Z"} {"query":"\n SELECT id, tag_id AS tag\n FROM taggings WHERE id IN (459)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.794Z"} {"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) WHERE id IN (459)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.794Z"} {"query":"\n UPDATE photos SET item_id = ? WHERE id in (457)","time":0,"level":"debug","message":"db query took 0ms","label":"project","timestamp":"2017-12-02T09:44:31.799Z"} {"level":"verbose","message":"metadata.load #118","label":"project","timestamp":"2017-12-02T09:44:31.816Z"} {"level":"verbose","message":"photo.bulk.update #119","label":"project","timestamp":"2017-12-02T09:44:31.825Z"} {"level":"verbose","message":"item.explode #120(117) Δ79ms","label":"project","timestamp":"2017-12-02T09:44:31.850Z"} {"level":"verbose","message":"history.tick #121","label":"project","timestamp":"2017-12-02T09:44:31.864Z"} {"query":"COMMIT TRANSACTION","time":16,"level":"debug","message":"db query took 16ms","label":"project","timestamp":"2017-12-02T09:44:31.866Z"} {"level":"verbose","message":"metadata.load #122(118) Δ64ms","label":"project","timestamp":"2017-12-02T09:44:31.880Z"} {"query":"\n SELECT id, property, text, datatype AS type\n FROM subjects\n JOIN metadata USING (id)\n JOIN metadata_values USING (value_id) WHERE id IN (458,459) ORDER BY id, metadata.created ASC","time":1,"level":"debug","message":"db query took 1ms","label":"project","timestamp":"2017-12-02T09:44:31.889Z"} {"level":"verbose","message":"*search query took 25ms","label":"project","timestamp":"2017-12-02T09:44:31.889Z"} {"level":"verbose","message":"qr.update #123","label":"project","timestamp":"2017-12-02T09:44:31.890Z"} {"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 \n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n \n \n deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","time":3,"level":"debug","message":"db query took 3ms","label":"project","timestamp":"2017-12-02T09:44:31.899Z"} {"level":"verbose","message":"item.delete #126","label":"project","timestamp":"2017-12-02T09:44:45.044Z"} {"level":"verbose","message":"item.bulk.update #127","label":"project","timestamp":"2017-12-02T09:44:45.340Z"} {"level":"verbose","message":"item.delete #128(126) Δ308ms","label":"project","timestamp":"2017-12-02T09:44:45.352Z"} {"level":"verbose","message":"history.tick #129","label":"project","timestamp":"2017-12-02T09:44:45.357Z"} {"query":"\n INSERT INTO trash (id, reason)\n VALUES (452, $reason),(458, $reason),(459, $reason)","time":16,"level":"debug","message":"db query took 16ms","label":"project","timestamp":"2017-12-02T09:44:45.361Z"} {"level":"verbose","message":"*search query took 17ms","label":"project","timestamp":"2017-12-02T09:44:45.368Z"} {"level":"verbose","message":"qr.update #130","label":"project","timestamp":"2017-12-02T09:44:45.368Z"} {"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 \n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n \n \n deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","time":3,"level":"debug","message":"db query took 3ms","label":"project","timestamp":"2017-12-02T09:44:45.430Z"}