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 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    7886, 5537, 5505, 7895, 8026, 8408, 8409, 
    8405, 8406, 5530, 5528, 8188, 8050, 
    5593, 7876, 8049, 7922, 7877, 8407, 
    5534, 7892, 7906, 7903, 5592, 5595, 
    5589, 5547, 7951, 7896, 5597, 7894, 
    5538, 7890, 5527, 7904, 7893, 7897, 
    5545, 5550, 5539, 5596, 5591, 5579, 
    5541, 5590, 5531, 8404, 5594, 5549, 
    7888, 5553, 5535, 7889, 5526, 7887, 
    5552, 7891, 5598
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00284

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "101.13"
    },
    "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": 58,
      "rows_produced_per_join": 58,
      "filtered": "100.00",
      "index_condition": "((`cscartdb`.`cscart_product_descriptions`.`product_id` in (7886,5537,5505,7895,8026,8408,8409,8405,8406,5530,5528,8188,8050,5593,7876,8049,7922,7877,8407,5534,7892,7906,7903,5592,5595,5589,5547,7951,7896,5597,7894,5538,7890,5527,7904,7893,7897,5545,5550,5539,5596,5591,5579,5541,5590,5531,8404,5594,5549,7888,5553,5535,7889,5526,7887,5552,7891,5598)) and (`cscartdb`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "95.33",
        "eval_cost": "5.80",
        "prefix_cost": "101.13",
        "data_read_per_join": "221K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}