QUERY PLAN
Sort (cost=27.77..27.79 rows=10 width=44)
Sort Key: u.pinyin1 NULLS FIRST, u.namecut1 NULLS FIRST, u.pinyin2 NULLS FIRST, u.namecut2 NULLS FIRST, u.pinyin3 NULLS FIRST, u.namecut3 NULLS FIRST, u.pinyin4 NULLS FIRST, u.namecut4 NULLS FIRST
-> Group (cost=27.55..27.60 rows=10 width=44)
Group Key: u.id
-> Sort (cost=27.55..27.58 rows=10 width=44)
Sort Key: u.id
-> Hash Right Join (cost=18.24..27.39 rows=10 width=44)
Hash Cond: (turs.user_id = u.id)
Filter: ((turs.task_group_id = 106) OR (u.id = 1000))
-> Seq Scan on tbl_task_group_user_relationships turs (cost=0.00..7.83 rows=483 width=8)
-> Hash (cost=16.44..16.44 rows=144 width=44)
-> Seq Scan on tbl_users u (cost=0.00..16.44 rows=144 width=44)