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 (10763, 11053, 11190) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00115

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": 3,
          "filtered": 100,
          "index_condition": "cscart_product_descriptions.product_id in (10763,11053,11190) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
10763		Stamping plate is an innovative tool for creating the perfect nail design, designed to be used by both professionals and manicure enthusiasts. This accessory allows you to transfer patterns and designs onto your nails with ease. How to use: Choose a suitable pattern on the steamping plate. Apply stamping varnish on the selected pattern on the plate. Using a spatula or a special card, carefully remove excess varnish from the surface of the plate, leaving varnish only in the recesses of the design. Press the silicone stamp against the pattern on the plate so that the design is transferred to its surface. Then carefully transfer the pattern from the stamper to the nail, pressing it evenly to the entire surface. Wait until the pattern is completely dry on the nail and then apply the fixing top coat.
11053		Stamping plate is an innovative tool for creating the perfect nail design, designed to be used by both professionals and manicure enthusiasts. This accessory allows you to transfer patterns and designs onto your nails with ease. How to use: Choose a suitable pattern on the steamping plate. Apply stamping varnish on the selected pattern on the plate. Using a spatula or a special card, carefully remove excess varnish from the surface of the plate, leaving varnish only in the recesses of the design. Press the silicone stamp against the pattern on the plate so that the design is transferred to its surface. Then carefully transfer the pattern from the stamper to the nail, pressing it evenly to the entire surface. Wait until the pattern is completely dry on the nail and then apply the fixing top coat.
11190		Stamping plate is an innovative tool for creating the perfect nail design, designed to be used by both professionals and manicure enthusiasts. This accessory allows you to transfer patterns and designs onto your nails with ease. How to use: Choose a suitable pattern on the steamping plate. Apply stamping varnish on the selected pattern on the plate. Using a spatula or a special card, carefully remove excess varnish from the surface of the plate, leaving varnish only in the recesses of the design. Press the silicone stamp against the pattern on the plate so that the design is transferred to its surface. Then carefully transfer the pattern from the stamper to the nail, pressing it evenly to the entire surface. Wait until the pattern is completely dry on the nail and then apply the fixing top coat.