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 (
    8299, 23269, 23055, 23268, 23054, 10270, 
    12408, 12409, 12406, 12407, 11798, 
    10782, 12410, 12088, 11802, 13619, 
    18138, 11801, 11415, 11050, 10308, 
    10439, 6983, 11602
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00163

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 (8299,23269,23055,23268,23054,10270,12408,12409,12406,12407,11798,10782,12410,12088,11802,13619,18138,11801,11415,11050,10308,10439,6983,11602) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
6983		Cap Starlet D 13, 80 grit Disposable abrasive caps 13 mm. Are made of high-quality silicon carbide - (karborundum). Abrasive 80 grit Used in pedicure for skin polishing.
8299		Container for storing cutters. Can accommodate 48 pcs. The container for cutters is made of practical and durable plastic. It is convenient for storing cutters and nozzles for the device both in the salon and at home. The plastic container for cutters is a convenient, practical and necessary accessory for the professional work of the master.
10270		A set of cutters with diamond dusting, 30 pcs. Diamond nozzles for hardware manicure, cutters for engraving on glass, stone, ceramics. Set: 30 pcs. A set of cutter nozzles can be used for hardware manicure of any complexity. The professional set is fully equipped and convenient to work with. The set consists of thirty milling bits with diamond dusting. All of them have a different shape and are designed to perform numerous tasks in the process of hardware nail and skin care: correction of the length and shape of the free edge, sawing off hardened materials during extension, treatment of the nail area and cuticles, removal of roughness, etc.
10308		Cap-nozzle for pedicure Starlet 120 grit, pcs The nozzle cap is designed for hardware pedicure. It copes well with corns, keratinized particles, corns. To be disinfected. For a more effective result, it is recommended to apply Callus remover for a few minutes before starting the procedure, then wipe with a towel. Finish the pedicure by polishing with a soft nozzle. Abrasiveness : 120 grit.
10439		Cap-nozzle for pedicure Starlet 180 grit, pcs The nozzle cap is designed for hardware pedicure. It copes well with corns, keratinized particles, corns. To be disinfected. For a more effective result, it is recommended to apply Callus remover for a few minutes before starting the procedure, then wipe with a towel. Finish the pedicure by polishing with a soft nozzle. Abrasiveness : 180 grit.
10782		Set of nozzles with diamond spraying Staleks drop blue 2.5 mm 6 pcs
11050		Cap D 10 , 180 grit Grinding caps are used in hardware procedures for skin care in the area of the feet and the periungual zone. With their help, it is possible to qualitatively and quickly remove corns, corn formations and various cornifications. Recently, nozzle caps have become very popular when performing pedicures in beauty salons, and this is no accident, because the use of caps during the procedure has a beneficial effect on the skin of the feet, and after treatment, the skin retains a well-groomed appearance and remains smooth for a long time. Designed for individual use, therefore, they allow to give the process of hardware care a high degree of hygiene and safety. Characteristics: diameter 10 mm height 15 mm grit 180 grit
11415		Cap D 10, 100 grit
11602		Carbide tip D 60 V cone cornNozzle for a milling cutter, carbide is a carbide nozzle (cutter) for the correction of acrylic and gel nails: coarse sawdust, sawdust under the nails, shape and length correction. Also, it can be used for sawing out detachments, removing gel, gel polish and pedicure.The service life and efficiency of carbide tips far exceeds the life of diamond-coated tips.It does not rust, disinfected and sterilized.It is also important to care for nozzles:It is safer to store nozzles in a special lockable stand.Disinfect, clean and sterilize the tips after each use and each client.
11798		Set of nozzles with diamond spraying Staleks cylinder blue 2.5 mm 6 pcs
11801		Set of nozzles with diamond spraying Staleks flame safe red 1.6 mm 5 pcs
11802		Set of nozzles with diamond spraying Staleks flame safe blue 1.6 mm 6 pcs
12088		Set of nozzles with diamond spraying Staleks flame safe blue 1.4 mm 6 pcs
12406		Set of nozzles with diamond dusting Staleks ball red 4 mm 6 pcs
12407		Set of nozzles with diamond dusting Staleks ball red 5 mm 6 pcs
12408		Set of nozzles with diamond spraying Staleks ball blue 4 mm 6 pcs
12409		Set of nozzles with diamond dusting Staleks ball blue 5 mm 6 pcs
12410		Set of nozzles with diamond spraying Staleks drop red 1.6 mm 6 pcs
13619		Set of nozzles with diamond spraying Staleks flame sharp blue 1.6 mm 6 pcs
18138		Set of nozzles with diamond spraying Staleks flame sharp red 1.6 mm 6 pcs
23054
23055
23268
23269