mysql-create-index

2020-07-11T15:13:09.556506Z	1970928 Query	SHOW TABLES LIKE 'mdl\_%'
2020-07-11T15:13:09.560104Z	1970928 Query	CREATE TEMPORARY TABLE mdl_backup_ids_temp (
    id BIGINT(10) NOT NULL auto_increment,
    backupid VARCHAR(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '29c59f21596c4a54840f7b555a234447',
    itemname VARCHAR(160) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    itemid BIGINT(10) NOT NULL,
    newitemid BIGINT(10) NOT NULL DEFAULT 0,
    parentitemid BIGINT(10),
    info LONGTEXT COLLATE utf8mb4_unicode_ci,
CONSTRAINT  PRIMARY KEY (id)
) DEFAULT COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC
;
2020-07-11T15:13:09.584332Z	1970928 Query	CREATE INDEX mdl_backidstemp_bacitepar_ix ON mdl_backup_ids_temp (backupid, itemname, parentitemid)
;
2020-07-11T15:13:09.585628Z	1970928 Query	CREATE INDEX mdl_backidstemp_bacitenew_ix ON mdl_backup_ids_temp (backupid, itemname, newitemid)
;
2020-07-11T15:13:09.586994Z	1970928 Query	CREATE UNIQUE INDEX mdl_backidstemp_baciteite_uix ON mdl_backup_ids_temp (backupid, itemname, itemid)
2020-07-11T15:13:09.591832Z	1970928 Query	SELECT cm.*, cp.value AS version, m.name AS modulename, s.id AS sectionid, s.section AS sectionnumber
              FROM mdl_course_modules cm
              JOIN mdl_modules m ON m.id = cm.module
              JOIN mdl_config_plugins cp ON cp.plugin = CONCAT('mod_', m.name) AND cp.name = 'version'
              JOIN mdl_course_sections s ON s.id = cm.section
             WHERE cm.id = '43630'
2020-07-11T15:13:09.592889Z	1970928 Query	SELECT t.id, t.name, t.rawname
                                FROM mdl_tag t
                                JOIN mdl_tag_instance ti ON ti.tagid = t.id
                               WHERE ti.itemtype = 'course_modules'
                                 AND ti.component = 'core'
                                 AND ti.itemid = '43630'
2020-07-11T15:13:09.593585Z	1970928 Query	SELECT * FROM mdl_backup_ids_temp WHERE backupid = '29c59f21596c4a54840f7b555a234447' AND itemname = 'grouping'
2020-07-11T15:13:09.719925Z	1970986 Connect	moodleuser@localhost on moodle using Socket
2020-07-11T15:13:09.720487Z	1970986 Query	SET NAMES utf8mb4