LOG:  duration: 0.053 ms  parse <unnamed>: SELECT * FROM mdl_context WHERE contextlevel = $1 AND instanceid = $2
LOG:  duration: 0.094 ms  bind <unnamed>: SELECT * FROM mdl_context WHERE contextlevel = $1 AND instanceid = $2
DETAIL:  parameters: $1 = '30', $2 = '133997'
LOG:  duration: 17.703 ms  execute <unnamed>: SELECT * FROM mdl_context WHERE contextlevel = $1 AND instanceid = $2
DETAIL:  parameters: $1 = '30', $2 = '133997'
LOG:  duration: 0.156 ms  parse <unnamed>: SELECT ctx.path, ra.roleid, ra.contextid
	              FROM mdl_role_assignments ra
	              JOIN mdl_context ctx
	                   ON ctx.id = ra.contextid
	         LEFT JOIN mdl_block_instances bi
	                   ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	         LEFT JOIN mdl_context bpctx
	                   ON (bpctx.id = bi.parentcontextid)
	             WHERE ra.userid = $1
	                   AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
LOG:  duration: 0.730 ms  bind <unnamed>: SELECT ctx.path, ra.roleid, ra.contextid
	              FROM mdl_role_assignments ra
	              JOIN mdl_context ctx
	                   ON ctx.id = ra.contextid
	         LEFT JOIN mdl_block_instances bi
	                   ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	         LEFT JOIN mdl_context bpctx
	                   ON (bpctx.id = bi.parentcontextid)
	             WHERE ra.userid = $1
	                   AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
DETAIL:  parameters: $1 = '133997'
LOG:  duration: 0.061 ms  execute <unnamed>: SELECT ctx.path, ra.roleid, ra.contextid
	              FROM mdl_role_assignments ra
	              JOIN mdl_context ctx
	                   ON ctx.id = ra.contextid
	         LEFT JOIN mdl_block_instances bi
	                   ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	         LEFT JOIN mdl_context bpctx
	                   ON (bpctx.id = bi.parentcontextid)
	             WHERE ra.userid = $1
	                   AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
DETAIL:  parameters: $1 = '133997'
LOG:  duration: 0.533 ms  parse <unnamed>: (SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                     FROM mdl_role_capabilities rc
	                     JOIN mdl_context ctx
	                          ON (ctx.id = rc.contextid)
	                     JOIN mdl_context pctx
	                          ON (pctx.id = $1
	                              AND (ctx.id = pctx.id
	                                   OR ctx.path LIKE  '' || pctx.path || '/%' 
	                                   OR pctx.path LIKE  '' || ctx.path || '/%' ))
	                LEFT JOIN mdl_block_instances bi
	                          ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	                LEFT JOIN mdl_context bpctx
	                          ON (bpctx.id = bi.parentcontextid)
	                    WHERE rc.roleid = $2
	                          AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
	                   )
	UNION
	(SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                     FROM mdl_role_capabilities rc
	                     JOIN mdl_context ctx
	                          ON (ctx.id = rc.contextid)
	                     JOIN mdl_context pctx
	                          ON (pctx.id = $3
	                              AND (ctx.id = pctx.id
	                                   OR ctx.path LIKE  '' || pctx.path || '/%' 
	                                   OR pctx.path LIKE  '' || ctx.path || '/%' ))
	                LEFT JOIN mdl_block_instances bi
	                          ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	                LEFT JOIN mdl_context bpctx
	                          ON (bpctx.id = bi.parentcontextid)
	                    WHERE rc.roleid = $4
	                          AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
	                   )
	UNION
	(SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                     FROM mdl_role_capabilities rc
	                     JOIN mdl_context ctx
	                          ON (ctx.id = rc.contextid)
	                     JOIN mdl_context pctx
	                          ON (pctx.id = $5
	                              AND (ctx.id = pctx.id
	                                   OR ctx.path LIKE  '' || pctx.path || '/%' 
	                                   OR pctx.path LIKE  '' || ctx.path || '/%' ))
	                LEFT JOIN mdl_block_instances bi
	                          ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	                LEFT JOIN mdl_context bpctx
	                          ON (bpctx.id = bi.parentcontextid)
	                    WHERE rc.roleid = $6
	                          AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
	                   )ORDER BY capability
LOG:  duration: 2.799 ms  bind <unnamed>: (SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                     FROM mdl_role_capabilities rc
	                     JOIN mdl_context ctx
	                          ON (ctx.id = rc.contextid)
	                     JOIN mdl_context pctx
	                          ON (pctx.id = $1
	                              AND (ctx.id = pctx.id
	                                   OR ctx.path LIKE  '' || pctx.path || '/%' 
	                                   OR pctx.path LIKE  '' || ctx.path || '/%' ))
	                LEFT JOIN mdl_block_instances bi
	                          ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	                LEFT JOIN mdl_context bpctx
	                          ON (bpctx.id = bi.parentcontextid)
	                    WHERE rc.roleid = $2
	                          AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
	                   )
	UNION
	(SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                     FROM mdl_role_capabilities rc
	                     JOIN mdl_context ctx
	                          ON (ctx.id = rc.contextid)
	                     JOIN mdl_context pctx
	                          ON (pctx.id = $3
	                              AND (ctx.id = pctx.id
	                                   OR ctx.path LIKE  '' || pctx.path || '/%' 
	                                   OR pctx.path LIKE  '' || ctx.path || '/%' ))
	                LEFT JOIN mdl_block_instances bi
	                          ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	                LEFT JOIN mdl_context bpctx
	                          ON (bpctx.id = bi.parentcontextid)
	                    WHERE rc.roleid = $4
	                          AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
	                   )
	UNION
	(SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                     FROM mdl_role_capabilities rc
	                     JOIN mdl_context ctx
	                          ON (ctx.id = rc.contextid)
	                     JOIN mdl_context pctx
	                          ON (pctx.id = $5
	                              AND (ctx.id = pctx.id
	                                   OR ctx.path LIKE  '' || pctx.path || '/%' 
	                                   OR pctx.path LIKE  '' || ctx.path || '/%' ))
	                LEFT JOIN mdl_block_instances bi
	                          ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	                LEFT JOIN mdl_context bpctx
	                          ON (bpctx.id = bi.parentcontextid)
	                    WHERE rc.roleid = $6
	                          AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
	                   )ORDER BY capability
DETAIL:  parameters: $1 = '1', $2 = '7', $3 = '2', $4 = '8', $5 = '582744', $6 = '5'
LOG:  duration: 332.021 ms  execute <unnamed>: (SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                     FROM mdl_role_capabilities rc
	                     JOIN mdl_context ctx
	                          ON (ctx.id = rc.contextid)
	                     JOIN mdl_context pctx
	                          ON (pctx.id = $1
	                              AND (ctx.id = pctx.id
	                                   OR ctx.path LIKE  '' || pctx.path || '/%' 
	                                   OR pctx.path LIKE  '' || ctx.path || '/%' ))
	                LEFT JOIN mdl_block_instances bi
	                          ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	                LEFT JOIN mdl_context bpctx
	                          ON (bpctx.id = bi.parentcontextid)
	                    WHERE rc.roleid = $2
	                          AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
	                   )
	UNION
	(SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                     FROM mdl_role_capabilities rc
	                     JOIN mdl_context ctx
	                          ON (ctx.id = rc.contextid)
	                     JOIN mdl_context pctx
	                          ON (pctx.id = $3
	                              AND (ctx.id = pctx.id
	                                   OR ctx.path LIKE  '' || pctx.path || '/%' 
	                                   OR pctx.path LIKE  '' || ctx.path || '/%' ))
	                LEFT JOIN mdl_block_instances bi
	                          ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	                LEFT JOIN mdl_context bpctx
	                          ON (bpctx.id = bi.parentcontextid)
	                    WHERE rc.roleid = $4
	                          AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
	                   )
	UNION
	(SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                     FROM mdl_role_capabilities rc
	                     JOIN mdl_context ctx
	                          ON (ctx.id = rc.contextid)
	                     JOIN mdl_context pctx
	                          ON (pctx.id = $5
	                              AND (ctx.id = pctx.id
	                                   OR ctx.path LIKE  '' || pctx.path || '/%' 
	                                   OR pctx.path LIKE  '' || ctx.path || '/%' ))
	                LEFT JOIN mdl_block_instances bi
	                          ON (ctx.contextlevel = 80 AND bi.id = ctx.instanceid)
	                LEFT JOIN mdl_context bpctx
	                          ON (bpctx.id = bi.parentcontextid)
	                    WHERE rc.roleid = $6
	                          AND (ctx.contextlevel <= 50 OR bpctx.contextlevel < 50)
	                   )ORDER BY capability
DETAIL:  parameters: $1 = '1', $2 = '7', $3 = '2', $4 = '8', $5 = '582744', $6 = '5'
LOG:  duration: 0.143 ms  parse <unnamed>: SELECT ra.*, ctx.path
	                  FROM mdl_role_assignments ra
	                  JOIN mdl_context ctx ON ra.contextid = ctx.id
	                 WHERE ra.userid = $1 AND (ctx.id IN ($2,$3,$4,$5) OR ctx.path LIKE $6)
LOG:  duration: 0.496 ms  bind <unnamed>: SELECT ra.*, ctx.path
	                  FROM mdl_role_assignments ra
	                  JOIN mdl_context ctx ON ra.contextid = ctx.id
	                 WHERE ra.userid = $1 AND (ctx.id IN ($2,$3,$4,$5) OR ctx.path LIKE $6)
DETAIL:  parameters: $1 = '133997', $2 = '582744', $3 = '9176', $4 = '24', $5 = '1', $6 = '/1/24/9176/582744/%'
LOG:  duration: 0.159 ms  execute <unnamed>: SELECT ra.*, ctx.path
	                  FROM mdl_role_assignments ra
	                  JOIN mdl_context ctx ON ra.contextid = ctx.id
	                 WHERE ra.userid = $1 AND (ctx.id IN ($2,$3,$4,$5) OR ctx.path LIKE $6)
DETAIL:  parameters: $1 = '133997', $2 = '582744', $3 = '9176', $4 = '24', $5 = '1', $6 = '/1/24/9176/582744/%'
LOG:  duration: 0.097 ms  parse <unnamed>: SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                 FROM mdl_role_capabilities rc
	                 JOIN mdl_context ctx
	                      ON (ctx.id = rc.contextid)
	                 JOIN mdl_context cctx
	                      ON (cctx.id = $1
	                          AND (ctx.id IN ($2,$3,$4,$5) OR ctx.path LIKE  '' || cctx.path || '/%' ))
	                WHERE rc.roleid IN ($6,$7)
	             ORDER BY rc.capability
LOG:  duration: 0.310 ms  bind <unnamed>: SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                 FROM mdl_role_capabilities rc
	                 JOIN mdl_context ctx
	                      ON (ctx.id = rc.contextid)
	                 JOIN mdl_context cctx
	                      ON (cctx.id = $1
	                          AND (ctx.id IN ($2,$3,$4,$5) OR ctx.path LIKE  '' || cctx.path || '/%' ))
	                WHERE rc.roleid IN ($6,$7)
	             ORDER BY rc.capability
DETAIL:  parameters: $1 = '582744', $2 = '582744', $3 = '9176', $4 = '24', $5 = '1', $6 = '5', $7 = '7'
LOG:  duration: 156.932 ms  execute <unnamed>: SELECT ctx.path, rc.roleid, rc.capability, rc.permission
	                 FROM mdl_role_capabilities rc
	                 JOIN mdl_context ctx
	                      ON (ctx.id = rc.contextid)
	                 JOIN mdl_context cctx
	                      ON (cctx.id = $1
	                          AND (ctx.id IN ($2,$3,$4,$5) OR ctx.path LIKE  '' || cctx.path || '/%' ))
	                WHERE rc.roleid IN ($6,$7)
	             ORDER BY rc.capability
DETAIL:  parameters: $1 = '582744', $2 = '582744', $3 = '9176', $4 = '24', $5 = '1', $6 = '5', $7 = '7'
LOG:  duration: 0.133 ms  parse <unnamed>: SELECT 'x'
	                  FROM mdl_groups_members gm, mdl_groupings_groups gg
	                 WHERE gm.userid = $1 AND gm.groupid = gg.groupid AND gg.groupingid = $2 LIMIT 1 OFFSET 0
LOG:  duration: 0.375 ms  bind <unnamed>: SELECT 'x'
	                  FROM mdl_groups_members gm, mdl_groupings_groups gg
	                 WHERE gm.userid = $1 AND gm.groupid = gg.groupid AND gg.groupingid = $2 LIMIT 1 OFFSET 0
DETAIL:  parameters: $1 = '133997', $2 = '1890'
LOG:  duration: 0.087 ms  execute <unnamed>: SELECT 'x'
	                  FROM mdl_groups_members gm, mdl_groupings_groups gg
	                 WHERE gm.userid = $1 AND gm.groupid = gg.groupid AND gg.groupingid = $2 LIMIT 1 OFFSET 0
DETAIL:  parameters: $1 = '133997', $2 = '1890'