Explain Query (mysql)
EXPLAIN SELECT
product_id,
SUM(number_of_units_available) qtyonhand
FROM
inventory
WHERE
product_id IN (40, 43, 48, 50, 54, 136, 235, 244, 247, 301, 304, 447, 512, 513, 516, 544, 914, 915, 920, 935, 1114, 1120, 1121, 1122, 1139, 1140, 1204, 1287, 1299, 1362, 1364, 1365, 1367, 1370, 1371, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1427, 1431, 1500, 1501, 1525, 1743, 1744, 1776, 1777, 1778, 1945, 2012, 2013, 2018, 2020, 2026, 2060, 2061, 2093, 2094, 2153, 2156, 2181, 2231, 2288, 2331, 2349, 2350, 2351, 2352, 2353, 2354, 2355, 2356, 2357, 2358, 2359, 2362, 2363, 2364, 2369, 2370, 2380, 2381, 2406, 2427, 2439, 2440, 2510, 2526, 2563, 2572, 2573, 2596, 2597, 2640, 2644, 2675, 2679, 2681, 2695, 2697, 2709, 2710, 2711, 2714, 2738, 2743, 2754, 2755, 2756, 2770, 2771, 2772, 2778, 2796, 2905, 2906, 2907, 2910, 2917, 2918, 2939, 2982, 3002, 3052, 3209, 3215, 3216, 3220, 3222, 3230, 3231, 3235, 3236, 3237, 3239, 3240, 3241, 3243, 3253, 3254, 3262, 3264, 3266, 3309, 3313, 3318, 3322, 3323, 3326, 3329, 3335, 3336, 3351, 3352, 3373, 3374, 3377, 3385, 3386, 3387, 3485, 3498, 3499, 3500, 3501, 3502, 3587, 3590, 3617, 3622, 3623, 3668, 3669, 3690, 3692, 3725, 3792, 3794, 4203, 4204, 4206, 4211, 4226, 4228, 4231, 4249, 4261, 4262, 4278, 4282, 4285, 4288, 4289, 4320, 4321, 4322, 4325, 4332, 4335, 4339, 4346, 4361, 4363, 4367, 4371, 4373, 4375, 4379, 4386, 4387, 4413, 4414, 4437, 4449, 4450, 4455, 4471, 4475, 4476, 4478, 4486, 4496, 4520, 4521, 4529, 4533, 4539, 4555, 4556, 4583, 4584, 4589, 4592, 4605, 4675, 4685, 4691, 4692, 4693, 4694, 4743, 4932, 4933, 5039, 5043, 5047, 5071, 5157, 5164, 5168, 5171, 5185, 5194, 5205, 5207, 5208, 5213, 5215, 5219, 5237, 5239, 5240, 5294, 5376, 5540, 5547, 5604, 5609, 5630, 5631, 5632, 5633, 5646, 5688, 5693, 5696, 5707, 5712, 5750, 5763, 5764, 5776, 5791, 5793, 5831, 5841, 5843, 5922, 5960, 5964, 5966, 6010, 6021, 6042, 6043, 6046, 6047, 6048, 6072, 6074, 6089, 6109, 6121, 6122, 6150, 6151, 6194, 6196, 6198, 6200, 6223, 6265, 6288, 6362, 6374, 6565, 6569, 6599, 6654, 6677, 6729, 6788, 6797, 6798, 6799, 6801, 6803, 6805, 6807, 6808, 6830, 6834, 6835, 6837, 6840, 6855, 6856, 6873, 6877, 6880, 6889, 6897, 6985, 6991, 7020, 7022, 7025, 7027, 7047, 7093, 7094, 7095, 7107, 7113, 7122, 7128, 7129, 7130, 7136, 7137, 7138, 7140, 7157, 7158, 7177, 7260, 7279, 7280, 7281, 7307, 7308, 7309, 7310, 7337, 7353, 7354, 7357, 7362, 7397, 7428, 7431, 7439, 7444, 7447, 7479, 7480, 7482, 7483, 7487, 7489, 7490, 7491, 7528, 7530, 7595, 7597, 7598, 7601, 7602, 7679, 7750, 7753, 7774, 7775, 7812, 7813, 7814, 7818, 7820, 7822, 7877, 7880, 7923, 7994, 7995, 8004, 8005, 8006, 8007, 8024, 8030, 8054, 8055, 8072, 8201, 8236, 8239, 8248, 8274, 8275, 8312, 8326, 8341, 8356, 8404, 8405, 8413, 8420, 8445, 8513, 8514, 8529, 8546, 8549, 8550, 8555, 8556, 8557, 8558, 8565, 8575, 8577, 8591, 8597, 8598, 8600, 8602, 8606, 8608, 8614, 8618, 8621, 8622, 8624, 8625, 8627, 8628, 8630, 8632, 8634, 8635, 8669, 8670, 8673, 8674, 8687, 8690, 8695, 8708, 8710, 8723, 8733, 8736, 8737, 8738, 8752, 8754, 8756, 8757, 8758, 8759, 8760, 8761, 8762, 8767, 8768, 8769, 8780, 8788, 8789, 8820, 8845, 8848, 8853, 8886, 8894, 8898, 8899, 8900, 8907, 8922, 8925, 8926, 8928, 8945, 8971, 8980, 8988, 8989, 8990, 8991, 8992, 8993, 8995, 8996, 8997, 8998, 9012, 9036, 9055, 9056, 9057, 9064, 9065, 9066, 9067, 9068, 9076, 9093, 9095, 9116, 9117, 9118, 9119, 9120, 9121, 9126, 9128, 9129, 9134, 9135, 9144, 9145, 9148, 9149, 9150, 9159, 9219, 9222, 9227, 9235, 9236, 9237, 9238, 9239, 9253, 9264, 9409, 9416, 9417, 9435, 9436, 9438, 9439, 9448, 9449, 9487, 9510, 9525, 9546, 9577, 9578, 9579, 9650, 9658, 9686, 9699, 9700, 9712, 9723, 9736, 9737, 9741, 9772, 9796, 9799, 9800, 9820, 9832, 9892, 9893, 9895, 9896, 9908, 9909, 9910, 9911, 9914, 9918, 9921, 9923, 9924, 9951, 9956, 9959, 9960, 9966, 9997, 9998, 10034, 10037, 10038, 10053, 10056, 10058, 10059, 10060, 10062, 10063, 10074, 10084, 10096, 10097, 10119, 10122, 10123, 10124, 10133, 10137, 10143, 10144, 10145, 10147, 10148, 10156, 10158, 10160, 10174, 10177, 10180, 10186, 10189, 10201, 10202, 10203, 10204, 10205, 10206, 10207, 10208, 10234, 10235, 10254, 10260, 10273, 10274, 10275, 10288, 10289, 10290, 10291, 10292, 10293, 10295, 10332, 10337, 10388, 10389, 10390, 10392, 10394, 10396, 10397, 10398, 10400, 10407, 10409, 10410, 10411, 10413, 10414, 10424, 10446, 10455, 10456, 10457, 10464, 10510, 10522, 10546, 10557, 10559, 10560, 10562, 10572, 10573, 10575, 10576, 10577, 10578, 10579, 10580, 10582, 10583, 10584, 10585, 10586, 10609, 10613, 10643, 10644, 10649, 10651, 10652, 10662, 10663, 10664, 10665, 10666, 10667, 10668, 10680, 10693, 10700, 10701, 10704, 10705, 10706, 10727, 10728, 10731, 10734, 10735, 10736, 10745, 10746, 10747, 10748, 10749, 10759, 10763, 10766, 10767, 10770, 10771, 10774, 10776, 10794, 10834, 10848, 10849, 10851, 10852, 10853, 10862, 10863, 10864, 10895, 10902, 10903, 10904, 10905, 10906, 10907, 10908, 10909, 10910, 10912, 10917, 10918, 10920, 10938, 10939, 10940, 10941, 10942, 10943, 10976, 10987, 11011, 11022, 11024, 11025, 11026, 11027, 11028, 11029, 11031, 11032, 11060, 11063, 11091, 11092, 11095, 11106, 11124, 11127, 11128, 11142, 11170, 11171, 11192, 11204, 11215, 11216, 11217, 11220, 11226, 11239, 11243, 11259, 11268, 11269, 11270, 11272, 11276, 11279, 11280, 11300, 11301, 11315, 11328, 11329, 11330, 11332, 11339, 11344, 11353, 11354, 11357, 11358, 11359, 11360, 11363, 11364, 11367, 11370, 11409, 11410, 11411, 11413, 11424, 11452, 11475, 11478, 11479, 11496, 11508, 11529, 11534, 11551, 11563, 11565, 11567, 11580, 11581, 11587, 11588, 11589, 11592, 11593, 11601, 11609, 11640, 11643, 11646, 11664, 11665, 11688, 11689, 11706, 11729, 11753, 11770, 11776, 11777, 11782, 11784, 11786, 11815, 11820, 11825, 11834, 11840, 11853, 11869, 11870, 11871, 11894, 11903, 11908, 11918, 11940, 11952, 11985, 11990, 11994, 11995, 12000, 12002, 12004, 12009, 12010, 12016, 12018, 12019, 12020, 12021, 12067, 12079, 12082, 12094, 12100, 12101, 12102, 12103, 12104, 12105, 12109, 12111, 12112, 12119, 12120, 12125, 12126, 12127, 12129, 12130, 12131, 12132, 12133, 12134, 12136, 12154, 12176, 12184, 12185, 12190, 12191, 12192, 12198, 12206, 12213, 12216, 12236, 12239, 12240, 12260, 12263, 12264, 12269, 12270, 12271, 12272, 12273, 12274, 12282, 12283, 12289, 12290, 12291, 12292, 12293, 12294, 12296, 12299, 12302, 12306, 12307, 12308, 12313, 12319, 12322, 12326, 12337, 12338, 12345, 12353, 12356, 12369, 12374, 12393, 12395, 12399, 12426, 12439, 12442, 12444, 12445, 12465, 12466, 12471, 12472, 12475, 12483, 12491, 12500, 12502, 12503, 12504, 12505, 12531, 12532, 12533, 12536, 12537, 12538, 12542, 12553, 12558, 12559, 12567, 12585, 12586, 12608, 12614, 12616, 12640, 12644, 12676, 12719, 12720, 12721, 12722, 12727, 12735, 12737, 12738, 12741, 12743, 12746, 12747, 12748, 12766, 12767, 12775, 12779, 12782, 12809, 12810, 12818, 12822, 12843, 12850, 12853, 12856, 12857, 12871, 12894, 12927, 12929, 12932, 12958, 12959, 12960, 12961, 12962, 12963, 12964, 12965, 12966, 12967, 12974, 12979, 12980, 12983, 12984, 12986, 12988, 12990, 12999, 13015, 13032, 13040, 13043, 13050, 13053, 13054, 13060, 13062, 13073, 13082, 13085, 13087, 13091, 13097, 13172, 13181, 13182, 13183, 13184, 13187, 13188, 13189, 13190, 13191, 13193, 13194, 13195, 13196, 13228, 13251, 13262, 13264, 13265, 13266, 13268, 13269, 13275, 13279, 13297, 13299, 13323, 13324, 13331, 13333, 13334, 13354, 13355, 13357, 13358, 13359, 13368, 13378, 13379, 13381, 13403, 13409, 13410, 13414, 13419, 13423, 13424, 13450, 13483, 13485, 13486, 13497, 13507, 13512, 13552, 13558, 13563, 13584, 13595, 13599, 13601, 13602, 13619, 13622, 13624, 13626, 13627, 13628, 13629, 13630, 13641, 13646, 13647, 13674, 13675, 13676, 13681, 13689, 13691, 13692, 13695, 13697, 13703, 13706, 13707, 13708, 13709, 13710, 13712, 13718, 13719, 13722, 13730, 13736, 13739, 13741, 13745, 13750, 13754, 13756, 13757, 13758, 13759, 13761, 13762, 13763, 13765, 13766, 13772, 13775, 13781, 13791, 13794, 13801, 13803, 13806, 13808, 13812, 13813, 13814, 13815, 13818, 13820, 13827, 13829, 13833, 13834, 13835, 13844, 13845, 13851, 13852, 13853, 13854, 13856, 13860, 13873, 13874, 13879, 13881, 13882, 13883, 13890, 13896, 13897, 13911, 13915, 13916, 13921, 13929, 13931, 13932, 13942, 13950, 13951, 13952, 13958, 13965, 13995, 13996, 13998, 14001, 14005, 14006, 14023, 14027, 14044, 14045, 14046, 14064, 14071, 14076, 14078, 14079, 14088, 14090, 14092, 14093, 14094, 14095, 14096, 14097, 14098, 14099, 14100, 14101, 14103, 14132, 14135, 14136, 14137, 14146, 14147, 14149, 14159, 14167, 14170, 14180, 14185, 14186, 14188, 14189, 14190, 14191, 14192, 14197, 14212, 14213, 14219, 14220, 14223, 14230, 14239, 14241, 14243, 14247, 14249, 14265, 14270, 14276, 14285, 14291, 14293, 14294, 14304, 14306, 14316, 14317, 14318, 14320, 14322, 14323, 14327, 14332, 14333, 14337, 14343, 14344, 14348, 14349, 14356, 14360, 14363, 14370, 14374, 14376, 14381, 14388, 14396, 14397, 14400, 14405, 14406, 14408, 14409, 14410, 14411, 14417, 14420, 14428, 14437, 14439, 14442, 14451, 14452, 14456, 14460, 14461, 14463, 14482, 14484, 14491, 14527, 14528, 14530, 14541, 14554, 14556, 14578, 14579, 14580, 14581, 14611, 14627, 14641, 14662, 14690, 14691, 14693, 14701, 14705, 14706, 14713, 14715, 14716, 14717, 14718, 14719, 14723, 14725, 14727, 14728, 14729, 14745, 14749, 14760, 14762, 14774, 14775, 14786, 14795, 14796, 14797, 14808, 14812, 14813, 14819, 14820, 14824, 14825, 14826, 14831, 14834, 14841, 14845, 14854, 14856, 14872, 14885, 14900, 14901, 14926, 14986, 14987, 15017, 15036, 15038, 15053, 15058, 15061, 15064, 15067, 15079, 15082, 15083, 15084, 15085, 15090, 15101, 15102, 15107, 15112, 15117, 15119, 15124, 15127, 15128, 15130, 15147, 15148, 15156, 15163, 15165, 15166, 15168, 15169, 15170, 15171, 15173, 15174, 15175, 15176, 15177, 15180, 15184, 15189, 15190, 15191, 15192, 15193, 15194, 15199, 15219, 15221, 15222, 15223, 15272, 15275, 15277, 15289, 15292, 15300, 15314, 15315, 15335, 15336, 15340, 15341, 15342, 15343, 15344, 15365, 15366, 15382, 15398, 15402, 15403, 15404, 15405, 15407, 15413, 15417, 15428, 15430, 15431, 15437, 15449, 15450, 15453, 15459, 15468, 15475, 15478, 15479, 15484, 15495, 15497, 15498, 15501, 15502, 15503, 15507, 15508, 15515, 15516, 15517, 15520, 15526, 15529, 15534, 15535, 15542, 15545, 15546, 15547, 15548, 15549, 15550, 15551, 15554, 15555, 15556, 15558, 15559, 15560, 15561, 15562, 15569, 15573, 15585, 15586, 15589, 15590, 15591, 15592, 15593, 15607, 15619, 15620, 15621, 15622, 15623, 15631, 15635, 15639, 15663, 15668, 15669, 15673, 15675, 15677, 15693, 15694, 15711, 15712, 15720, 15729, 15747, 15748, 15751, 15752, 15759, 15760, 15763, 15764, 15769, 15776, 15778, 15786, 15796, 15797, 15802, 15817, 15818, 15821, 15824, 15845, 15846, 15848, 15853, 15862, 15870, 15874, 15875, 15882, 15889, 15895, 15901, 15902, 15903, 15907, 15909, 15910, 15911, 15912, 15916, 15919, 15920, 15921, 15931, 15932, 15933, 15939, 15947, 15954, 15956, 15957, 15958, 15968, 15972, 15973, 15975, 15976, 15977, 15981, 15982, 15984, 15989, 15992, 16002, 16016, 16019, 16020, 16025, 16026, 16033, 16034, 16035, 16036, 16037, 16038, 16041, 16058, 16060, 16064, 16074, 16086, 16090, 16092, 16096, 16097, 16099, 16100, 16101, 16109, 16110, 16111, 16112, 16114, 16115, 16122, 16123, 16124, 16125, 16128, 16129, 16132, 16135, 16137, 16140, 16141, 16142, 16144, 16145, 16213, 16215, 16216, 16218, 16227, 16228, 16230, 16235, 16238, 16239, 16241, 16242, 16243, 16247, 16248, 16250, 16251, 16252, 16254, 16257, 16265, 16278, 16291, 16299, 16302, 16303, 16304, 16313, 16315, 16322, 16332, 16335, 16336, 16338, 16355, 16367, 16368, 16370, 16371, 16372, 16378, 16385, 16386, 16391, 16392, 16393, 16397, 16398, 16399, 16400, 16401, 16402, 16404, 16405, 16406, 16408, 16410, 16411, 16412, 16414, 16415, 16416, 16418, 16420, 16422, 16423, 16424, 16425, 16426, 16428, 16430, 16431, 16434, 16435, 16436, 16437, 16438, 16439, 16440, 16441, 16443, 16450, 16457, 16459, 16466, 16467, 16468, 16469, 16476, 16477, 16478, 16481, 16482, 16483, 16484, 16485, 16486, 16487, 16488, 16489, 16490, 16491, 16492, 16499, 16503, 16504, 16505, 16508, 16509, 16511, 16512, 16513, 16524, 16525, 16547, 16548, 16552, 16553, 16554, 16555, 16563, 16568, 16580, 16581, 16582, 16583, 16587, 16599, 16613, 16627, 16636, 16643, 16644, 16645, 16653, 16656, 16662, 16665, 16666, 16671, 16673, 16676, 16679, 16690, 16691, 16692, 16694, 16697, 16705, 16706, 16710, 16711, 16733, 16734, 16736, 16737, 16738, 16743, 16747, 16755, 16785, 16787, 16788, 16789, 16790, 16792, 16793, 16802, 16810, 16811, 16814, 16820, 16821, 16824, 16827, 16831, 16835, 16836, 16837, 16850, 16851, 16852, 16853, 16854, 16855, 16858, 16859, 16863, 16865, 16874, 16875, 16876, 16883, 16884, 16893, 16896, 16897, 16898, 16899, 16903, 16909, 16913, 16924, 16925, 16931, 16932, 16934, 16941, 16944, 16949, 16957, 16958, 16961, 16965, 16967, 16971, 16979, 16981, 16982, 16995, 16996, 16998, 17008, 17011, 17012, 17013, 17014, 17015, 17016, 17017, 17018, 17019, 17022, 17025, 17033, 17034, 17037, 17042, 17045, 17046, 17048, 17051, 17059, 17060, 17062, 17063, 17066, 17068, 17069, 17073, 17075, 17077, 17080, 17084, 17091, 17092, 17112, 17115, 17117, 17126, 17127, 17130, 17141, 17142, 17143, 17144, 17145, 17146, 17147, 17148, 17152, 17153, 17154, 17155, 17156, 17157, 17158, 17161, 17168, 17169, 17170, 17171, 17172, 17177, 17178, 17180, 17181, 17182, 17186, 17189, 17190, 17198, 17199, 17201, 17205, 17209, 17210, 17211, 17212, 17213, 17216, 17223, 17224, 17225, 17226, 17227, 17228, 17230, 17231, 17233, 17234, 17235, 17236, 17240, 17243, 17244, 17245, 17248, 17249, 17250, 17251, 17252, 17253, 17254, 17255, 17263, 17264, 17265, 17266, 17267, 17268, 17270, 17272, 17273, 17280, 17281, 17282, 17284, 17285, 17286, 17290, 17293, 17332, 17338, 17339, 17340, 17341, 17342, 17344, 17345, 17346, 17348, 17350, 17351, 17352, 17353, 17354, 17355, 17356, 17357, 17358, 17359, 17360, 17365, 17366, 17368, 17371, 17372, 17373, 17374, 17378, 17379, 17380, 17382, 17384, 17385, 17387, 17389, 17391, 17396, 17398, 17399, 17401, 17402, 17408, 17412, 17416, 17418, 17424, 17428, 17429, 17430, 17433, 17435, 17436, 17441, 17444, 17445, 17446, 17447, 17449, 17450, 17451, 17452, 17461, 17466, 17467, 17468, 17472, 17481, 17485, 17486, 17487, 17488, 17492, 17493, 17495, 17502, 17504, 17505, 17508, 17509, 17510, 17512, 17514, 17515, 17524, 17526, 17527, 17528, 17530, 17543, 17545, 17554, 17555, 17557, 17558, 17559, 17560, 17561, 17562, 17563, 17565, 17566, 17567, 17576, 17577, 17578, 17581, 17582, 17583, 17584, 17585, 17586, 17587, 17589, 17590, 17591, 17592, 17600, 17601, 17606, 17607, 17608, 17610, 17612, 17613, 17614, 17616, 17617, 17619, 17620, 17621, 17622, 17623, 17624, 17625, 17628, 17635, 17637, 17640, 17641, 17642, 17649, 17650, 17654, 17657, 17658, 17659, 17660, 17661, 17664, 17668, 17669, 17670, 17671, 17672, 17673, 17674, 17675, 17677, 17680, 17682, 17683, 17688, 17689, 17690, 17691, 17692, 17693, 17697, 17699, 17700, 17701, 17704, 17710, 17711, 17718, 17721, 17729, 17733, 17738, 17739, 17741, 17742, 17743, 17744, 17746, 17747, 17748, 17750, 17756, 17763, 17764, 17765, 17766, 17768, 17769, 17770, 17773, 17775, 17777, 17778, 17788, 17789, 17790, 17795, 17796, 17799, 17802, 17806, 17808, 17809, 17814, 17817, 17818, 17819, 17820, 17821, 17823, 17827, 17830, 17831, 17832, 17834, 17835, 17836, 17838, 17841, 17843, 17844, 17847, 17854, 17856, 17858, 17859, 17860, 17863, 17864, 17865, 17871, 17873, 17874, 17875, 17876, 17878, 17879, 17880, 17881, 17882, 17883, 17884, 17885, 17886, 17891, 17892, 17893, 17894, 17895, 17896, 17897, 17898, 17899, 17900, 17901, 17902, 17903, 17904, 17906, 17907, 17909, 17912, 17913, 17914, 17921, 17922, 17923, 17926, 17928, 17929, 17930, 17931, 17932, 17939, 17940, 17941, 17942, 17943, 17944, 17945, 17946, 17948, 17949, 17951, 17952, 17953, 17954, 17955, 17956, 17957, 17958, 17959, 17960, 17961, 17962, 17963, 17964, 17965, 17966, 17967, 17968, 17969, 17970, 17971, 17972, 17973, 17974, 17975, 17976, 17977, 17980, 17981, 17983, 17987, 17988, 17990, 17992, 17993, 17994, 17995, 17996, 17997, 17998, 18001, 18002, 18003, 18004, 18016, 18017, 18018, 18019, 18020, 18021, 18022, 18023, 18024, 18025, 18026, 18027, 18028, 18032, 18034, 18035, 18038, 18039, 18040, 18041, 18042, 18044, 18045, 18046, 18047, 18048, 18057, 18058, 18059, 18061, 18062, 18064, 18065, 18066, 18067, 18068, 18069, 18070, 18071, 18079, 18080, 18082, 18084, 18086, 18087, 18088, 18089, 18090, 18091, 18092, 18093, 18094, 18096, 18098, 18099, 18100, 18101, 18102, 18108, 18109, 18110, 18111, 18112, 18113, 18115, 18116, 18117, 18118, 18119, 18120, 18121, 18123, 18125, 18126, 18128, 18129, 18130, 18131, 18132, 18134, 18135, 18138, 18142, 18143, 18154, 18155, 18156, 18157, 18158, 18159, 18160, 18161, 18162, 18164, 18166, 18170, 18171, 18172, 18173, 18174, 18177, 18178, 18179, 18180, 18181, 18182, 18183, 18185, 18186, 18187, 18188, 18189, 18190, 18193, 18199, 18211, 18212, 18213, 18214, 18216, 18219, 18220, 18221, 18224, 18233, 18235, 18236, 18237, 18239, 18240, 18241, 18247, 18251, 18252, 18253, 18254, 18256, 18271, 18275, 18276, 18277, 18281, 18282, 18293, 18304, 18309, 18312, 18313, 18314, 18315, 18316, 18317, 18318, 18328, 18329, 18330, 18331, 18332, 18334, 18335, 18338, 18341, 18342, 18345, 18346, 18347, 18348, 18350, 18351, 18356, 18359, 18360, 18361, 18362, 18365, 18367, 18368, 18369, 18370, 18371, 18372, 18373, 18375, 18379, 18383, 18384, 18385, 18386, 18388, 18389, 18390, 18391, 18392, 18393, 18396, 18398, 18399, 18400, 18401, 18402, 18403, 18404, 18406, 18407, 18409, 18422, 18423, 18424, 18428, 18429, 18431, 18432, 18433, 18437, 18438, 18439, 18440, 18441, 18442, 18443, 18445, 18446, 18448, 18449, 18450, 18451, 18452, 18453, 18454, 18455, 18456, 18457, 18458, 18459, 18464, 18465, 18466, 18467, 18475, 18476, 18498, 18499, 18511, 18512, 18515, 18516, 18517, 18522, 18523, 18524, 18525, 18528, 18529, 18530, 18531, 18532, 18533, 18534, 18535, 18536, 18540, 18541, 18542, 18545, 18546, 18554, 18556, 18557, 18559, 18560, 18562, 18564, 18579, 18580, 18581, 18583, 18584, 18585, 18587, 18588, 18589, 18590, 18593, 18595, 18597, 18601, 18605, 18608, 18614, 18615, 18616, 18617, 18632, 18633, 18634, 18640, 18643, 18644, 18645, 18646, 18647, 18648, 18649, 18650, 18651, 18652, 18653, 18654, 18655, 18656, 18657, 18661, 18662, 18663, 18664, 18665, 18666, 18674, 18682, 18683, 18684, 18686, 18695, 18696, 18697, 18698, 18699, 18700, 18701, 18703, 18704, 18705, 18706, 18708, 18709, 18710, 18711, 18712, 18713, 18714, 18715, 18717, 18726, 18728, 18729, 18730, 18731, 18734, 18735, 18736, 18741, 18742, 18743, 18746, 18748, 18750, 18751, 18752, 18753, 18754, 18757, 18758, 18763, 18766, 18768, 18771, 18772, 18773, 18774, 18775, 18779, 18780, 18781, 18782, 18783, 18784, 18786, 18789, 18794, 18797, 18798, 18802, 18803, 18807, 18811, 18815, 18816, 18818, 18822, 18823, 18824, 18827, 18828, 18830, 18831, 18832, 18833, 18834, 18836, 18837, 18838, 18839, 18840, 18841, 18842, 18846, 18847, 18848, 18850, 18851, 18853, 18854, 18860, 18862, 18865, 18866, 18867, 18868, 18869, 18870, 18875, 18876, 18877, 18881, 18889, 18890, 18891, 18892, 18897, 18898, 18899, 18901, 18902, 18903, 18904, 18905, 18906, 18911, 18912, 18913, 18914, 18915, 18917, 18918, 18920, 18921, 18922, 18924, 18925, 18926, 18928, 18929, 18930, 18932, 18933, 18940, 18941, 18942, 18943, 18946, 18947, 18948, 18949, 18950, 18952, 18953, 18955, 18956, 18957, 18958, 18959, 18960, 18962, 18963, 18965, 18966, 18967, 18968, 18972, 18973, 18974, 18975, 18976, 18979, 18981, 18982, 18985, 18986, 18988, 18991, 18992, 18994, 18996, 18997, 18999, 19000, 19001, 19002, 19003, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018, 19019, 19020, 19022, 19025, 19026, 19027, 19028, 19029, 19033, 19034, 19035, 19036, 19042, 19044, 19049, 19050, 19051, 19053, 19054, 19056, 19057, 19058, 19059, 19060, 19061, 19062, 19063, 19065, 19066, 19067, 19068, 19069, 19071, 19072, 19073, 19074, 19075, 19076, 19077, 19078, 19083, 19084, 19085, 19086, 19087, 19088, 19089, 19090, 19091, 19092, 19093, 19094, 19095, 19096, 19097, 19098, 19099, 19100, 19101, 19102, 19103, 19104, 19105, 19106, 19107, 19109, 19110, 19111, 19112, 19113, 19114, 19115, 19116, 19117, 19119, 19120, 19122, 19123, 19124, 19125, 19126, 19127, 19128, 19129, 19130, 19131, 19135, 19136, 19138, 19140, 19141, 19143, 19144, 19145, 19148, 19149, 19150, 19151, 19153, 19154, 19155, 19156, 19157, 19158, 19159, 19160, 19161, 19162, 19163, 19164, 19165, 19166, 19167, 19168, 19169, 19170, 19171, 19173, 19174, 19175, 19178, 19179, 19180, 19181, 19182, 19183, 19185, 19188, 19189, 19191, 19192, 19194, 19195, 19196, 19197, 19198, 19205, 19206, 19207, 19208, 19209, 19210, 19211, 19212, 19213, 19214, 19215, 19217, 19218, 19220, 19221, 19222, 19223, 19224, 19225, 19226, 19227, 19228, 19229, 19231, 19232, 19236, 19237, 19238, 19239, 19240, 19241, 19252, 19253, 19254, 19255, 19256, 19257, 19258, 19259, 19261, 19264, 19265, 19266, 19267, 19268, 19269, 19271, 19272, 19273, 19274, 19275, 19276, 19277, 19278, 19279, 19280, 19281, 19282, 19283, 19284, 19286, 19294, 19295) AND
`number_of_units_available` > 0
GROUP BY
product_id;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | inventory | range | idx_number_of_units_available, product_id | idx_number_of_units_available | 4 | 3506 | 18.00 | Using index condition; Using where; Using temporary |