SELECT 
  product_id, 
  short_description, 
  full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  product_id IN (12498, 15904, 3441, 877, 3500, 3501) 
  AND lang_code = 'en'

Query time 0.00081

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 (12498,15904,3441,877,3500,3501)) 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
877 <ul style="margin-top:0px;margin-bottom:10px;color:#4f4f4f;font-family:Roboto, sans-serif;font-size:16px;"><li>All-Cast Construction</li> <li>7000lb (3175.14kg) Tested Capacity</li> <li>Lifts, Winches, Clamps, & More</li> <li>Most Durable Design</li> <li>Size: 152cm</li><li>Min. Lift Height: 11.43cm</li><li>Max. Lift Height: 126.37cm</li><li>Overall Height: 156.85.cm</li><li>Width: 12.7cm</li><li>Depth: 24.46cm</li><li>Rated Load (RL): 2,113kg</li><li>RL on upper 12" (30.5cm): 1206kg</li><li>Tested Load (TL): 1,814kg</li><li>Winching Capacity: 2,268kg</li><li>Clamping Capacity: 340kg</li><li>Weight: 14.2kg</li></ul>
3441 <p>For more than 20 years, Enlan has made quality knives, the Hunt-Pro collection has an innovative design with excellent quality this is the Enlan Hunt-Pro with a fixed blade and gut hook, perfect for those hunters out there.  Enlan products vary from pocket knife, hunting knife, army knife, tactical knife and fishing knife.</p> <h4>Product Features:</h4> <ul><li>Blade: 7cR17MoV</li><li>Blade: Satin finish with gut hook</li><li>Handle material: Rubber</li><li>Overall Length: 27.5cm</li><li>Length: 11.3cm</li></ul> <p><br /></p>
3500 <ul><li>High quality stylish stainless steel flask, with unique double walled vacuum technology for optimum insulation</li><li>Keeps your drinks hot for 12 hours and cold for up to 24 hours</li><li>Durable and lightweight, it can take a beating and still provide you with an ice cold drink</li><li>Slim design fits most of the vehicle bottle cup holders</li><li>Stainless steel inner allows for easy cleaning</li><li>Perfect for your gym bag, car, bicycle and backpack to enjoy your long hikes, trekking, hot yoga class, long load trip, or any other outdoor activities</li><li>Five year guarantee</li></ul> <p></p>
3501 <ul><li>High quality stylish stainless steel flask, with unique double walled vacuum technology for optimum insulation</li><li>Keeps your drinks hot for 12 hours and cold for up to 24 hours</li><li>Durable and lightweight, it can take a beating and still provide you with an ice cold drink</li><li>Slim design fits most of the vehicle bottle cup holders</li><li>Stainless steel inner allows for easy cleaning</li><li>Perfect for your gym bag, car, bicycle and backpack to enjoy your long hikes, trekking, hot yoga class, long load trip, or any other outdoor activities</li><li>Five year guarantee</li></ul> <p></p>
12498 <p></p><p>These plastic, workable sized storage boxes are easy to arrange in a cargo bed and vertical-sided to avoid wasted space. They stack securely for convenient storage in your vehicle thanks to the lids fitting neatly into the base of the box above it.</p> <ul><li>Made from black, high strength plastic.</li><li>Integrated grips for easy carrying.</li><li>Versatile. Use in the cargo bed, truck/boot, or on your roof rack.</li><li>Suitable for exterior storage.</li></ul> <p>These plastic, workable sized storage boxes are easy to arrange in a cargo bed and vertical-sided to avoid wasted space. They stack securely for convenient storage in your vehicle thanks to the lids fitting neatly into the base of the box above it.</p> <ul><li>Made from black, high strength plastic.</li><li>Integrated grips for easy carrying.</li><li>Versatile. Use in the cargo bed, truck/boot, or on your roof rack.</li><li>Suitable for exterior storage.</li></ul><p></p>
15904