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(34:9f815c020d38845c-CMH): devadmin.tracqa.co.uk/site-map'

0: [0/0 rows] (0.00069200000000003sec)

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.001575sec)

3: SELECT * FROM url JOIN blocks USING (blockid) WHERE parenturlid=1 AND urlstring='site-map'

3: [1/1 rows] (0.00079200000000001sec)

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(6766)) ORDER BY blocks.parentid asc, blocks.displayorder asc

4: [1/1 rows] (0.001239sec)

5: SELECT roles.roleid, roles.roledesc, roles.roletype, roles.rootfolder, roles.massmailrole FROM roles

5: [32/32 rows] (0.00060299999999991sec)

6: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (1)

6: [133/133 rows] (0.00084399999999996sec)

7: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6766)

7: [133/133 rows] (0.0015660000000001sec)

8: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6767)

8: [133/133 rows] (0.001109sec)

9: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6018)

9: [22/22 rows] (0.00065700000000002sec)

10: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6343)

10: [133/133 rows] (0.00075599999999998sec)