SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  cscart_product_descriptions.full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (65114, 8042) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00034

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.78"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id",
        "idx_product_desc_lang",
        "idx_product_name_search",
        "idx_product_desc_sort"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 2,
      "rows_produced_per_join": 2,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "1.58",
        "eval_cost": "0.20",
        "prefix_cost": "1.78",
        "data_read_per_join": "9K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`cscart_db`.`cscart_product_descriptions`.`product_id` in (65114,8042)) and (`cscart_db`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
8042 Long-lasting pearl-like finish <p>ITS TIME TO SHINE RENÉEs FAB 3 in 1 highlighter brings out just the right facial features adding radiance to your makeup look. It is a heavenly mixture of new light reflecting pigments that feel light on your skin but make sure you emit radiance like that of the moon. It contains three exotic shades including the warm pinkish hues of Rose Gold, shimmer of the rich Gold and the subtle sparkle of the White Gold. All these shades add a pearl-like finish to your skin rich, elegant and enticing. Made with natural ingredients like coconut oil, castor oil and vitamin E, it sits extremely well with all skin complexions since it is non-oily and non-greasy. It leaves a silky, smooth texture and makes your skin breathe in luxury. It is a perfect fit for your makeup arsenal since it is extremely easy to carry and easy to use anytime, anywhere. Add just this one highlighter stick to your travel kit and watch it become the star of your trip. After all, our FAB in 1 highlighter is not just an ordinary highlighter; it is a stick of illumination that makes you outshine everyone else! </p> <p><strong>How to use :-</strong> Select the shade that you want to with. Pop the shade and push it at the back of the stick to choose the colour you like and with one gentle stroke, apply it to the part of the face that you want to add a sparkle to. Now, using a makeup brush, carefully spread it out so that the highlighter does not stick to a single portion of your skin and voila, watch yourself carry the unmissable glow effortlessly!</p>
65114 Gives instant glossy shine to the skin <p>Get ready to light up the room with your statement glow using RENEE Hot Shot Face and Body Glowstick. Just one swipe of this roll-on glowstick will transform you into a sizzling hot goddess that's not just glowing, but downright captivating! Just roll it on the areas that you want to highlight be it your cheeks, arms, legs or back and invoke that shiny-healthy glow! RENEE Hot Shot Face & Body Glowstick is a shimmering dream come true, packed with the goodness of nourishing Vitamin E from Marula, Rosehip and Avocado oil, this sleek stick is travel-friendly & ease-to-use. Say goodbye to dullness and hello to radiant, moisturized skin that steals the show wherever you go. Get your glow on, anytime, anywhere!</p>