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 (
    91125, 91127, 91129, 91200, 91202, 91206, 
    91208, 91211, 91213, 91215, 91255, 
    91257, 91261, 91263, 91266, 91268, 
    91270, 85352, 85354, 91145, 91147, 
    91151, 91153, 91156, 91158, 91160, 
    82811, 82813, 82884, 82886, 82957, 
    82959, 83331, 83333, 83341, 83343, 
    89493, 89494, 89501, 89502, 89509, 
    89510, 89517, 89518, 82592, 82594, 
    83355, 83357
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00129

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.62"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.82",
        "eval_cost": "4.80",
        "prefix_cost": "21.62",
        "data_read_per_join": "183K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (91125,91127,91129,91200,91202,91206,91208,91211,91213,91215,91255,91257,91261,91263,91266,91268,91270,85352,85354,91145,91147,91151,91153,91156,91158,91160,82811,82813,82884,82886,82957,82959,83331,83333,83341,83343,89493,89494,89501,89502,89509,89510,89517,89518,82592,82594,83355,83357)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}