Excessive database query when getting resource index (select ... from ... where id is null)

Excessive database query when getting resource index (select ... from ... where id is null) #2268