SELECT 
  SUM(amount) 
FROM 
  ushop_order_details 
WHERE 
  product_id IN (
    526, 
    522, 
    523, 
    524, 
    525, 
    519, 
    520, 
    521, 
    507, 
    508, 
    509, 
    510, 
    511, 
    512, 
    513, 
    514, 
    515, 
    516, 
    517, 
    518, 
    506, 
    503, 
    504, 
    505, 
    500, 
    501, 
    502, 
    496, 
    497, 
    498, 
    499, 
    493, 
    494, 
    495, 
    459, 
    460, 
    461, 
    462, 
    463, 
    464, 
    465, 
    466, 
    467, 
    468, 
    469, 
    470, 
    471, 
    472, 
    473, 
    474, 
    475, 
    476, 
    477, 
    478, 
    479, 
    480, 
    481, 
    482, 
    483, 
    484, 
    485, 
    486, 
    487, 
    488, 
    489, 
    490, 
    491, 
    492, 
    458, 
    457, 
    456, 
    446, 
    447, 
    448, 
    449, 
    450, 
    451, 
    452, 
    453, 
    454, 
    455, 
    445, 
    435, 
    436, 
    437, 
    438, 
    439, 
    440, 
    441, 
    442, 
    443, 
    444, 
    431, 
    432, 
    433, 
    434, 
    429, 
    430, 
    287, 
    288, 
    289, 
    290, 
    291, 
    292, 
    293, 
    294, 
    295, 
    296, 
    297, 
    298, 
    300, 
    301, 
    302, 
    303, 
    304, 
    305, 
    306, 
    307, 
    308, 
    309, 
    310, 
    311, 
    312, 
    313, 
    314, 
    315, 
    316, 
    317, 
    318, 
    319, 
    320, 
    321, 
    322, 
    323, 
    324, 
    325, 
    326, 
    327, 
    328, 
    329, 
    330, 
    331, 
    332, 
    333, 
    334, 
    335, 
    336, 
    337, 
    338, 
    339, 
    340, 
    341, 
    342, 
    343, 
    344, 
    345, 
    346, 
    347, 
    348, 
    349, 
    350, 
    351, 
    352, 
    353, 
    354, 
    355, 
    356, 
    357, 
    358, 
    359, 
    360, 
    361, 
    362, 
    363, 
    364, 
    365, 
    366, 
    367, 
    368, 
    369, 
    370, 
    371, 
    372, 
    373, 
    374, 
    375, 
    376, 
    377, 
    378, 
    379, 
    380, 
    381, 
    382, 
    383, 
    384, 
    385, 
    386, 
    387, 
    388, 
    389, 
    390, 
    391, 
    392, 
    393, 
    394, 
    395, 
    396, 
    397, 
    398, 
    399, 
    400, 
    401, 
    402, 
    403, 
    404, 
    405, 
    406, 
    407, 
    408, 
    409, 
    410, 
    411, 
    412, 
    413, 
    414, 
    415, 
    416, 
    417, 
    418, 
    419, 
    420, 
    421, 
    422, 
    423, 
    424, 
    426, 
    427, 
    428, 
    547, 
    537, 
    544, 
    545, 
    546, 
    548, 
    551, 
    552, 
    553, 
    554, 
    555, 
    556, 
    557, 
    558
  )

Query time 0.00131

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "39.74"
    },
    "table": {
      "table_name": "ushop_order_details",
      "access_type": "ALL",
      "rows_examined_per_scan": 291,
      "rows_produced_per_join": 145,
      "filtered": "50.00",
      "cost_info": {
        "read_cost": "25.19",
        "eval_cost": "14.55",
        "prefix_cost": "39.74",
        "data_read_per_join": "32K"
      },
      "used_columns": [
        "product_id",
        "amount"
      ],
      "attached_condition": "(`marketplace`.`ushop_order_details`.`product_id` in (526,522,523,524,525,519,520,521,507,508,509,510,511,512,513,514,515,516,517,518,506,503,504,505,500,501,502,496,497,498,499,493,494,495,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,458,457,456,446,447,448,449,450,451,452,453,454,455,445,435,436,437,438,439,440,441,442,443,444,431,432,433,434,429,430,287,288,289,290,291,292,293,294,295,296,297,298,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,426,427,428,547,537,544,545,546,548,551,552,553,554,555,556,557,558))"
    }
  }
}

Result

SUM(amount)
107