DB 쿼리 시간이 많이 걸려서 이런 내용을 받았는데 혹시 해석? 좀 해주실 수 있나요? 채택완료

DB 쿼리 시간이 많이 걸려서 이런 내용을 받았는데 혹시 해석? 좀 해주실 수 있나요?

어디 DB 쿼리 때문에 로딩에 시간이 많이 걸리는걸까요..?

# Time: 191007 10:03:49
# User@Host: SITENAME[SITENAME] @ localhost []
# Thread_id: 1641134  Schema: SITENAME  QC_hit: No
# Query_time: 4.641318  Lock_time: 0.626739  Rows_sent: 32  Rows_examined: 256
# Rows_affected: 0
use SITENAME;
SET timestamp=1570410229;
SELECT c.* , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance
              FROM mdl_course c
              JOIN (
                SELECT DISTINCT e.courseid
                  FROM mdl_enrol e
                  JOIN mdl_user_enrolments ue ON (ue.enrolid = e.id AND ue.userid = '378')
                 WHERE ue.status = '0' AND e.status = '0' AND ue.timestart < 1570410200
                       AND (ue.timeend = 0 OR ue.timeend > 1570410200)) en ON (en.courseid = c.id)
           LEFT JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = '50')
             WHERE c.id <> '1'
          ORDER BY c.visible DESC,c.sortorder ASC;
# Time: 191007 10:03:50
# User@Host: SITENAME[SITENAME] @ localhost []
# Thread_id: 1641194  Schema: SITENAME  QC_hit: No
# Query_time: 3.476462  Lock_time: 0.000030  Rows_sent: 1  Rows_examined: 8
# Rows_affected: 0
SET timestamp=1570410230;
SELECT  g.id, g.name, g.description, g.descriptionformat, g.idnumber
                                   FROM mdl_groups g , mdl_groups_members gm 
                                  WHERE g.courseid = '89' AND g.id = gm.groupid AND gm.userid = '353'
                               ORDER BY name ASC;
# User@Host: SITENAME[SITENAME] @ localhost []
# Thread_id: 1641186  Schema: SITENAME  QC_hit: No
# Query_time: 3.720253  Lock_time: 0.000022  Rows_sent: 3  Rows_examined: 12
# Rows_affected: 0
SET timestamp=1570410230;
SELECT *
                                   FROM mdl_groups_members gm
                                   JOIN mdl_groups g
                                    ON g.id = gm.groupid
                                  WHERE gm.userid = '353'
                                   ORDER BY name ASC;
# Time: 191007 10:03:51
# User@Host: SITENAME[SITENAME] @ localhost []
# Thread_id: 1641207  Schema: SITENAME  QC_hit: No
# Query_time: 3.341557  Lock_time: 0.000046  Rows_sent: 3  Rows_examined: 12
# Rows_affected: 0
SET timestamp=1570410231;
SELECT *
                                   FROM mdl_groups_members gm
                                   JOIN mdl_groups g
                                    ON g.id = gm.groupid
                                  WHERE gm.userid = '397'
                                   ORDER BY name ASC;
# User@Host: SITENAME[SITENAME] @ localhost []
# Thread_id: 1641209  Schema: SITENAME  QC_hit: No
# Query_time: 3.522715  Lock_time: 0.000041  Rows_sent: 1  Rows_examined: 8
# Rows_affected: 0
SET timestamp=1570410231;
SELECT  g.id, g.name, g.description, g.descriptionformat, g.idnumber
                                   FROM mdl_groups g , mdl_groups_members gm 
                                  WHERE g.courseid = '44' AND g.id = gm.groupid AND gm.userid = '349'
                               ORDER BY name ASC;
# Time: 191007 10:03:53
# User@Host: SITENAME[SITENAME] @ localhost []
# Thread_id: 1641235  Schema: SITENAME  QC_hit: No
# Query_time: 3.176174  Lock_time: 0.000104  Rows_sent: 32  Rows_examined: 256
# Rows_affected: 0
SET timestamp=1570410233;
SELECT c.id,c.category,c.sortorder,c.shortname,c.fullname,c.idnumber,c.startdate,c.visible,c.defaultgroupingid,c.groupmode,c.groupmodeforce,c.summary,c.summaryformat,c.format,c.showgrades,c.lang,c.enablecompletion,c.enddate , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance
              FROM mdl_course c
              JOIN (SELECT DISTINCT e.courseid
                      FROM mdl_enrol e
                      JOIN mdl_user_enrolments ue ON (ue.enrolid = e.id AND ue.userid = '331')
                 WHERE ue.status = '0' AND e.status = '0' AND ue.timestart < 1570410200 AND (ue.timeend = 0 OR ue.timeend > 1570410200)
                   ) en ON (en.courseid = c.id)
           LEFT JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = '50')
             WHERE c.id <> '1'
          ORDER BY c.visible DESC,c.sortorder ASC;
# User@Host: SITENAME[SITENAME] @ localhost []
# Thread_id: 1641186  Schema: SITENAME  QC_hit: No
# Query_time: 3.115000  Lock_time: 0.000084  Rows_sent: 32  Rows_examined: 256
# Rows_affected: 0
SET timestamp=1570410233;
SELECT c.* , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance
              FROM mdl_course c
              JOIN (
                SELECT DISTINCT e.courseid
                  FROM mdl_enrol e
                  JOIN mdl_user_enrolments ue ON (ue.enrolid = e.id AND ue.userid = '353')
                 WHERE ue.status = '0' AND e.status = '0' AND ue.timestart < 1570410200
                       AND (ue.timeend = 0 OR ue.timeend > 1570410200)) en ON (en.courseid = c.id)
           LEFT JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = '50')
             WHERE c.id <> '1'
          ORDER BY c.visible DESC,c.sortorder ASC;