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 (1232051, 1232054) 
  AND cscart_product_descriptions.lang_code = 'ro'

Query time 0.00112

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.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": 2,
      "rows_produced_per_join": 2,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "2.21",
        "eval_cost": "0.20",
        "prefix_cost": "2.41",
        "data_read_per_join": "7K"
      },
      "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 (1232051,1232054)) and (`maniamall_cscart`.`cscart_product_descriptions`.`lang_code` = 'ro'))"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
1232051 CaracteristiciBucati per UM1 UMBUC Nr. bucati set25 Nr. bucati bax200 Tip ProdusCLESTI SI TRUSE DE SERTIZARE ... cleste dezizolat cablu coaxial , rg58, rg59, rg6 Cleste dezizolat cablu coaxial , RG58, RG59, RG6 MFER-GF-1440 cabluri <font color='229d0'>Livrare in 2-3 zile</font>
1232054 CaracteristiciBucati per UM1 UMBUC Nr. bucati set10 Nr. bucati bax100 Tip ProdusCLESTI SI TRUSE DE SERTIZARE ... cleste dezizolat cablu coaxial, telefon, utp Cleste dezizolat cablu coaxial, telefon, utp MFER-GF-1443 cabluri <font color='229d0'>Livrare in 2-3 zile</font>