Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.1, 10.0.30, 10.2, 10.3
-
None
-
Linux Debian 8.8 Jessie
3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u2 (2017-06-26) x86_64 GNU/Linux
Description
We have switched from MySQL 5.5.55 to MariaDB 10.0.30 and have noticed a significant slowdown of the optimizer in the following scenario.
Create the following table:
CREATE TABLE IF NOT EXISTS `codes` (
|
`code_id` int unsigned not null auto_increment,
|
`root_code_id` int unsigned not null,
|
PRIMARY KEY (`code_id`),
|
KEY `ix_root_code_id` (`root_code_id`),
|
CONSTRAINT `fk_codes__root_code_id` FOREIGN KEY (`root_code_id`) REFERENCES `codes` (`code_id`)
|
) ENGINE = InnoDB;
|
Do not insert any data into it - leave it blank
Then run the following query:
SELECT SQL_NO_CACHE
|
*
|
FROM
|
codes
|
WHERE
|
/* Long IN clause */
|
code_id IN (
|
8842, 8843, 12117, 12119, 12120, 12147, 12363, 12930, 13541, 13542, 12122, 12123, 12128, 13505, 12080, 12107, 12121,
|
12129, 12130, 12131, 12132, 12133, 12135, 12136, 12138, 12139, 12140, 12141, 12142, 12143, 12144, 12145, 12146, 12149,
|
12150, 12151, 12152, 12153, 12154, 12155, 12156, 12157, 12158, 12159, 12160, 12161, 12162, 12163, 12164, 12165, 12166,
|
12167, 12168, 12169, 12170, 12171, 12172, 12173, 12174, 12175, 12176, 12177, 12178, 12179, 12180, 12181, 12182, 12183,
|
12184, 12185, 12186, 12187, 12188, 12189, 12190, 12191, 12192, 12193, 12194, 12195, 12196, 12197, 12198, 12199, 12200,
|
12201, 12202, 12203, 12204, 12205, 12206, 12207, 12208, 12209, 12210, 12211, 12212, 12213, 12216, 12217, 12218, 12219,
|
12220, 12221, 12222, 12223, 12224, 12225, 12226, 12227, 12228, 12229, 12230, 12231, 12232, 12233, 12234, 12235, 12236,
|
12237, 12238, 12239, 12240, 12241, 12242, 12243, 12244, 12245, 12246, 12247, 12248, 12249, 12250, 12251, 12252, 12253,
|
12254, 12255, 12256, 12257, 12258, 12259, 12260, 12261, 12262, 12263, 12264, 12265, 12266, 12267, 12268, 12269, 12270,
|
12271, 12272, 12273, 12274, 12275, 12276, 12277, 12278, 12279, 12280, 12281, 12282, 12283, 12284, 12285, 12286, 12287,
|
12288, 12289, 12290, 12291, 12292, 12293, 12294, 12295, 12296, 12297, 12298, 12299, 12300, 12301, 12302, 12303, 12304,
|
12305, 12306, 12307, 12308, 12309, 12310, 12311, 12312, 12313, 12314, 12315, 12316, 12317, 12318, 12319, 12320, 12322,
|
12323, 12324, 12325, 12326, 12327, 12328, 12329, 12330, 12331, 12332, 12333, 12334, 12335, 12336, 12337, 12338, 12339,
|
12340, 12341, 12342, 12343, 12344, 12345, 12346, 12347, 12348, 12349, 12350, 12351, 12352, 12353, 12354, 12355, 12356,
|
12357, 12358, 12359, 12365, 12366, 12368, 12369, 12370, 12371, 12372, 12373, 12374, 12375, 12377, 12378, 12379, 12380,
|
12381, 12382, 12383, 12384, 12385, 12386, 12387, 12388, 12390, 12391, 12392, 12393, 12394, 12395, 12396, 12397, 12398,
|
12399, 12400, 12401, 12402, 12403, 12404, 12405, 12406, 12407, 12409, 12410, 12411, 12412, 12413, 12414, 12415, 12416,
|
12417, 12418, 12420, 12421, 12422, 12423, 12424, 12425, 12426, 12428, 12429, 12430, 12431, 12432, 12433, 12435, 12436,
|
12437, 12438, 12439, 12440, 12441, 12442, 12443, 12444, 12445, 12446, 12447, 12448, 12449, 12450, 12451, 12452, 12453,
|
12454, 12455, 12456, 12457, 12458, 12459, 12460, 12461, 12462, 12463, 12464, 12465, 12466, 12467, 12468, 12469, 12470,
|
12471, 12472, 12473, 12474, 12475, 12476, 12477, 12478, 12479, 12480, 12481, 12482, 12483, 12484, 12485, 12486, 12487,
|
12488, 12489, 12490, 12491, 12492, 12493, 12494, 12495, 12496, 12497, 12498, 12499, 12500, 12501, 12502, 12503, 12504,
|
12506, 12507, 12508, 12509, 12510, 12511, 12512, 12513, 12514, 12515, 12516, 12517, 12518, 12519, 12520, 12521, 12522,
|
12523, 12524, 12525, 12526, 12527, 12528, 12529, 12530, 12531, 12532, 12533, 12534, 12535, 12536, 12537, 12538, 12539,
|
12540, 12541, 12542, 12543, 12544, 12545, 12546, 12547, 12548, 12549, 12550, 12551, 12552, 12553, 12554, 12555, 12556,
|
12557, 12558, 12559, 12560, 12561, 12562, 12563, 12564, 12565, 12567, 12569, 12570, 12571, 12572, 12573, 12574, 12575,
|
12576, 12577, 12578, 12579, 12580, 12581, 12582, 12583, 12584, 12585, 12586, 12587, 12588, 12589, 12590, 12591, 12592,
|
12593, 12594, 12595, 12596, 12597, 12598, 12599, 12600, 12601, 12602, 12603, 12604, 12605, 12606, 12607, 12609, 12610,
|
12611, 12612, 12613, 12614, 12615, 12616, 12617, 12618, 12619, 12620, 12621, 12622, 12623, 12624, 12625, 12626, 12627,
|
12628, 12629, 12630, 12632, 12633, 12634, 12635, 12636, 12637, 12638, 12639, 12640, 12641, 12642, 12643, 12644, 12645,
|
12646, 12647, 12648, 12649, 12650, 12651, 12652, 12653, 12654, 12655, 12656, 12657, 12658, 12659, 12660, 12661, 12662,
|
12663, 12664, 12665, 12666, 12667, 12668, 12669, 12670, 12671, 12672, 12673, 12674, 12675, 12676, 12677, 12678, 12679,
|
12680, 12681, 12682, 12683, 12684, 12685, 12686, 12687, 12688, 12691, 12692, 12693, 12694, 12695, 12696, 12697, 12698,
|
12699, 12700, 12701, 12702, 12703, 12704, 12705, 12707, 12708, 12709, 12710, 12711, 12712, 12713, 12714, 12715, 12716,
|
12718, 12719, 12720, 12721, 12722, 12723, 12724, 12725, 12726, 12727, 12728, 12729, 12730, 12731, 12732, 12733, 12734,
|
12736, 12737, 12738, 12739, 12740, 12741, 12742, 12743, 12745, 12746, 12747, 12749, 12750, 12751, 12752, 12754, 12755,
|
12756, 12757, 12758, 12759, 12760, 12761, 12762, 12763, 12764, 12765, 12767, 12768, 12769, 12770, 12771, 12772, 12773,
|
12774, 12775, 12776, 12777, 12778, 12779, 12780, 12781, 12782, 12783, 12784, 12786, 12787, 12788, 12789, 12790, 12791,
|
12792, 12793, 12794, 12795, 12796, 12797, 12798, 12800, 12801, 12802, 12803, 12804, 12805, 12806, 12807, 12808, 12809,
|
12810, 12813, 12814, 12815, 12816, 12817, 12818, 12819, 12820, 12821, 12822, 12823, 12824, 12825, 12826, 12827, 12828,
|
12829, 12830, 12831, 12832, 12833, 12834, 12835, 12836, 12837, 12838, 12839, 12840, 12841, 12842, 12843, 12844, 12845,
|
12846, 12847, 12848, 12849, 12850, 12852, 12853, 12854, 12855, 12856, 12857, 12858, 12859, 12860, 12861, 12862, 12863,
|
12864, 12865, 12866, 12867, 12868, 12869, 12870, 12871, 12872, 12873, 12874, 12875, 12876, 12877, 12878, 12879, 12880,
|
12881, 12882, 12883, 12884, 12885, 12886, 12887, 12888, 12889, 12890, 12891, 12892, 12893, 12894, 12895, 12896, 12897,
|
12898, 12899, 12900, 12901, 12902, 12903, 12904, 12905, 12906, 12907, 12908, 12909, 12910, 12911, 12912, 12913, 12914,
|
12915, 12916, 12917, 12918, 12919, 12920, 12921, 12922, 12923, 12924, 12925, 12926, 12927, 12928, 12929, 12931, 12932,
|
12933, 12934, 12935, 12936, 12937, 12938, 12939, 12940, 12941, 12942, 12943, 12944, 12945, 12946, 12947, 12948, 12949,
|
12950, 12951, 12952, 12953, 12954, 12955, 12956, 12957, 12958, 12959, 12960, 12961, 12962, 12963, 12964, 12965, 12966,
|
12967, 12968, 12969, 12970, 12971, 12972, 12973, 12974, 12975, 12976, 12977, 12978, 12979, 12980, 12981, 12982, 12983,
|
12984, 12985, 12986, 12987, 12988, 12989, 12990, 12991, 12992, 12993, 12994, 12995, 12996, 12997, 12998, 12999, 13000,
|
13001, 13002, 13003, 13004, 13005, 13006, 13007, 13008, 13009, 13010, 13011, 13012, 13013, 13014, 13015, 13016, 13017,
|
13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13026, 13027, 13028, 13029, 13030, 13031, 13032, 13033, 13034,
|
13035, 13036, 13037, 13038, 13040, 13041, 13042, 13043, 13044, 13045, 13046, 13047, 13048, 13049, 13050, 13051, 13052,
|
13053, 13054, 13055, 13056, 13057, 13058, 13059, 13060, 13061, 13062, 13063, 13064, 13065, 13066, 13067, 13068, 13069,
|
13070, 13071, 13072, 13073, 13074, 13075, 13076, 13077, 13079, 13080, 13081, 13082, 13083, 13084, 13085, 13087, 13088,
|
13089, 13090, 13091, 13092, 13093, 13094, 13095, 13096, 13097, 13098, 13099, 13100, 13101, 13102, 13103, 13104, 13105,
|
13106, 13107, 13108, 13109, 13110, 13111, 13112, 13113, 13114, 13115, 13116, 13117, 13118, 13119, 13120, 13121, 13122,
|
13123, 13124, 13125, 13126, 13127, 13128, 13129, 13130, 13131, 13132, 13133, 13134, 13135, 13136, 13137, 13138, 13139,
|
13140, 13141, 13142, 13143, 13144, 13145, 13146, 13147, 13148, 13149, 13150, 13151, 13152, 13153, 13154, 13155, 13156,
|
13157, 13158, 13159, 13160, 13161, 13162, 13163, 13164, 13165, 13166, 13167, 13168, 13169, 13170, 13171, 13172, 13173,
|
13174, 13175, 13176, 13177, 13178, 13179, 13180, 13181, 13182, 13183, 13184, 13185, 13186, 13187, 13188, 13189, 13190,
|
13191, 13192, 13193, 13194, 13195, 13196, 13197, 13198, 13199, 13200, 13201, 13202, 13203, 13204, 13205, 13206, 13207,
|
13208, 13209, 13210, 13211, 13212, 13213, 13214, 13215, 13216, 13217, 13218, 13219, 13220, 13221, 13222, 13223, 13224,
|
13225, 13226, 13227, 13228, 13229, 13230, 13231, 13232, 13233, 13234, 13235, 13236, 13237, 13238, 13239, 13240, 13241,
|
13242, 13243, 13244, 13245, 13246, 13247, 13248, 13249, 13250, 13251, 13252, 13253, 13254, 13255, 13256, 13257, 13258,
|
13259, 13260, 13261, 13262, 13263, 13267, 13268, 13269, 13271, 13272, 13273, 13274, 13275, 13276, 13277, 13278, 13279,
|
13280, 13281, 13282, 13283, 13284, 13285, 13286, 13287, 13288, 13289, 13290, 13291, 13292, 13293, 13294, 13295, 13296,
|
13297, 13298, 13299, 13300, 13301, 13302, 13303, 13304, 13305, 13306, 13307, 13308, 13309, 13310, 13311, 13312, 13313,
|
13314, 13315, 13316, 13317, 13318, 13319, 13320, 13321, 13322, 13323, 13324, 13325, 13326, 13327, 13328, 13329, 13330,
|
13331, 13332, 13333, 13334, 13335, 13336, 13337, 13338, 13339, 13340, 13341, 13342, 13343, 13344, 13345, 13346, 13347,
|
13348, 13349, 13350, 13351, 13352, 13353, 13354, 13355, 13356, 13357, 13358, 13359, 13360, 13361, 13362, 13365, 13366,
|
13367, 13368, 13369, 13370, 13371, 13372, 13373, 13374, 13375, 13376, 13377, 13378, 13379, 13380, 13381, 13382, 13383,
|
13384, 13385, 13386, 13387, 13388, 13389, 13390, 13391, 13392, 13393, 13394, 13395, 13396, 13397, 13398, 13400, 13401,
|
13402, 13403, 13404, 13405, 13406, 13407, 13408, 13409, 13410, 13411, 13412, 13413, 13414, 13415, 13416, 13417, 13418,
|
13419, 13420, 13421, 13422, 13423, 13424, 13425, 13426, 13427, 13428, 13429, 13430, 13431, 13432, 13433, 13434, 13435,
|
13436, 13437, 13438, 13439, 13440, 13441, 13442, 13443, 13444, 13445, 13446, 13447, 13448, 13449, 13450, 13451, 13452,
|
13453, 13456, 13457, 13459, 13460, 13461, 13462, 13463, 13464, 13465, 13466, 13467, 13468, 13469, 13470, 13471, 13472,
|
13473, 13474, 13475, 13476, 13477, 13478, 13479, 13480, 13481, 13482, 13483, 13484, 13485, 13486, 13487, 13488, 13489,
|
13490, 13491, 13492, 13493, 13494, 13495, 13496, 13497, 13498, 13499, 13500, 13501, 13502, 13508, 13509, 13510, 13511,
|
13512, 13513, 13514, 13515, 13516, 13517, 13518, 13519, 13520, 13521, 13522, 13523, 13524, 13525, 13526, 13527, 13528,
|
13529, 13530, 13531, 13532, 13533, 13534, 13536, 13537, 13538, 13539, 13540, 13543, 13544, 13545, 13546, 13547, 13548,
|
13549, 13550, 13551, 13552, 13553, 13554, 13555, 13556, 13558, 13559, 13560, 13561, 13562, 13563, 13564, 13565, 13566,
|
13567, 13569, 13570, 13571, 13572, 13573, 13574, 13575, 13576, 13577, 13578, 13579, 13580, 13581, 13582, 13584, 13585,
|
13586, 13587, 13588, 13589, 13590, 13591, 13592, 13593, 13594, 13595, 13596, 13597, 13598, 13599, 13600, 13601, 13602,
|
13603, 13604, 13605, 13606, 13607, 13608, 13609, 13610, 13611, 13612, 13613, 13614, 13615, 13616, 13617, 13618, 13619,
|
13620, 13621, 13622, 13623, 13624, 13625, 13626, 13627, 13628, 13629, 13630, 13631, 13632, 13633, 13634, 13635, 13636,
|
13637, 13638, 13639, 13640, 13641, 13642, 13643, 13644, 13645, 13646, 13647, 13648, 13649, 13650, 13651, 13652, 13653,
|
13654, 13655, 13656, 13657, 13658, 13659, 13660, 13661, 13662, 13663, 13664, 13665, 13666, 13667, 13668, 13669, 13670,
|
13671, 13672, 13673, 13674, 13675, 13676, 13677, 13678, 13679, 13680, 13681, 13682, 13683, 13684, 13685, 13686, 13687,
|
13688, 13689, 13690, 13691, 13692, 13693, 13694, 13695, 13696, 13697, 13698, 13699, 13700, 13701, 13702, 13703, 13704,
|
13705, 13706, 13707, 13708, 13709, 13710, 13711, 13712, 13713, 13714, 13715, 13716, 13717, 13718, 13719, 13720, 13721,
|
13722, 13723, 13724, 13725, 13726, 13727, 13728, 13729, 13730, 13731, 13732, 13733, 13734, 13735, 13736, 13737, 13738,
|
13739, 13740, 13741, 13742, 13743, 13744, 13745, 13746, 13747, 13748, 13749, 13750, 13751, 13752, 13753, 13754, 13755,
|
13756, 13757, 13759, 13761, 13762, 13763, 13764, 13765, 13766, 13767, 13768, 13769, 13770, 13771, 13772, 13773, 13774,
|
13775, 13776, 13777, 13778, 13779, 13780, 13781, 13782, 13783, 13784, 13785, 13786, 13787, 13788, 13789, 13790, 13791,
|
13792, 13793, 13794, 13795, 13796, 13797, 13798, 13799, 13800, 13801, 13802, 13803, 13804, 13805, 13806, 13807, 13808,
|
13809, 13810, 13811, 13812, 13813, 13814, 13815, 13816, 13817, 13818, 13819, 13820, 13821, 13822, 13823, 13824, 13825,
|
13826, 13827, 13828, 13829, 13830, 13831, 13832, 13833, 13834, 13835, 13836, 13837, 13838, 13839, 13840, 13841, 13842,
|
13843, 13844, 13845, 13846, 13847, 13848, 13849, 13850, 13851, 13852, 13853, 13854, 13855, 13856, 13857, 13858, 13859,
|
13860, 13861, 13862, 13863, 13864, 13865, 13866, 13867, 13868, 13869, 13870, 13871, 13872, 13873, 13874, 13875, 13876,
|
13877, 13878, 13879, 13880, 13881, 13882, 13883, 13884, 13885, 13886, 13887, 13888, 13889, 13890, 13891, 13892, 13893,
|
13894, 13895, 13896, 13897, 13898, 13899, 13900, 13901, 13902, 13903, 13904, 13905, 13906, 13907, 13908, 13909, 13910,
|
13911, 13912, 13913, 13914, 13915, 13916, 13917, 13918, 13919, 13921, 13922, 13923, 13924, 13925, 13926, 13927, 13928,
|
13929, 13930, 13931, 13932, 13933, 13934, 13935, 13936, 13937, 13938, 13939, 13940, 13941, 13942, 13943, 13944, 13945,
|
13946, 13947, 13948, 13949, 13950, 13951, 13952, 13953, 13954, 13955, 13956, 13957, 13958, 13959, 13960, 13961, 13962,
|
13963, 13964, 13965, 13966, 13967, 13968, 13969, 13970, 13971, 13972, 13973, 13974, 13975, 13976, 13977, 13978, 13979,
|
13980, 13981, 13982, 13983, 13984, 13985, 13986, 13987, 13988, 13989, 13990, 13991, 13993, 13994, 13995, 13996, 13997,
|
13998, 13999, 14000, 14001, 14002, 14003, 14004, 14005, 14006, 14007, 14015, 14024, 14025, 14026, 14027, 14028, 14029,
|
14031, 14032, 14033, 14034, 14035, 14036, 14037, 14038, 14039, 14040, 14041, 14042, 14043, 14044, 14045, 14046, 14047,
|
14048, 14049, 14050, 14051, 14052, 14053, 14054, 14055, 14056, 14057, 14058, 14059, 14060, 14061, 14062, 14064, 14065,
|
14066, 14067, 14068, 14069, 14070, 14071, 14072, 14073, 14074, 14075, 14076, 14077, 14078, 14079, 14080, 14081, 14088,
|
14089, 14090, 14091, 14092, 14093, 14094, 14095, 14096, 14097, 14098, 14099, 14100, 14101, 14102, 14103, 14104, 14105,
|
14106, 14107, 14108, 14109, 14110, 14111, 14112, 14113, 14114, 14115, 14116, 14117, 14119, 14120, 14121, 14122, 14123,
|
14124, 14125, 14126, 14127, 14128, 14129, 14130, 14131, 14132, 14133, 14135, 14136, 14137, 14138, 14139, 14140, 14141,
|
14142, 14143, 14144, 14145, 14146, 14147, 14148, 14149, 14150, 14151, 14152, 14153, 14154, 14155, 14156, 14157, 14158,
|
14159, 14160, 14161, 14162, 14163, 14164, 14165, 14166, 14167, 14168, 14169, 14170, 14171, 14172, 14173, 14174, 14175,
|
14176, 14178, 14179, 14180, 14181, 14182, 14183, 14184, 14185, 14186, 14187, 14188, 14189, 14190, 14191, 14192, 14193,
|
14194, 14195, 14196, 14197, 14198, 14199, 14200, 14201, 14202, 14203, 14204, 14205, 14206, 14207, 14208, 14209, 14210,
|
14211, 14212, 14213, 14214, 14215, 14216, 14217, 14218, 14219, 14220, 14221, 14222, 14223, 14224, 14225, 14226, 14227,
|
14228, 14229, 14230, 14231, 14232, 14233, 14234, 14235, 14236, 14237, 14238, 14239, 14240, 14241, 14242, 14243, 14244,
|
14245, 14246, 14247, 14248, 14249, 14250, 14251, 14252, 14253, 14254, 14255, 14256, 14257, 14258, 14259, 14260, 14261,
|
14262, 14263, 14264, 14265, 14266, 14267, 14268, 14269, 14270, 14271, 14272, 14273, 14274, 14275, 14276, 14277, 14278,
|
14279, 14280, 14281, 14282, 14283, 14284, 14285, 14286, 14287, 14288, 14289, 14290, 14291, 14292, 14293, 14294, 14295,
|
14296, 14297, 14298, 14299, 14300, 14301, 14302, 14303, 14304, 14305, 14306, 14307, 14308, 14309, 14310, 14311, 14312,
|
14313, 14314, 14315, 14316, 14317, 14318, 14319, 14320, 14321, 14322, 14323, 14324, 14325, 14326, 14327, 14328, 14329,
|
14330, 14331, 14332, 14333, 14334, 14335, 14336, 14337, 14338, 14339, 14340, 14341, 14342, 14343, 14344, 14345, 14346,
|
14347, 14348, 14349, 14350, 14351, 14352, 14353, 14354, 14355, 14356, 14357, 14359, 14360, 14361, 14362, 14363, 14364,
|
14365, 14367, 14368, 14369, 14370, 14371, 14372, 14373, 14374, 14375, 14376, 14377, 14378, 14379, 14380, 14381, 14382,
|
14383, 14384, 14385, 14386, 14387, 14388, 14389, 14390, 14391, 14392, 14393, 14394, 14395, 14396, 14397, 14398, 14400,
|
14401, 14402, 14403, 14404, 14405, 14406, 14407, 14408, 14409, 14410, 14411, 14412, 14413, 14414, 14415, 14416, 14419,
|
14420, 14421, 14422, 14423, 14424, 14425, 14426, 14427, 14428, 14429, 14430, 14431, 14432, 14433, 14434, 14435, 14436,
|
14437, 14438, 14439, 14440, 14441, 14442, 14443, 14444, 14446, 14447, 14448, 14449, 14450, 14451, 14452, 14453, 14454,
|
14455, 14456, 14457, 14458, 14459, 14460, 14461, 14462, 14463, 14464, 14465, 14466, 14467, 14468, 14469, 14470, 14471,
|
14472, 14473, 14474, 14475, 14476, 14477, 14478, 14480, 14481, 14482, 14483, 14484, 14485, 14486, 14487, 14488, 14489,
|
14490, 14491, 14492, 14493, 14494, 14495, 14496, 14497, 14498, 14499, 14500, 14501, 14502, 14503, 14504, 14505, 14506,
|
14507, 14508, 14509, 14510, 14511, 14512, 14513, 14514, 14515, 14516, 14517, 14518, 14519, 14520, 14521, 14522, 14524,
|
14525, 14527, 14528, 14529, 14530, 14531, 14532, 14533, 14534, 14535, 14536, 14537, 14538, 14539, 14540, 14541, 14542,
|
14543, 14544, 14545, 14546, 14547, 14548, 14549, 14550, 14551, 14552, 14553, 14554, 14555, 14556, 14557, 14558, 14559,
|
14560, 14561, 14562, 14563, 14564, 14565, 14566, 14567, 14568, 14569, 14570, 14571, 14572, 14573, 14574, 14575, 14576,
|
14577, 14578, 14579, 14580, 14581, 14582, 14583, 14584, 14586, 14587, 14588, 14589, 14590, 14591, 14592, 14593, 14594,
|
14595, 14596, 14597, 14598, 14599, 14600, 14602, 14603, 14604, 14605, 14606, 14607, 14608, 14609, 14610, 14611, 14612,
|
14613, 14614, 14615, 14616, 14617, 14618, 14619, 14620, 14621, 14622, 14623, 14624, 14625, 14626, 14627, 14628, 14629,
|
14630, 14631, 14632, 14633, 14634, 14635, 14636, 14637, 14638, 14639, 14640, 14641, 14642, 14643, 14644, 14645, 14646,
|
14647, 14648, 14649, 14650, 14651, 14652, 14653, 14654, 14655, 14656, 14657, 14658, 14659, 14660, 14661, 14662, 14663,
|
14664, 14665, 14666, 14667, 14668, 14669, 14670, 14671, 14672, 14673, 14674, 14675, 14676, 14677, 14678, 14679, 14680,
|
14681, 14682, 14683, 14684, 14685, 14686, 14687, 14688, 14689, 14690, 14691, 14692, 14693, 14694, 14695, 14696, 14697,
|
14698, 14699, 14700, 14701, 14702, 14703, 14704, 14705, 14706, 14707, 14708, 14709, 14710, 14711, 14712, 14713, 14714,
|
14715, 14716, 14717, 14718, 14719, 14720, 14721, 14722, 14723, 14724, 14725, 14726, 14727, 14728, 14729, 14730, 14731,
|
14732, 14733, 14734, 14735, 14737, 14738, 14739, 14740, 14741, 14742, 14743, 14744, 14745, 14746, 14747, 14748, 14749,
|
14750, 14751, 14752, 14753, 14754, 14758, 14759, 14760, 14761, 14762, 14763, 14764, 14765, 14766, 14767, 14769, 14770,
|
14771, 14772, 14773, 14774, 14775, 14776, 14778, 14779, 14780, 14781, 14782, 14783, 14784, 14785, 14786, 14787, 14788,
|
14789, 14790, 14791, 14792, 14793, 14794, 14795, 14796, 14797, 14798, 14799, 14800, 14801, 14802, 14803, 14804, 14805,
|
14806, 14807, 14808, 14809, 14810, 14811, 14812, 14813, 14814, 14816, 14817, 14818, 14819, 14820, 14821, 14822, 14823,
|
14824, 14825, 14826, 14827, 14828, 14829, 14830, 14831, 14832, 14833, 14834, 14835, 14836, 14837, 14838, 14839, 14841,
|
14844, 14845, 14846, 14847, 14848, 14849, 14850, 14851, 14852, 14853, 14854, 14855, 14856, 14857, 14858, 14859, 14860,
|
14861, 14862, 14863, 14864, 14865, 14866, 14867, 14868, 14869, 14870, 14871, 14872, 14873, 14874, 14875, 14876, 14877,
|
14878, 14879, 14880, 14881, 14882, 14883, 14884, 14885, 14886, 14887, 14888, 14889, 14890, 14891, 14892, 14893, 14894,
|
14895, 14896, 14897, 14898, 14899, 14900, 14901, 14902, 14903, 14904, 14905, 14906, 14907, 14908, 14910, 14911, 14912,
|
14913, 14914, 14915, 14916, 14917, 14918, 14919, 14920, 14921, 14922, 14923, 14924, 14925, 14926, 14927, 14928, 14929,
|
14930, 14931, 14932, 14933, 14934, 14935, 14936, 14937, 14938, 14939, 14940, 14941, 14942, 14943, 14944, 14945, 14946,
|
14947, 14948, 14949, 14950, 14951, 14952, 14954, 14955, 14956, 14957, 14958, 14959, 14960, 14961, 14962, 14963, 14964,
|
14965, 14966, 14967, 14968, 14969, 14970, 14971, 14972, 14973, 14974, 14975, 14976, 14977, 14978, 14979, 14980, 14981,
|
14982, 14983, 14984, 14985, 15784, 15819, 44911, 44920, 44923, 44935, 44944, 44950, 44955, 44958, 44966, 44997, 45022,
|
45024, 45037, 45038, 45059, 45087, 45113, 45136, 45310, 45422, 45890, 46419, 46423, 46511, 46512, 46521, 46523, 46525,
|
46529, 46531, 46541, 46545, 46548, 46555, 46557, 46566, 46571, 46574, 46580, 46583, 46584, 46605, 46608, 46613, 46619,
|
46627, 46628, 46630, 46639, 46643, 46645, 46646, 46648, 46650, 46652, 46660, 46664, 46665, 46669, 46676, 46678, 46692,
|
46700, 46702, 46703, 46706, 46711, 46724, 46728, 46730, 46731, 46732, 46733, 46736, 46739, 46741, 46743, 46745, 46748,
|
46751, 46767, 46769, 46770, 46771, 46774, 46777, 46780, 46781, 46787, 46790, 46791, 46792, 46795, 46796, 46797, 46803,
|
46809, 46814, 46817, 46823, 46826, 46830, 46831, 46836, 46838, 46843, 46847, 46856, 46857, 46858, 46859, 46866, 46870,
|
46871, 46876, 46879, 46894, 46900, 46906, 46909, 46910, 46914, 46929, 46930, 46933, 46937, 46939, 46940, 46941, 46942,
|
46943, 46945, 46949, 46950, 46951, 46955, 46957, 46958, 46959, 46960, 46962, 46963, 46964, 46966, 46967, 46970, 46977,
|
46980, 46987, 46988, 46990, 46994, 46995, 47004, 47022, 47024, 47026, 47032, 47034, 47035, 47038, 47040, 47043, 47044,
|
47046, 47047, 47049, 47051, 47056, 47059, 47060, 47062, 47065, 47067, 47069, 47070, 47071, 47072, 47073, 47076, 47077,
|
47079, 47080, 47081, 47085, 47086, 47088, 47090, 47091, 47094, 47095, 47096, 47100, 47101, 47102, 47103, 47104, 47105,
|
47106, 47109, 47111, 47112, 47113, 47115, 47116, 47121, 47124, 47128, 47130, 47131, 47137, 47138, 47140, 47141, 47142,
|
47145, 47146, 47150, 47151, 47152, 47153, 47163, 47164, 47167, 47169, 47170, 47171, 47172, 47175, 47176, 47177, 47178,
|
47179, 47183, 47189, 47199, 47200, 47205, 47207, 47208, 47210, 47214, 47216, 47230, 47233, 47234, 47235, 47237, 47241,
|
47244, 47249, 47251, 47253, 47258, 47259, 47263, 47266, 47269, 47270, 47273, 47278, 47285, 47292, 47295, 47297, 47301,
|
47305, 47307, 47313, 47314, 47320, 47321, 47325, 47329, 47330, 47331, 47332, 47335, 47337, 47339, 47342, 47343, 47344,
|
47354, 47355, 47360, 47370, 47375, 47381, 47382, 47391, 47394, 47396, 47397, 47399, 47401, 47403, 47405, 47408, 47416,
|
47418, 47423, 47425, 47428, 47434, 47441, 47443, 47445, 47448, 47449, 47450, 47453, 47454, 47455, 47457, 47460, 47461,
|
47462, 47463, 47468, 47471, 47472, 47473, 47474, 47476, 47477, 47478, 47485, 47493, 47505, 47509, 47511, 47517, 47519,
|
47520, 47524, 47526, 47527, 47530, 47531, 47539, 47542, 47547, 47548, 47551, 47558, 47561, 47562, 47564, 47580, 47582,
|
47592, 47593, 47596, 47599, 47600, 47603, 47608, 47609, 47612, 47624, 47632, 47634, 47636, 47638, 47649, 47669, 47678,
|
47679, 47681, 47682, 47683, 47684, 47699, 47702, 47703, 47704, 47706, 47708, 47712, 47714, 47715, 47716, 47718, 47727,
|
47729, 47730, 47733, 47737, 47747, 47753, 47758, 47760, 47767, 47771, 47779, 47780, 47784, 47790, 47791, 47794, 47800,
|
47803, 47809, 47816, 47818, 47819, 47820, 47825, 47833, 47834, 47838, 47840, 47841, 47845, 47847, 47851, 47852, 47854,
|
47857, 47858, 47859, 47863, 47864, 47870, 47873, 47878, 47879, 47883, 47888, 47900, 47908, 47910, 47913, 47917, 47947,
|
47950, 47955, 47956, 47957, 47959, 47962, 47963, 47964, 47965, 47967, 47973, 47975, 47980, 47994, 47996, 48001, 48002,
|
48005, 48009, 48010, 48012, 48014, 48020, 48023, 48024, 48032, 48033, 48042, 48056, 48057, 48073, 48086, 48089, 48097,
|
48105, 48110, 48118, 48126, 48131, 48138, 48144, 48148, 48151, 48153, 48154, 48160, 48165, 48170, 48172, 48174, 48177,
|
48183, 48184, 48190, 48198, 48204, 48208, 48209, 48211, 48213, 48218, 48223, 48229, 48232, 48234, 48239, 48241, 48244,
|
48245, 48248, 48249, 48250, 48258, 48261, 48265, 48269, 48270, 48273, 48275, 48281, 48285, 48294, 48300, 48301, 48302,
|
48307, 48312, 48314, 48319, 48321, 48324, 48326, 48327, 48328, 48330, 48331, 48333, 48338, 48342, 48352, 48355, 48357,
|
48358, 48374, 48387, 48393, 48394, 48398, 48400, 48408, 48411, 48412, 48418, 48426, 48435, 48446, 48451, 48453, 48457,
|
48458, 48459, 48462, 48463, 48466, 48467, 48471, 48472, 48482, 48489, 48491, 48499, 48501, 48503, 48508, 48509, 48513,
|
48514, 48518, 48523, 48529, 48530, 48532, 48537, 48538, 48541, 48546, 48551, 48554, 48563, 48565, 48570, 48587, 48595,
|
48598, 48601, 48603, 48607, 48609, 48610, 48618, 48621, 48624, 48633, 48642, 48645, 48648, 48652, 48657, 48662, 48671,
|
48673, 48674, 48683, 48692, 48695, 48710, 48711, 48715, 48723, 48738, 48746, 48747, 48765, 48781, 48782, 48793, 48795,
|
48798, 48799, 48815, 48823, 48826, 48864, 48871, 48882, 48886, 48891, 48895, 48898, 48913, 48918, 48919, 48931, 48945,
|
48946, 48954, 48957, 48958, 48968, 48969, 48972, 48974, 48978, 48994, 49013, 49042, 49051, 49054, 49056, 49069, 49073,
|
49078, 49083, 49086, 49087, 49093, 49105, 49108, 49109, 49112, 49134, 49135, 49153, 49182, 49183, 49187, 49192, 49201,
|
49209, 49216, 49218, 49220, 49232, 49255, 49322, 49329, 49330, 49331, 49342, 49357, 49362, 49378, 49380, 49381, 49382,
|
49399, 49415, 49446, 49450, 49453, 49457, 49460, 49480, 49484, 49486, 49491, 49505, 49506, 49521, 49522, 49537, 49549,
|
49554, 49557, 49622, 49627, 49631, 49637, 49646, 49649, 49677, 49681, 49685, 49686, 49704, 49711, 49714, 49729, 49730,
|
49740, 49744, 49758, 49786, 49798, 49818, 49827, 49848, 49849, 49853, 49856, 49859, 49860, 49880, 49892, 49950, 49951,
|
49955, 49980, 49994, 50001, 50002, 50009, 50013, 50036, 50062, 50064, 50075, 50079, 50081, 50083, 50084, 50091, 50093,
|
50108, 50109, 50119, 50128, 50130, 50131, 50160, 50167, 58256, 58257, 58266, 58311, 58332, 58338, 58342, 58369, 58374,
|
58381, 58382, 58391, 58402, 58407, 58409, 58439, 58441, 58442, 58457, 58483, 58521, 58531, 58539, 58543, 58545, 58568,
|
58571, 58572, 58582, 58590, 58594, 58609, 58611, 58612, 58633, 58654, 58687, 58693, 58696, 58707, 58715, 58745, 58779,
|
58850, 58855, 58870, 58890, 58945, 58950, 58985, 59023, 59026, 59042, 59043, 59053, 59062, 59064, 59081, 59091, 59092,
|
59096, 59097, 59111, 59112, 59131, 59205, 59215, 59287, 59332, 59339, 59346, 59363, 59378, 59440, 59441, 59453, 59463,
|
59466, 59468, 59702, 59796, 59798, 59799, 59825, 59843, 59844, 59845, 59846, 59848, 59858, 59883, 8856, 14009, 14011,
|
8865, 8866, 8807, 8808, 8809, 8810, 8811, 8812, 8813, 8814, 8815, 8816, 8817, 8818, 8819, 8820, 8821, 8822, 8823, 8824,
|
8825, 8826, 8827, 8828, 8829, 8830, 8831, 8832, 8833, 8834, 8835, 8836, 8837, 8838, 8839, 8876, 13363, 8868, 8871, 14063,
|
8873, 12214, 8877, 8879, 8880, 8881, 8882, 14086, 14757, 33443, 33442, 8775, 8776, 8786, 8845, 8846, 8847, 8848, 12083,
|
12087, 12090, 12091, 12093, 12111, 12112, 12115, 13364, 13454, 13506, 13920, 14008, 14010, 14014, 14016, 14018, 14019,
|
14020, 14021, 14022, 14023, 14030, 14082, 14084, 14085, 14087, 14445, 14736, 14768, 14953, 12321, 12376, 12389, 12408,
|
12419, 12427, 12434, 12566, 12608, 12631, 12706, 12717, 12735, 12744, 12748, 12753, 12785, 12799, 12811, 12851, 13264,
|
13265, 13266, 13270, 13399, 13503, 13504, 13535, 13760, 13992, 14118, 14134, 14177, 14358, 14366, 14399, 14417, 14418,
|
14523, 14526, 14755, 14909, 16926, 16927, 16928, 16929, 16930, 16931, 16932, 16933, 16934, 16935, 16936, 16937, 16938,
|
16939, 16940, 16941, 16942, 16943, 16944, 16945, 16946, 16947, 16948, 16949, 16950, 16951, 16952, 16953, 16954, 16955,
|
16956, 16957, 16958, 16959, 16960, 16961, 16962, 16963, 16964, 16965, 16966, 16967, 16968, 16969, 16970, 16971, 16972,
|
16973, 16974, 16975, 16976, 16977, 16978, 16979, 16980, 16981, 16982, 16983, 16984, 16985, 16986, 16987, 16988, 16989,
|
16990, 16991, 16992, 16993, 16994, 16995, 16996, 16997, 16998, 16999, 17000, 17001, 17002, 17003, 17004, 17005, 17006,
|
17007, 17008, 17009, 17010, 17011, 17012, 17013, 17014, 17015, 17016, 17017, 17018, 17019, 17020, 17021, 17022, 17023,
|
17024, 17025, 17026, 17027, 17028, 17029, 17030, 17031, 17032, 17033, 17034, 17035, 17036, 17037, 17038, 17039, 17040,
|
17041, 17042, 17043, 17044, 17045, 17046, 17047, 17048, 17049, 17050, 17051, 17052, 17053, 17054, 17055, 17056, 17057,
|
17058, 17059, 17060, 17061, 17062, 17063, 17064, 17065, 17066, 17067, 17068, 17069, 17070, 17071, 17072, 17073, 17074,
|
17075, 17076, 17077, 17078, 17079, 17080, 17081, 17082, 17083, 17084, 17085, 17086, 17087, 17088, 17089, 17090, 17091,
|
17092, 17093, 17094, 17095, 17096, 17097, 17098, 17099, 17100, 17101, 17102, 17607, 22959, 22969, 23045, 23267, 23332,
|
23396, 23398, 23692, 23729, 23781, 23786, 24028, 24042, 24046, 24047, 24092, 24169, 24185, 24189, 24204, 24206, 24209,
|
24221, 24237, 24261, 24289, 24292, 24318, 24374, 24375, 24442, 24459, 24564, 24587, 24882, 27132, 27139, 27403, 27817,
|
27901, 27996, 28368, 28583, 28604, 29348, 29357, 31653, 32737, 33438, 33441, 35118, 35929, 43106, 44275, 45637, 46354,
|
50445, 50887, 50888, 50889, 50890, 50891, 50892, 50893, 50894, 50895, 50896, 50897, 50898, 50899, 50900, 50901, 50902,
|
50903, 50904, 50905, 50906, 50907, 50908, 50909, 50910, 50911, 50912, 17634, 17635, 17636, 17637, 17638, 17639, 17640,
|
17641, 17642, 17643, 17644, 17645, 17646, 17647, 17648, 17649, 17650, 17651, 17652, 17653, 17654, 17655, 17656, 17657,
|
17658, 17659, 17660, 17661, 17662, 17663, 17664, 17665, 17666, 17667, 17668, 17669, 17670, 17671, 17672, 17673, 17674,
|
17675, 17676, 17677, 17678, 17679, 17680, 17681, 17682, 17683, 17684, 17685, 17686, 17687, 17688, 17689, 17690, 17691,
|
17692, 17693, 17694, 17695, 17696, 17697, 17698, 17699, 17700, 17701, 17702, 17703, 17704, 17705, 17706, 17707, 17708,
|
17709, 17710, 17711, 17712, 17713, 17714, 17715, 17716, 17717, 17718, 17719, 17720, 17721, 17722, 17723, 17724, 17725,
|
17726, 17727, 17728, 17729, 17730, 17731, 17732, 17733, 17734, 17735, 17736, 17737, 17738, 17739, 17740, 17741, 17742,
|
17743, 17744, 17745, 17746, 17747, 17748, 17749, 17750, 17751, 17752, 17753, 17754, 17755, 17756, 17757, 17758, 17759,
|
17760, 17761, 17762, 17763, 17764, 17765, 17766, 17767, 17768, 17769, 17770, 17771, 17772, 17773, 17774, 17775, 17776,
|
24344, 24370, 24410, 24449, 24456, 24462, 50968, 17361, 17362, 33435, 50952, 50953, 50954, 50955, 50956, 17425, 17426, 17427, 17428, 17429, 33437, 50957, 8883, 8884, 13086, 13583, 17430, 17431, 17432, 17433,
|
17434, 17435, 17436, 17437, 17438, 17439, 17440, 17441, 17442, 17103, 8777, 8778, 8779, 8780, 8781, 8782, 8783, 8784, 8785, 8787, 8788, 8789, 8790, 8791, 8792, 8793, 8794, 8795, 8796, 8797, 8798, 8799, 8800, 88
|
01, 8802, 8803, 8804, 8805, 8806, 8852, 8853, 8854, 8860, 8861, 8864, 8867, 8872, 8874, 8875, 8878, 8885, 8886, 8887, 8888, 8889, 8890, 8891, 8892, 8893, 8894, 8895, 8896, 8897, 8898, 8899, 8900, 12081, 12082, 1
|
2084, 12085, 12086, 12088, 12089, 12092, 12094, 12095, 12096, 12097, 12098, 12099, 12100, 12101, 12102, 12103, 12104, 12105, 12106, 12108, 12109, 12110, 12113, 12114, 12134, 12137, 12148, 12360, 12364, 12367, 12
|
568, 12689, 12690, 12812, 13078, 13458, 13507, 13758, 14012, 14017, 14083, 14585, 14601, 14756, 14815, 14843, 17104, 17105, 17106, 17107, 17108, 17109, 17110, 17111, 17112, 17113, 17114, 17115, 17116, 17117, 171
|
18, 17119, 17120, 17121, 17122, 17123, 17124, 17125, 17126, 17127, 17128, 17129, 17130, 17131, 17132, 17133, 17134, 17135, 17136, 17137, 17138, 17139, 17140, 17141, 17142, 17143, 17144, 17145, 17146, 17147, 1714
|
8, 17149, 17150, 17151, 17152, 17153, 17154, 17155, 17156, 17157, 17158, 17159, 17160, 17161, 17162, 17163, 17164, 17165, 17166, 17167, 17168, 17169, 17170, 17171, 17172, 17173, 17174, 17175, 17176, 17177, 17178
|
, 17179, 17180, 17181, 17182, 17183, 17184, 17185, 17186, 17187, 17188, 17189, 17190, 17191, 17192, 17193, 17194, 17195, 17196, 17197, 17198, 17199, 17200, 17201, 17202, 17203, 17204, 17205, 17206, 17207, 17208,
|
17209, 17210, 17211, 17212, 17213, 21757, 22389, 22606, 23568, 24001, 24029, 27923, 28522, 31378, 34302, 44917, 49629, 50240, 50338, 50913, 50914, 50915, 50916, 50917, 50918, 50919, 50920, 50921, 8840, 8841, 88
|
44, 12116, 12118, 14479, 17214, 17215, 17216, 17217, 17218, 17219, 17220, 17221, 17222, 50922, 50923, 50924, 50925, 50926, 50927, 50928, 50929, 50930, 50931, 50932, 50933, 50934, 50935, 50936, 50937, 17223, 1722
|
4, 17225, 17226, 17227, 17228, 17229, 17230, 17231, 17232, 17233, 17234, 17235, 17236, 17237, 17238, 17239, 17240, 17241, 17242, 17243, 17244, 17245, 17246, 17247, 17248, 17249, 17250, 17251, 17252, 17253, 17254
|
, 17255, 17256, 17257, 17258, 17259, 17260, 17261, 17262, 17263, 17264, 17265, 17266, 17267, 17268, 17269, 17270, 17271, 17272, 17273, 17274, 17275, 17276, 17277, 17278, 17279, 17280, 17281, 17282, 17283, 17284,
|
17285, 17286, 17287, 17288, 17289, 17290, 17291, 17292, 17293, 17294, 17295, 17296, 17297, 17298, 17299, 17300, 17301, 17302, 17303, 17304, 17305, 17306, 17307, 17308, 17309, 17310, 17311, 17312, 17313, 17314,
|
17315, 17316, 17317, 17318, 17319, 17320, 17321, 17322, 17323, 17324, 17325, 17326, 17327, 17328, 17329, 17330, 17331, 17332, 17333, 17334, 17335, 17336, 17337, 17338, 17339, 17340, 17341, 17342, 17343, 17344, 1
|
7345, 17346, 17347, 17348, 17349, 17350, 17351, 27634, 27665, 27716, 27824, 27899, 28632, 28893, 31864, 33436, 33980, 34388, 35682, 44463, 44742, 45551, 46505, 49944, 50938, 50939, 17352, 17353, 17354, 17355, 17
|
356, 17357, 17358, 17359, 17360, 27267, 31719, 50940, 50941, 8857, 8858, 8859, 12361, 12362, 14013, 17363, 17364, 17365, 17366, 17367, 17368, 17369, 17370, 17371, 17372, 17373, 17374, 17375, 17376, 17377, 17378,
|
17379, 17380, 17381, 17382, 17383, 17384, 17385, 17386, 17387, 17388, 24217, 24251, 27392, 30303, 8862, 8863, 12766, 13039, 13557, 17389, 17390, 17391, 17392, 17393, 17394, 17395, 17396, 17397, 17398, 17399, 17
|
400, 17401, 17402, 17403, 17404, 17405, 17406, 24390, 27228, 34574, 50942, 50943, 50944, 50945, 50946, 50947, 50948, 50949, 50950, 50951, 8869, 8870, 17407, 17408, 17409, 17410, 17411, 17412, 17413, 17414, 17415
|
, 17416, 17417, 17418, 17419, 17420, 17421, 17422, 17423, 17424, 22136, 33439, 33440, 17443, 16666, 17444, 17445, 17446, 17447, 17448, 17449, 17450, 17451, 17452, 17453, 17454, 17455, 17456, 17457, 17458, 17459,
|
17460, 17461, 17462, 17463, 17464, 17465, 17466, 17467, 17468, 17469, 17470, 17471, 17472, 17473, 17474, 17475, 17476, 17477, 17478, 17479, 17480, 17481, 17482, 17483, 17484, 17485, 17486, 17487, 17488, 17489,
|
17490, 17491, 17492, 17493, 17494, 17495, 17496, 17497, 17498, 17499, 17500, 17501, 17502, 17503, 17504, 17505, 17506, 17507, 17508, 17509, 17510, 17511, 17512, 17513, 17514, 17515, 17516, 17517, 17518, 17519, 1
|
7520, 17521, 17522, 17523, 17524, 17525, 17526, 23472, 23474, 23476, 23480, 23482, 23490, 23491, 23493, 23496, 23502, 23506, 23508, 23511, 23513, 23517, 23521, 23524, 23526, 23527, 23529, 23532, 23533, 23534, 23
|
536, 23538, 23539, 23544, 23550, 23556, 23557, 23559, 23562, 23563, 23569, 23572, 23573, 23574, 23575, 23577, 23578, 23579, 23582, 23585, 23587, 23591, 23593, 23596, 23597, 23600, 23603, 23606, 23607, 23610, 236
|
12, 23616, 23619, 23622, 23624, 23625, 23626, 23627, 23629, 23651, 23653, 23656, 23657, 23658, 23659, 23660, 23661, 23662, 23665, 23666, 23667, 23671, 23675, 23676, 23682, 23683, 23684, 23687, 23696, 23709, 2371
|
1, 23712, 23713, 23716, 23718, 23719, 23720, 23726, 23733, 23734, 23736, 23771, 23772, 23773, 23776, 23782, 23783, 23785, 23793, 23805, 23808, 23815, 23825, 23966, 23968, 23969, 23970, 23971, 23973, 23974, 23975
|
, 23977, 23978, 23984, 23985, 23986, 23987, 23990, 24004, 24007, 24013, 24025, 24039, 24044, 24048, 24051, 24059, 24062, 24067, 24068, 24069, 24070, 24071, 24075, 24077, 24078, 24083, 24085, 24086, 24097, 24116,
|
24117, 24118, 24122, 24131, 24132, 24134, 24137, 24139, 24144, 24149, 24150, 24161, 24162, 24167, 24176, 24177, 24191, 24194, 24196, 24199, 24201, 24203, 24214, 24222, 24245, 24247, 24248, 24250, 24254, 24257,
|
24266, 24268, 24271, 24275, 24276, 24281, 24284, 24285, 24290, 24291, 24295, 24298, 24303, 24306, 24307, 24308, 24309, 24310, 24312, 24314, 24316, 24317, 24324, 24333, 24341, 24354, 24359, 24361, 24367, 24371, 2
|
4372, 24382, 24389, 24393, 24396, 24404, 24405, 24434, 24440, 24450, 24451, 24461, 24523, 24533, 24537, 24581, 24601, 24626, 24640, 24643, 24668, 24669, 24670, 24705, 27134, 27141, 27150, 27172, 27174, 27204, 27
|
205, 27208, 27212, 27234, 27238, 27239, 27249, 27274, 27276, 27278, 27282, 27288, 27291, 27297, 27377, 27396, 27419, 27436, 27457, 27548, 27633, 27654, 27703, 27777, 27798, 27818, 27935, 28063, 28064, 28083, 280
|
90, 28120, 28322, 28385, 28390, 28416, 28456, 28480, 28534, 28536, 28537, 28558, 28628, 28677, 28926, 29013, 29082, 29148, 29193, 29203, 29285, 29288, 29430, 29505, 29717, 29729, 29819, 29820, 29939, 30027, 3006
|
9, 30167, 30181, 30183, 30213, 30273, 30306, 30316, 30401, 30486, 30512, 30741, 30871, 30905, 30978, 31012, 31218, 31806, 32144, 32270, 32575, 32589, 32622, 32685, 32728, 33574, 33670, 33689, 33782, 33851, 33898
|
, 34025, 34212, 34218, 34376, 34633, 34702, 34962, 35046, 35069, 35121, 35359, 35374, 35525, 36565, 47739, 47785, 49473, 13568, 14840, 17527, 17528, 17529, 17530, 17531, 17532, 17533, 17534, 17535, 17536, 17537,
|
17538, 17539, 17540, 17541, 17542, 17543, 17544, 17545, 17546, 17547, 17548, 23469, 23484, 23487, 23498, 23500, 23540, 23543, 23546, 23549, 23588, 23613, 23645, 23663, 23674, 23678, 23701, 23723, 23731, 23740,
|
23789, 23796, 23804, 23807, 23819, 23965, 23976, 23980, 23983, 23988, 23991, 23999, 24000, 24003, 24005, 24009, 24035, 24057, 24079, 24082, 24084, 24089, 24096, 24120, 24126, 24130, 24133, 24135, 24136, 24141, 2
|
4168, 24181, 24192, 24193, 24197, 24198, 24205, 24210, 24225, 24246, 24249, 24253, 24277, 24293, 24299, 24321, 24329, 24357, 24360, 24366, 24368, 24369, 24379, 24391, 24392, 24415, 24432, 24438, 24527, 24541, 24
|
605, 24612, 24674, 24890, 27133, 27161, 27332, 27350, 27410, 27487, 27506, 27719, 27784, 27916, 27918, 27947, 28025, 28065, 28091, 28093, 28290, 28414, 28519, 28591, 28664, 28713, 29093, 29568, 29725, 29726, 298
|
22, 29961, 29989, 30106, 30192, 30222, 30368, 30396, 31082, 31380, 31918, 32329, 32619, 32764, 33672, 33953, 34440, 34467, 34497, 34721, 34786, 34980, 35003, 35057, 35304, 35357, 35415, 43142, 44301, 17549, 1755
|
0, 17551, 17552, 17553, 23510, 23565, 23654, 23679, 23766, 23768, 23780, 24074, 24200, 24208, 24269, 24323, 24444, 24696, 27185, 27220, 27347, 27635, 27684, 28973, 29890, 30363, 34532, 45599, 17554, 17555, 17556
|
, 17557, 17558, 17559, 17560, 17561, 23681, 23737, 23755, 23818, 23993, 24255, 24256, 24376, 24536, 24559, 24617, 27136, 27163, 27173, 27189, 27223, 27224, 27240, 27280, 27395, 27398, 27485, 27505, 27508, 27524,
|
27547, 27909, 29488, 35184, 17562, 17563, 17564, 17565, 17566, 17567, 17568, 17569, 17570, 23589, 17571, 17572, 17573, 17574, 17575, 17576, 17577, 17578, 23495, 23518, 23566, 23581, 23617, 23621, 23685, 23694,
|
23698, 23704, 23967, 23994, 23995, 23996, 24119, 24140, 24175, 24260, 24270, 24272, 24279, 24287, 24358, 24377, 24378, 24395, 24589, 24750, 24867, 24869, 27143, 27227, 27243, 27248, 27283, 27284, 27352, 27397, 2
|
7399, 27402, 27412, 27529, 27677, 27704, 28071, 28082, 28086, 28531, 29004, 29083, 29749, 29762, 29906, 30098, 30295, 30367, 30794, 30884, 30912, 30964, 32069, 32121, 32483, 32817, 34028, 34392, 34463, 35234, 35
|
272, 35338, 35523, 36108, 17579, 17580, 17581, 17582, 17583, 17584, 17585, 17586, 17587, 17588, 17589, 17590, 17591, 17592, 17593, 17594, 17595, 33433, 33434, 45539, 17596, 17597, 17598, 22796, 23552, 23567, 235
|
70, 23599, 23650, 23735, 24002, 24016, 24055, 24066, 24081, 24098, 24099, 24101, 24138, 24179, 24188, 24231, 24234, 24235, 24258, 24273, 24286, 24385, 24448, 24473, 24570, 24647, 24862, 27135, 27219, 27281, 2740
|
5, 27416, 27451, 27463, 27534, 27800, 28409, 28850, 28853, 28929, 29832, 31466, 34632, 34762, 35045, 35352, 36317, 58810, 17599, 17600, 17601, 17602, 17603, 23721, 23741, 23788, 24022, 24032, 24158, 24300, 24398
|
, 24740, 24878, 27379, 28415, 29835, 29858, 30370, 31458, 32584, 33575, 34453, 17604, 17605, 17606, 23505, 23664, 23669, 23673, 23728, 24065, 24087, 24297, 24455, 24549, 24586, 24591, 24870, 24896, 27401, 27613,
|
27944, 28637, 29736, 32225, 33737, 35254, 46350, 50958, 17608, 34179, 50959, 8849, 8850, 8851, 12124, 12125, 12126, 12127, 12505, 14777, 16618, 17609, 17610, 17611, 17612, 17613, 17614, 17615, 50960, 50961, 176
|
16, 17617, 17618, 14842, 17619, 50962, 17620, 49891, 17621, 17622, 17623, 17624, 24283, 24313, 34594, 17625, 17626, 17627, 17628, 17629, 17630, 17631, 17632, 17633, 30103, 23464, 23503, 23680, 23691, 23730, 2382
|
0, 23992, 24015, 24156, 24171, 24186, 24190, 24202, 24244, 24364, 24373, 24397, 24443, 24445, 24534, 24571, 24579, 24623, 24649, 24673, 24684, 24880, 24888, 25883, 27230, 27261, 27285, 27340, 27345, 27390, 27394
|
, 27424, 27425, 27434, 27447, 27517, 27540, 27565, 27593, 27620, 27715, 27731, 27787, 27799, 27920, 27931, 27990, 28298, 28389, 28413, 28478, 28630, 28838, 28898, 28899, 28950, 28955, 29103, 29212, 29429, 29780,
|
29814, 29827, 29864, 29874, 29920, 30221, 30261, 30371, 30382, 30417, 30520, 30704, 30785, 30854, 30994, 31072, 31626, 32156, 32591, 32757, 33510, 33857, 33861, 33886, 34011, 34148, 34154, 34158, 34247, 34252,
|
34290, 34455, 34644, 34673, 34736, 35186, 35294, 35421, 36004, 36332, 36517, 36553, 36640, 36872, 42654, 42777, 42841, 42870, 43003, 43029, 43043, 43170, 43297, 43384, 43644, 43690, 22080, 22126, 22151, 22337, 2
|
2487, 22488, 22550, 22715, 22883, 44758, 45115, 45427, 45602, 45832, 46121, 46356, 46391, 46398, 49121, 49835, 49879, 50320, 50336, 50876, 50877, 50878, 50879, 50880, 50881, 50882, 50883, 50884, 50885, 50886, 58
|
637, 58811, 59807, 33373, 33374, 33375, 33376, 33377, 33378, 33379, 33380, 33381, 33382, 33383, 33384, 33385, 33386, 33387, 33388, 33389, 33390, 33391, 33392, 33393, 33394, 33395, 33396, 33397, 33398, 33399, 334
|
00, 33401, 33402, 33403, 33404, 33405, 33406, 33407, 33408, 33409, 33410, 33411, 33412, 33413, 33414, 33415, 33416, 33417, 33418, 33419, 33420, 33421, 33422, 33423, 33424, 33425, 33426, 33427, 33428, 33429, 3343
|
0, 33431, 33432, 33641, 34178, 34696, 34904, 35023, 35024, 35236, 35291, 42788, 43477, 35595, 34868, 34900, 43240, 34989, 29753, 24894, 27251, 27482, 28605, 29541, 29758, 30070, 32710, 32793, 24394, 24588, 24760
|
, 27137, 27889, 43569, 27426, 34021, 30821, 34504, 31390, 33879, 24679, 28041, 28387, 30531, 32006, 32721, 33642, 29993, 35142, 34379, 28024, 43558, 29968, 33784, 34222, 34226, 34616, 34631, 34694, 35198, 35529,
|
35539, 35674, 36070, 43669, 24641, 27213, 27480, 27680, 28195, 28373, 29195, 29481, 29826, 29847, 30311, 30388, 30697, 31134, 32227, 33709, 33730, 33731, 34117, 34399, 35489, 35948, 31785, 32421, 33632, 33803,
|
34903, 34990, 35538, 35141, 24590, 24799, 24892, 28442, 30006, 24453, 24577, 24582, 24619, 24656, 27253, 28193, 28448, 28526, 31482, 32631, 24777, 27167, 27435, 27718, 27788, 27902, 27946, 28039, 28682, 28839, 2
|
9578, 30220, 30878, 30886, 31801, 31894, 32860, 33671, 34020, 34036, 34258, 34372, 34418, 34690, 34730, 34770, 35102, 35789, 43997, 15207, 15217, 15227, 15250, 15423, 15598, 15664, 15667, 15673, 15697, 15762, 15
|
887, 15933, 16120, 16398, 16399, 16546, 16619, 22192, 22647, 22758, 22807, 23006, 23247, 23256, 23258, 23263, 23319, 23326, 24008, 24223, 24418, 27181, 27186, 27359, 27575, 27597, 27599, 27607, 27682, 27827, 278
|
76, 28185, 28344, 28348, 28424, 28468, 28471, 28472, 28476, 28489, 28492, 28496, 28497, 28506, 28520, 28575, 28578, 28582, 28602, 28608, 28610, 28612, 28613, 28617, 28621, 28623, 28653, 28656, 28696, 28704, 2871
|
7, 28815, 28831, 28901, 28968, 28981, 28986, 29046, 29069, 29081, 29158, 29162, 29209, 29243, 29267, 29303, 29337, 29391, 29406, 29495, 29712, 29778, 29840, 29842, 29919, 30008, 30014, 30019, 30032, 30038, 30173
|
, 30175, 30178, 30185, 30186, 30191, 30198, 30204, 30205, 30383, 30394, 30398, 30403, 30429, 30432, 30452, 30454, 30457, 30470, 30528, 30640, 30682, 30689, 30701, 30702, 30716, 30761, 30897, 31235, 31252, 31253,
|
31277, 31278, 31338, 31406, 31410, 31503, 31525, 31526, 31527, 31555, 31556, 31557, 31617, 31641, 31642, 31644, 31647, 31651, 31705, 31715, 31826, 31841, 31917, 32019, 32084, 32113, 32126, 32323, 32391, 32424,
|
32455, 32456, 32598, 32691, 32712, 32713, 32762, 32799, 32801, 32803, 32804, 32855, 32863, 33502, 33533, 33692, 33712, 33747, 33862, 33876, 33899, 33916, 34032, 34084, 34149, 34150, 34230, 34248, 34261, 34296, 3
|
4304, 34327, 34473, 34475, 34476, 34482, 34483, 34484, 34485, 34514, 34541, 34552, 34561, 34583, 34588, 34590, 34596, 34628, 34634, 34651, 34658, 34659, 34678, 34682, 34692, 34698, 34703, 34713, 34729, 34732, 34
|
754, 34755, 34766, 34772, 34789, 34790, 34794, 34807, 34809, 34810, 34885, 34886, 34887, 34901, 34939, 34953, 34973, 34991, 35026, 35029, 35035, 35051, 35072, 35073, 35076, 35096, 35097, 35115, 35182, 35255, 352
|
59, 35260, 35262, 35265, 35281, 35315, 35316, 35342, 35471, 35476, 35477, 35479, 35486, 35487, 35531, 35532, 35545, 35572, 35581, 35586, 35597, 35602, 35625, 35632, 35638, 35656, 35659, 35699, 35701, 35727, 3573
|
7, 35762, 35774, 35780, 35790, 35878, 35886, 35888, 35956, 35973, 36002, 36024, 36061, 36099, 36111, 36123, 36202, 36208, 36299, 36300, 36314, 36413, 36417, 36505, 36541, 36559, 36570, 36581, 36595, 36690, 36745
|
, 36748, 36752, 36763, 36764, 36765, 36766, 36786, 36788, 36810, 36811, 36820, 36821, 43375, 43469, 43473, 43474, 43475, 43592, 43605, 43606, 43782, 43834, 43862, 43873, 43880, 43920, 43959, 43967, 44042, 44054,
|
44065, 44066, 44071, 44079, 44080, 44093, 44133, 44177, 44179, 44193, 44195, 44208, 44215, 44232, 44243, 44500, 44507, 44510, 44520, 44522, 44529, 44538, 44546, 44556, 44572, 44574, 44582, 44595, 44602, 44608,
|
44611, 44613, 44614, 44616, 44617, 44618, 44630, 44638, 44639, 44642, 44647, 44672, 44674, 44681, 44694, 44700, 44723, 45100
|
)
|
AND code_id = root_code_id;
|
Note that I have also attached the SQL as above.
This is taking about 30 seconds to run whereas in MySQL is was pretty much instant.