Sandbox

SELECT 
  product_id, 
  short_description, 
  full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  product_id IN (2825, 2562, 2563, 2564, 12698, 2626) 
  AND lang_code = 'en'

Query time 0.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.21"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 6,
      "rows_produced_per_join": 6,
      "filtered": "100.00",
      "index_condition": "((`dev_yourmart_co_bw`.`cscart_product_descriptions`.`product_id` in (2825,2562,2563,2564,12698,2626)) and (`dev_yourmart_co_bw`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "3.61",
        "eval_cost": "0.60",
        "prefix_cost": "4.21",
        "data_read_per_join": "22K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id	short_description	full_description
2562		<ul><li>4th STREET Natural Sweet Red is easy to drink, <b>fresh</b> and naturally sweet</li><li>Unashamedly uncomplicated, easy-drinking and versatile, 4th STREET is a wine inspired by a passion for friendship and sharing</li><li>Easy drinking low alcohol sweet red wine</li><li>Great wine as entry into the wine category</li><li>This is the perfect Rare Red Blend</li><li>The 4th Street Sweet Red wine has a fruity sweetness which comes from preserving fresh grape juice, allowing no fermentation</li><li>It combines its sophisticated taste perfectly with the playful fruity taste </li><li>If you’re all about the perfect combination of playful and edgy, then this is the wine for you</li></ul>
2563		<ul><li>4th STREET Natural Sweet Red is easy to drink, <b>fresh</b> and naturally sweet</li><li>Unashamedly uncomplicated, easy-drinking and versatile, 4th STREET is a wine inspired by a passion for friendship and sharing</li><li>Easy drinking low alcohol sweet red wine</li><li>Great wine as entry into the wine category</li><li>This is the perfect Rare Red Blend</li><li>The 4th Street Sweet Red wine has a fruity sweetness which comes from preserving fresh grape juice, allowing no fermentation</li><li>It combines its sophisticated taste perfectly with the playful fruity taste </li><li>If you’re all about the perfect combination of playful and edgy, then this is the wine for you</li></ul>
2564		<ul><li>The fruity sweetness comes from preserving fresh grape juice, allowing no fermentation</li><li>Careful blending in the cellar gives a wine low in alcohol while bursting with fruity freshness</li><li>This is the perfect Rare Red Blend</li><li>The 4th Street Sweet Red wine has a fruity sweetness which comes from preserving fresh grape juice, allowing no fermentation</li><li> It combines its sophisticated taste perfectly with the playful fruity taste</li><li> If you’re all about the perfect combination of playful and edgy, then this is the wine for you</li></ul>
2626		<ul><li>Allesverloren is a Fine Old Vintage Port </li><li>Excellent enjoyed on its own or served with cheese and desserts</li><li>The seven varietals from which this wine is made came from trellised vineyards, grown in Malmesbury shale and situated some 270m to 340m above sea level</li></ul> <p><br /></p>
2825		<ul><li><span style="color:rgb(0,0,0);">Cabernet is known for its distinctive dark fruit flavors, high <a href="https://www.wine-searcher.com/technical-wine-terms-q-t.lml#tannins" title="'Tannin' definition" target="_self" rel="noreferrer noopener">tannins</a>, good acidity, and full-bodied texture</span></li><li><span style="color:rgb(0,0,0);">It is often used to ameliorate lesser grape varieties with its strength</span></li></ul>
12698		<p>999 VERGELEGEN WINE MILL RACE RED 1 x 750ML (1S)</p>