需要微调我在varchar列上有索引的mysql查询

I have a table which has nearly 2,000,000 records. I have a column(crmid) which is a varchar in that table. I wrote a query say, recor