SELECT 
  category_id, 
  parent_id 
FROM 
  tmall_categories 
WHERE 
  parent_id IN(
    286, 282, 272, 280, 266, 277, 273, 270, 
    285, 287, 289, 288, 292, 281, 279, 291, 
    269, 283, 275, 276, 274, 267, 278, 268, 
    271, 290, 284, 235, 216, 204, 242, 229, 
    222, 251, 210, 168, 198, 166, 212, 176, 
    178, 190, 224, 255, 246, 167, 182, 175, 
    230, 220, 252, 197, 211, 213, 236, 185, 
    169, 243, 191, 247, 209, 217, 203, 225, 
    193, 223, 199, 215, 221, 214, 231, 240, 
    208, 179, 249, 253, 226, 186, 218, 174, 
    244, 219, 234, 194, 200, 180, 238, 232, 
    202, 227, 248, 187, 181, 195, 177, 228, 
    237, 196, 188, 241, 254, 189, 245, 250, 
    165, 170, 171, 172, 201, 263
  )

Query time 0.00812

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.028190165,
    "nested_loop": [
      {
        "table": {
          "table_name": "tmall_categories",
          "access_type": "ALL",
          "possible_keys": ["parent"],
          "loops": 1,
          "rows": 113,
          "cost": 0.028190165,
          "filtered": 100,
          "attached_condition": "tmall_categories.parent_id in (286,282,272,280,266,277,273,270,285,287,289,288,292,281,279,291,269,283,275,276,274,267,278,268,271,290,284,235,216,204,242,229,222,251,210,168,198,166,212,176,178,190,224,255,246,167,182,175,230,220,252,197,211,213,236,185,169,243,191,247,209,217,203,225,193,223,199,215,221,214,231,240,208,179,249,253,226,186,218,174,244,219,234,194,200,180,238,232,202,227,248,187,181,195,177,228,237,196,188,241,254,189,245,250,165,170,171,172,201,263)"
        }
      }
    ]
  }
}