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 (
    6682, 6695, 6696, 11104, 6692, 8688, 
    6697, 6698, 6699, 6700, 6701, 6702, 
    6703, 6705, 6707, 6708, 6709, 6710, 
    6714, 6706, 6716, 6717, 6718, 6715
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00069

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": 24,
          "filtered": 100,
          "index_condition": "cscart_product_descriptions.product_id in (6682,6695,6696,11104,6692,8688,6697,6698,6699,6700,6701,6702,6703,6705,6707,6708,6709,6710,6714,6706,6716,6717,6718,6715) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
6682		Gel polish Kira Nails №018 Color: light coral, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6692		Gel polish Kira Nails №022 Color: beige, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6695		Gel polish Kira Nails №019 Color: carrot, neon Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6696		Gel polish Kira Nails №020 Color: pink-peach, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6697		Gel polish Kira Nails №024 Color: light green, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6698		Gel Polish Kira Nails №026 Color: light turquoise, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6699		Gel polish Kira Nails №027 Color: blue, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6700		Gel polish Kira Nails №028 Color: green, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6701		Gel polish Kira Nails №029 Color: blue-violet, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6702		Gel polish Kira Nails №030 Color: purple, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6703		Gel polish Kira Nails №031 Color: fuchsia, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6705		Gel polish Kira Nails №033 Color: burgundy, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6706		Gel polish Kira Nails №039 Color: brown, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6707		Gel polish Kira Nails №034 Color: dark red, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6708		Gel polish Kira Nails №035 Color: black, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6709		Gel polish Kira Nails №036 Color: white, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6710		Gel polish Kira Nails №037 Color: bright red, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6714		Gel polish Kira Nails №038 Color: red, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6715		Gel polish Kira Nails №043 Color: muted raspberry, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6716		Gel polish Kira Nails №040 Color: dark red, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6717		Gel polish Kira Nails №041 Color: crimson, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
6718		Gel polish Kira Nails №041 Color: crimson, enamel Volume: 6 ml The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.
8688		Gel Polish Kira Nails No. 023 (yellow, enamel), 6 ml
11104		Gel polish Kira Nails No. 021 (orange, enamel) The series presents a wide range of shades, tones: from delicate pastel french to bright neon with expressive glossy sheen. Gel polishes are made from high quality Ukrainian materials. Evenly distributed over the entire base, do not have an unpleasant odor, dense. Easily removed and not deformed. Long time keep tone and gloss.