sql 字符串 数值型不走索引

SQL_ID  99tfs2tpapwqk, child number 0
-------------------------------------
select count(*) num   from ( select a.*, b.client_name client_name2, 
a.err_msg err_msg2 from tbtranscfm a inner join tbclient b on 
a.in_client_no = b.in_client_no inner join tbtainfo c on c.ta_code = 
a.ta_code  where a.bank_acc= :1 and  (a.prd_code in ( select prd_code 
from tbproduct  where dep_id <> dep_id and ta_code='LF' and model_flag 
<> '1' union  select temp_b.prd_code from tbdataaccess_dep temp_a  
inner join tbproduct temp_b on temp_a.prd_code=temp_b.prd_code  where 
temp_a.dep_id='' and temp_a.reserve1 like '1%' and ta_code='LF' and 
model_flag <> '1' union  select