varchar类型的字段,如果存的数字,in查询时一定要加引号,要不然特别损耗性能,特别慢。
SET STATISTICS TIME ON
SELECT * FROM TestA WHERE ID IN (150168,150169,150170,150171,150172,150173,150174)
SET STATISTICS TIME OFF
SET STATISTICS TIME ON
SELECT * FROM TestA WHERE ID IN ('150168','150169','150170','150171','150172','150173','150174')
SET STATISTICS TIME OFF