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 (
    11137, 11138, 11132, 12383, 11136, 21487, 
    18707, 12384, 11131, 11129, 21486
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00273

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": 11,
          "filtered": 100,
          "index_condition": "cscart_product_descriptions.product_id in (11137,11138,11132,12383,11136,21487,18707,12384,11131,11129,21486) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
11129		Massage candle Komilfo Massage Candle - Vanilla Frangipani, 20 g Vanilla Frangipani massage candle from Komilfo is an ideal tool for massaging the skin of the hands. In the process of burning, a mixture of essential and vegetable oils is formed, which has a positive effect on the condition of the nail plates and cuticles. Useful vegetable oils shea, cocoa, coconut, tea tree and almonds contain a whole range of trace elements, minerals and vitamins; take care of the skin, making it soft and supple. And vanilla and frangipani essential oils even out skin tone, soothe it and relieve irritation, increase its softness and elasticity; nourish dry skin and promote cell regeneration. It has a pronounced antiseptic, anti-inflammatory and cleansing effect. The candle has a gentle and soothing aroma of vanilla and frangipani. Mode of application: Light a candle, wait a couple of minutes. Extinguish the candle and pour the melted butter over your hands. Rub into the skin with massage movements. Remove excess with a paper towel.
11131		Massage candle Komilfo Massage Candle - Juicy Melon, 20 g Juicy Melon massage candle from Komilfo is an ideal tool for hand massage. In the process of burning, a mixture of essential and vegetable oils is formed, which has a positive effect on the condition of the nail plates and cuticles. Useful vegetable oils shea, cocoa, coconut, tea tree and almonds contain a whole range of trace elements, minerals and vitamins; take care of the skin, making it soft and supple. And melon essential oils relieve irritation and dryness of the skin, protecting it from wrinkles and age spots; contribute to the restoration of nails, preventing their fragility and delamination. Provides additional protection from the effects of the external environment and sunlight. The candle has a gentle and soothing aroma of juicy melon. Mode of application: Light a candle, wait a couple of minutes. Extinguish the candle and pour the melted butter over your hands. Rub into the skin with massage movements. Remove excess with a paper towel.
11132		Massage candle Komilfo Massage Candle - Flower Garden, 20 g Massage candle Flower Garden from Komilfo is an ideal tool for massaging the skin of the hands. In the process of burning, a mixture of essential and vegetable oils is formed, which has a positive effect on the condition of the nail plates and cuticles. Useful vegetable oils shea, cocoa, coconut, tea tree and almonds contain a whole range of trace elements, minerals and vitamins; take care of the skin, making it soft and supple. And floral essential oils help to restore the skin of the hands, normalize the water balance and stimulate the production of collagen; strengthen nails, improve their growth and give shine. It has softening, antibacterial and stimulating properties. The candle has a gentle and soothing scent of a flower garden. Mode of application: Light a candle, wait a couple of minutes. Extinguish the candle and pour the melted butter over your hands. Rub into the skin with massage movements. Remove excess with a paper towel.
11136		Massage candle Komilfo Massage Candle - Sakura, 20 g Sakura Massage Candle from Komilfo is the perfect tool for hand massage. In the process of burning, a mixture of essential and vegetable oils is formed, which has a positive effect on the condition of the nail plates and cuticles. Useful vegetable oils shea, cocoa, coconut, tea tree and almonds contain a whole range of trace elements, minerals and vitamins; take care of the skin, making it soft and supple. And the essential oils of sakura flowers help reduce irritation and inflammation of the skin of the hands, perfectly nourish and moisturize it, improve elasticity and prevent the appearance of wrinkles; are an excellent antioxidant. Provides additional protection from the effects of the external environment and sunlight. The candle has a gentle and soothing aroma of sakura. Mode of application: Light a candle, wait a couple of minutes. Extinguish the candle and pour the melted butter over your hands. Rub into the skin with massage movements. Remove excess with a paper towel.
11137		Massage candle Komilfo Massage Candle - Lemon Lime, 20 g Massage candle Lemon Lime from Komilfo is an ideal tool for massaging the skin of the hands. In the process of burning, a mixture of essential and vegetable oils is formed, which has a positive effect on the condition of the nail plates and cuticles. Useful vegetable oils shea, cocoa, coconut, tea tree and almonds contain a whole range of trace elements, minerals and vitamins; take care of the skin, making it soft and supple. And the essential oils of lemon and lime activate the production of collagen, reduce irritation and redness of the skin, contribute to its lightening; improve the condition of nails and promote their growth. It has a pronounced bactericidal and antiseptic effect. The candle has a gentle and soothing aroma of lemon and lime. Mode of application: Light a candle, wait a couple of minutes. Extinguish the candle and pour the melted butter over your hands. Rub into the skin with massage movements. Remove excess with a paper towel.
11138		Massage candle Komilfo Massage Candle - Chocolate Orange, 20 g Komilfo`s Chocolate Orange Massage Candle is the perfect tool for hand massage. In the process of burning, a mixture of essential and vegetable oils is formed, which has a positive effect on the condition of the nail plates and cuticles. Useful vegetable oils shea, cocoa, coconut, tea tree and almonds contain a whole range of trace elements, minerals and vitamins; take care of the skin, making it soft and supple. And the essential oils of orange and cocoa perfectly moisturize the dry skin of the hands, improve its texture and help smooth fine wrinkles and reduce inflammation; act as a vitaminizing, whitening and protective agent. Provides removal of toxins, healing and softening effect. The candle has a gentle and soothing aroma of chocolate and orange. Mode of application: Light a candle, wait a couple of minutes. Extinguish the candle and pour the melted butter over your hands. Rub into the skin with massage movements. Remove excess with a paper towel.
12383		Massage candle Komilfo Massage Candle Frozen Apple 30 g Massage candle Frozen Apple from Komilfo is an ideal tool for massaging the skin of the hands. In the process of burning, a mixture of essential and vegetable oils is formed, which has a positive effect on the condition of the nail plates and cuticles. Useful vegetable oils shea, cocoa, coconut, tea tree and almonds contain a whole range of trace elements, minerals and vitamins; take care of the skin, making it soft and supple. And the essential oils of the paradise apple perfectly soften, moisturize, strengthen and regenerate the skin of the hands. Saturated with vitamin E and organic acids, has a high antioxidant activity. Protects against bacteria. Reduces wrinkles and reduces irritation. Suitable for problem skin.
12384		Massage candle Komilfo Massage Candle Frozen Apple 60 g Massage candle Frozen Apple from Komilfo is an ideal tool for massaging the skin of the hands. In the process of burning, a mixture of essential and vegetable oils is formed, which has a positive effect on the condition of the nail plates and cuticles. Useful vegetable oils shea, cocoa, coconut, tea tree and almonds contain a whole range of trace elements, minerals and vitamins; take care of the skin, making it soft and supple. And the essential oils of the paradise apple perfectly soften, moisturize, strengthen and regenerate the skin of the hands. Saturated with vitamin E and organic acids, has a high antioxidant activity. Protects against bacteria. Reduces wrinkles and reduces irritation. Suitable for problem skin.
18707		Massage candle Komilfo Massage Candle – Fresh Grapefruit, 30 g Massage candle Frozen Apple from Komilfo is an ideal tool for massaging the skin of the hands. In the process of burning, a mixture of essential and vegetable oils is formed, which has a positive effect on the condition of the nail plates and cuticles. Useful vegetable oils shea, cocoa, coconut, tea tree and almonds contain a whole range of trace elements, minerals and vitamins; take care of the skin, making it soft and supple. And the essential oils of mint and grapefruit relieve irritation and dryness of the skin, protecting it from wrinkles and age spots, help restore nails, preventing their fragility and delamination. Provides additional protection from the effects of the external environment and sunlight. The candle has a gentle and soothing aroma of fresh grapefruit. Mode of application: - Light a candle, wait a couple of minutes. Extinguish the candle and pour the melted butter over your hands. - Rub into the skin with massage movements. - Remove excess with a paper towel.
21486
21487