深圳智汇创想科技有限公司

经分析，有部分允许为空的查询条件，在ORM生成的SQL里自动加了IFNULL函数导致索引失效，性能降低
SELECT Count(*) FROM `aml_amazon_product_base_dep81`  WHERE ((((( `CustomerID` = 1 ) AND ( `IsDelete` = 0 )) AND ( `IsActive` = 1 )) AND ( `IsHotData` = 0 )) AND  (IFNULL(`OrderSourceID`,0) IN (6173,6407,6464,6479,6484,6485,6486,6487,6499,6554,6556,6557,6558,6559,6560,6561,6562,6563,6564,6607,6637,6638,6639,6640,6652,6756,6775,6777,6783,6923,6924,6934,7121,7192,7196,7295,7296,7297,7298,7421,7701,7993,7995,8017,8018,8023,8024,8155,8240,8241,8242,8354,8357,8410,8411,8412,8413,8414,8428,8437,8505,8511,8520,8549,8676,8677,8678,8679,8687,8694,9057,9074,9112,9113,9114,9121,9283,9379,9380,9572,9661,9662,9663,9711,9712,9713,9714,9799,9804,9805,9876,9877,9892,9902,9903,9904,9905,10001,10043,10073,10075,10086,10087,10089,10094,10106,10107,10229,10230,10245,10246,10247,10255,10263,10264,10265,10266,10280,10281,10282,10283,10284,10285,10363,10386,10388,10395,10417,10427,10428,10429,10454,10465,10521,10522,10561,10709,10710,10906,10908,10916,10942,10952,10953,10954,11016,11033,11042,11043,11046,11057,11063,11066,11068,11070,11239,11267,11269,11302,11305,11351,11392,11398,11399,11400,11401,11638,11681,11694,11798,11811,11825,11838,11851,11866,11879,11892,11899,11961,11965,11979,11990,12015,12045,12059,12085,12091,12108,12119,12128,12193,12194,12261,12265,12272,12347,12361,12374,12394,12407,12420,12426,12439,12459,12474,12487,12505,12519,12545,12558,12594,12614,12629,12665,12682,12697,12717,12731,12739,12765,12777,12798,12812,12856,12883,12897,12911,12916,12937,12955,12968,13018,13037,13073,13082,13102,13107,13115,13135,13146,13186,13201,13289,13332,13337,13340,13343,13371,13401,13407,13410,13430,13468,13471,13491,13519,13520,13526,13529,13541,13563,13566,13569,13574,13577,13580,13583,13586,13589,13595,13598,13601,13604,13606,13624,13628,13629,13709,13809,13814,13819,13836,13841,13846,13851,13857,13870,13875,13924,13926,14288,14293,14302,14307,14312,14325,14338,14351,14364,14369,14468,14472,14478,14482,14486,14495,14501,14506,14511,14521,14525,14531,14536,14544,14558,14566,14569,14578,14582,14676,14680,14715,14719,14723,14727,14730,14741,14764,14776,14798,14802,14806,14818,14821,14833,14845,14857,14877,14897,14913,14925,14929,14933,14966,14971,14975,14996,15002,15012,15016,15029,15041,15067,15071,15084,15089,15136,15160,15163,15166,15179,15191,15212,15249,15260,15319,15336,15352,15370,15379,15387,15399,15413,15422,15488,15503,15522,15538,15550,15579,15594,15615,15638,15657,15672,15699,15731,15743,15766,15787,15803,15836,15885,15948,15963,15981,15998,16013,16028,16041,16056,16084,16153,16169,16186,16201,16226,16251,16265,16276,16293,16305,16317,16330,16342,16372,16391,16394,16439,16452,16489,16502,16524,16538,16551,16566,16586,16599,16612,16626,16644,16665,16680,16694,16707,16721,16735,16740,16754,16778,16791,16812,16826,16840,16863,16877,16891,16904,16918,16932,16946,16960,16981,16995,17009,17023,17026,17037,17051,17065,17079,17093,17110,17126,17146,17173,17221,17241,17378,17427,17442,17457,17542,17586,17622,17652,17667,17681,17701,17734,17747,17774,17808,17828,17844,17858,17872,17906,17940,17954,17998,18024,8160,8514,8515,8517,8524,8525,8540,8541,8543,8544,8548,8566,8567,8568,8569,8570,8571,8572,8573,8574,8594,8595,8597,8598,8599,8601,8602,8641,8642,8689,8992,9747,9946,9947,9969,9970,9971,9972,9973,9974,9975,9976,9977,9978,9979,9980,9981,9982,10000,10085,11991,12105,12201,12246,12249,12262,12266,12267,12269,12271,12287,12334,12341,12450,12530,12566,12573,12610,12611,13159,13431,13440,13444,13446,13448,13494,13798,14644,14672,14694,14697,14698,15322,15339,15355,15373,15416,15491,15525,15554,15582,15597,15641,15675,15678,15702,15769,15790,15806,15839,15874,15892,15894,15897,15898,15900,15902,15904,15950,15965,15983,15987,16002,16017,16044,16058,16086,16110,16112,16114,16116,16128,16139,16156,16158,16173,16175,16190,16229,16254,16281,16353,16358,16374,16966,16969,17159,17253,17687,17958,17960,17962,17968,18005,18006)) );

建议的解决方案：将实体模型对应的允许为空改为非空，在使用时候要做空值的处理。 另外也可以将ORM的方法改为执行SQL查询。

开发组已经处理更新！