SELECT 
  DISTINCT feature_id 
FROM 
  cscart_product_features_descriptions 
WHERE 
  LOWER(description) IN (
    'import flag', 'importflag', 'import_flag'
  ) 
  OR description = '해외구매대행'

Query time 0.00019

JSON explain

{
  "query_block": {
    "select_id": 1,
    "temporary_table": {
      "table": {
        "table_name": "cscart_product_features_descriptions",
        "access_type": "ALL",
        "rows": 650,
        "filtered": 100,
        "attached_condition": "lcase(cscart_product_features_descriptions.description) in ('import flag','importflag','import_flag') or cscart_product_features_descriptions.description = '해외구매대행'"
      }
    }
  }
}