0: SELECT * FROM url JOIN blocks USING (blockid) WHERE urlid=1
** Auto-selected read-only connection **
** Using RW connect string from ConnectStrConfigValue **
0: SET application_name = 'web(36:9f81b7ac786d224d-CMH): devadmin.tracqa.co.uk/forgot'
0: [0/0 rows] (0.00094300000000003sec)
1: [1/1 rows] (0sec)
2: SELECT blocks.blockid, blocks.parentid, blocks.name, blocks.title, blocks.module, blocks.type, blocks.subtype, blocks.def, blocks.displayorder, EXTRACT('epoch' FROM blocks.createddatetime) AS createddatetime, blocks.createdby, EXTRACT('epoch' FROM blocks.updateddatetime) AS updateddatetime, blocks.updatedby, EXTRACT('epoch' FROM blocks.childrenupdateddatetime) AS childrenupdateddatetime, EXTRACT('epoch' FROM blocks.significantlyupdateddatetime) AS significantlyupdateddatetime, url.urlid, url.parenturlid, url.urlstring, url.allowdocs, EXTRACT('epoch' FROM url.indexeddatetime) AS indexeddatetime, url.allowimages, url.lastreviewedby, EXTRACT('epoch' FROM (date_trunc('day', url.nextreviewdate)+ interval '12 hours')::timestamp)AS nextreviewdate, EXTRACT('epoch' FROM (date_trunc('day', url.lastrevieweddate)+ interval '12 hours')::timestamp)AS lastrevieweddate, EXTRACT('epoch' FROM url.childurlsupdateddatetime) AS childurlsupdateddatetime, EXTRACT('epoch' FROM url.childblocksupdateddatetime) AS childblocksupdateddatetime FROM blocks LEFT OUTER JOIN url USING (blockid) WHERE blockid IN (SELECT * FROM child_blockids_recursive(1)) ORDER BY blocks.parentid asc, blocks.displayorder asc
2: [6/6 rows] (0.001584sec)
3: SELECT * FROM url JOIN blocks USING (blockid) WHERE parenturlid=1 AND urlstring='forgot'
3: [1/1 rows] (0.001048sec)
4: SELECT blocks.blockid, blocks.parentid, blocks.name, blocks.title, blocks.module, blocks.type, blocks.subtype, blocks.def, blocks.displayorder, EXTRACT('epoch' FROM blocks.createddatetime) AS createddatetime, blocks.createdby, EXTRACT('epoch' FROM blocks.updateddatetime) AS updateddatetime, blocks.updatedby, EXTRACT('epoch' FROM blocks.childrenupdateddatetime) AS childrenupdateddatetime, EXTRACT('epoch' FROM blocks.significantlyupdateddatetime) AS significantlyupdateddatetime, url.urlid, url.parenturlid, url.urlstring, url.allowdocs, EXTRACT('epoch' FROM url.indexeddatetime) AS indexeddatetime, url.allowimages, url.lastreviewedby, EXTRACT('epoch' FROM (date_trunc('day', url.nextreviewdate)+ interval '12 hours')::timestamp)AS nextreviewdate, EXTRACT('epoch' FROM (date_trunc('day', url.lastrevieweddate)+ interval '12 hours')::timestamp)AS lastrevieweddate, EXTRACT('epoch' FROM url.childurlsupdateddatetime) AS childurlsupdateddatetime, EXTRACT('epoch' FROM url.childblocksupdateddatetime) AS childblocksupdateddatetime FROM blocks LEFT OUTER JOIN url USING (blockid) WHERE blockid IN (SELECT * FROM child_blockids_recursive(2112)) ORDER BY blocks.parentid asc, blocks.displayorder asc
4: [1/1 rows] (0.001485sec)
5: SELECT roles.roleid, roles.roledesc, roles.roletype, roles.rootfolder, roles.massmailrole FROM roles
5: [32/32 rows] (0.0023070000000001sec)
6: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (1)
6: [133/133 rows] (0.002947sec)
7: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (2112)
7: [91/91 rows] (0.001915sec)
8: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (2565)
8: [22/22 rows] (0.001447sec)
9: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6018)
9: [22/22 rows] (0.003061sec)
10: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6343)
10: [133/133 rows] (0.00080399999999992sec)
Please enter your email address. We will send you an email containing instructions to help you to reset your password.
If you do not receive the email or have difficulty following the instructions within then please contact your recruitment department.