One Slow MySQL Query and the Index It Wanted

Read MySQL 8 EXPLAIN output for one slow query, choose composite index column order, make the index covering, and retire unused indexes safely by making them invisible first.