{"level":30,"time":1582126399546,"type":"browser","name":"main","opts":{"_":[],"environment":"production","env":"production","auto-updates":true,"ignore-gpu-blacklist":false,"debug":false,"trace":false,"port":null,"p":null,"$0":"Applications/Tropy.app/Contents/MacOS/Tropy","data":"/Users/emd40p/Library/Application Support/Tropy","cache":"/Users/emd40p/Library/Caches/Tropy","logs":"/Users/emd40p/Library/Logs/Tropy"},"version":"1.6.0","msg":"main.init 1.6.0 Darwin 18.7.0 (x64)","v":1} {"level":30,"time":1582126399755,"type":"browser","name":"main","msg":"plugins scanned: 0","v":1} {"level":30,"time":1582126399757,"type":"browser","name":"main","msg":"app state restored","v":1} {"level":30,"time":1582126399758,"type":"browser","name":"main","file":"/Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","msg":"open new project window","v":1} {"level":30,"time":1582126399801,"type":"browser","name":"main","msg":"ready after 284ms [req:59ms]","v":1} {"level":30,"time":1582126399860,"type":"browser","name":"main","msg":"checking for updates...","v":1} {"level":50,"time":1582126399860,"type":"browser","name":"main","stack":"Error: La connexion Internet semble interrompue.","msg":"failed to fetch update: La connexion Internet semble interrompue.","v":1} {"level":30,"time":1582126400085,"type":"renderer","name":"project","dpx":2,"opts":{"dark":false,"environment":"production","documents":"/Users/emd40p/Documents","maximizable":true,"minimizable":true,"pictures":"/Users/emd40p/Pictures","scrollbars":true,"theme":"light","file":"/Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","recent":["/Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","/Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/Banks and Poland.tpy","/Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/Group of Thirty REBASED.tpy"],"data":"/Users/emd40p/Library/Application Support/Tropy","debug":false,"dev":false,"cache":"/Users/emd40p/Library/Caches/Tropy","plugins":"/Users/emd40p/Library/Application Support/Tropy/plugins","frameless":true,"level":"info","locale":"en","log":"/Users/emd40p/Library/Logs/Tropy/tropy.log","uuid":"2a495400-f170-11e8-a920-ff4bf4355ac8","update":{},"version":"1.6.0","webgl":true,"zoom":1},"msg":"project.init","v":1} {"level":30,"time":1582126400124,"type":"renderer","name":"project","msg":"plugins scanned: 0","v":1} {"level":30,"time":1582126400124,"type":"renderer","name":"project","msg":"plugins loaded: 0","v":1} {"level":30,"time":1582126401256,"type":"renderer","name":"project","msg":"open db /Users/emd40p/Library/Application Support/Tropy/ontology.db","v":1} {"level":30,"time":1582126401259,"type":"renderer","name":"project","msg":"restoring recent@tropy","v":1} {"level":30,"time":1582126401333,"type":"renderer","name":"project","msg":"restoring settings@tropy","v":1} {"level":30,"time":1582126401333,"type":"renderer","name":"project","msg":"restoring ui@tropy","v":1} {"level":30,"time":1582126401348,"type":"renderer","name":"project","msg":"project ready 1294ms [dom:65ms win:23ms req:1194ms]","v":1} {"level":30,"time":1582126401380,"type":"renderer","name":"project","msg":"open db /Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","v":1} {"level":30,"time":1582126401533,"type":"renderer","name":"project","msg":"esper using webgl renderer","v":1} {"level":30,"time":1582126401609,"type":"renderer","name":"project","msg":"open db /Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","v":1} {"level":40,"time":1582126403094,"type":"renderer","name":"project","query":"PRAGMA integrity_check(10)","ms":1467,"msg":"SLOW: db query took 1467ms","v":1} {"level":40,"time":1582126403421,"type":"renderer","name":"project","query":"PRAGMA foreign_key_check","ms":326,"msg":"SLOW: db query took 326ms","v":1} {"level":30,"time":1582126403426,"type":"renderer","name":"project","msg":"restoring nav@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126403426,"type":"renderer","name":"project","msg":"restoring notepad@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126403426,"type":"renderer","name":"project","msg":"restoring esper@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126403448,"type":"renderer","name":"project","msg":"restoring imports@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126403448,"type":"renderer","name":"project","msg":"restoring sidebar@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126403448,"type":"renderer","name":"project","msg":"restoring panel@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126403565,"type":"renderer","name":"project","msg":"open db /Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","v":1} {"level":40,"time":1582126415415,"type":"renderer","name":"project","msg":"SLOW: photo.load","v":1} {"level":40,"time":1582126420166,"type":"renderer","name":"project","msg":"SLOW: metadata.load","v":1} {"level":40,"time":1582126420278,"type":"renderer","name":"project","query":"\n SELECT id, tag_id AS tag\n FROM taggings","ms":955,"msg":"SLOW: db query took 955ms","v":1} {"level":40,"time":1582126420278,"type":"renderer","name":"project","query":"\n SELECT\n id,\n template,\n datetime(created, \"localtime\") AS created,\n datetime(modified, \"localtime\") AS modified,\n deleted\n FROM subjects\n JOIN items USING (id)\n LEFT OUTER JOIN trash USING (id)","ms":1134,"msg":"SLOW: db query took 1134ms","v":1} {"level":40,"time":1582126420278,"type":"renderer","name":"project","query":"\n SELECT id AS photo, item_id AS id\n FROM photos\n LEFT OUTER JOIN trash USING (id)\n WHERE \n deleted IS NULL\n ORDER BY item_id, position","ms":1285,"msg":"SLOW: db query took 1285ms","v":1} {"level":40,"time":1582126420278,"type":"renderer","name":"project","query":"\n SELECT id, property, text, datatype AS type\n FROM subjects\n JOIN metadata USING (id)\n JOIN metadata_values USING (value_id) ORDER BY id, metadata.created ASC","ms":2726,"msg":"SLOW: db query took 2726ms","v":1} {"level":40,"time":1582126420278,"type":"renderer","name":"project","query":"\n SELECT\n id,\n item_id AS item,\n template,\n datetime(created, \"localtime\") AS created,\n datetime(modified, \"localtime\") AS modified,\n angle,\n color,\n density,\n mirror,\n negative,\n brightness,\n contrast,\n hue,\n saturation,\n sharpen,\n width,\n height,\n path,\n page,\n size,\n protocol,\n mimetype,\n checksum,\n orientation\n FROM subjects\n JOIN images USING (id)\n JOIN photos USING (id)","ms":4234,"msg":"SLOW: db query took 4234ms","v":1} {"level":40,"time":1582126421008,"type":"renderer","name":"project","msg":"SLOW: item.load","v":1} {"level":30,"time":1582126421259,"type":"renderer","name":"project","msg":"db query took 100ms","query":"\n SELECT\n id,\n photo_id AS photo,\n x,\n y,\n width,\n height,\n angle,\n mirror,\n negative,\n brightness,\n contrast,\n hue,\n saturation,\n sharpen,\n template,\n datetime(created, \"localtime\") AS created,\n datetime(modified, \"localtime\") AS modified\n FROM subjects\n JOIN images USING (id)\n JOIN selections USING (id)","ms":100,"v":1} {"level":40,"time":1582126421279,"type":"renderer","name":"project","msg":"SLOW: selection.load","v":1} {"level":40,"time":1582126421318,"type":"renderer","name":"project","msg":"SLOW: note.load","v":1} {"level":40,"time":1582126421369,"type":"renderer","name":"project","ms":17795,"list":false,"query":"","tags":false,"trash":null,"msg":"SLOW: *search query \"\" took 17795ms","v":1} {"level":30,"time":1582126421469,"type":"renderer","name":"project","msg":"db query took 89ms","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\n FROM items\n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n id IN (367482,367484,367486,367488,367490,367492,367494,367496,367498,367500,367502,367504,367506,367508,367510,367512,367514,367516,367518,367520,367522,367524,367526,367528,367530,367532,367534,367536,367538,367540,367542,367544,367546,367548,367550,367552,367554,367556,367558,367560,367562,367564,367566,367568,367570,367572,367574,367576,367578,367580,367582,367584,367586,367588,367590,367592,367594,367596,367598,367600,367602,367604,367606,367608,367610,367612,367614,367616,367618,367620,367622,367624,367626,367628,367630,367632,367634,367636,367638,367640,367642,367644,367646,367648,367650,367652,367654,367656,367658,367660,367662,367664,367666,367668,367670,367672,367674,367676,367678,367680,367682,367684,367686,367688,367690,367692,367694,367696,367698,367700,367702,367704,367706,367708,367710,367712,367714,367716,367718,367720,367722,367724,367726,367728,367730,367732,367734,367736,367738,367740,367742,367744,367746,367748,367750,367752,367754,367756,367758,367760,367762,367764,367766,367768,367770,367772,367774,367776,367778,367780,367782,367784,367786,367788,367790,367792,367794,367796,367798,367800,367802,367804,367806,367808,367810,367812,367814,367816,367818,367820,367822,367824,367826,367828,367830,367832,367834,367836,367838,367840,367842,367844,367846,367848,367850,367852,367854,367856,367858,367860,367862,367864,367866,367868,367870,367872,367874,367876,367878,367880,367882,367884,367886,367888,367890,367892,367894,367896,367898,367900,367902,367904,367906,367908,367910,367912,367914,367916,367918,367920,367922,367924,367926,367928,367930,367932,367934,367936,367938,367940,367942,367944,367946,367948,367950,367952,367954,367956,367958,367960,367962,367964,367966,367968,367970,367972,367974,367976,367978,367980,367982,367984,367986,367988,367990,367992,367994,367996,367998,368000,368002,368004,368006,368008,368010,368012,368014,368016,368018,368020,368022,368024,368026,368028,368030,368032,368034,368036,368038,368040,368042,368044,368046,368048,368050,368052,368054,368056,368058,368060,368062,368064,368066,368068,368070,368072,368074,368076,368078,368080,368082,368084,368086,368088,368090,368092,368094,368096,368098,368100,368102,368104,368106,368108,368110,368112,368114,368116,368118,368120,368122,368124,368126,368128,368130,368132,368134,368136,368138,368140,368142,368144,368146,368148,368150,368152,368154,368156,368158,368160,368162,368164,368166,368168,368170,368172,368174,368176,368178,368180,368182,368184,368186,368188,368190,368192,368194,368196,368198,368200,368202,368204,368206,368208,368210,368212,368214,368216,368218,368220,368222,368224,368226,368228,368230,368232,368234,368236,368238,368240,368242,368244,368246,368248,368250,368252,368254,368256,368258,368260,368262,368264,368266,368268,368270,368272,368274,368276,368278,368280,368282,368284,368286,368288,368290,368292,368294,368296,368298,368300,368302,368304,368306,368308,368310,368312,368314,368316,368318,368320,368322,368324,368326,368328,368330,368332,368334,368336,368338,368340,368342,368344,368346,368348,368350,368352,368354,368356,368358,368360,368362,368364,368366,368368,368370,368372,368374,368376,368378,368380,368382,368384,368386,368388,368390,368392,368394,368396,368398,368400,368402,368404,368406,368408,368410,368412,368414,368416,368418,368420,368422,368424,368426,368428,368430,368432,368434,368436,368438,368440,368442,368444,368446,368448,368450,368452,368454,368456,368458,368460,368462,368464,368466,368468,368470,368472,368474,368476,368478,368480,368482,368484,368486,368488,368490,368492,368494,368496,368498,368500,368502,368504,368506,368508,368510,368512,368514,368516,368518,368520,368522,368524,368526,368528,368530,368532,368534,368536,368538,368540,368542,368544,368546,368548,368550,368552,368554,368556,368558,368560,368562,368564,368566,368568,368570,368572,368574,368576,368578,368580,368582,368584,368586,368588,368590,368592,368594,368596,368598,368600,368602,368604,368606) AND deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","ms":89,"v":1} {"level":30,"time":1582126526316,"type":"renderer","name":"project","msg":"db query took 62ms","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\n FROM items\n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n id IN (367482,367484,367486,367488,367490,367492,367494,367496,367498,367500,367502,367504,367506,367508,367510,367512,367514,367516,367518,367520,367522,367524,367526,367528,367530,367532,367534,367536,367538,367540,367542,367544,367546,367548,367550,367552,367554,367556,367558,367560,367562,367564,367566,367568,367570,367572,367574,367576,367578,367580,367582,367584,367586,367588,367590,367592,367594,367596,367598,367600,367602,367604,367606,367608,367610,367612,367614,367616,367618,367620,367622,367624,367626,367628,367630,367632,367634,367636,367638,367640,367642,367644,367646,367648,367650,367652,367654,367656,367658,367660,367662,367664,367666,367668,367670,367672,367674,367676,367678,367680,367682,367684,367686,367688,367690,367692,367694,367696,367698,367700,367702,367704,367706,367708,367710,367712,367714,367716,367718,367720,367722,367724,367726,367728,367730,367732,367734,367736,367738,367740,367742,367744,367746,367748,367750,367752,367754,367756,367758,367760,367762,367764,367766,367768,367770,367772,367774,367776,367778,367780,367782,367784,367786,367788,367790,367792,367794,367796,367798,367800,367802,367804,367806,367808,367810,367812,367814,367816,367818,367820,367822,367824,367826,367828,367830,367832,367834,367836,367838,367840,367842,367844,367846,367848,367850,367852,367854,367856,367858,367860,367862,367864,367866,367868,367870,367872,367874,367876,367878,367880,367882,367884,367886,367888,367890,367892,367894,367896,367898,367900,367902,367904,367906,367908,367910,367912,367914,367916,367918,367920,367922,367924,367926,367928,367930,367932,367934,367936,367938,367940,367942,367944,367946,367948,367950,367952,367954,367956,367958,367960,367962,367964,367966,367968,367970,367972,367974,367976,367978,367980,367982,367984,367986,367988,367990,367992,367994,367996,367998,368000,368002,368004,368006,368008,368010,368012,368014,368016,368018,368020,368022,368024,368026,368028,368030,368032,368034,368036,368038,368040,368042,368044,368046,368048,368050,368052,368054,368056,368058,368060,368062,368064,368066,368068,368070,368072,368074,368076,368078,368080,368082,368084,368086,368088,368090,368092,368094,368096,368098,368100,368102,368104,368106,368108,368110,368112,368114,368116,368118,368120,368122,368124,368126,368128,368130,368132,368134,368136,368138,368140,368142,368144,368146,368148,368150,368152,368154,368156,368158,368160,368162,368164,368166,368168,368170,368172,368174,368176,368178,368180,368182,368184,368186,368188,368190,368192,368194,368196,368198,368200,368202,368204,368206,368208,368210,368212,368214,368216,368218,368220,368222,368224,368226,368228,368230,368232,368234,368236,368238,368240,368242,368244,368246,368248,368250,368252,368254,368256,368258,368260,368262,368264,368266,368268,368270,368272,368274,368276,368278,368280,368282,368284,368286,368288,368290,368292,368294,368296,368298,368300,368302,368304,368306,368308,368310,368312,368314,368316,368318,368320,368322,368324,368326,368328,368330,368332,368334,368336,368338,368340,368342,368344,368346,368348,368350,368352,368354,368356,368358,368360,368362,368364,368366,368368,368370,368372,368374,368376,368378,368380,368382,368384,368386,368388,368390,368392,368394,368396,368398,368400,368402,368404,368406,368408,368410,368412,368414,368416,368418,368420,368422,368424,368426,368428,368430,368432,368434,368436,368438,368440,368442,368444,368446,368448,368450,368452,368454,368456,368458,368460,368462,368464,368466,368468,368470,368472,368474,368476,368478,368480,368482,368484,368486,368488,368490,368492,368494,368496,368498,368500,368502,368504,368506,368508,368510,368512,368514,368516,368518,368520,368522,368524,368526,368528,368530,368532,368534,368536,368538,368540,368542,368544,368546,368548,368550,368552,368554,368556,368558,368560,368562,368564,368566,368568,368570,368572,368574,368576,368578,368580,368582,368584,368586,368588,368590,368592,368594,368596,368598,368600,368602,368604,368606) AND deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","ms":62,"v":1} {"level":30,"time":1582126528606,"type":"renderer","name":"project","msg":"db query took 58ms","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\n FROM items\n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n id IN (367482,367484,367486,367488,367490,367492,367494,367496,367498,367500,367502,367504,367506,367508,367510,367512,367514,367516,367518,367520,367522,367524,367526,367528,367530,367532,367534,367536,367538,367540,367542,367544,367546,367548,367550,367552,367554,367556,367558,367560,367562,367564,367566,367568,367570,367572,367574,367576,367578,367580,367582,367584,367586,367588,367590,367592,367594,367596,367598,367600,367602,367604,367606,367608,367610,367612,367614,367616,367618,367620,367622,367624,367626,367628,367630,367632,367634,367636,367638,367640,367642,367644,367646,367648,367650,367652,367654,367656,367658,367660,367662,367664,367666,367668,367670,367672,367674,367676,367678,367680,367682,367684,367686,367688,367690,367692,367694,367696,367698,367700,367702,367704,367706,367708,367710,367712,367714,367716,367718,367720,367722,367724,367726,367728,367730,367732,367734,367736,367738,367740,367742,367744,367746,367748,367750,367752,367754,367756,367758,367760,367762,367764,367766,367768,367770,367772,367774,367776,367778,367780,367782,367784,367786,367788,367790,367792,367794,367796,367798,367800,367802,367804,367806,367808,367810,367812,367814,367816,367818,367820,367822,367824,367826,367828,367830,367832,367834,367836,367838,367840,367842,367844,367846,367848,367850,367852,367854,367856,367858,367860,367862,367864,367866,367868,367870,367872,367874,367876,367878,367880,367882,367884,367886,367888,367890,367892,367894,367896,367898,367900,367902,367904,367906,367908,367910,367912,367914,367916,367918,367920,367922,367924,367926,367928,367930,367932,367934,367936,367938,367940,367942,367944,367946,367948,367950,367952,367954,367956,367958,367960,367962,367964,367966,367968,367970,367972,367974,367976,367978,367980,367982,367984,367986,367988,367990,367992,367994,367996,367998,368000,368002,368004,368006,368008,368010,368012,368014,368016,368018,368020,368022,368024,368026,368028,368030,368032,368034,368036,368038,368040,368042,368044,368046,368048,368050,368052,368054,368056,368058,368060,368062,368064,368066,368068,368070,368072,368074,368076,368078,368080,368082,368084,368086,368088,368090,368092,368094,368096,368098,368100,368102,368104,368106,368108,368110,368112,368114,368116,368118,368120,368122,368124,368126,368128,368130,368132,368134,368136,368138,368140,368142,368144,368146,368148,368150,368152,368154,368156,368158,368160,368162,368164,368166,368168,368170,368172,368174,368176,368178,368180,368182,368184,368186,368188,368190,368192,368194,368196,368198,368200,368202,368204,368206,368208,368210,368212,368214,368216,368218,368220,368222,368224,368226,368228,368230,368232,368234,368236,368238,368240,368242,368244,368246,368248,368250,368252,368254,368256,368258,368260,368262,368264,368266,368268,368270,368272,368274,368276,368278,368280,368282,368284,368286,368288,368290,368292,368294,368296,368298,368300,368302,368304,368306,368308,368310,368312,368314,368316,368318,368320,368322,368324,368326,368328,368330,368332,368334,368336,368338,368340,368342,368344,368346,368348,368350,368352,368354,368356,368358,368360,368362,368364,368366,368368,368370,368372,368374,368376,368378,368380,368382,368384,368386,368388,368390,368392,368394,368396,368398,368400,368402,368404,368406,368408,368410,368412,368414,368416,368418,368420,368422,368424,368426,368428,368430,368432,368434,368436,368438,368440,368442,368444,368446,368448,368450,368452,368454,368456,368458,368460,368462,368464,368466,368468,368470,368472,368474,368476,368478,368480,368482,368484,368486,368488,368490,368492,368494,368496,368498,368500,368502,368504,368506,368508,368510,368512,368514,368516,368518,368520,368522,368524,368526,368528,368530,368532,368534,368536,368538,368540,368542,368544,368546,368548,368550,368552,368554,368556,368558,368560,368562,368564,368566,368568,368570,368572,368574,368576,368578,368580,368582,368584,368586,368588,368590,368592,368594,368596,368598,368600,368602,368604,368606) AND deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","ms":58,"v":1} {"level":30,"time":1582126631684,"type":"renderer","name":"project","msg":"persisting nav@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126631686,"type":"renderer","name":"project","msg":"persisting notepad@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126631686,"type":"renderer","name":"project","msg":"persisting esper@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126631752,"type":"renderer","name":"project","msg":"persisting imports@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126631752,"type":"renderer","name":"project","msg":"persisting sidebar@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126631752,"type":"renderer","name":"project","msg":"persisting panel@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":40,"time":1582126632087,"type":"renderer","name":"project","query":"\n DELETE\n FROM metadata_values\n WHERE value_id IN (\n SELECT v.value_id\n FROM metadata_values v\n LEFT OUTER JOIN metadata m\n USING (value_id)\n WHERE m.value_id IS NULL\n )","ms":265,"msg":"SLOW: db query took 265ms","v":1} {"level":30,"time":1582126632221,"type":"renderer","name":"project","msg":"persisting recent@tropy","v":1} {"level":30,"time":1582126632222,"type":"renderer","name":"project","msg":"persisting settings@tropy","v":1} {"level":30,"time":1582126632222,"type":"renderer","name":"project","msg":"persisting ui@tropy","v":1} {"level":30,"time":1582126632410,"type":"renderer","name":"project","dpx":2,"opts":{"dark":false,"environment":"production","documents":"/Users/emd40p/Documents","maximizable":true,"minimizable":true,"pictures":"/Users/emd40p/Pictures","scrollbars":true,"theme":"light","file":"/Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","recent":["/Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","/Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/Banks and Poland.tpy","/Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/Group of Thirty REBASED.tpy"],"data":"/Users/emd40p/Library/Application Support/Tropy","debug":false,"dev":false,"cache":"/Users/emd40p/Library/Caches/Tropy","plugins":"/Users/emd40p/Library/Application Support/Tropy/plugins","frameless":true,"level":"info","locale":"en","log":"/Users/emd40p/Library/Logs/Tropy/tropy.log","uuid":"2a495400-f170-11e8-a920-ff4bf4355ac8","update":{},"version":"1.6.0","webgl":true,"zoom":1},"msg":"project.init","v":1} {"level":30,"time":1582126632478,"type":"renderer","name":"project","msg":"plugins scanned: 0","v":1} {"level":30,"time":1582126632478,"type":"renderer","name":"project","msg":"plugins loaded: 0","v":1} {"level":30,"time":1582126633556,"type":"renderer","name":"project","msg":"open db /Users/emd40p/Library/Application Support/Tropy/ontology.db","v":1} {"level":30,"time":1582126633561,"type":"renderer","name":"project","msg":"restoring recent@tropy","v":1} {"level":30,"time":1582126633571,"type":"renderer","name":"project","msg":"restoring settings@tropy","v":1} {"level":30,"time":1582126633572,"type":"renderer","name":"project","msg":"restoring ui@tropy","v":1} {"level":30,"time":1582126633579,"type":"renderer","name":"project","msg":"project ready 1200ms [dom:88ms win:30ms req:1077ms]","v":1} {"level":30,"time":1582126633600,"type":"renderer","name":"project","msg":"open db /Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","v":1} {"level":30,"time":1582126633741,"type":"renderer","name":"project","msg":"esper using webgl renderer","v":1} {"level":40,"time":1582126633751,"type":"renderer","name":"project","query":"\n SELECT count(*) AS count FROM sqlite_master","ms":172,"msg":"SLOW: db query took 172ms","v":1} {"level":30,"time":1582126633831,"type":"renderer","name":"project","msg":"open db /Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","v":1} {"level":40,"time":1582126635318,"type":"renderer","name":"project","query":"PRAGMA integrity_check(10)","ms":1475,"msg":"SLOW: db query took 1475ms","v":1} {"level":40,"time":1582126635638,"type":"renderer","name":"project","query":"PRAGMA foreign_key_check","ms":319,"msg":"SLOW: db query took 319ms","v":1} {"level":30,"time":1582126635642,"type":"renderer","name":"project","msg":"restoring nav@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126635643,"type":"renderer","name":"project","msg":"restoring notepad@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126635643,"type":"renderer","name":"project","msg":"restoring esper@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126635671,"type":"renderer","name":"project","msg":"restoring imports@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126635672,"type":"renderer","name":"project","msg":"restoring sidebar@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126635672,"type":"renderer","name":"project","msg":"restoring panel@53cf5646-6c51-47de-b639-3bb61d22f4c0","v":1} {"level":30,"time":1582126635738,"type":"renderer","name":"project","msg":"open db /Users/emd40p/OneDrive - University of Glasgow/Transfert/ARCHIVES/EURECON Rebased.tpy","v":1} {"level":40,"time":1582126642212,"type":"renderer","name":"project","msg":"SLOW: photo.load","v":1} {"level":40,"time":1582126644712,"type":"renderer","name":"project","msg":"SLOW: metadata.load","v":1} {"level":40,"time":1582126644794,"type":"renderer","name":"project","query":"\n SELECT id, tag_id AS tag\n FROM taggings","ms":840,"msg":"SLOW: db query took 840ms","v":1} {"level":40,"time":1582126644794,"type":"renderer","name":"project","query":"\n SELECT\n id,\n template,\n datetime(created, \"localtime\") AS created,\n datetime(modified, \"localtime\") AS modified,\n deleted\n FROM subjects\n JOIN items USING (id)\n LEFT OUTER JOIN trash USING (id)","ms":1087,"msg":"SLOW: db query took 1087ms","v":1} {"level":40,"time":1582126644794,"type":"renderer","name":"project","query":"\n SELECT id AS photo, item_id AS id\n FROM photos\n LEFT OUTER JOIN trash USING (id)\n WHERE \n deleted IS NULL\n ORDER BY item_id, position","ms":1186,"msg":"SLOW: db query took 1186ms","v":1} {"level":40,"time":1582126644794,"type":"renderer","name":"project","query":"\n SELECT id, property, text, datatype AS type\n FROM subjects\n JOIN metadata USING (id)\n JOIN metadata_values USING (value_id) ORDER BY id, metadata.created ASC","ms":2676,"msg":"SLOW: db query took 2676ms","v":1} {"level":40,"time":1582126644794,"type":"renderer","name":"project","query":"\n SELECT\n id,\n item_id AS item,\n template,\n datetime(created, \"localtime\") AS created,\n datetime(modified, \"localtime\") AS modified,\n angle,\n color,\n density,\n mirror,\n negative,\n brightness,\n contrast,\n hue,\n saturation,\n sharpen,\n width,\n height,\n path,\n page,\n size,\n protocol,\n mimetype,\n checksum,\n orientation\n FROM subjects\n JOIN images USING (id)\n JOIN photos USING (id)","ms":3765,"msg":"SLOW: db query took 3765ms","v":1} {"level":40,"time":1582126645002,"type":"renderer","name":"project","msg":"SLOW: item.load","v":1} {"level":30,"time":1582126645071,"type":"renderer","name":"project","msg":"db query took 56ms","query":"\n SELECT\n id,\n photo_id AS photo,\n x,\n y,\n width,\n height,\n angle,\n mirror,\n negative,\n brightness,\n contrast,\n hue,\n saturation,\n sharpen,\n template,\n datetime(created, \"localtime\") AS created,\n datetime(modified, \"localtime\") AS modified\n FROM subjects\n JOIN images USING (id)\n JOIN selections USING (id)","ms":56,"v":1} {"level":40,"time":1582126645080,"type":"renderer","name":"project","msg":"SLOW: selection.load","v":1} {"level":40,"time":1582126645098,"type":"renderer","name":"project","msg":"SLOW: note.load","v":1} {"level":40,"time":1582126645245,"type":"renderer","name":"project","ms":9502,"list":false,"query":"","tags":false,"trash":null,"msg":"SLOW: *search query \"\" took 9502ms","v":1} {"level":30,"time":1582126645321,"type":"renderer","name":"project","msg":"db query took 71ms","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\n FROM items\n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n id IN (367482,367484,367486,367488,367490,367492,367494,367496,367498,367500,367502,367504,367506,367508,367510,367512,367514,367516,367518,367520,367522,367524,367526,367528,367530,367532,367534,367536,367538,367540,367542,367544,367546,367548,367550,367552,367554,367556,367558,367560,367562,367564,367566,367568,367570,367572,367574,367576,367578,367580,367582,367584,367586,367588,367590,367592,367594,367596,367598,367600,367602,367604,367606,367608,367610,367612,367614,367616,367618,367620,367622,367624,367626,367628,367630,367632,367634,367636,367638,367640,367642,367644,367646,367648,367650,367652,367654,367656,367658,367660,367662,367664,367666,367668,367670,367672,367674,367676,367678,367680,367682,367684,367686,367688,367690,367692,367694,367696,367698,367700,367702,367704,367706,367708,367710,367712,367714,367716,367718,367720,367722,367724,367726,367728,367730,367732,367734,367736,367738,367740,367742,367744,367746,367748,367750,367752,367754,367756,367758,367760,367762,367764,367766,367768,367770,367772,367774,367776,367778,367780,367782,367784,367786,367788,367790,367792,367794,367796,367798,367800,367802,367804,367806,367808,367810,367812,367814,367816,367818,367820,367822,367824,367826,367828,367830,367832,367834,367836,367838,367840,367842,367844,367846,367848,367850,367852,367854,367856,367858,367860,367862,367864,367866,367868,367870,367872,367874,367876,367878,367880,367882,367884,367886,367888,367890,367892,367894,367896,367898,367900,367902,367904,367906,367908,367910,367912,367914,367916,367918,367920,367922,367924,367926,367928,367930,367932,367934,367936,367938,367940,367942,367944,367946,367948,367950,367952,367954,367956,367958,367960,367962,367964,367966,367968,367970,367972,367974,367976,367978,367980,367982,367984,367986,367988,367990,367992,367994,367996,367998,368000,368002,368004,368006,368008,368010,368012,368014,368016,368018,368020,368022,368024,368026,368028,368030,368032,368034,368036,368038,368040,368042,368044,368046,368048,368050,368052,368054,368056,368058,368060,368062,368064,368066,368068,368070,368072,368074,368076,368078,368080,368082,368084,368086,368088,368090,368092,368094,368096,368098,368100,368102,368104,368106,368108,368110,368112,368114,368116,368118,368120,368122,368124,368126,368128,368130,368132,368134,368136,368138,368140,368142,368144,368146,368148,368150,368152,368154,368156,368158,368160,368162,368164,368166,368168,368170,368172,368174,368176,368178,368180,368182,368184,368186,368188,368190,368192,368194,368196,368198,368200,368202,368204,368206,368208,368210,368212,368214,368216,368218,368220,368222,368224,368226,368228,368230,368232,368234,368236,368238,368240,368242,368244,368246,368248,368250,368252,368254,368256,368258,368260,368262,368264,368266,368268,368270,368272,368274,368276,368278,368280,368282,368284,368286,368288,368290,368292,368294,368296,368298,368300,368302,368304,368306,368308,368310,368312,368314,368316,368318,368320,368322,368324,368326,368328,368330,368332,368334,368336,368338,368340,368342,368344,368346,368348,368350,368352,368354,368356,368358,368360,368362,368364,368366,368368,368370,368372,368374,368376,368378,368380,368382,368384,368386,368388,368390,368392,368394,368396,368398,368400,368402,368404,368406,368408,368410,368412,368414,368416,368418,368420,368422,368424,368426,368428,368430,368432,368434,368436,368438,368440,368442,368444,368446,368448,368450,368452,368454,368456,368458,368460,368462,368464,368466,368468,368470,368472,368474,368476,368478,368480,368482,368484,368486,368488,368490,368492,368494,368496,368498,368500,368502,368504,368506,368508,368510,368512,368514,368516,368518,368520,368522,368524,368526,368528,368530,368532,368534,368536,368538,368540,368542,368544,368546,368548,368550,368552,368554,368556,368558,368560,368562,368564,368566,368568,368570,368572,368574,368576,368578,368580,368582,368584,368586,368588,368590,368592,368594,368596,368598,368600,368602,368604,368606) AND deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","ms":71,"v":1} {"level":30,"time":1582126744843,"type":"renderer","name":"project","msg":"db query took 72ms","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\n FROM items\n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n id IN (367482,367484,367486,367488,367490,367492,367494,367496,367498,367500,367502,367504,367506,367508,367510,367512,367514,367516,367518,367520,367522,367524,367526,367528,367530,367532,367534,367536,367538,367540,367542,367544,367546,367548,367550,367552,367554,367556,367558,367560,367562,367564,367566,367568,367570,367572,367574,367576,367578,367580,367582,367584,367586,367588,367590,367592,367594,367596,367598,367600,367602,367604,367606,367608,367610,367612,367614,367616,367618,367620,367622,367624,367626,367628,367630,367632,367634,367636,367638,367640,367642,367644,367646,367648,367650,367652,367654,367656,367658,367660,367662,367664,367666,367668,367670,367672,367674,367676,367678,367680,367682,367684,367686,367688,367690,367692,367694,367696,367698,367700,367702,367704,367706,367708,367710,367712,367714,367716,367718,367720,367722,367724,367726,367728,367730,367732,367734,367736,367738,367740,367742,367744,367746,367748,367750,367752,367754,367756,367758,367760,367762,367764,367766,367768,367770,367772,367774,367776,367778,367780,367782,367784,367786,367788,367790,367792,367794,367796,367798,367800,367802,367804,367806,367808,367810,367812,367814,367816,367818,367820,367822,367824,367826,367828,367830,367832,367834,367836,367838,367840,367842,367844,367846,367848,367850,367852,367854,367856,367858,367860,367862,367864,367866,367868,367870,367872,367874,367876,367878,367880,367882,367884,367886,367888,367890,367892,367894,367896,367898,367900,367902,367904,367906,367908,367910,367912,367914,367916,367918,367920,367922,367924,367926,367928,367930,367932,367934,367936,367938,367940,367942,367944,367946,367948,367950,367952,367954,367956,367958,367960,367962,367964,367966,367968,367970,367972,367974,367976,367978,367980,367982,367984,367986,367988,367990,367992,367994,367996,367998,368000,368002,368004,368006,368008,368010,368012,368014,368016,368018,368020,368022,368024,368026,368028,368030,368032,368034,368036,368038,368040,368042,368044,368046,368048,368050,368052,368054,368056,368058,368060,368062,368064,368066,368068,368070,368072,368074,368076,368078,368080,368082,368084,368086,368088,368090,368092,368094,368096,368098,368100,368102,368104,368106,368108,368110,368112,368114,368116,368118,368120,368122,368124,368126,368128,368130,368132,368134,368136,368138,368140,368142,368144,368146,368148,368150,368152,368154,368156,368158,368160,368162,368164,368166,368168,368170,368172,368174,368176,368178,368180,368182,368184,368186,368188,368190,368192,368194,368196,368198,368200,368202,368204,368206,368208,368210,368212,368214,368216,368218,368220,368222,368224,368226,368228,368230,368232,368234,368236,368238,368240,368242,368244,368246,368248,368250,368252,368254,368256,368258,368260,368262,368264,368266,368268,368270,368272,368274,368276,368278,368280,368282,368284,368286,368288,368290,368292,368294,368296,368298,368300,368302,368304,368306,368308,368310,368312,368314,368316,368318,368320,368322,368324,368326,368328,368330,368332,368334,368336,368338,368340,368342,368344,368346,368348,368350,368352,368354,368356,368358,368360,368362,368364,368366,368368,368370,368372,368374,368376,368378,368380,368382,368384,368386,368388,368390,368392,368394,368396,368398,368400,368402,368404,368406,368408,368410,368412,368414,368416,368418,368420,368422,368424,368426,368428,368430,368432,368434,368436,368438,368440,368442,368444,368446,368448,368450,368452,368454,368456,368458,368460,368462,368464,368466,368468,368470,368472,368474,368476,368478,368480,368482,368484,368486,368488,368490,368492,368494,368496,368498,368500,368502,368504,368506,368508,368510,368512,368514,368516,368518,368520,368522,368524,368526,368528,368530,368532,368534,368536,368538,368540,368542,368544,368546,368548,368550,368552,368554,368556,368558,368560,368562,368564,368566,368568,368570,368572,368574,368576,368578,368580,368582,368584,368586,368588,368590,368592,368594,368596,368598,368600,368602,368604,368606) AND deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","ms":72,"v":1} {"level":30,"time":1582126885447,"type":"renderer","name":"project","msg":"db query took 66ms","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\n FROM items\n LEFT OUTER JOIN sort USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n id IN (367482,367484,367486,367488,367490,367492,367494,367496,367498,367500,367502,367504,367506,367508,367510,367512,367514,367516,367518,367520,367522,367524,367526,367528,367530,367532,367534,367536,367538,367540,367542,367544,367546,367548,367550,367552,367554,367556,367558,367560,367562,367564,367566,367568,367570,367572,367574,367576,367578,367580,367582,367584,367586,367588,367590,367592,367594,367596,367598,367600,367602,367604,367606,367608,367610,367612,367614,367616,367618,367620,367622,367624,367626,367628,367630,367632,367634,367636,367638,367640,367642,367644,367646,367648,367650,367652,367654,367656,367658,367660,367662,367664,367666,367668,367670,367672,367674,367676,367678,367680,367682,367684,367686,367688,367690,367692,367694,367696,367698,367700,367702,367704,367706,367708,367710,367712,367714,367716,367718,367720,367722,367724,367726,367728,367730,367732,367734,367736,367738,367740,367742,367744,367746,367748,367750,367752,367754,367756,367758,367760,367762,367764,367766,367768,367770,367772,367774,367776,367778,367780,367782,367784,367786,367788,367790,367792,367794,367796,367798,367800,367802,367804,367806,367808,367810,367812,367814,367816,367818,367820,367822,367824,367826,367828,367830,367832,367834,367836,367838,367840,367842,367844,367846,367848,367850,367852,367854,367856,367858,367860,367862,367864,367866,367868,367870,367872,367874,367876,367878,367880,367882,367884,367886,367888,367890,367892,367894,367896,367898,367900,367902,367904,367906,367908,367910,367912,367914,367916,367918,367920,367922,367924,367926,367928,367930,367932,367934,367936,367938,367940,367942,367944,367946,367948,367950,367952,367954,367956,367958,367960,367962,367964,367966,367968,367970,367972,367974,367976,367978,367980,367982,367984,367986,367988,367990,367992,367994,367996,367998,368000,368002,368004,368006,368008,368010,368012,368014,368016,368018,368020,368022,368024,368026,368028,368030,368032,368034,368036,368038,368040,368042,368044,368046,368048,368050,368052,368054,368056,368058,368060,368062,368064,368066,368068,368070,368072,368074,368076,368078,368080,368082,368084,368086,368088,368090,368092,368094,368096,368098,368100,368102,368104,368106,368108,368110,368112,368114,368116,368118,368120,368122,368124,368126,368128,368130,368132,368134,368136,368138,368140,368142,368144,368146,368148,368150,368152,368154,368156,368158,368160,368162,368164,368166,368168,368170,368172,368174,368176,368178,368180,368182,368184,368186,368188,368190,368192,368194,368196,368198,368200,368202,368204,368206,368208,368210,368212,368214,368216,368218,368220,368222,368224,368226,368228,368230,368232,368234,368236,368238,368240,368242,368244,368246,368248,368250,368252,368254,368256,368258,368260,368262,368264,368266,368268,368270,368272,368274,368276,368278,368280,368282,368284,368286,368288,368290,368292,368294,368296,368298,368300,368302,368304,368306,368308,368310,368312,368314,368316,368318,368320,368322,368324,368326,368328,368330,368332,368334,368336,368338,368340,368342,368344,368346,368348,368350,368352,368354,368356,368358,368360,368362,368364,368366,368368,368370,368372,368374,368376,368378,368380,368382,368384,368386,368388,368390,368392,368394,368396,368398,368400,368402,368404,368406,368408,368410,368412,368414,368416,368418,368420,368422,368424,368426,368428,368430,368432,368434,368436,368438,368440,368442,368444,368446,368448,368450,368452,368454,368456,368458,368460,368462,368464,368466,368468,368470,368472,368474,368476,368478,368480,368482,368484,368486,368488,368490,368492,368494,368496,368498,368500,368502,368504,368506,368508,368510,368512,368514,368516,368518,368520,368522,368524,368526,368528,368530,368532,368534,368536,368538,368540,368542,368544,368546,368548,368550,368552,368554,368556,368558,368560,368562,368564,368566,368568,368570,368572,368574,368576,368578,368580,368582,368584,368586,368588,368590,368592,368594,368596,368598,368600,368602,368604,368606) AND deleted IS NULL\n \n ORDER BY sort.text ASC, id ASC","ms":66,"v":1} {"level":40,"time":1582127232477,"type":"browser","name":"main","msg":"project[1] contents crashed","v":1}