SELECT 
  category_id, 
  ab__lc_catalog_image_control 
FROM 
  netting_categories 
WHERE 
  category_id in (
    '297', '366', '401', '382', '276', '290', 
    '335', '361', '392', '434', '419', 
    '369', '416', '378', '274', '451', 
    '331', '347', '444', '373', '376', 
    '304', '275', '310', '447', '383', 
    '265', '282', '381', '400', '384', 
    '334', '441', '333', '466'
  )

Query time 0.00125

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "netting_categories",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY", "p_category_id"],
          "rows": 180,
          "filtered": 19.44444466,
          "attached_condition": "netting_categories.category_id in ('297','366','401','382','276','290','335','361','392','434','419','369','416','378','274','451','331','347','444','373','376','304','275','310','447','383','265','282','381','400','384','334','441','333','466')"
        }
      }
    ]
  }
}