AND ma10.store_cd IN ( 'SG0233', 'HN2112', 'SG0287', 'SG0225', 'SG0204', 'HN2144', 'HN2154', 'SG0093', 'SG0293', 'SG0194', 'HN2047', 'SG0162', 'SG0167', 'SG0276', 'SG0303', 'HN2179', 'SG0221', 'SG0123', 'SG0134', 'HN2135', 'SG0155', 'SG0070', 'SG0290', 'HN2080', 'SG0044', 'HN2035', 'SG0114', 'SG0147', 'SG0079', 'SG0074', 'SG0208', 'HN2183', 'SG0119', 'SG0089', 'SG0275', 'SG0130', 'SG0059', 'CT5011', 'VT3007', 'HN2123', 'HN2108','SG0004', 'HN2094', 'SG0068', 'HN2034', 'HL4004', 'SG0161', 'SG0042', 'HN2124', 'HN2134', 'HN2031', 'HN2105', 'SG0163', 'SG0021', 'HN2082', 'SG0278', 'SG0267', 'SG0056', 'SG0046', 'SG0075', 'SG0216', 'HN2101', 'HN2165', 'SG0142', 'SG0003', 'HN2148', 'HN2151', 'SG0263', 'HN2113', 'SG0232', 'SG0062', 'SG0207', 'SG0292', 'SG0064', 'HN2040', 'SG0217', 'SG0066', 'SG0254', 'SG0140', 'HN2058', 'SG0063', 'HP6007', 'SG0146', 'HN2002', 'HN2102', 'SG0249', 'SG0149', 'HN2090', 'HN2140', 'HN2104', 'HN2046', 'HN2117', 'SG0006', 'SG0122', 'HN2107', 'SG0060', 'SG0065', 'HN2223', 'SG0209', 'HN2070', 'SG0152', 'HL4001', 'SG0304', 'HN2068', 'HN2012', 'HN2006', 'HN2141', 'SG0193', 'CT5003', 'HP6001', 'SG0023', 'HN2051', 'SG0082', 'VT3004', 'HN2172', 'SG0215', 'VT3006', 'HN2036', 'HP6009', 'HN2071', 'SG0120', 'CT5006', 'SG0270', 'SG0281', 'HN2138', 'SG0180', 'V3019', 'SG0202', 'HN2018', 'SG0116', 'HN2084', 'SG0258', 'SG0111', 'HN2109', 'SG0160', 'HN2032', 'HN2023', 'SG0081', 'SG0018', 'SG0228', 'SG1111', 'SG0124', 'SG0097', 'SG0098', 'SG0148', 'SG0259', 'HN2050', 'HN2133', 'SG0031', 'HN2083', 'SG0257', 'SG0139', 'HN2126', 'HN2152', 'HN2164', 'SG0176', 'SG0237', 'HN2096', 'SG0083', 'HN2043', 'SG0205', 'SG0012', 'CT5009', 'VT3011', 'BD7002', 'HN2156', 'SG0115', 'HN2170', 'HN2163', 'VT3008', 'SG0222', 'SG0255', 'HN2132', 'HN2169', 'SG0307', 'SG0007', 'HN2088', 'HN2091', 'HN2053', 'SG0191', 'HN2049', 'HN2063','SG0166', 'HN2139', 'SG0226', 'SG0088', 'SG0085', 'SG0095', 'SG0229', 'HN2146', 'HN2136', 'VT3005', 'HN2086', 'SG0235', 'SG0239', 'HN2224', 'SG0027', 'SG0047', 'HN2130', 'SG0250', 'HN2057', 'HN2145', 'SG0178'
in很影响效率，为什么这么使用。
如果你有这样的需求的话，建议你可以将数据存到缓存中，每次拿数据直接从缓存中获取
in里面的字段太多会导致索引失效