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 (
    24324, 24325, 24330, 24331, 24332, 24333, 
    24335, 24338, 24339, 18577, 10054, 
    19406, 18708, 18710, 18711, 18712, 
    18938, 18944, 23233, 23234, 23237, 
    7030, 7458, 12509
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00080

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 (24324,24325,24330,24331,24332,24333,24335,24338,24339,18577,10054,19406,18708,18710,18711,18712,18938,18944,23233,23234,23237,7030,7458,12509) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
7030		It has a diamond shine and impeccable durability. Top without sticky layer 12ml.
7458		Diamond top for gel polish without a sticky layer is used at the finishing stage of a decorative manicure. It is a colorless transparent material with impeccable durability and wear. It qualitatively and reliably fixes the decorative gel-varnish coating, does not change its color, but guarantees a bright luxurious gloss. Due to the absence of residual stickiness, this top is great for different nail designs. Polymerizes in ultraviolet (2 min.) and LED lamps (30-60 sec.). Volume 50 ml.
10054		Base coat for gel DIS Base, 15 ml Base RUBBER is a unique thick rubber base for gel polishes that provides a super strong grip and allows you to level and strengthen the most brittle and flaky nails. The coating is applied in a thicker layer. The RUBBER base has a medium density, is more elastic and very comfortable to use. With an advanced rubber-based formula, RUBBER base provides up to three weeks of gel polish durability, preventing flaking and chipping. GEL POLISH BASE RUBBER by DIS Nails is a rubber base coat that is applied before applying colored gel polish. Even when covered with a thick layer, it does not lose its elasticity and dries very quickly in the lamp. The RUBBER base is unique in that it provides a super strong grip to make evening and strengthening the most brittle and flaky nails perfect. Thanks to its advanced rubber-based formula, RUBBER base not only ensures the durability of any gel polish for up to three weeks or more, but also completely prevents flaking and chipping. Method of application: the base is applied in a thin layer on the nail treated with DIS NAILS primer. Cure time in LED lamp 30 seconds or UV lamp 36W 2-3 minutes.
12509		Gel Polish DIS Diamond Cat Eyes No. 04 7.5 ml Diamond Cat Eyes by DIS Nails are gel polishes that, together with a magnet, create real miracles on nails with smooth transitions and incredible glare. Thanks to a convenient brush, applying gel polish evenly on the nail plate has become a breeze. In addition, it is quite dense, dries quickly and will surely please the owner with its resistance to chipping. Mode of application: 1. Prepare the nail plate. Remove the old coating, degrease the nail with NAIL PREP and file the nails to the desired shape. 2. Apply base coat and cure in UV lamp for 2 minutes or LED lamp for 1 minute. 3. Cover the nail plate with 3D Cat Eyes gel polish. After applying, bring a special magnet to the nail as close as possible and hold it for up to 15 seconds (to get a beautiful stripe, the effect of a cat`s eye). Dry each layer in a UV lamp for 2 minutes or an LED lamp for 1 minute. 4. Apply a finish (top) coat. If necessary, remove the sticky layer with a special tool CLENSER.
18577		Decor for design Chain metal Gold, gold Chain nail decor will be a spectacular decoration for many nail compositions. Chains give the design of nails a bright personality, elements of luxury, look good on a contrasting background. They are perfect for 3D design. Decor material - metal. Decor color - gold.
18708		Base for gel polish FOX Spectrum Rubber Base №055, 14 ml Need a bright design without gel polish? Modern products for nail service allow you to create a high-quality decorative coating without weighing down the nail plate with unnecessary layers. FOX Spectrum Rubber Base is a pigment-rich base that will hide minor defects in the nail plate and give a juicy shade to the manicure. Features of the camouflage Spectrum Rubber Base: due to rich pigmentation, it is able to fully replace the coating with gel polish;elastic structure prevents subsidence at the junction of the nail bed and the free edge;strengthens nails and gives impeccable smoothness;easy to apply and self-leveling;does not spread beyond the boundaries of the working area;the shade will become a spectacular touch in the image of a bright and stylish girl. How to apply the Spectrum Rubber Base: Make any hygienic manicure.Treat the nail with a buff, degreaser and apply a primer.For best results, use underlay.Cover the nail plate with a thin layer of a transparent base with rubbing movements and dry it in a UV / LED lamp. Then apply a layer of color base and polymerize in a lamp. If the surface of the nail has no visible irregularities, you can stop there.The second layer will be corrective. Pick up a large drop on the brush and lower it 3-4 millimeters from the nail bed, and then with a quick movement, without pressure, slide down to the edge of the nail.After spreading the base, turn the nail parallel to the table for 10-15 seconds so that the last imperfections disappear and the surface becomes perfectly smooth.Dry under 36W UV lamp for 2 minutes or 48W LED lamp for 60 seconds. FOX Spectrum Rubber Base Camouflage Base is self-leveling, dense texture and unrivaled trendy color.
18710		Base for gel polish FOX Spectrum Rubber Base №065, 14 ml Need a bright design without gel polish? Modern products for nail service allow you to create a high-quality decorative coating without weighing down the nail plate with unnecessary layers. FOX Spectrum Rubber Base is a pigment-rich base that will hide minor defects in the nail plate and give a juicy shade to the manicure. Features of the camouflage Spectrum Rubber Base: due to rich pigmentation, it is able to fully replace the coating with gel polish;elastic structure prevents subsidence at the junction of the nail bed and the free edge;strengthens nails and gives impeccable smoothness;easy to apply and self-leveling;does not spread beyond the boundaries of the working area;the shade will become a spectacular touch in the image of a bright and stylish girl. How to apply the Spectrum Rubber Base: Make any hygienic manicure.Treat the nail with a buff, degreaser and apply a primer.For best results, use underlay.Cover the nail plate with a thin layer of a transparent base with rubbing movements and dry it in a UV / LED lamp. Then apply a layer of color base and polymerize in a lamp. If the surface of the nail has no visible irregularities, you can stop there.The second layer will be corrective. Pick up a large drop on the brush and lower it 3-4 millimeters from the nail bed, and then with a quick movement, without pressure, slide down to the edge of the nail.After spreading the base, turn the nail parallel to the table for 10-15 seconds so that the last imperfections disappear and the surface becomes perfectly smooth.Dry under 36W UV lamp for 2 minutes or 48W LED lamp for 60 seconds. FOX Spectrum Rubber Base Camouflage Base is self-leveling, dense texture and unrivaled trendy color.
18711		Base for gel polish FOX Spectrum Rubber Base №067, 14 mlNeed a bright design without gel polish? Modern products for nail service allow you to create a high-quality decorative coating without weighing down the nail plate with unnecessary layers. FOX Spectrum Rubber Base is a pigment-rich base that will hide minor defects in the nail plate and give a juicy shade to the manicure. Features of the camouflage Spectrum Rubber Base: due to rich pigmentation, it is able to fully replace the coating with gel polish;elastic structure prevents subsidence at the junction of the nail bed and the free edge;strengthens nails and gives impeccable smoothness;easy to apply and self-leveling;does not spread beyond the boundaries of the working area;the shade will become a spectacular touch in the image of a bright and stylish girl. How to apply the Spectrum Rubber Base: Make any hygienic manicure.Treat the nail with a buff, degreaser and apply a primer.For best results, use underlay.Cover the nail plate with a thin layer of a transparent base with rubbing movements and dry it in a UV / LED lamp. Then apply a layer of color base and polymerize in a lamp. If the surface of the nail has no visible irregularities, you can stop there.The second layer will be corrective. Pick up a large drop on the brush and lower it 3-4 millimeters from the nail bed, and then with a quick movement, without pressure, slide down to the edge of the nail.After spreading the base, turn the nail parallel to the table for 10-15 seconds so that the last imperfections disappear and the surface becomes perfectly smooth.Dry under 36W UV lamp for 2 minutes or 48W LED lamp for 60 seconds. FOX Spectrum Rubber Base Camouflage Base is self-leveling, dense texture and unrivaled trendy color.
18712		Base for gel polish FOX Spectrum Rubber Base №070, 14 ml Need a bright design without gel polish? Modern products for nail service allow you to create a high-quality decorative coating without weighing down the nail plate with unnecessary layers. FOX Spectrum Rubber Base is a pigment-rich base that will hide minor defects in the nail plate and give a juicy shade to the manicure. Features of the camouflage Spectrum Rubber Base: due to rich pigmentation, it is able to fully replace the coating with gel polish;elastic structure prevents subsidence at the junction of the nail bed and the free edge;strengthens nails and gives impeccable smoothness;easy to apply and self-leveling;does not spread beyond the boundaries of the working area;the shade will become a spectacular touch in the image of a bright and stylish girl. How to apply the Spectrum Rubber Base: Make any hygienic manicure.Treat the nail with a buff, degreaser and apply a primer.For best results, use underlay.Cover the nail plate with a thin layer of a transparent base with rubbing movements and dry it in a UV / LED lamp. Then apply a layer of color base and polymerize in a lamp. If the surface of the nail has no visible irregularities, you can stop there.The second layer will be corrective. Pick up a large drop on the brush and lower it 3-4 millimeters from the nail bed, and then with a quick movement, without pressure, slide down to the edge of the nail.After spreading the base, turn the nail parallel to the table for 10-15 seconds so that the last imperfections disappear and the surface becomes perfectly smooth.Dry under 36W UV lamp for 2 minutes or 48W LED lamp for 60 seconds. FOX Spectrum Rubber Base Camouflage Base is self-leveling, dense texture and unrivaled trendy color.
18938		Gel polish DARK №154, 8 ml
18944		Gel polish DARK №162, 8 ml
19406
23233
23234
23237
24324
24325
24330
24331
24332
24333
24335
24338
24339