SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (438) 
  AND cscart_product_descriptions.lang_code = 'ja'

Query time 0.00056

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "const",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_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": "3K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text"
      ]
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
438 <p><strong style="background-color: initial;">DETAILS:</strong> You won't have to say a word - the elegant sophistication of these gorgeous roses will get your message across.</p> <p><strong>DELIVERY:</strong> Deliveries are normally made between 8am and 7pm - (Mon to Sun). However, during busy periods, these delivery times may differ slightly, and we reserve the right to deliver between <strong>7am and 7pm</strong> East African Time (+3GMT). Our florist delivered flowers and arrangements are personally hand delivered by our local florists. Vase are for the purpose of photographs only but can be purchased separately where necessary</p> <p><strong>CONTENT:</strong> All of our flowers, bouquets and arrangements are individually crafted from the freshest blooms. While we always strive to ensure that products are accurately represented in our photographs, from season to season and subject to availability, our florists may be required to substitute one or more flowers for a variety of equal or greater quality, appearance and value.&nbsp;</p> <p><b>WE OFFER NO-QUIBBLE GUARANTEE!</b></p> <p>You can order with confidence thanks to our quality guarantees. We take great care and pride in packing all our flower and plant gifts and provide a 7 day freshness guarantee for your peace of mind. But we're human and understand that things don’t always work out as expected - our no quibble guarantee means that we will make things right for you without any hassle.</p>