SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    386230, 1026757, 671515, 1001748, 1002989, 
    1026639, 1026634, 1028815, 1029088, 
    459108, 562176, 1205512, 1779540, 
    1029029, 1914195, 1028861, 1006064, 
    999679, 1329210, 1005469, 1005477, 
    1026067, 1028489, 1001621, 1051465, 
    1000770, 1026826, 1051466, 1000273, 
    1005777, 1000893, 999510, 998713, 
    1026835, 1005493, 1000638, 1118393, 
    999450, 1914203, 999451, 1002439, 
    2089921, 1914202, 1033401, 2077210, 
    1730378, 1730377, 1730386, 1033409, 
    1730384, 999697, 1734632, 1232017, 
    1629494, 1232162, 1231209, 1231096, 
    1629497, 2068214, 1231338, 1232051, 
    1232167, 1231215, 1231839
  ) 
  AND cscart_product_descriptions.lang_code = 'ro'

Query time 0.00795

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "76.64"
    },
    "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": 64,
      "rows_produced_per_join": 64,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "70.24",
        "eval_cost": "6.40",
        "prefix_cost": "76.64",
        "data_read_per_join": "244K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text"
      ],
      "attached_condition": "((`maniamall_cscart`.`cscart_product_descriptions`.`product_id` in (386230,1026757,671515,1001748,1002989,1026639,1026634,1028815,1029088,459108,562176,1205512,1779540,1029029,1914195,1028861,1006064,999679,1329210,1005469,1005477,1026067,1028489,1001621,1051465,1000770,1026826,1051466,1000273,1005777,1000893,999510,998713,1026835,1005493,1000638,1118393,999450,1914203,999451,1002439,2089921,1914202,1033401,2077210,1730378,1730377,1730386,1033409,1730384,999697,1734632,1232017,1629494,1232162,1231209,1231096,1629497,2068214,1231338,1232051,1232167,1231215,1231839)) and (`maniamall_cscart`.`cscart_product_descriptions`.`lang_code` = 'ro'))"
    }
  }
}

Result