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 (
    82356, 82392, 86900, 91311, 91313, 91315, 
    82389, 85543, 85592, 88907, 88908, 
    89163, 89164, 88905, 88906, 92239, 
    85546, 85571, 85573, 85574, 87758, 
    90267, 90274, 92408, 91877, 91878, 
    91879, 91880, 91881, 91882, 91883, 
    85555, 85594, 86362, 86363, 87993, 
    88931, 91427, 91429, 91984, 85564, 
    85649, 85650, 85651, 86809, 90025, 
    82382, 82383, 82430, 82431, 82433, 
    82558, 87387, 87389, 85575, 85579, 
    82372, 86889, 86895, 82359, 87383, 
    87384, 87385, 89612, 89613, 91896, 
    87888, 91844, 88932, 92185, 92382, 
    85561, 88393, 91856, 82407, 82427, 
    87386, 82429, 85591, 85597, 85600, 
    88910, 90755, 82350, 86343, 88909, 
    82368, 82370, 82376, 86893, 85553, 
    85556, 85557, 85559, 85589, 85593
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00110

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.24"
    },
    "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": 96,
      "rows_produced_per_join": 96,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "33.64",
        "eval_cost": "9.60",
        "prefix_cost": "43.24",
        "data_read_per_join": "366K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (82356,82392,86900,91311,91313,91315,82389,85543,85592,88907,88908,89163,89164,88905,88906,92239,85546,85571,85573,85574,87758,90267,90274,92408,91877,91878,91879,91880,91881,91882,91883,85555,85594,86362,86363,87993,88931,91427,91429,91984,85564,85649,85650,85651,86809,90025,82382,82383,82430,82431,82433,82558,87387,87389,85575,85579,82372,86889,86895,82359,87383,87384,87385,89612,89613,91896,87888,91844,88932,92185,92382,85561,88393,91856,82407,82427,87386,82429,85591,85597,85600,88910,90755,82350,86343,88909,82368,82370,82376,86893,85553,85556,85557,85559,85589,85593)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}