SELECT 
  cscart_product_descriptions.product_id, 
  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 (
    503738, 1114057, 503771, 524883, 622209, 
    484137
  ) 
  AND cscart_product_descriptions.lang_code = 'ro'

Query time 0.09854

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "7.21"
    },
    "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": 6,
      "rows_produced_per_join": 6,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "6.61",
        "eval_cost": "0.60",
        "prefix_cost": "7.21",
        "data_read_per_join": "22K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text"
      ],
      "attached_condition": "((`maniamall_cscart`.`cscart_product_descriptions`.`product_id` in (503738,1114057,503771,524883,622209,484137)) and (`maniamall_cscart`.`cscart_product_descriptions`.`lang_code` = 'ro'))"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
484137 actuator auto universal cu 2 fire pentru inchidere centralizata si alarme auto Actuator Auto Universal cu 2 Fire pentru Inchidere Centralizata si Alarme Auto BLW4-1235
503738 camera video auto marsarier blow + cabluri montaj incluse Camera Video Auto Marsarier Blow + Cabluri Montaj Incluse BLW5-78-544 camere
503771 comutator buton auto on/off tunning 10a 125vac / 6a 250vac Comutator Buton Auto ON/OFF Tunning 10A 125VAC / 6A 250VAC BLW5-4905
524883 modulator fm auto bluetooth blow cu afisaj lcd, functie telefon, telecomanda, microfon incorporat si incarcator usb, culoare alb Modulator FM Auto Bluetooth Blow cu Afisaj LCD, Functie Telefon, Telecomanda, Microfon Incorporat si Incarcator USB, Culoare Alb BLW6-74-129 albe alba incarcatoare
622209 buton contact electric 5x5x1.4 pentru telecomanda, cheie auto l4 Buton contact electric 5x5x1.4 pentru telecomanda, cheie auto L4 OKY2-L4 electrica
1114057 purificator aer auto carruzzo, cu functie de ionizare, filtru de carbon, eficienta 3.6mp Purificator Aer Auto Carruzzo, cu Functie de Ionizare, Filtru de carbon, Eficienta 3.6mp GTL19-Q34E filtre