频繁的数据类型转换导致查询很慢

FROM RES_PORT_SEQ A,

(SELECT A.SEQ_UUID, A.ISTOP, A.STATUS, A.PORT_SEQ_NO, A.STATEFLAG

FROM RES_PORT_SEQ A

WHERE EXISTS (SELECT 0

FROM RES_DEV_TERMINAL B

WHERE B.ROOM_ID = '331856359'

AND B.INT_ID = A.PORT_ID)) B

WHERE A.STATEFLAG = 0

AND B.STATEFLAG = 0

AND A.ISTOP <> '0'

AND B.ISTOP <> '0'

AND A.STATUS = '0'

AND B.STATUS = '0'

AND A.OPTI_CIRCUIT_ID IS NULL

AND A.SEQ_UUID = B.SEQ_UUID

AND EXISTS (SELECT 0

FROM RES_DEV_TERMINAL B

WHERE B.ROOM_ID = '331856359'

AND B.INT_ID = A.PORT_ID);