2 lines
4.2 KiB
Text
2 lines
4.2 KiB
Text
|
2024-09-06 16:38:15 36844016 {"timestamp":"2024-09-06 16:38:15.324 CEST","user":"onlineed","dbname":"wedeojpa","pid":34,"remote_host":"payara.docker_default","remote_port":59636,"session_id":"66db1333.22","line_num":81790,"ps":"BIND","session_start":"2024-09-06 16:35:31 CEST","vxid":"3/40692","txid":0,"error_severity":"LOG","message":"duration: 0.085 ms bind S_13: SELECT t0.createdat, t0.modifiedat, t0.validuntil, t1.id, t1.createdat, t1.modifiedat, t1.validuntil, t2.id, t2.createdat, t2.modifiedat, t2.validuntil, t3.id, t3.createdat, t3.modifiedat, t3.validuntil, t3.description, t2.comments, t2.firstname, t2.surname, t2.title, t2.birthstartyear, t2.birthdatetype, t2.birthendstatus, t2.birthendday, t2.birthendmonth, t2.birthendyear, t2.birthstartdatestatus, t2.birthstartday, t2.birthstartmonth, t2.deathstartyear, t2.deathdatetype, t2.deathendstatus, t2.deathendday, t2.deathendmonth, t2.deathendyear, t2.deathstartdatestatus, t2.deathstartday, t2.deathstartmonth, t2.dnbref, t2.gender, t2.isinstitution, t4.id, t4.createdat, t4.modifiedat, t4.validuntil, t4.extendedbiography_id, t4.city, t4.country, t4.dnbref, t4.region, t4.sitecityid, t4.wikilink, t4.zipcode, t5.id, t5.createdat, t5.modifiedat, t5.validuntil, t5.extendedbiography_id, t5.city, t5.country, t5.dnbref, t5.region, t5.sitecityid, t5.wikilink, t5.zipcode, t2.personid, t2.pseudonym, t2.wikilink, t1.bequest_id, t1.city_id, t1.documentcategory, t1.documentcontentcleaned, t1.documentcontenthtml, t1.documentcontentteibody, t6.id, t6.createdat, t6.modifiedat, t6.validuntil, t6.extendedbiography_id, t6.city, t6.country, t6.dnbref, t6.region, t6.sitecityid, t6.wikilink, t6.zipcode, t1.notes, t1.datetype, t1.enddatestatus, t1.endday, t1.endmonth, t1.endyear, t1.startdatestatus, t1.startday, t1.startmonth, t1.startyear, t1.documentdelivery_id, t1.documentid, t1.documentstatus, t7.id, t7.createdat, t7.modifiedat, t7.validuntil, t7.activated, t8.id, t8.createdat, t8.modifiedat, t8.validuntil, t8.description, t8.userrole, t7.comments, t7.emailaddress, t7.firstname, t7.institution, t7.lastlogindate, t7.loggedin, t7.loggedinsince, t7.loginname, t7.password, t7.registrationdate, t7.salt, t7.surname, t7.title, t1.envelope_id, t1.firstprint_id, t1.followsdocument_id, t1.iscomplete, t1.isdispatched, t1.ispublishedindb, t1.isreconstructed, t1.location_id, t1.font, t1.fontmedium, t1.fonttools, t1.misc, t1.typingpool, t1.numberofpages, t1.numberofsheets, t1.parentdocument_id, t1.processingnotes, t1.reconstructednotes, t1.reviewer_id, t1.signature, t1.textsystemcomment, t9.id, t9.createdat, t9.modifiedat, t9.validuntil, t9.available, t9.comments, t9.description, t9.editor_id, t9.\"fileHash\", t9.\"fileHeight\", t9.\"fileName\", t9.\"fileSize\", t9.\"fileType\", t9.\"fileWidth\", t10.id, t10.createdat, t10.modifiedat, t10.validuntil, t10.addresstype, t10.city, t10.country, t10.housenumber, t10.misc, t10.postofficebox, t10.street, t10.zipcode, t10.anonymizedcontactperson, t11.id, t11.createdat, t11.modifiedat, t11.validuntil, t11.comments, t11.firstname, t11.surname, t11.title, t11.addresstype, t11.city, t11.country, t11.housenumber, t11.misc, t11.postofficebox, t11.street, t11.zipcode, t11.emailaddress, t11.institution, t11.countrycode, t11.number, t11.phonenumbertype, t11.prefix, t10.expressionofthanks, t10.link, t10.locationcomments, t10.locationname, t9.transformation, t0.priority FROM public.DocumentFacsimile t0 LEFT OUTER JOIN public.Document t1 ON t0.document_id = t1.id LEFT OUTER JOIN public.facsimile t9 ON t0.facsimile_id = t9.id LEFT OUTER JOIN public.historicalperson t2 ON t1.authorperson_id = t2.id LEFT OUTER JOIN public.sitecity t6 ON t1.city_id = t6.id LEFT OUTER JOIN public.appuser t7 ON t1.editor_id = t7.id LEFT OUTER JOIN public.location t10 ON t9.location_id = t10.id LEFT OUTER JOIN public.extendedbiography t3 ON t2.extendedbiography_id = t3.id LEFT OUTER JOIN public.sitecity t4 ON t2.sitecity_birth_id = t4.id LEFT OUTER JOIN public.sitecity t5 ON t2.sitecity_death_id = t5.id LEFT OUTER JOIN public.appuserrole t8 ON t7.appuserrole_id = t8.id LEFT OUTER JOIN public.cont
|