Explain Query (mysql)

EXPLAIN SELECT s.product_id, s.start_selling_on_date AS d, SUM(s.number_of_units_ordered * IF(s.reception_type = 4, floor(s.reception_weight/p.weight), 1)) AS nb FROM supplier_forecast_orders s LEFT JOIN products p ON (p.product_id = s.product_id) WHERE s.start_selling_on_date BETWEEN DATE_ADD('2025-04-09', INTERVAL 1 DAY) AND '2025-04-17' AND s.status IN (3, 14) AND s.instant_in_out = 0 AND s.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) GROUP BY product_id, start_selling_on_date;