indexが必要なところの調査

必要なところ

SELECT FROM skill WHERE EXISTS (SELECT FROM skill WHERE skill_name = ?)
SELECT match_group_id, match_group_name, description, status, created_by, created_at FROM match_group WHERE match_group_id = ? AND status = 'open'

SELECT user_id FROM user WHERE mail = ? AND password = ?
SELECT user_id, user_name, office_id, user_icon_id FROM user ORDER BY entry_date ASC, kana ASC LIMIT ? OFFSET ?
SELECT department_id FROM department WHERE department_name LIKE ? AND active = true
SELECT user_id FROM department_role_member WHERE department_id IN (?) AND belong = true
SELECT role_id FROM role WHERE role_name LIKE ? AND active = true
SELECT user_id FROM department_role_member WHERE role_id IN (?) AND belong = true
SELECT office_id FROM office WHERE office_name LIKE ?
SELECT user_id FROM user WHERE office_id IN (?)
SELECT skill_id FROM skill WHERE skill_name LIKE ?
SELECT department_name FROM department WHERE department_id = (SELECT department_id FROM department_role_member WHERE user_id = ? AND belong = true)

getUsersByKeywordの時色々なfieldが条件なので、全部indexを作成すると大変です。