Hi Team,
We are using SonarQube 6.7.6 (LTS).
we use web api to apply template to my project , there is mysql slow query as follows
SELECT u.login FROM(
SELECT DISTINCT u.login AS login, u.name AS name
FROM users u
LEFT JOIN perm_templates_users ptu ON ptu.user_id=u.id AND ptu.template_id=xxxx
INNER JOIN organization_members om ON u.id=om.user_id AND om.organization_uuid=‘xxxxx’
WHERE u.active = true
and ptu.permission_reference is not null
and ptu.permission_reference=‘xxxx’
) u
ORDER BY u.name;
Can you please help us to understand how it can be done ?
Thanks,
lili