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 (415288) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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
415288 <p>Smartwatch Usmart V8, SIM card, camera, facebook notifications, whatsApp, black<br /></p><p>Characteristics:<br />1. High-definition touch screen, sensitive to touch, easy to use, 240 x 240 resolution.<br />2. GSM/GPRS - 850/900/1800/1900 calling function, hands-free, receiving SMS and sending SMS (For Android phones).<br />4. Function - MP3; Function to listen to your favorite song via BT; Missed call reminder function; Vibration function to remind you of missed calls/messages.<br />5. Bidirectional – Anti Loss, Bi-directional Search.<br />6. Camera for photos – The watch can take photos, they are saved on a micro-sd inside the watch (the microsd card is not included)</p> <p>7. Smartphone control with the help of the application - You can play the images taken with the watch on the phone.<br />8. Message information transfer (Only for Android): Whatsapp, Facebook, Skype, etc...</p> <p>Technical Parameters:<br />Bluetooth version: 3.0<br />1. ROM + RAM: 32M + 32M, Support 32GB TF Card (Micro-sd card is not included)<br />2. Screen: 1.22 inch 240 x 240 IPS HD<br />3. Touch Screen: OGS capacitive touch screen, full lamination technology<br />4. Resolution: 240 x 240 pixels<br />5. Battery: 280mAh Polymer Battery<br />6. SIM Card Type: Micro SIM<br />7. Band Material: TPU Band<br />8. Watch Weight: Approx 62G<br />9. Dimensions: 6 x 4 x 12.5 cm</p> <p>Note:<br />1. This watch only works in the network type: GSM 850/900/1800/1900MHz<br />2. The charging cable in the package can only be used for charging.</p> <p>It works in any* mobile phone network that uses the GSM 2G network: Digi, Vodafone, Telekom, Orange, etc.</p> <p>*Check with your mobile phone provider if there is a GSM 2G signal in your area</p> <p>Specifications:<br />Personalized<br />Hardware<br />Bluetooth version: Bluetooth 3.0<br />External memory: TF card up to 32GB<br />RAM: 32MB<br />ROM: 32MB<br />Waterproof: No</p> <p>Functions<br />Alert type: Indicator light<br />Anti-lost: Yes<br />Bluetooth Calling: Phone call reminder<br />Find phone: Yes<br />Health monitor: pedometer, sleep monitor<br />Notification: Yes<br />Other function: Bluetooth, alarm<br />Remote control function: Remote camera</p> <p>Screen<br />Screen: IPS<br />Screen resolution: 240 x 240<br />Screen size: 1.2 inches<br />Operating mode: Touch screen</p> <p>Battery<br />Battery capacity: 280mAh<br />Charging time: about 2 hours<br />Waiting time: 72 hours<br />Battery type: lithium battery</p> <p>Dial and Band<br />Band material: TPU<br />Case material: metal<br />Dial shape: round</p> <p>Characteristics<br />Color: Black<br />Compatible operating system: Android<br />Language: English, French, Spanish, Portuguese, Russian, German, Italian, Polish, Turkish</p><p></p> <p><br /></p>