Sort (cost=17.83..17.84 rows=6 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=17.72..17.75 rows=6 width=44) |
Group Key: u.id |
-> Sort (cost=17.72..17.74 rows=6 width=44) |
Sort Key: u.id |
-> Hash Right Join (cost=9.13..17.64 rows=6 width=44) |
Hash Cond: (turs.user_id = u.id) |
Filter: ((turs.task_group_id = 196) OR (u.id = 1000)) |
-> Seq Scan on tbl_task_group_user_relationships turs (cost=0.00..7.33 rows=433 width=8) |
-> Hash (cost=7.39..7.39 rows=139 width=44) |
-> Seq Scan on tbl_users u (cost=0.00..7.39 rows=139 width=44) |