id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE d ref parentId, published parentId 5 const 2 Using where