SELECT 
  category_id, 
  parent_id 
FROM 
  ushop_categories 
WHERE 
  parent_id IN(
    318, 328, 329, 330, 331, 332, 333, 334, 
    335, 325, 320, 326, 319, 336, 323, 337, 
    315, 338, 339, 324, 340, 341, 321, 342, 
    317, 322, 316, 343, 344, 345, 327, 346, 
    375, 767, 768, 769, 770, 771, 772, 773, 
    774
  ) 
  AND category_id != 264

Query time 0.00228

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "50.13"
    },
    "table": {
      "table_name": "ushop_categories",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "parent",
        "p_category_id"
      ],
      "rows_examined_per_scan": 462,
      "rows_produced_per_join": 421,
      "filtered": "91.13",
      "cost_info": {
        "read_cost": "8.03",
        "eval_cost": "42.10",
        "prefix_cost": "50.13",
        "data_read_per_join": "1M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "((`marketplace`.`ushop_categories`.`parent_id` in (318,328,329,330,331,332,333,334,335,325,320,326,319,336,323,337,315,338,339,324,340,341,321,342,317,322,316,343,344,345,327,346,375,767,768,769,770,771,772,773,774)) and (`marketplace`.`ushop_categories`.`category_id` <> 264))"
    }
  }
}