MySQL firstMatch策略

在业务上遇到一个sql，线下跑要1min半，到线上生产环境却只要0.5s，是一个子查询语句。

select issue_id, parent_id
FROM dq_result_ones_tasks
WHERE parent_id in (
SELECT issue_id
    FROM dq_result_ones_requirements
    WHERE issue_id in
          (5088896, 5088708, 5088680, 5088378, 5088267, 5088257, 5088066, 5088034, 5087963, 5087819,
           5087710, 5087708, 5087588, 5087556, 5087396, 5087081, 5086811, 5086791, 5086790, 5086199,
           5086180, 5086101, 5085934, 5085801, 5085779, 5085520, 5085470, 5085431, 5085403, 5085361,
           5085333, 5085309, 5085305, 5085118, 5084983, 5084914, 5084884, 5084813, 5084725, 5083584,
           5083517, 5083485, 5083475, 5083447, 5083323, 5083314, 5083312, 5083298, 5083297, 5083287,
           5083230, 5083202, 5083200, 5083198, 5083193, 5083190, 5083171, 5083155, 5082951, 5082917,
           5082808, 5082786, 5082703, 5082666, 5082622, 5082557, 5082534, 5082314, 5082238, 5081424,
           5081174, 5080563, 5080533, 5079649, 5079641, 5079599, 5079419, 5079418, 5079367, 5079285,
           5079282, 5079275, 5079261, 5079231, 5079228, 5079218, 5079160, 5079135, 5079132, 5079096,
           5079020, 5079014, 5078971, 5078936, 5078924, 5078815, 5078814, 5078712, 5078659, 5078658,
           5078602, 5078522, 5078223, 5078145, 5078135, 5078120, 5078094, 5078092, 5077997, 5077914,
           5077911, 5077900, 5077887, 5077848, 5077758, 5077623, 5077601, 5077565, 5077539, 5077526,
           5077420, 5077410, 5077364, 5077311, 5077157, 5077130, 5077075, 5077054, 5077040, 5077036,
           5077028, 5076944, 5076937, 5076891, 5076878, 5076804, 5076767, 5076622, 5076614, 5076607,
           5076588, 5076575, 5076548, 5076511, 5076497, 5076470, 5076440, 5076403, 5076402, 5076399,
           5076374, 5076330, 5076323, 5076310, 5076285, 5076275, 5076273, 5076253, 5076242, 5076225,
           5076224, 5076219, 5076211, 5076185, 5076130, 5076124, 5075735, 5075605, 5075596, 5075591,
           5075503, 5075422, 5075367, 5075317, 5075309, 5075298, 5075272, 5075125, 5075061, 5074900,
           5074833, 5074824, 5074801, 5074765, 5074755, 5074643, 5074424, 5074415, 5074405, 5074372,
           5074104, 5073727, 5073673, 5073650, 5073504, 5073468, 5073458, 5073403, 5073391, 5073389,
           5073162, 5073122, 5073003, 5072137, 5071971, 5071762, 5071720, 5071693, 5070806, 5070761,
           5070548, 5070501, 5070481, 5070467, 5070416, 5070371, 5070331, 5070330, 5070272, 5070215,
           5070214, 5070004, 5069980, 5069950, 5069908, 5069852, 5069847, 5069713, 5069562, 5069477,
           5069433, 5069431, 5069422, 5069378, 5069345, 5069308, 5069292, 5069278, 5069228, 5069213,
           5069089, 5069063, 5068891, 5068583, 5068544, 5068360, 5068332, 5068245, 5068222, 5068196,
           5068170, 5068163, 5068155, 5067949, 5067902, 5067901, 5067817, 5067802, 5067603, 5067074,
           5067051, 5067049, 5066944, 5066929, 5066921, 5066907, 5066897, 5066861, 5066819, 5066794,
           5066758, 5066756, 5066727, 5066724, 5066721, 5066623, 5066393, 5065621, 5065456, 5065387,
           5065379, 5065376, 5065369, 5065179, 5065120, 5065115, 5065006, 5064826, 5064791, 5064391,
           5064274, 5064270, 5064230, 5064188, 5064017, 5063871, 5063835, 5063824, 5063783, 5063721,
           5063343, 5061868, 5061205, 5060912, 5059616, 5059612, 5059608, 5058766, 5058705, 5058702,
           5058698, 5058697, 5058426, 5057676, 5057258, 5055531, 5051189, 5050688, 5050207, 5050014,
           5049657, 5049397, 5049371, 5049370, 5049353, 5049330, 5049283, 5049227, 5049142, 5049088,
           5048997, 5048995, 5048994, 5048974, 5048973, 5048942, 5048931, 5048920, 5048844, 5048782,
           5048770, 5048762, 5048746, 5048531, 5048514, 5048420, 5048415, 5048407, 5048385, 5048383,
           5048374, 5048366, 5048340, 5048330, 5048257, 5048243, 5047487, 5047410, 5047407, 5047405,
           5047289, 5047235, 5047179, 5047172, 5047165, 5047049, 5047017, 5046997, 5046914, 5046851,
           5046826, 5046756, 5046725, 5046677, 5046632, 5046577, 5046573, 5046556, 5046546, 5046523,
           5046520, 5046482, 5046473, 5046469, 5046451, 5046441, 5046428, 5046419, 5046395, 5046298,
           5046269, 5046210, 5046194, 5045682, 5045624, 5045523, 5045426, 5045413, 5045411, 5045401,
           5045070, 5044915, 5044695, 5044537, 5044536, 5044476, 5044167, 5044112, 5044038, 5043970,
           5043890, 5043813, 5043776, 5043759, 5043693, 5043689, 5043610, 5043602, 5043510, 5043462,
           5043390, 5043344, 5043342, 5043279, 5043206, 5043062, 5042988, 5042985, 5042963, 5042745,
           5042672, 5042621, 5042612, 5042536, 5042430, 5042381, 5042348, 5042221, 5042173, 5041984,
           5041967, 5041887, 5041612, 5041613, 5039717, 5038999, 5038957, 5038170, 5036144, 5035401,
           5035086, 5034941, 5034920, 5034773, 5033278, 5032103, 5031941, 5031898, 5031888, 5031814,
           5031803, 5031672, 5031221, 5030852, 5030452, 5030356, 5030292, 5030243, 5030142, 5030115,
           5030036, 5030004, 5029905, 5029900, 5029882, 5029777, 5029743, 5029741, 5029693, 5029571,
           5029553, 5029431, 5029145, 5028864, 5028757, 5028723, 5028589, 5028567, 5028400, 5028361,
           5028354, 5028073, 5028062, 5028057, 5027945, 5027935, 5027841, 5027759, 5027750, 5027655,
           5027602, 5027563, 5027367, 5027336, 5027308, 5027287, 5027255, 5027239, 5027234, 5027187,
           5027171, 5027111, 5027082, 5027081, 5027031, 5026989, 5026965, 5026909, 5026760, 5026678,
           5026651, 5026622, 5026576, 5026430, 5026421, 5026213, 5026171, 5026151, 5026127, 5026061,
           5026057, 5026008, 5025980, 5025891, 5025797, 5025745, 5025742, 5025365, 5024998, 5024981,
           5024808, 5024731, 5024702, 5023989, 5023984, 5023982, 5023975, 5023947, 5023442, 5023400,
           5023287, 5023234, 5023147, 5023116, 5022995, 5022826, 5022802, 5022787, 5022777, 5022740,
           5022706, 5022636, 5022545, 5022527, 5022481, 5022356, 5022348, 5022255, 5022250, 5022126,
           5022113, 5021930, 5021893, 5021801, 5021709, 5021673, 5021574, 5021548, 5021449, 5019749,
           5019735, 5019565, 5019521, 5019394, 5019313, 5019303, 5019168, 5019094, 5019058, 5019007,
           5018968, 5018959, 5018908, 5018873, 5018813, 5018743, 5018728, 5018680, 5018652, 5018495,
           5018224, 5017901, 5016977, 5016761, 5016186, 5015873, 5015847, 5015741, 5015651, 5015619,
           5015594, 5015593, 5015592, 5015578, 5015566, 5015560, 5015549, 5015522, 5015523, 5015495,
           5015473, 5015456, 5015442, 5015340, 5015119, 5015086, 5015055, 5015034, 5014988, 5014982,
           5014970, 5014935, 5014909, 5014866, 5014817, 5014791, 5014689, 5014622, 5014463, 5014455,
           5014127, 5014010, 5014003, 5013762, 5013562, 5013396, 5013356, 5013325, 5012334, 5010706,
           5010677, 5010616, 5010599, 5010548, 5010433, 5009953, 5009918, 5009867, 5009816, 5009502,
           5009454, 5009303, 5009041, 5008957, 5008631, 5008589, 5008587, 5008571, 5008502, 5008425,
           5008362, 5008343, 5008228, 5008022, 5007838, 5007811, 5007798, 5007773, 5007629, 5007613,
           5007589, 5007561, 5007515, 5006991, 5006721, 5006686, 5006654, 5006545, 5006540, 5006525,
           5006480, 5006384, 5005742, 5005668, 5005652, 5005467, 5005465, 5005442, 5005344, 5005325,
           5005288, 5005281, 5005278, 5005268, 5005263, 5005158, 5005099, 5005053, 5004913, 5004798,
           5004695, 5004500, 5004491, 5004414, 5004165, 5004123, 5004110, 5004025, 5003511, 5003490,
           5003103, 5002954, 5002719, 5002631, 5002585, 5002445, 5002432, 5002382, 5002379, 5002351,
           5002094, 5001366, 5000505, 5000202, 4994950, 4993132, 4992742, 4990821, 4990768, 4990760,
           4990757, 4990613, 4990587, 4990108, 4990084, 4990001, 4989984, 4989925, 4989875, 4989857,
           4989768, 4989738, 4989661, 4989294, 4988022, 4988011, 4987622, 4987583, 4987534, 4987430,
           4987429, 4987297, 4987253, 4987238, 4987201, 4987132, 4987091, 4987088, 4987082, 4987073,
           4987046, 4987032, 4987018, 4986968, 4986760, 4986533, 4986519, 4986503, 4986497, 4986428,
           4986220, 4986120, 4985983, 4985968, 4985957, 4985900, 4985847, 4985842, 4985736, 4985719,
           4985681, 4985644, 4985640, 4985200, 4984510, 4984131, 4984128, 4984050, 4983589, 4983585,
           4983523, 4983293, 4983208, 4983193, 4983060, 4982558, 4981786, 4981749, 4981531, 4981451,
           4981425, 4981389, 4981008, 4980973, 4980808, 4980716, 4980495, 4980482, 4980268, 4980122,
           4979482, 4979479, 4979151, 4978805, 4978498, 4977548, 4977110, 4976364, 4976268, 4975681,
           4974644, 4972477, 4964842, 4964742, 4964686, 4964675, 4964605, 4964494, 4964402, 4964385,
           4964347, 4964202, 4964198, 4964178, 4964053, 4964035, 4963971, 4963948, 4961381, 4960136,
           4959847, 4959349, 4957295, 4957145, 4957130, 4957116, 4957052, 4957041, 4956783, 4956759,
           4956693, 4956643, 4956551, 4956490, 4956457, 4956437, 4956433, 4956357, 4956291, 4956238,
           4956170, 4956114, 4956104, 4955992, 4955957, 4955955, 4955901, 4955857, 4955851, 4955712,
           4955632, 4955589, 4955525, 4955513, 4955508, 4955474, 4955424, 4955300, 4955227, 4955123,
           4955006, 4954957, 4954877, 4954806, 4954552, 4954277, 4954145, 4954082, 4953992, 4953928,
           4953901, 4953834, 4953824, 4953777, 4953696, 4953609, 4953422, 4953260, 4953127, 4953119,
           4953061, 4953008, 4952917, 4952570, 4952456, 4952386, 4952352, 4952299, 4952189, 4952113,
           4952094, 4952025, 4951982, 4951772, 4951694, 4951374, 4951336, 4951289, 4951064, 4951013,
           4950879, 4950869, 4950868, 4950682, 4950557, 4950509, 4950473, 4950464, 4950409, 4950329,
           4950249, 4950224, 4950090, 4949978, 4949906, 4949891, 4949741, 4949658, 4949628, 4949324,
           4949145, 4949014, 4948980, 4948970, 4948810, 4948785, 4948770, 4948639, 4948537, 4948502,
           4948491, 4948490, 4948464, 4948454, 4948390, 4948388, 4948187, 4948141, 4947963, 4947914,
           4947861, 4947822, 4947621, 4947600, 4947589, 4947571, 4947388, 4947383, 4947312, 4947305,
           4947233, 4947218, 4947169, 4947164, 4947088, 4947083, 4947080, 4947073, 4947070, 4947067,
           4947041, 4947001, 4946925, 4946846, 4946842, 4946839, 4946811, 4946805, 4946642, 4946500,
           4946360, 4946290, 4946249, 4945762, 4945757, 4945704, 4945682, 4945654, 4945652,