require "#{__dir__}/setup"
# _ { QuickScript::General::PreProfessionalLeagueScript.new(user_name: "藤井聡太").call } # => "549.23 ms"
# s { QuickScript::General::PreProfessionalLeagueScript.new(user_name: "藤井聡太").call }

# _ { QuickScript::General::PreProfessionalLeagueScript.new(season_key: "").call } # => "935.38 ms"
# _ { QuickScript::General::PreProfessionalLeagueScript.new(season_key: "").call } # => "371.06 ms"
# s { QuickScript::General::PreProfessionalLeagueScript.new(season_key: "").call }
# s { QuickScript::General::PreProfessionalLeagueScript.new(season_key: "").top_content }
# s { QuickScript::General::PreProfessionalLeagueScript.new(season_key: "").bottom_content }

s { QuickScript::General::PreProfessionalLeagueScript.new(season_key: "").as_general_json }

# >>   SQL (295.2ms)  SELECT `ppl_users`.`id` AS t0_r0, `ppl_users`.`rank_id` AS t0_r1, `ppl_users`.`mentor_id` AS t0_r2, `ppl_users`.`name` AS t0_r3, `ppl_users`.`age_min` AS t0_r4, `ppl_users`.`age_max` AS t0_r5, `ppl_users`.`runner_up_count` AS t0_r6, `ppl_users`.`win_max` AS t0_r7, `ppl_users`.`win_ratio` AS t0_r8, `ppl_users`.`promotion_membership_id` AS t0_r9, `ppl_users`.`promotion_win` AS t0_r10, `ppl_users`.`promotion_season_position` AS t0_r11, `ppl_users`.`memberships_first_id` AS t0_r12, `ppl_users`.`memberships_last_id` AS t0_r13, `ppl_users`.`deactivated_membership_id` AS t0_r14, `ppl_users`.`memberships_count` AS t0_r15, `ppl_users`.`created_at` AS t0_r16, `ppl_users`.`updated_at` AS t0_r17, `ppl_ranks`.`id` AS t1_r0, `ppl_ranks`.`key` AS t1_r1, `ppl_ranks`.`position` AS t1_r2, `ppl_ranks`.`created_at` AS t1_r3, `ppl_ranks`.`updated_at` AS t1_r4 FROM `ppl_users` LEFT OUTER JOIN `ppl_ranks` ON `ppl_ranks`.`id` = `ppl_users`.`rank_id` ORDER BY `ppl_ranks`.`position` ASC, `ppl_users`.`promotion_season_position` ASC, `ppl_users`.`promotion_win` DESC, `ppl_users`.`runner_up_count` DESC, `ppl_users`.`age_min` ASC, `ppl_users`.`memberships_count` ASC /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:85:in 'Enumerable#collect'
# >>   Ppl::Mentor Load (81.8ms)  SELECT `ppl_mentors`.* FROM `ppl_mentors` WHERE `ppl_mentors`.`id` IN (1530, 1531, 1536, 1535, 1533, 1537, 1534, 1538, 1529, 1547, 1527, 1540, 1545, 1546, 1549, 1528, 1543, 1552, 1551, 1555, 1542, 1559, 1557, 1558, 1562, 1560, 1564, 1565, 1568, 1544, 1553, 1563, 1566, 1567, 1570, 1561, 1576, 1574, 1571, 1569, 1575, 1580, 1578, 1583, 1577, 1572, 1584, 1589, 1587, 1585, 1593, 1592, 1582, 1596, 1579, 1591, 1581, 1600, 1597, 1590, 1599, 1588, 1594, 1541, 1604, 1605, 1601, 1602, 1595, 1607, 1608, 1609, 1611, 1613, 1614, 1610, 1612, 1615, 1616, 1621, 1619, 1617, 1626, 1628, 1629, 1630, 1631, 1634, 1633, 1637, 1640, 1643, 1645, 1639, 1598, 1636, 1653, 1632, 1651, 1650, 1646, 1642, 1652, 1658, 1548, 1657, 1662, 1647, 1638, 1663, 1668, 1659, 1661, 1660, 1627, 1667, 1665, 1664, 1666, 1641, 1635, 1654, 1624, 1618, 1656, 1625, 1603, 1655, 1573, 1606, 1622, 1649, 1623, 1648, 1550, 1554, 1526, 1556, 1525, 1539, 1532) /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:85:in 'Enumerable#collect'
# >>   Ppl::Membership Load (752.0ms)  SELECT `ppl_memberships`.* FROM `ppl_memberships` WHERE `ppl_memberships`.`user_id` IN (4093, 4094, 4099, 4098, 4096, 4100, 4097, 4101, 4092, 4116, 4108, 4103, 4117, 4111, 4125, 4119, 4124, 4114, 4122, 4112, 4121, 4130, 4126, 4107, 4133, 4129, 4134, 4139, 4147, 4148, 4132, 4141, 4138, 4151, 4146, 4145, 4144, 4152, 4164, 4159, 4154, 4160, 4166, 4167, 4176, 4155, 4172, 4156, 4161, 4168, 4170, 4165, 4181, 4171, 4177, 4178, 4179, 4173, 4175, 4180, 4184, 4149, 4191, 4188, 4174, 4185, 4202, 4183, 4189, 4182, 4205, 4200, 4197, 4199, 4201, 4196, 4209, 4195, 4193, 4198, 4169, 4192, 4226, 4221, 4213, 4186, 4210, 4227, 4219, 4212, 4217, 4230, 4233, 4232, 4224, 4207, 4216, 4239, 4238, 4214, 4231, 4225, 4229, 4249, 4253, 4243, 4240, 4228, 4252, 4245, 4248, 4251, 4246, 4204, 4261, 4263, 4242, 4241, 4257, 4264, 4260, 4268, 4254, 4266, 4272, 4258, 4267, 4270, 4277, 4273, 4287, 4234, 4300, 4291, 4289, 4283, 4286, 4302, 4299, 4292, 4250, 4293, 4288, 4297, 4301, 4276, 4275, 4307, 4280, 4309, 4315, 4290, 4304, 4313, 4308, 4317, 4303, 4331, 4278, 4332, 4316, 4341, 4329, 4334, 4344, 4336, 4335, 4328, 4333, 4322, 4337, 4353, 4346, 4348, 4338, 4357, 4314, 4340, 4360, 4330, 4349, 4364, 4368, 4369, 4345, 4379, 4373, 4371, 4363, 4377, 4367, 4372, 4378, 4383, 4376, 4352, 4399, 4407, 4396, 4409, 4390, 4408, 4389, 4411, 4392, 4416, 4385, 4422, 4403, 4410, 4426, 4429, 4414, 4425, 4413, 4424, 4443, 4384, 4400, 4436, 4430, 4437, 4439, 4451, 4454, 4406, 4417, 4465, 4428, 4412, 4415, 4463, 4469, 4423, 4464, 4459, 4462, 4447, 4442, 4449, 4446, 4477, 4433, 4486, 4448, 4476, 4498, 4475, 4494, 4481, 4468, 4484, 4516, 4521, 4467, 4492, 4483, 4493, 4489, 4480, 4501, 4530, 4520, 4488, 4534, 4358, 4404, 4397, 4452, 4526, 4514, 4499, 4524, 4549, 4531, 4513, 4548, 4543, 4535, 4532, 4518, 4511, 4546, 4536, 4539, 4503, 4478, 4541, 4528, 4527, 4517, 4509, 4502, 4504, 4507, 4495, 4500, 4544, 4545, 4537, 4538, 4529, 4508, 4542, 4525, 4519, 4523, 4540, 4533, 4445, 4438, 4466, 4427, 4450, 4458, 4381, 4281, 4362, 4365, 4370, 4135, 4282, 4115, 4150, 4142, 4327, 4374, 4421, 4394, 4497, 4470, 4274, 4393, 4405, 4355, 4244, 4211, 4473, 4496, 4386, 4343, 4471, 4487, 4482, 4318, 4434, 4157, 4218, 4323, 4222, 4105, 4220, 4472, 4375, 4491, 4398, 4490, 4453, 4311, 4402, 4237, 4235, 4255, 4140, 4356, 4236, 4351, 4354, 4361, 4387, 4388, 4479, 4485, 4265, 4419, 4431, 4460, 4306, 4310, 4312, 4347, 4279, 4206, 4305, 4104, 4247, 4158, 4203, 4153, 4190, 4391, 4395, 4420, 4435, 4441, 4461, 4262, 4294, 4296, 4342, 4366, 4444, 4455, 4456, 4506, 4091, 4123, 4321, 4350, 4474, 4215, 4256, 4505, 4271, 4401, 4187, 4284, 4285, 4324, 4136, 4163, 4127, 4547, 4457, 4319, 4325, 4326, 4359, 4515, 4380, 4418, 4522, 4259, 4298, 4137, 4143, 4223, 4162, 4295, 4432, 4510, 4194, 4269, 4120, 4110, 4208, 4320, 4339, 4382, 4440, 4512, 4118, 4106, 4128, 4090, 4113, 4089, 4131, 4109, 4088, 4102, 4095) /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:85:in 'Enumerable#collect'
# >>   Ppl::Season Load (41.1ms)  SELECT `ppl_seasons`.* FROM `ppl_seasons` WHERE `ppl_seasons`.`id` IN (1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1156, 1160, 1151, 1152, 1153, 1154, 1155, 1157, 1158, 1159, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1218, 1219, 1220, 1221, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254) /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:85:in 'Enumerable#collect'
# >>   Ppl::Result Load (30.2ms)  SELECT `ppl_results`.* FROM `ppl_results` WHERE `ppl_results`.`id` IN (4, 1, 3, 2) ORDER BY `ppl_results`.`position` ASC /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:85:in 'Enumerable#collect'
# >>   Ppl::Membership Load (608.7ms)  SELECT `ppl_memberships`.* FROM `ppl_memberships` WHERE `ppl_memberships`.`id` IN (26064, 26065, 26081, 26080, 26078, 26082, 26079, 26093, 26063, 26169, 26124, 26102, 26177, 26150, 26265, 26195, 26256, 26153, 26246, 26151, 26238, 26304, 26275, 26123, 26344, 26303, 26345, 26368, 26449, 26450, 26315, 26379, 26367, 26471, 26422, 26415, 26413, 26481, 26577, 26536, 26492, 26537, 26594, 26609, 26664, 26513, 26657, 26514, 26553, 26610, 26626, 26578, 26683, 26656, 26675, 26676, 26681, 26658, 26663, 26682, 26697, 26451, 26710, 26705, 26659, 26702, 26744, 26691, 26706, 26684, 26747, 26738, 26735, 26737, 26739, 26734, 26764, 26733, 26721, 26736, 26618, 26720, 26815, 26804, 26790, 26703, 26765, 26816, 26802, 26772, 26800, 26832, 26853, 26840, 26807, 26762, 26799, 26874, 26862, 26791, 26833, 26808, 26831, 26898, 26906, 26882, 26875, 26830, 26905, 26894, 26897, 26900, 26895, 26746, 26976, 26978, 26881, 26876, 26958, 26979, 26975, 27020, 26907, 27000, 27065, 26973, 27019, 27042, 27091, 27066, 27163, 26854, 27212, 27175, 27173, 27120, 27148, 27244, 27211, 27176, 26899, 27177, 27172, 27209, 27243, 27090, 27068, 27303, 27094, 27329, 27381, 27174, 27274, 27379, 27328, 27403, 27245, 27527, 27092, 27528, 27402, 27562, 27503, 27530, 27589, 27532, 27531, 27502, 27529, 27429, 27533, 27666, 27615, 27617, 27559, 27691, 27380, 27561, 27737, 27504, 27640, 27741, 27770, 27771, 27590, 27859, 27827, 27773, 27740, 27857, 27769, 27826, 27858, 27888, 27856, 27665, 27987, 28085, 27984, 28087, 27921, 28086, 27920, 28119, 27952, 28156, 27916, 28216, 28051, 28088, 28220, 28254, 28122, 28219, 28121, 28218, 28416, 27889, 28017, 28355, 28255, 28383, 28385, 28457, 28460, 28054, 28187, 28624, 28253, 28120, 28123, 28596, 28654, 28217, 28623, 28564, 28595, 28420, 28415, 28455, 28419, 28719, 28322, 28760, 28421, 28718, 28887, 28689, 28858, 28723, 28653, 28758, 29001, 29041, 28626, 28828, 28725, 28857, 28795, 28722, 28918, 29123, 29040, 28762, 29164, 27714, 28052, 27985, 28458, 29083, 28999, 28888, 29081, 29297, 29124, 28998, 29296, 29253, 29165, 29162, 29003, 28962, 29256, 29166, 29169, 28920, 28720, 29212, 29121, 29084, 29002, 28960, 28919, 28921, 28925, 28884, 28889, 29254, 29255, 29167, 29168, 29122, 28959, 29213, 29082, 29011, 29043, 29211, 29163, 28418, 28384, 28625, 28252, 28456, 28532, 27886, 27118, 27739, 27742, 27772, 26346, 27119, 26168, 26452, 26390, 27480, 27828, 28215, 27982, 28886, 28655, 27067, 27981, 28053, 27689, 26893, 26771, 28658, 28885, 27917, 27588, 28656, 28761, 28724, 27404, 28353, 26521, 26801, 27430, 26805, 26104, 26803, 28657, 27829, 28827, 27986, 28826, 28459, 27354, 28019, 26857, 26855, 26921, 26378, 27690, 26856, 27642, 27688, 27738, 27918, 27919, 28721, 28759, 26999, 28213, 28289, 28565, 27302, 27353, 27355, 27616, 27093, 26761, 27301, 26103, 26896, 26530, 26745, 26482, 26709, 27950, 27983, 28214, 28354, 28414, 28566, 26977, 27178, 27180, 27563, 27743, 28417, 28495, 28496, 28923, 26062, 26247, 27428, 27641, 28688, 26792, 26930, 28922, 27044, 28018, 26704, 27121, 27122, 27454, 26357, 26570, 26284, 29257, 28497, 27426, 27455, 27479, 27715, 29000, 27862, 28212, 29042, 26974, 27210, 26366, 26403, 26806, 26555, 27179, 28321, 28961, 26725, 27021, 26213, 26144, 26763, 27427, 27560, 27887, 28413, 28997, 26194, 26105, 26294, 26061, 26152, 26060, 26314, 26126, 26059, 26094, 26073, 26071, 26072, 26207, 26090, 26108, 26110, 26119, 26139, 26147, 26178, 26198, 26223, 26230, 26276, 26270, 26300, 26311, 26316, 26326, 26358, 26348, 26381, 26406, 26391, 26426, 26439, 26466, 26475, 26472, 26502, 26516, 26523, 26543, 26563, 26575, 26587, 26604, 26632, 26647, 26635, 26653, 26650, 26672, 26667, 26677, 26665, 26670, 26668, 26671, 26689, 26690, 26694, 26687, 26693, 26695, 26707, 26724, 26718, 26713, 26715, 26727, 26730, 26741, 26770, 26759, 26756, 26758, 26760, 26755, 26754, 26778, 26779, 26774, 26777, 26812, 26793, 26798, 26839, 26824, 26835, 26822, 26851, 26861, 26847, 26842, 26843, 26880, 26877, 26869, 26866, 26868, 26904, 26890, 26886, 26916, 26935, 26937, 26953, 26956, 26983, 26996, 27008, 27002, 27025, 27024, 27058, 27048, 27070, 27071, 27098, 27097, 27124, 27125, 27170, 27181, 27214, 27231, 27258, 27249, 27279, 27275, 27320, 27306, 27344, 27332, 27356, 27361, 27399, 27383, 27405, 27409, 27431, 27436, 27460, 27459, 27456, 27487, 27481, 27506, 27541, 27546, 27572, 27574, 27597, 27601, 27620, 27626, 27646, 27647, 27671, 27680, 27711, 27698, 27731, 27717, 27744, 27761, 27778, 27776, 27803, 27807, 27836, 27832, 27871, 27872, 27890, 27894, 27924, 27923, 27953, 27968, 27998, 27988, 28022, 28039, 28072, 28067, 28109, 28089, 28131, 28124, 28157, 28159, 28189, 28191, 28243, 28226, 28260, 28263, 28294, 28304, 28349, 28336, 28357, 28376, 28390, 28430, 28423, 28465, 28469, 28502, 28505, 28537, 28535, 28584, 28575, 28598, 28632, 28629, 28667, 28662, 28695, 28693, 28750, 28732, 28772, 28765, 28806, 28796, 28830, 28832, 28868, 28881, 28880, 28907, 28891, 28930, 28927, 28965, 28980, 29007, 29053, 29051, 29047, 29091, 29088, 29138, 29147, 29195, 29172, 29214, 29232, 27954, 28055, 28339, 28581, 29263, 29279, 29270, 29258, 29281, 29266, 29259, 29294, 29282, 29277, 29265, 29286, 29273, 29261, 29287, 29269, 29285, 29280, 29267, 29292, 29274, 29268, 29288, 29284, 29262, 29289, 29260, 29293, 29264, 29272, 29295, 29271, 29283, 29278, 29276, 29290, 29275, 29291, 29009, 28568, 28908, 28500, 28728, 28814, 28021, 27155, 27964, 28319, 28330, 26423, 27145, 26232, 26580, 26630, 27899, 28343, 28742, 28552, 28996, 28810, 27272, 28452, 28521, 28267, 27554, 26788, 28681, 28981, 28181, 27838, 29045, 29219, 29179, 27756, 28802, 26773, 27289, 27961, 27316, 26117, 26845, 28782, 28084, 29194, 28352, 29229, 28831, 27670, 28431, 27242, 27373, 27466, 26402, 27713, 27009, 27854, 27910, 27969, 28173, 28178, 28992, 29038, 27216, 28529, 28587, 28834, 27536, 27604, 27598, 27867, 27406, 27063, 28094, 26355, 26562, 26786, 26539, 26784, 28147, 28179, 28405, 28550, 28614, 28752, 27137, 27374, 27367, 27720, 27941, 28649, 28712, 28696, 29199, 26149, 26394, 27618, 27841, 28929, 27086, 26957, 29080, 27161, 28172, 26817, 27285, 27300, 27595, 26499, 26679, 26527, 28563, 27518, 27551, 27575, 27805, 29160, 28024, 28361, 29222, 27117, 27360, 26505, 26622, 26827, 26588, 27217, 28429, 29113, 26834, 27347, 26490, 26487, 26820, 27519, 27655, 27993, 28545, 29155, 26322, 26429, 26479, 26392, 26456, 26114, 26476, 26602, 26066, 26335, 26083, 26091) /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:85:in 'Enumerable#collect'
# >>   Ppl::Season Load (46.6ms)  SELECT `ppl_seasons`.* FROM `ppl_seasons` WHERE `ppl_seasons`.`id` IN (1128, 1130, 1132, 1134, 1135, 1136, 1137, 1138, 1139, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1129, 1131, 1133, 1140, 1154, 1163, 1211) /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:85:in 'Enumerable#collect'
# >>   SQL (27.4ms)  SELECT `ppl_users`.`id` AS t0_r0, `ppl_users`.`rank_id` AS t0_r1, `ppl_users`.`mentor_id` AS t0_r2, `ppl_users`.`name` AS t0_r3, `ppl_users`.`age_min` AS t0_r4, `ppl_users`.`age_max` AS t0_r5, `ppl_users`.`runner_up_count` AS t0_r6, `ppl_users`.`win_max` AS t0_r7, `ppl_users`.`win_ratio` AS t0_r8, `ppl_users`.`promotion_membership_id` AS t0_r9, `ppl_users`.`promotion_win` AS t0_r10, `ppl_users`.`promotion_season_position` AS t0_r11, `ppl_users`.`memberships_first_id` AS t0_r12, `ppl_users`.`memberships_last_id` AS t0_r13, `ppl_users`.`deactivated_membership_id` AS t0_r14, `ppl_users`.`memberships_count` AS t0_r15, `ppl_users`.`created_at` AS t0_r16, `ppl_users`.`updated_at` AS t0_r17, `ppl_ranks`.`id` AS t1_r0, `ppl_ranks`.`key` AS t1_r1, `ppl_ranks`.`position` AS t1_r2, `ppl_ranks`.`created_at` AS t1_r3, `ppl_ranks`.`updated_at` AS t1_r4 FROM `ppl_users` LEFT OUTER JOIN `ppl_ranks` ON `ppl_ranks`.`id` = `ppl_users`.`rank_id` ORDER BY `ppl_ranks`.`position` ASC, `ppl_users`.`promotion_season_position` DESC, `ppl_users`.`promotion_win` DESC, `ppl_users`.`runner_up_count` DESC, `ppl_users`.`age_min` ASC, `ppl_users`.`memberships_count` ASC /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:119:in 'Enumerable#flat_map'
# >>   Ppl::Mentor Load (21.4ms)  SELECT `ppl_mentors`.* FROM `ppl_mentors` WHERE `ppl_mentors`.`id` IN (1647, 1631, 1600, 1662, 1657, 1609, 1548, 1652, 1616, 1658, 1636, 1632, 1628, 1630, 1642, 1646, 1640, 1650, 1651, 1653, 1611, 1639, 1598, 1529, 1587, 1645, 1643, 1626, 1601, 1595, 1585, 1633, 1617, 1610, 1637, 1580, 1612, 1634, 1565, 1615, 1614, 1629, 1594, 1588, 1551, 1591, 1619, 1604, 1613, 1621, 1564, 1546, 1596, 1528, 1583, 1607, 1578, 1597, 1608, 1568, 1602, 1559, 1570, 1530, 1605, 1541, 1579, 1590, 1599, 1569, 1581, 1593, 1592, 1582, 1589, 1535, 1562, 1572, 1584, 1577, 1566, 1558, 1540, 1575, 1537, 1576, 1574, 1571, 1561, 1567, 1557, 1544, 1533, 1553, 1536, 1563, 1552, 1527, 1560, 1531, 1542, 1555, 1543, 1549, 1545, 1547, 1538, 1534, 1638, 1663, 1668, 1659, 1661, 1660, 1627, 1667, 1665, 1664, 1666, 1641, 1635, 1654, 1624, 1618, 1656, 1625, 1603, 1655, 1573, 1606, 1622, 1649, 1623, 1648, 1550, 1554, 1526, 1556, 1525, 1539, 1532) /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:119:in 'Enumerable#flat_map'
# >>   Ppl::Membership Load (59.4ms)  SELECT `ppl_memberships`.* FROM `ppl_memberships` WHERE `ppl_memberships`.`user_id` IN (4488, 4534, 4530, 4520, 4480, 4501, 4493, 4489, 4467, 4492, 4483, 4516, 4521, 4468, 4484, 4494, 4481, 4498, 4475, 4486, 4448, 4476, 4477, 4433, 4449, 4446, 4447, 4442, 4459, 4462, 4423, 4464, 4463, 4469, 4412, 4415, 4465, 4428, 4406, 4417, 4451, 4454, 4437, 4439, 4436, 4430, 4384, 4400, 4424, 4443, 4425, 4413, 4429, 4414, 4410, 4426, 4422, 4403, 4416, 4385, 4411, 4392, 4408, 4389, 4409, 4390, 4407, 4396, 4352, 4399, 4383, 4376, 4372, 4378, 4377, 4367, 4371, 4363, 4379, 4373, 4369, 4345, 4364, 4368, 4330, 4349, 4340, 4360, 4357, 4314, 4348, 4338, 4353, 4346, 4322, 4337, 4328, 4333, 4336, 4335, 4334, 4344, 4341, 4329, 4332, 4316, 4331, 4278, 4317, 4303, 4304, 4313, 4308, 4315, 4290, 4280, 4309, 4275, 4307, 4301, 4276, 4288, 4297, 4250, 4293, 4299, 4292, 4286, 4302, 4289, 4283, 4300, 4291, 4287, 4234, 4277, 4273, 4267, 4270, 4272, 4258, 4254, 4266, 4260, 4268, 4257, 4264, 4242, 4241, 4261, 4263, 4246, 4204, 4248, 4251, 4245, 4249, 4253, 4243, 4240, 4228, 4252, 4239, 4238, 4214, 4231, 4225, 4229, 4230, 4233, 4232, 4224, 4207, 4216, 4227, 4219, 4212, 4217, 4226, 4221, 4213, 4186, 4210, 4193, 4198, 4169, 4192, 4205, 4200, 4197, 4199, 4201, 4196, 4209, 4195, 4202, 4183, 4189, 4182, 4191, 4188, 4174, 4185, 4149, 4177, 4178, 4179, 4173, 4175, 4180, 4184, 4172, 4156, 4161, 4168, 4170, 4165, 4181, 4171, 4167, 4176, 4155, 4160, 4166, 4154, 4159, 4164, 4152, 4144, 4145, 4146, 4151, 4138, 4132, 4141, 4148, 4139, 4147, 4134, 4133, 4129, 4107, 4130, 4126, 4121, 4122, 4112, 4114, 4119, 4124, 4125, 4111, 4117, 4103, 4108, 4116, 4092, 4101, 4097, 4096, 4100, 4099, 4098, 4093, 4094, 4452, 4397, 4404, 4358, 4526, 4514, 4499, 4524, 4549, 4531, 4513, 4548, 4543, 4535, 4532, 4518, 4511, 4546, 4536, 4539, 4503, 4478, 4541, 4528, 4527, 4517, 4509, 4502, 4504, 4507, 4495, 4500, 4544, 4545, 4537, 4538, 4529, 4508, 4542, 4525, 4519, 4523, 4540, 4533, 4445, 4438, 4466, 4427, 4450, 4458, 4381, 4281, 4362, 4365, 4370, 4135, 4282, 4115, 4150, 4142, 4327, 4374, 4421, 4394, 4497, 4470, 4274, 4393, 4405, 4355, 4244, 4211, 4473, 4496, 4386, 4343, 4471, 4487, 4482, 4318, 4434, 4157, 4218, 4323, 4222, 4105, 4220, 4472, 4375, 4491, 4398, 4490, 4453, 4311, 4402, 4237, 4235, 4255, 4140, 4356, 4236, 4351, 4354, 4361, 4387, 4388, 4479, 4485, 4265, 4419, 4431, 4460, 4306, 4310, 4312, 4347, 4279, 4206, 4305, 4104, 4247, 4158, 4203, 4153, 4190, 4391, 4395, 4420, 4435, 4441, 4461, 4262, 4294, 4296, 4342, 4366, 4444, 4455, 4456, 4506, 4091, 4123, 4321, 4350, 4474, 4215, 4256, 4505, 4271, 4401, 4187, 4284, 4285, 4324, 4136, 4163, 4127, 4547, 4457, 4319, 4325, 4326, 4359, 4515, 4380, 4418, 4522, 4259, 4298, 4137, 4143, 4223, 4162, 4295, 4432, 4510, 4194, 4269, 4120, 4110, 4208, 4320, 4339, 4382, 4440, 4512, 4118, 4106, 4128, 4090, 4113, 4089, 4131, 4109, 4088, 4102, 4095) /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:119:in 'Enumerable#flat_map'
# >>   Ppl::Season Load (0.9ms)  SELECT `ppl_seasons`.* FROM `ppl_seasons` WHERE `ppl_seasons`.`id` IN (1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1156, 1160, 1151, 1152, 1153, 1154, 1155, 1157, 1158, 1159, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1218, 1219, 1220, 1221, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254) /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:119:in 'Enumerable#flat_map'
# >>   Ppl::Result Load (0.4ms)  SELECT `ppl_results`.* FROM `ppl_results` WHERE `ppl_results`.`id` IN (4, 1, 3, 2) ORDER BY `ppl_results`.`position` ASC /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:119:in 'Enumerable#flat_map'
# >>   Ppl::Membership Load (246.8ms)  SELECT `ppl_memberships`.* FROM `ppl_memberships` WHERE `ppl_memberships`.`id` IN (28762, 29164, 29123, 29040, 28722, 28918, 28857, 28795, 28626, 28828, 28725, 29001, 29041, 28653, 28758, 28858, 28723, 28887, 28689, 28760, 28421, 28718, 28719, 28322, 28455, 28419, 28420, 28415, 28564, 28595, 28217, 28623, 28596, 28654, 28120, 28123, 28624, 28253, 28054, 28187, 28457, 28460, 28383, 28385, 28355, 28255, 27889, 28017, 28218, 28416, 28219, 28121, 28254, 28122, 28088, 28220, 28216, 28051, 28156, 27916, 28119, 27952, 28086, 27920, 28087, 27921, 28085, 27984, 27665, 27987, 27888, 27856, 27826, 27858, 27857, 27769, 27773, 27740, 27859, 27827, 27771, 27590, 27741, 27770, 27504, 27640, 27561, 27737, 27691, 27380, 27617, 27559, 27666, 27615, 27429, 27533, 27502, 27529, 27532, 27531, 27530, 27589, 27562, 27503, 27528, 27402, 27527, 27092, 27403, 27245, 27274, 27379, 27328, 27381, 27174, 27094, 27329, 27068, 27303, 27243, 27090, 27172, 27209, 26899, 27177, 27211, 27176, 27148, 27244, 27173, 27120, 27212, 27175, 27163, 26854, 27091, 27066, 27019, 27042, 27065, 26973, 26907, 27000, 26975, 27020, 26958, 26979, 26881, 26876, 26976, 26978, 26895, 26746, 26897, 26900, 26894, 26898, 26906, 26882, 26875, 26830, 26905, 26874, 26862, 26791, 26833, 26808, 26831, 26832, 26853, 26840, 26807, 26762, 26799, 26816, 26802, 26772, 26800, 26815, 26804, 26790, 26703, 26765, 26721, 26736, 26618, 26720, 26747, 26738, 26735, 26737, 26739, 26734, 26764, 26733, 26744, 26691, 26706, 26684, 26710, 26705, 26659, 26702, 26451, 26675, 26676, 26681, 26658, 26663, 26682, 26697, 26657, 26514, 26553, 26610, 26626, 26578, 26683, 26656, 26609, 26664, 26513, 26537, 26594, 26492, 26536, 26577, 26481, 26413, 26415, 26422, 26471, 26367, 26315, 26379, 26450, 26368, 26449, 26345, 26344, 26303, 26123, 26304, 26275, 26238, 26246, 26151, 26153, 26195, 26256, 26265, 26150, 26177, 26102, 26124, 26169, 26063, 26093, 26079, 26078, 26082, 26081, 26080, 26064, 26065, 28458, 27985, 28052, 27714, 29083, 28999, 28888, 29081, 29297, 29124, 28998, 29296, 29253, 29165, 29162, 29003, 28962, 29256, 29166, 29169, 28920, 28720, 29212, 29121, 29084, 29002, 28960, 28919, 28921, 28925, 28884, 28889, 29254, 29255, 29167, 29168, 29122, 28959, 29213, 29082, 29011, 29043, 29211, 29163, 28418, 28384, 28625, 28252, 28456, 28532, 27886, 27118, 27739, 27742, 27772, 26346, 27119, 26168, 26452, 26390, 27480, 27828, 28215, 27982, 28886, 28655, 27067, 27981, 28053, 27689, 26893, 26771, 28658, 28885, 27917, 27588, 28656, 28761, 28724, 27404, 28353, 26521, 26801, 27430, 26805, 26104, 26803, 28657, 27829, 28827, 27986, 28826, 28459, 27354, 28019, 26857, 26855, 26921, 26378, 27690, 26856, 27642, 27688, 27738, 27918, 27919, 28721, 28759, 26999, 28213, 28289, 28565, 27302, 27353, 27355, 27616, 27093, 26761, 27301, 26103, 26896, 26530, 26745, 26482, 26709, 27950, 27983, 28214, 28354, 28414, 28566, 26977, 27178, 27180, 27563, 27743, 28417, 28495, 28496, 28923, 26062, 26247, 27428, 27641, 28688, 26792, 26930, 28922, 27044, 28018, 26704, 27121, 27122, 27454, 26357, 26570, 26284, 29257, 28497, 27426, 27455, 27479, 27715, 29000, 27862, 28212, 29042, 26974, 27210, 26366, 26403, 26806, 26555, 27179, 28321, 28961, 26725, 27021, 26213, 26144, 26763, 27427, 27560, 27887, 28413, 28997, 26194, 26105, 26294, 26061, 26152, 26060, 26314, 26126, 26059, 26094, 26073, 29214, 29232, 29195, 29172, 29138, 29147, 29091, 29088, 29053, 29051, 29047, 29007, 28965, 28980, 28930, 28927, 28907, 28891, 28868, 28881, 28880, 28830, 28832, 28806, 28796, 28772, 28765, 28750, 28732, 28695, 28693, 28667, 28662, 28632, 28629, 28598, 28584, 28575, 28537, 28535, 28502, 28505, 28465, 28469, 28430, 28423, 28390, 28357, 28376, 28349, 28336, 28294, 28304, 28260, 28263, 28243, 28226, 28189, 28191, 28157, 28159, 28131, 28124, 28109, 28089, 28072, 28067, 28022, 28039, 27998, 27988, 27953, 27968, 27924, 27923, 27890, 27894, 27871, 27872, 27836, 27832, 27803, 27807, 27778, 27776, 27744, 27761, 27731, 27717, 27711, 27698, 27671, 27680, 27646, 27647, 27620, 27626, 27597, 27601, 27572, 27574, 27541, 27546, 27506, 27487, 27481, 27460, 27459, 27456, 27431, 27436, 27405, 27409, 27399, 27383, 27356, 27361, 27344, 27332, 27320, 27306, 27279, 27275, 27258, 27249, 27214, 27231, 27181, 27170, 27124, 27125, 27098, 27097, 27070, 27071, 27058, 27048, 27025, 27024, 27008, 27002, 26983, 26996, 26953, 26956, 26935, 26937, 26916, 26904, 26890, 26886, 26880, 26877, 26869, 26866, 26868, 26851, 26861, 26847, 26842, 26843, 26839, 26824, 26835, 26822, 26812, 26793, 26798, 26778, 26779, 26774, 26777, 26770, 26759, 26756, 26758, 26760, 26755, 26754, 26727, 26730, 26741, 26724, 26718, 26713, 26715, 26707, 26689, 26690, 26694, 26687, 26693, 26695, 26672, 26667, 26677, 26665, 26670, 26668, 26671, 26653, 26650, 26647, 26635, 26632, 26604, 26587, 26575, 26563, 26543, 26523, 26516, 26502, 26475, 26472, 26466, 26439, 26426, 26406, 26391, 26381, 26358, 26348, 26326, 26311, 26316, 26300, 26276, 26270, 26230, 26223, 26198, 26178, 26147, 26139, 26119, 26108, 26110, 26207, 26090, 26071, 26072, 28581, 28339, 28055, 27954, 29263, 29279, 29270, 29258, 29281, 29266, 29259, 29294, 29282, 29277, 29265, 29286, 29273, 29261, 29287, 29269, 29285, 29280, 29267, 29292, 29274, 29268, 29288, 29284, 29262, 29289, 29260, 29293, 29264, 29272, 29295, 29271, 29283, 29278, 29276, 29290, 29275, 29291, 29009, 28568, 28908, 28500, 28728, 28814, 28021, 27155, 27964, 28319, 28330, 26423, 27145, 26232, 26580, 26630, 27899, 28343, 28742, 28552, 28996, 28810, 27272, 28452, 28521, 28267, 27554, 26788, 28681, 28981, 28181, 27838, 29045, 29219, 29179, 27756, 28802, 26773, 27289, 27961, 27316, 26117, 26845, 28782, 28084, 29194, 28352, 29229, 28831, 27670, 28431, 27242, 27373, 27466, 26402, 27713, 27009, 27854, 27910, 27969, 28173, 28178, 28992, 29038, 27216, 28529, 28587, 28834, 27536, 27604, 27598, 27867, 27406, 27063, 28094, 26355, 26562, 26786, 26539, 26784, 28147, 28179, 28405, 28550, 28614, 28752, 27137, 27374, 27367, 27720, 27941, 28649, 28712, 28696, 29199, 26149, 26394, 27618, 27841, 28929, 27086, 26957, 29080, 27161, 28172, 26817, 27285, 27300, 27595, 26499, 26679, 26527, 28563, 27518, 27551, 27575, 27805, 29160, 28024, 28361, 29222, 27117, 27360, 26505, 26622, 26827, 26588, 27217, 28429, 29113, 26834, 27347, 26490, 26487, 26820, 27519, 27655, 27993, 28545, 29155, 26322, 26429, 26479, 26392, 26456, 26114, 26476, 26602, 26066, 26335, 26083, 26091) /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:119:in 'Enumerable#flat_map'
# >>   Ppl::Season Load (1.5ms)  SELECT `ppl_seasons`.* FROM `ppl_seasons` WHERE `ppl_seasons`.`id` IN (1128, 1130, 1132, 1134, 1135, 1136, 1137, 1138, 1139, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1129, 1131, 1133, 1140, 1154, 1163, 1211) /*application='ShogiWeb'*/
# >>   ↳ app/models/quick_script/general/pre_professional_league_script.rb:119:in 'Enumerable#flat_map'
