Yo, optimize dat shit bruh, let's find a nice solution. Any comments are welcome, e.g. database storage type.

query.sql

(
  select *
  from `entity`
  where
      `id` = 1 
  and `subid` not in (3, 2, 1) 
  
) union all (
  select *
  from `entity`
  where 
      `subid` in (3, 2, 1)
  and `id` not in(1)
)