Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.product, 
  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 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    5456, 5455, 5448, 5467, 5469, 5462, 5472, 
    5463, 5464, 5468, 5466, 5470
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.41"
    },
    "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": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "index_condition": "((`dbggbern`.`cscart_product_descriptions`.`product_id` in (5456,5455,5448,5467,5469,5462,5472,5463,5464,5468,5466,5470)) and (`dbggbern`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "7.21",
        "eval_cost": "1.20",
        "prefix_cost": "8.41",
        "data_read_per_join": "45K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "product",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id	product	full_description
5448	Flesh and Blood Dice - Small Steam Counters Set Of 4 (16mm)	<p><strong>Enhance your Flesh and Blood matches with these small Steam Counter dices that indicate your resources or damage!</strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>4 small Steam Counter dice</li></ul>
5455	Flesh and Blood Dice - Small Runechant Set Of 2 (16mm)	<p><strong>Enhance your Flesh and Blood matches with these small Runechant dices that indicate your resources or damage!</strong></p> <p><strong>You will receive:</strong></p> <ul><li>2 small Runechant dice</li></ul>
5456	Flesh and Blood Dice - Small Frostbite Set Of 2 (16mm)	<p><strong>Enhance your Flesh and Blood matches with these small Frostbite dices that indicate your resources or damage!</strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>2 small Frostbite dice</li></ul>
5462	Flesh and Blood Tokens - Large Black Dominate/GA Token	<div></div> <p><strong>Enhance your Flesh and Blood matches with these metal tokens that indicate if your attacks have Dominate or Go Again!</strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>1 BLACK Dominate/Go Again token</li></ul>
5463	Flesh and Blood Tokens - Large Gold Dominate/GA Token	<div></div> <p><strong>Enhance your Flesh and Blood matches with these metal tokens that indicate if your attacks have Dominate or Go Again!<br></strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>1 GOLD Dominate/Go Again token</li></ul>
5464	Flesh and Blood Tokens - Large Silver Dominate/GA Token	<div></div> <p><strong>Enhance your Flesh and Blood matches with these metal tokens that indicate if your attacks have Dominate or Go Again!<br></strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>1 SILVER Dominate/Go Again token</li></ul>
5466	Flesh and Blood Tokens - Silver Shield Set Of 4	<p><strong>Enhance your Flesh and Blood matches with these Silver Shield counter metal tokens for your equipment to indicate the damage they have taken!<br></strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>4 SILVER Shield tokens</li></ul>
5467	Flesh and Blood Tokens - Gold Shield Set Of 4	<p><strong>Enhance your Flesh and Blood matches with these GOLD Shield counter metal tokens for your equipment to indicate the damage they have taken!<br></strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>4 GOLD Shield tokens</li></ul>
5468	Flesh and Blood Tokens - Shiny Silver Shield Set Of 4	<p><strong>Enhance your Flesh and Blood matches with these Shiny Silver Shield counter metal tokens for your equipment to indicate the damage they have taken!<br></strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>4 SHINY SILVER Shield tokens</li></ul>
5469	Flesh and Blood Tokens - Large Attack Set Of 5	<p><strong>Enhance your Flesh and Blood matches with these metal tokens that indicate your damage!</strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>5 Large Attack Modifiers tokens</li></ul>
5470	Flesh and Blood Tokens - Small Attack Set Of 5	<p><strong>Enhance your Flesh and Blood matches with these metal tokens that indicate your damage!</strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>5 small Attack tokens</li></ul>
5472	Flesh and Blood Tokens - Large Damage Modifier Set Of 2	<p><strong>Enhance your Flesh and Blood matches with these metal tokens that indicate your damage!<br></strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>2 Damage modifier tokens</li></ul>