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 (
    21639, 18958, 22905, 18981, 22906, 18982, 
    22907, 18984, 22909, 22048, 22910, 
    22055, 22911, 22052, 22912, 22054, 
    23988, 22064, 23989, 22063, 23990, 
    22062, 23991, 22056
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00095

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 (21639,18958,22905,18981,22906,18982,22907,18984,22909,22048,22910,22055,22911,22052,22912,22054,23988,22064,23989,22063,23990,22062,23991,22056) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
18958 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
18981 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
18982 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
18984 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
21639 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
22048 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
22052 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
22054 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
22055 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
22056 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
22062 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
22063 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
22064 DARK gel polish is an ideal choice for those who appreciate sophistication and perfection in every manicure. This gel polish is created with a uniquely selected pigmentation that provides rich and deep color from the first application. Its medium, comfortable consistency guarantees easy and even application without streaks, allowing you to achieve perfect coverage in just 1-2 layers. Technique of work: 1. Make a trim or hardware manicure. 2. Degrease the nail plate. 3. Apply a primer for better adhesion of the nail to the base. 4. Cover the nail with a base coat. Dry in the LED lamp for 60 seconds. 5. Apply DARK gel polish in 1-2 layers. Polymerize each layer in a UV/LED lamp for 60 seconds. 6. Finally - top coating. We send for drying in a UV device for 2 minutes or a UV/LED lamp for 60 seconds.
22905
22906
22907
22909
22910
22911
22912
23988
23989
23990
23991