id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE d index_merge parentId, published parentId, published 5, 2 2 Using intersect(parentId, published); Using where; Using index