SELECT 
  meta_description, 
  meta_keywords 
FROM 
  cscart_category_descriptions 
WHERE 
  category_id = 2902 
  AND lang_code = 'en'

Query time 0.00030

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "table": {
      "table_name": "cscart_category_descriptions",
      "access_type": "const",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "category_id",
        "lang_code"
      ],
      "key_length": "9",
      "ref": [
        "const",
        "const"
      ],
      "rows_examined_per_scan": 1,
      "rows_produced_per_join": 1,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.00",
        "eval_cost": "0.20",
        "prefix_cost": "0.00",
        "data_read_per_join": "4K"
      },
      "used_columns": [
        "category_id",
        "lang_code",
        "meta_keywords",
        "meta_description"
      ]
    }
  }
}

Result

meta_description meta_keywords
Cocktail Dress - Cocktail Dress - Discover the special products, the most beautiful dresses in Cocktail Dress only in Webmarco. The only market that offers good products for everyone. Webmarco, Web marco, Shopping online in Webmarco Cocktail Dress - beautiful dress, dress for events, beautifully knitted dress, dress in Webmarco, fashionable and special dress, dress, products in Webmarco