From bfda84b43d6a6c91682287567616f5efe45bc9b3 Mon Sep 17 00:00:00 2001
From: Belen Pruvost <belen.pruvost@sonarsource.com>
Date: Mon, 30 Nov 2020 13:08:57 +0000
Subject: [PATCH] SONAR-12659 Improve Quality Profiles Query Performance

---
 .../org/sonar/db/qualityprofile/QualityProfileMapper.xml      | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/server/sonar-db-dao/src/main/resources/org/sonar/db/qualityprofile/QualityProfileMapper.xml b/server/sonar-db-dao/src/main/resources/org/sonar/db/qualityprofile/QualityProfileMapper.xml
index 31c61544ed1..e6dabc0aa38 100644
--- a/server/sonar-db-dao/src/main/resources/org/sonar/db/qualityprofile/QualityProfileMapper.xml
+++ b/server/sonar-db-dao/src/main/resources/org/sonar/db/qualityprofile/QualityProfileMapper.xml
@@ -246,11 +246,11 @@
 
   <select id="countProjectsByProfiles" resultType="KeyLongValue" parameterType="map">
     select pqp.profile_key as "key", count(pj.uuid) as "value"
-    from components pj
+    from projects pj
     inner join project_qprofiles pqp on pqp.project_uuid = pj.uuid
     inner join org_qprofiles oqp on oqp.uuid = pqp.profile_key
     where
-      pj.enabled = ${_true}
+      pj.qualifier = 'TRK'
       and <foreach collection="profileUuids" item="profileUuid" open="(" separator=" or " close=")">
         oqp.uuid = #{profileUuid, jdbcType=VARCHAR}
       </foreach>
-- 
2.39.5