Sandbox

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 (415311, 415232, 415213) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00079

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.21"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 3,
      "rows_produced_per_join": 3,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "3.62",
        "eval_cost": "0.60",
        "prefix_cost": "4.22",
        "data_read_per_join": "20K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (415311,415232,415213)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id	short_description	full_description
415213		<p>Hair dryer Nova N-6130, 1800 W, black. It is essential to always keep the hair dry, after every shower, the hair dryer has always been an indispensable accessory, especially for women. Today, the hair dryer is a necessity, both for women and for men.<br /></p> <p>Thanks to its innovative design, with a simple connection to the 220V outlet and the push of a button, in just a few moments, your hair will be completely dry, all thanks to its very high power that reaches up to 1800 W.</p> <p>Specifications:<br />Two speeds;<br />Three temperature levels;<br />Overheating protection;<br />Power: 1800 W;<br />Power source 220-240 V;<br />Color: Black.</p> <p></p>
415232		<p>Hair and Beard Straightening Plate</p> <p>MODERN TECHNOLOGY<br />WITH THE HELP OF THIS MINI PLATES FOR HAIR AND BEARD, YOU CAN STYLE YOUR LOOK, YOU CAN GIVE VOLUME TO YOUR HAIR OR STRAIGHTEN YOUR BEARD.<br /> <br />THIS PLATE IS RECOMMENDED FOR ANY TYPE OF HAIR.</p> <p>THE PLATE HEATS UP QUICKLY (AROUND 15 SECONDS) AND HAS A COMB-TYPE BRUSH THAT YOU CAN USE TO STRAIGHTEN YOUR BEARD OR HAIR, FOR EFFECTIVE STYLING.</p> <p>DUE TO THE POWER OF NEGATIVE IONS, IRON MOISTURIZES AND SMOOTHENS THE BEARD, PREVENTS HEAT DAMAGE AND ENSURES THEIR HEALTHY AND SHINY APPEARANCE.</p> <p>THE HAIR OF THE COMB PROTECTS THE FACE AND HEAD SKIN FROM OVERHEATING, THE NEGATIVE IONS ENSURE A UNIFORM DISTRIBUTION AND PREVENT HAIR DAMAGE.</p> <p>THE IRON IS SUITABLE FOR MOST HAIR…</p><p></p>
415311		<p>DEVICE FOR BRAIDING HAIR, SECRET TWIST</p> <p>: Hair braiding device, Twist Secret<br />With the Twist Secret hair braiding device, you can create thick braids, tangled fancy threads, loose strands, luxurious braids, hair in a retro style, and many others limited only by your imagination.<br />This device has an innovative hair braiding system, for a precise styling, with an ergonomic shape that allows the quick and easy creation of the dream hairstyle you want, so you can create types of hairstyles such as: Romantic, Natural Hippie Chic , Chic headbands or any other style you want<br />With the help of the creative kit with 30 accessories available, you can create a fashionable hairstyle in just 3 simple steps.<br />Divide the hair into thin or thick pigtails, according to your preferences, put them in the pink Twister pins of the Twist Secret device and turn on the device to form them according to the style you have chosen. Specifications:<br />modern and ergonomic design<br />battery operation mode: 2 x AA<br />Hair accessories are NOT included.</p><p></p>