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(35:9f815c045956845c-CMH): devadmin.tracqa.co.uk/admin/dashb'
0: [0/0 rows] (0.00065299999999999sec)
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.00149sec)
3: SELECT * FROM url JOIN blocks USING (blockid) WHERE parenturlid=1 AND urlstring='admin'
3: [1/1 rows] (0.001411sec)
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(1082)) ORDER BY blocks.parentid asc, blocks.displayorder asc
4: [0/0 rows] (0.000944sec)
5: SELECT * FROM url JOIN blocks USING (blockid) WHERE parenturlid=657 AND urlstring='dashboard'
5: [1/1 rows] (0.00076199999999998sec)
6: 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(2317)) ORDER BY blocks.parentid asc, blocks.displayorder asc
6: [16/16 rows] (0.001543sec)
7: SELECT roles.roleid, roles.roledesc, roles.roletype, roles.rootfolder, roles.massmailrole FROM roles
7: [32/32 rows] (0.001025sec)
8: SELECT * FROM url JOIN blocks USING (blockid) WHERE urlid=1
8: [1/1 rows] (0.001618sec)
9: 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
9: [6/6 rows] (0.002052sec)
10: SELECT * FROM url JOIN blocks USING (blockid) WHERE parenturlid=1 AND urlstring='login'
10: [1/1 rows] (0.001021sec)
11: 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(2)) ORDER BY blocks.parentid asc, blocks.displayorder asc
11: [4/4 rows] (0.00556sec)
12: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (1)
12: [133/133 rows] (0.001916sec)
13: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (2170)
13: [26/26 rows] (0.00074999999999997sec)
14: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6231)
14: [22/22 rows] (0.000668sec)
15: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6668)
15: [91/91 rows] (0.000778sec)
16: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6715)
16: [91/91 rows] (0.00074299999999999sec)
17: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6018)
17: [22/22 rows] (0.00062900000000005sec)
18: SELECT permissions.blockid, permissions.permissionid, permissions.roleid, permissions.permtype, permissions.effectivepermtype FROM permissions WHERE blockid IN (6343)
18: [133/133 rows] (0.00078300000000003sec)
This is an internal system used to test the upcoming Trac release.
If you are not a member of Trac staff, please use the live system, and update any existing documentation to use the live link (admin.trac.jobs) instead of this site.
For Civica staff, send an email to "UK Trac Lead Engineers" to gain access to the site
