add new index on `measure_id` to speed up parent id lookups
mysql really wanted to have a join, give it one