In and equal operator not working in query record type

i am having a record with the data 2million rows. And in our db table we don't have primary key so we created a custom primary key using multiple fields in the table

when i am trying to fetch the data from records i am getting the value when i am using includes operator in filter

but when i am trying to fetch the data from records i am not getting the value when i am using equal to operator in filter.