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 (
    11059, 6813, 6919, 6920, 6921, 6923, 
    6922, 11211, 10640, 8865, 21995, 22344, 
    21996, 20369, 20370, 20371, 8000, 6704, 
    6740, 6751, 6769, 6743, 6777, 6781
  ) 
  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 (11059,6813,6919,6920,6921,6923,6922,11211,10640,8865,21995,22344,21996,20369,20370,20371,8000,6704,6740,6751,6769,6743,6777,6781) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
6704		Gel polish Kira Nails №032 Color: plum, 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.
6740		Gel Polish Kira Nails №069 Colour: wine 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.
6743		Gel polish Kira Nails №110 Color: cocoa, milk chocolate, 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.
6751		Gel polish Kira Nails №084 Color: cornflower 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.
6769		Gel polish Kira Nails №106 Color: light coral, enamel, 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.
6777		Gel polish Kira Nails №115 Color: lilac-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.
6781		Gel polish Kira Nails №119 Color: plum 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.
6813		Gel polish Kira Nails №162 Color: gold with silver sequins, 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.
6919		Gel polish Kira Nails №163 Color: scarlet rose, enamel Volume: 6 ml
6920		Gel polish Kira Nails №164 Color: wine, enamel Volume: 6 ml
6921		Gel Polish Kira Nails No. 165 (scarlet, enamel), 6 ml
6922		Gel Polish Kira Nails No. 167 (lavender tenderness, enamel), 6 ml
6923		Gel Polish Kira Nails No. 166 (piquant red, enamel), 6 ml
8000		Gel Polish Kira Nails No. 025 (pale light green, enamel), 6 ml
8865
10640		Gel polish Kira Nails №171, 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. GEL POLISH APPLICATION TECHNOLOGY : Start with a hygienic manicure, if necessary. File your nails and shape them.Apply a degreaser and dehydrator to a lint-free cloth , and wipe your nails to clean them of natural deposits (grease and dust), as well as to remove excess moisture from the surface of the nails.If the nails are soft or flaky, apply a special bonder to the nails for additional adhesion and let it dry for 10-20 seconds.Cover your nails with a thin layer of base coat under the gel polish. Seal the free edge. Cure in a UV lamp for 2 minutes or in a LED machine for 30 seconds.Apply color gel polish on nails, seal the free edge, cure each layer of gel polish in UV lamp for 2 minutes or in LED machine for 30 seconds. If the color gel polish does not adhere well to the base, remove the sticky layer from the base coat with a dry gel brush or a lint-free cloth moistened with a special liquid for removing the sticky layer .Apply top coat for gel polish. Seal the free edge and cure in a UV lamp for 2-3 minutes or in a LED machine for 30-60 seconds.With a cloth moistened with a special liquid to remove the sticky layer, remove the sticky layer.Apply cuticle oil to your nails .
11059		Gel Polish Kira Nails No. 161 (dark blue-azure, enamel), 6 ml
11211		Gel polish Kira Nails №170, 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. GEL POLISH APPLICATION TECHNOLOGY : Start with a hygienic manicure, if necessary. File your nails and shape them.Apply a degreaser and dehydrator to a lint-free cloth , and wipe your nails to clean them of natural deposits (grease and dust), as well as to remove excess moisture from the surface of the nails.If the nails are soft or flaky, apply a special bonder to the nails for additional adhesion and let it dry for 10-20 seconds.Cover your nails with a thin layer of base coat under the gel polish. Seal the free edge. Cure in a UV lamp for 2 minutes or in a LED machine for 30 seconds.Apply color gel polish on nails, seal the free edge, cure each layer of gel polish in UV lamp for 2 minutes or in LED machine for 30 seconds. If the color gel polish does not adhere well to the base, remove the sticky layer from the base coat with a dry gel brush or a lint-free cloth moistened with a special liquid for removing the sticky layer .Apply top coat for gel polish. Seal the free edge and cure in a UV lamp for 2-3 minutes or in a LED machine for 30-60 seconds.With a cloth moistened with a special liquid to remove the sticky layer, remove the sticky layer.Apply cuticle oil to your nails .
20369
20370
20371
21995		Kira Nails Gel-Lacquer №174 has a raspberry fuchsia colour, which gives nails a bright and expressive look. Thanks to the special texture, the gel-lacquer is easy to apply, has no unpleasant odour and is dense. Despite the high pigmentation, gel-lacquer dries well in the lamp. Application technology: 1. Carry out the standard preparation of the nail. 2. The nail plate should be degreased. Apply primer. 3. Apply a thin layer of base coat to the nail, then dry it in a UV lamp (2 minutes) or LED-lamp (30 seconds). If necessary, remove the adhesive layer for a better application of the coloured gel varnish. 4. Apply 2 coats of the base colour gel polish. Remember to seal each layer (including base and top). Curing time of the coloured gel-lacquer in UV lamp - 2 minutes, in LED-lamp - 30 seconds. 5. Apply a thin layer of topcoat, dry it in LED-lamp (30-60 seconds) or in UV-lamp (2-2.30 minutes).
21996		Kira Nails Gel-polish №177 has neon crimson colour, which gives nails a bright and expressive look. Thanks to its special texture, the gel-lacquer is easy to apply, has no unpleasant odour and is dense. Despite the high pigmentation, gel-lacquer dries well in the lamp. Application technology: 1. Carry out the standard preparation of the nail. 2. The nail plate should be degreased. Apply primer. 3. Apply a thin layer of base coat to the nail, then dry it in a UV lamp (2 minutes) or LED-lamp (30 seconds). If necessary, remove the adhesive layer for a better application of the coloured gel varnish. 4. Apply 2 coats of the base colour gel polish. Remember to seal each layer (including base and top). Curing time of the coloured gel-lacquer in UV lamp - 2 minutes, in LED-lamp - 30 seconds. 5. Apply a thin layer of topcoat, dry it in LED-lamp (30-60 seconds) or in UV-lamp (2-2.30 minutes).
22344