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 (
    18727, 18750, 18728, 18729, 18731, 18733, 
    18734, 18735, 18737, 18736, 18738, 
    18739, 20047, 17986, 17976, 19106, 
    19107, 11456, 11172, 7613, 7522, 11230, 
    10378, 13102
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00148

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 (18727,18750,18728,18729,18731,18733,18734,18735,18737,18736,18738,18739,20047,17986,17976,19106,19107,11456,11172,7613,7522,11230,10378,13102) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
7522 ReformA Minnie Gel Polish (neon red-pink, enamel), 10 mlReformA Cosmetics is a manufacturer of professional cosmetics for salon use. ReformA gel polishes have a wide range of colors and shades. The compositions of the funds have a rather thick, but not spreading consistency. Thanks to the innovative unique formula, the product is easily and simply applied to the nail plate and forms a smooth coating without various bumps and lumps. Many professionals note that varnishes have a rather comfortable brush: wide, but gaining the optimal amount of varnish for one nail. Subject to the technology and application rules, the durability is up to 3-5 weeks without cracks and darkening. GEL POLISH APPLICATION TECHNOLOGY:Start with a hygienic manicure, if necessary.File your nails with a nail file 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 colored gel polish does not adhere well to the base, remove the sticky layer from the base coat with a dry gel brush or lint-free cloth moistened with a special liquid for removing the sticky layer .Apply gel polish top coat .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 . GEL POLISH REMOVAL TECHNOLOGY:Treat the coating with a rough buff or file to remove the gloss. This will allow the remover (gel polish remover) to quickly penetrate the coating and quickly remove the gel polish.Moisten sponge with gel polish remover , apply to nail and seal with foil .After 10 minutes, remove the application and gently remove the gel polish with an orange stick . If the coating is difficult to remove, seal the nail again for a couple of minutes so as not to injure the nails.Polish the nail plate with a buff or file . If you do not plan to re-coat your nails with gel polish, you can polish with nail oil .
7613 Gel Polish ReformA Louise (creamy, enamel), 10 mlReformA Cosmetics is a manufacturer of professional cosmetics for salon use. ReformA gel polishes have a wide range of colors and shades. The compositions of the funds have a rather thick, but not spreading consistency. Thanks to the innovative unique formula, the product is easily and simply applied to the nail plate and forms a smooth coating without various bumps and lumps. Many professionals note that varnishes have a rather comfortable brush: wide, but gaining the optimal amount of varnish for one nail. Subject to the technology and application rules, the durability is up to 3-5 weeks without cracks and darkening. GEL POLISH APPLICATION TECHNOLOGY:Start with a hygienic manicure, if necessary.File your nails with a nail file 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 colored gel polish does not adhere well to the base, remove the sticky layer from the base coat with a dry gel brush or lint-free cloth moistened with a special liquid for removing the sticky layer .Apply gel polish top coat .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 . GEL POLISH REMOVAL TECHNOLOGY:Treat the coating with a rough buff or file to remove the gloss. This will allow the remover (gel polish remover) to quickly penetrate the coating and quickly remove the gel polish.Moisten sponge with gel polish remover , apply to nail and seal with foil .After 10 minutes, remove the application and gently remove the gel polish with an orange stick . If the coating is difficult to remove, seal the nail again for a couple of minutes so as not to injure the nails.Polish the nail plate with a buff or file . If you do not plan to re-coat your nails with gel polish, you can polish with nail oil .
10378 Gel Polish Reforma Moulin Rouge (neon red, enamel), 10 mlReformA Cosmetics is a manufacturer of professional cosmetics for salon use. ReformA gel polishes have a wide range of colors and shades. The compositions of the funds have a rather thick, but not spreading consistency. Thanks to the innovative unique formula, the product is easily and simply applied to the nail plate and forms a smooth coating without various bumps and lumps. Many professionals note that varnishes have a rather comfortable brush: wide, but gaining the optimal amount of varnish for one nail. Subject to the technology and application rules, the durability is up to 3-5 weeks without cracks and darkening. GEL POLISH APPLICATION TECHNOLOGY:Start with a hygienic manicure, if necessary.File your nails with a nail file 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 colored gel polish does not adhere well to the base, remove the sticky layer from the base coat with a dry gel brush or lint-free cloth moistened with a special liquid for removing the sticky layer .Apply gel polish top coat .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 . GEL POLISH REMOVAL TECHNOLOGY:Treat the coating with a rough buff or file to remove the gloss. This will allow the remover (gel polish remover) to quickly penetrate the coating and quickly remove the gel polish.Moisten sponge with gel polish remover , apply to nail and seal with foil .After 10 minutes, remove the application and gently remove the gel polish with an orange stick . If the coating is difficult to remove, seal the nail again for a couple of minutes so as not to injure the nails.Polish the nail plate with a buff or file . If you do not plan to re-coat your nails with gel polish, you can polish with nail oil .
11172 Gel Polish Reforma Giselle (soft cream, enamel), 10 mlReformA Cosmetics is a manufacturer of professional cosmetics for salon use. ReformA gel polishes have a wide range of colors and shades. The compositions of the funds have a rather thick, but not spreading consistency. Thanks to the innovative unique formula, the product is easily and simply applied to the nail plate and forms a smooth coating without various bumps and lumps. Many professionals note that varnishes have a rather comfortable brush: wide, but gaining the optimal amount of varnish for one nail. Subject to the technology and application rules, the durability is up to 3-5 weeks without cracks and darkening. GEL POLISH APPLICATION TECHNOLOGY:Start with a hygienic manicure, if necessary.File your nails with a nail file 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 colored gel polish does not adhere well to the base, remove the sticky layer from the base coat with a dry gel brush or lint-free cloth moistened with a special liquid for removing the sticky layer .Apply gel polish top coat .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 . GEL POLISH REMOVAL TECHNOLOGY:Treat the coating with a rough buff or file to remove the gloss. This will allow the remover (gel polish remover) to quickly penetrate the coating and quickly remove the gel polish.Moisten sponge with gel polish remover , apply to nail and seal with foil .After 10 minutes, remove the application and gently remove the gel polish with an orange stick . If the coating is difficult to remove, seal the nail again for a couple of minutes so as not to injure the nails.Polish the nail plate with a buff or file . If you do not plan to re-coat your nails with gel polish, you can polish with nail oil .
11230 Gel Polish Reforma, Montreal (red, enamel), 10 mlReformA Cosmetics is a manufacturer of professional cosmetics for salon use. ReformA gel polishes have a wide range of colors and shades. The compositions of the funds have a rather thick, but not spreading consistency. Thanks to the innovative unique formula, the product is easily and simply applied to the nail plate and forms a smooth coating without various bumps and lumps. Many professionals note that varnishes have a rather comfortable brush: wide, but gaining the optimal amount of varnish for one nail. Subject to the technology and application rules, the durability is up to 3-5 weeks without cracks and darkening. GEL POLISH APPLICATION TECHNOLOGY:Start with a hygienic manicure, if necessary.File your nails with a nail file 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 colored gel polish does not adhere well to the base, remove the sticky layer from the base coat with a dry gel brush or lint-free cloth moistened with a special adhesive remover .Apply gel polish top coat .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 . GEL POLISH REMOVAL TECHNOLOGY:Treat the coating with a rough buff or file to remove the gloss. This will allow the remover (gel polish remover) to quickly penetrate the coating and quickly remove the gel polish.Moisten sponge with gel polish remover , apply to nail and seal with foil .After 10 minutes, remove the application and gently remove the gel polish with an orange stick . If the coating is difficult to remove, seal the nail again for a couple of minutes so as not to injure the nails.Polish the nail plate with a buff or file . If you do not plan to re-coat your nails with gel polish, you can polish with nail oil .
11456 ReformA Cosmetics is a manufacturer of professional cosmetics for salon use. ReformA gel polishes have a wide range of colors and shades. The compositions of the funds have a rather thick, but not spreading consistency. Thanks to the innovative unique formula, the product is easily and simply applied to the nail plate and forms a smooth coating without various bumps and lumps. Many professionals note that varnishes have a rather comfortable brush: wide, but gaining the optimal amount of varnish for one nail. Subject to the technology and application rules, the durability is up to 3-5 weeks without cracks and darkening. GEL POLISH APPLICATION TECHNOLOGY: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 lint-free cloth moistened with a special liquid for removing the sticky layer.Apply top coat for gel polish. Seal free edge and cure in UV lamp 2-3 minutes or LED lamp 30-60 seconds.
13102 Gel polish Reforma Orgasm burgundy 10 mlReformA is a manufacturer of high quality manicure gel polishes . Reforma gel polishes have a varied palette of colors and shades. The material fits perfectly on the nail plate and forms the desired coating. Gel Polish ReformA has a thick consistency, but does not spread. The gel polish brush is wide and comfortable. With gel varnishes Reform manicure is well worn, does not change color and does not crack. Gel polishes Reforma always delight with bright novelties and a palette. Any modern girl will complete her image with a beautiful manicure with high-quality materials from the ReformA manufacturer , which will certainly become the highlight of every fashionista.
17976 FOX Flash Opal Gel Polish Top Reflective with Opal Glitter, 6 ml Top Flash Opal by FOX is a non-tack reflective top coat that contains a high amount of iridescent opal particles. Opal particles create a deep overflow, spectacular radiance is enhanced by the refraction of light. This top coat can be applied over both gel polish and camouflage base, which allows you to make a reflective coating from any shade. The material has an average consistency, prevents the formation of chips and scratches. Can be used as a standalone top coat or topped off with another top coat. Advantages: contains a large number of shimmering particles of opal;creates a spectacular glow under bright lighting;without sticky layer;suitable for application to the base or gel polish;after drying forms a smooth surface. Application technology: After applying the base or gel polish, cover the entire surface of the nail plate with a top coat.We polymerize in a UV lamp - 2 minutes, LED / UV lamp - 60 s. Allow to cool after polymerization. Apply cuticle oil.
17986 Top reflective for gel polish FOX Flash with silver sparkles, 6 ml Top Flash by FOX is a non-tacky, reflective clear top coat. The composition of the top contains a large number of small silver particles, which in certain lighting create an incredible radiance. This top coat can be applied over both gel polish and camouflage base, which allows you to make a reflective coating from any shade. The intensity of the radiance depends on the angle of the light and the power of the light source. The material has a liquid consistency, durable, prevents the formation of chips and scratches on the coating due to mechanical damage. Can be used as a standalone top coat or topped off with another top coat. Advantages: contains a large number of small silver particles;without sticky layer;suitable for application to the base or gel polish;after drying forms a smooth surface. Application technology: After applying the base or gel polish, cover the entire surface of the nail plate with a top coat.We polymerize in a UV lamp - 2 minutes, LED / UV lamp - 60 s. Allow to cool after polymerization. Apply cuticle oil.
18727 Gel polish reflective DIS Flash No. 02 beige, 7.5 ml DIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
18728 Gel polish reflective DIS Flash No. 04 cocoa, 7.5 ml DIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
18729 Reflective gel polish DIS Flash No. 05 grey, 7.5 ml DIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
18731 Reflective gel polish DIS Flash No. 07 cocoa pink, 7.5 ml DIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
18733 Gel polish reflective DIS Flash No. 09 blue, 7.5 mlDIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
18734 Reflective gel polish DIS Flash No. 10 fuchsia, 7.5 ml DIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
18735 Gel polish reflective DIS Flash No. 11 red, 7.5 ml DIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
18736
18737 Gel polish reflective DIS Flash No. 13 green, 7.5 ml DIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
18738 Reflective gel polish DIS Flash No. 14 green, 7.5 ml DIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
18739 Reflective gel polish DIS Flash No. 15 lavender, 7.5 ml DIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
18750 Gel polish reflective DIS Flash No. 03 pink, 7.5 ml DIS Nails Gel Polish Flash is a gel polish that can reflect light of any strength. The brighter the light, the stronger the glow effect. With shimmering opal glitter and microscopic sandy shimmer particles, Flash creates a dazzling sheen that changes with the light. Flash from DIS Nails has a rich pigment, lays down evenly and densely. The collection has 16 incredible shades, each of which is unique and irresistible!
19106 Gel polish Reforma Turmeric acid orange, 10 ml Gel polish Reforma, Turmeric Color: bright orange, neon Volume: 10 ml ReformA Cosmetics is a manufacturer of professional cosmetics for salon use. ReformA gel polishes have a wide range of colors and shades. The compositions of the funds have a rather thick, but not spreading consistency. Thanks to the innovative unique formula, the product is easily and simply applied to the nail plate and forms a smooth coating without various bumps and lumps. Many professionals note that varnishes have a rather comfortable brush: wide, but gaining the optimal amount of varnish for one nail. Subject to the technology and application rules, the durability is up to 3-5 weeks without cracks and darkening. 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 remove natural deposits (grease and dust) and 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 colored 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 to remove 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. GEL POLISH REMOVAL TECHNOLOGY : Treat the coating with a rough buff or file to remove the gloss. This will allow the remover (gel polish remover) to quickly penetrate the coating and quickly remove the gel polish.Moisten sponge with gel polish remover, apply to nail and seal with foil.After 10 minutes, remove the application and gently remove the gel polish with an orange stick. If the coating is difficult to remove, seal the nail again for a couple of minutes so as not to injure the nails.Polish the nail plate with a buff or file. If you do not plan to re-coat your nails with gel polish, you can polish with nail oil.
19107 Reforma Baby doll gel polish coral, 10 ml
20047