SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (415310) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

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": "6K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
415310 <p>Electric sewing machine with pedal Mini Sewing Machine SM-202A<br />: Electric pedal sewing machine Mini Sewing Machine SM-202A comes with a modern and simple design, thus making it a perfect sewing machine for lovers of this genre.<br />It should not be missing from anyone's home because it does not take up much space, being portable and with a shape that combines the useful with the pleasant.<br />The Mini Sewing Machine is a device that can sew almost any type of material, the pedal sewing machine can be easily installed, being portable and having a simple design, which makes it very maneuverable.<br />Something very special about this machine, is the fact that it can work with x 4 batteries or power from the socket being very useful, portable takes up little space, so you can take it with you on trips and vacations.<br />General features of the Mini Sewing Machine portable sewing machine:<br />~ The sewing machine only sews normally, it does not scroll or sew in zig zag!<br />~ Works by charging at the 220V outlet, with included adapter, or with 4 AA batteries (not included), if you go on vacation and want to be prepared<br />~ The electric machine is similar to the professional ones, it has a pedal to adjust the sewing speed and it works very easily and simply<br />~ Practically it works by itself, all you have to do is guide the material so that the needle penetrates where it should, and the stitch is ready!<br />~ It sometimes happens that you urgently need to mow something, without waiting to get to the tailor or to buy something new<br />~ With a little imagination, you can transform even an old and shabby thing into something beautiful<br />~ The portable electric sewing machine works with a 220V charger, or with batteries, it has a pedal for adjusting the sewing speed, 5 spools of thread included and accessories.<br />~ It behaves like a professional car, but small in size<br />~ Sew various materials: cotton, veil, silk, tricot, fabric, crepe<br />~ It has a pedal to control the sewing speed<br />~ It has 2 sewing speeds<br />~ Button for adjusting intensity, sewing speed<br />~ Button to change the power supply (either at the socket or with batteries)<br />~ Slot for connecting the pedal (Pedal with manual activation)<br />~ Led for use at night~ Slot with x4 AA 1.5 V batteries<br />~ Power supply with connection to the 100 - 240 V/AC socket<br />~ Dimensions (L x W x H): 22.00 x 13.10 x 21.10 cm<br />~ Package weight: 0.9</p>