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 (
    8346, 19924, 6939, 6894, 6896, 12818
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00079

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": 6,
          "filtered": 100,
          "index_condition": "cscart_product_descriptions.product_id in (8346,19924,6939,6894,6896,12818) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
6894		Lacquer for stamping Nail Story pastel 02, 11ml Pastel polishes for stamping Nail Story ? These are some of the best nail polishes on the market today. Stamping polishes are made on a special stamping base, which allows them to preserve their color on any substrate - from white to black.
6896		Lacquer for stamping Nail Story pastel 05, 11ml Pastel polishes for stamping Nail Story ? These are some of the best nail polishes on the market today. Stamping polishes are made on a special stamping base, which allows them to preserve their color on any substrate - from white to black.
6939		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.
8346		AR-99 Stamping Disc Despite the fact that stamping is a fairly new technique for decorating nails, it managed to win the hearts of many of the fair sex. With the help of a stencil, you can easily cope with applying a skillful drawing, which is not easy to reproduce by hand. In addition, stamping is used not only in creating a manicure, it is decorated with jewelry, watches, mobile phones and other accessories that you want to give a unique style. The advantage of stamping is that, despite the ease of use, your personal manicure will look no worse than a salon one. A variety of drawings allows you to choose the most attractive stamp for you in the form of nails, color and size. Mode of application: Apply varnish to the selected pattern on the plate.With a scraper, remove excess varnish from the plate with a quick movement, press the stamp on the plate to copy the pattern. Apply an imprint of the design on your nails with a light rolling motion, or simply quickly press the seal for one second.Clean the seal and plate with nail polish remover after each use.
12818		Lacquer for stamping Nail Story pastel 09 11 ml Nail Story stamping varnish - designed to transfer a pattern from a printing form (disk) to a nail. Volume: 11 ml Nail Story varnishes are high-quality stamping varnishes that have a high concentration of pigment in the composition, which makes them look bright and rich. They have a thick consistency, but they easily lay down on a plate or disk. Their advantage is the optimal drying speed, they do not dry out on the stamp. The drawing is well transferred to the nail (even the smallest details remain visible), has a clear contour and is not smeared after applying the top coat. Patterns look especially advantageous on the nail, which is covered with a contrasting color. Stamping varnishes are not used like ordinary varnishes: they cannot completely cover the nail plate, because. they won`t dry out. To apply designs on your nails, you will also need a stamp, a scraper and stamping discs, your favorite base and nail polish fixer, and a nail polish remover to clean the disc and remove excess design elements.
19924		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.