EXISTS一次使用问题未解

SELECT * FROM tabA r
.......
EXISTS (
SELECT DISTINCT pid
FROM table_a 
WHERE id in(
				select a_id
				from table_b
				WHERE b_id = 234345
			)
 AND r.pid = pid
)

table_b 的查询只用了1秒，整个查询耗时确比下列查询多了数十倍

SELECT * FROM tabA r
.......
EXISTS (
SELECT DISTINCT pid
FROM table_a 
WHERE id in(
			 'a_id'
			)
 AND r.pid = pid

有大神指导下吗？