SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (350) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00019

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "product_id", "company_id"],
      "key": "PRIMARY",
      "key_length": "13",
      "used_key_parts": ["product_id", "lang_code", "company_id"],
      "ref": ["const", "const", "const"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
350 <p><br> This is Hex Key 5/32&quot; (4 mm) L-Wrench<br /> <br /> Use when you tighten the screws of the camera plate and the lens plate.<br /> </p> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Specification</div> <table align="center" width="100%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <td bgcolor="#ffffff"><div align="center"><strong>Weight</strong></div></td> <td bgcolor="#ffffff"><div align="left">0.35 oz (10 g)</div></td> </tr> <tr> <td bgcolor="#ffffff"><div align="center"><strong>Size</strong></div></td> <td nowrap="nowrap" bgcolor="#ffffff"><div align="left">0.6 X 2.8 in (14 X 72 mm)</div></td> </tr> <tr> <td bgcolor="#ffffff"><div align="center"><strong>Color</strong></div></td> <td nowrap="nowrap" bgcolor="#ffffff"><div align="left">Silver</div></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#ffffff"><div align="center"><strong>Fit</strong></div></td> <td nowrap="nowrap" bgcolor="#ffffff"><div align="left"><a title="Hex Head Plate Screw" href="http://markins.willnet.ad.jp/accessory/hb1/">Hex Head Plate Screw</a>, <a title="Hex Head Plate Screw (for P20)" href="http://markins.willnet.ad.jp/accessory/hb2/">Hex Head Plate Screw (for P20)</a>, <a title="M6 Screw" href="http://markins.willnet.ad.jp/accessory/m6bt/">M6 Screw</a> </div></td> </tr> </table>