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, 
  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 (
    11475, 20583, 7772, 22234, 13712, 7520, 
    11765, 20146, 20077, 9524, 12869
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00059

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_descriptions",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["product_id", "lang_code"],
          "rows": 11,
          "filtered": 100,
          "index_condition": "cscart_product_descriptions.product_id in (11475,20583,7772,22234,13712,7520,11765,20146,20077,9524,12869) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
7520		Glasses for the master of manicure and pedicureManicure and pedicure goggles are a professional accessory necessary for safe work of any nail service specialist. The glasses are made of high-quality plastic, they are absolutely transparent in the eye area, so there is no distortion of the view. The handles are plastic and have a secure fit. Glasses are universal in size. They are light, do not interfere with work, do not create discomfort. They serve as a reliable protection against damage to the eyes by an accidental fragment of the nail plate, prevent the ingress of dust during the correction of artificial manicure. There are special rubber pads on both sides in the zone of interaction with the bridge of the nose, so after removing the glasses there will be no traces on the skin.
7772		Pink Opal knuckle ring in crystal beads
9524
11475		pedicure bathA pedicure bath is an effective way to get rid of fatigue and tension in the legs.The bath combines comfort, practicality and health.Such a device can be used both in salons and at home.A foot bath will help prepare the skin for a pedicure, relieve fatigue in the muscles of the foot and tension.The bath has a convenient shape for comfortable placement of the legs and prevents splashing of water.Color in assortment.
11765		Smartphone lens set Fisheye 1 pc Macro 1 pc case included Mobile phone lenses are a know-how that allows you to take high-quality pictures in any conditions. Why do you need phone lenses? Each lens has individual optical characteristics, while the telephone one has minimal ones. In order to form an image and correct errors, you need a special lens for the phone. This device allows you to shoot in fisheye, macro and wide-angle formats. Each shooting option needs its own lens! Especially popular today is the fisheye - a lens on a phone with a viewing angle of 180 degrees. Perfect for a selfie! Fisheye for the phone has a high distortion, can distort the image, due to the "big capture", so the author`s "rounded" pictures are obtained. A special clip facilitates the work with lenses, which securely fixes the elements, as well as a soft ring that protects the body of the gadget from scratches.Specifications (Fish eye lens - Fish eye 180):View: up to 180 degreesConstruction: 2 elementsDimensions (main body): 24mm (diameter) x 14mm (length)Weight: 4gSpecifications (macro lens - macro lens):Review: super macro (20X)Construction: 2 elementsDimensions(main body): 19mm (diameter) x 5.5mm (length)Weight: 0.9gGeneral characteristics:Body material: plasticLens material: plasticClip size: 532020mmClip weight: 6.2gBlack colourEquipment: clip; 2 lenses; 2 lens caps.
12869		Face shield short
13712		Glasses for manicure and pedicure black When working as a manicurist , first of all, you need to protect your eyes from getting saws and various particles that form during work. For full eye protection, the master will need goggles . Glasses with black frames and polycarbonate lenses will protect your eyes. The lenses of the goggles completely cover the eyes and peripheral vision both in front and on the sides. Also, during operation, the glasses do not fog up, this will ensure that this procedure is performed with accuracy. The glasses are made from hypoallergenic materials.
20077
20146
20583
22234		This model has a platform with a diameter of 8 cm and allows you to adjust the heating temperature from 55 to 75°C. This allows you to use it to heat water, cosmetic materials, such as wax or paraffin. The temperature is adjusted in 10 ° C increments by successive pressing of the power button.