Sandbox

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 (
    1717787, 1605583, 1717795, 1717796, 
    1339739, 1339719
  ) 
  AND cscart_product_descriptions.lang_code = 'ro'

Query time 0.00101

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "7.20"
    },
    "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.60",
        "eval_cost": "0.60",
        "prefix_cost": "7.20",
        "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 (1717787,1605583,1717795,1717796,1339739,1339719)) and (`maniamall_cscart`.`cscart_product_descriptions`.`lang_code` = 'ro'))"
    }
  }
}

Result

product_id	meta_keywords	search_words
1339719	jucarie mini atelier de lucru pentru copii, din lemn, cu scule si accesorii, 45x49cm, 32 piese	Jucarie mini atelier de lucru pentru copii, din lemn, cu scule si accesorii, 45x49cm, 32 piese MSTR20-1176N jucarii jocuri copii copil joc jucarie joc jucarii
1339739	cort de joaca pentru copii cu tunel si piscina uscata, cu 100 bile, multicolor	Cort de joaca pentru Copii cu Tunel si Piscina uscata, cu 100 bile, multicolor MSTR20-8188B piscine jucarie jucari jucarii copii copil jucarie joc jucarii
1605583	masuta de cafea moderna pentru living, model scandinav, din mdf, dimensiune 64x47.5cm, alb	Masuta de cafea moderna pentru living, model Scandinav, din MDF, dimensiune 64x47.5cm, alb MSTR21-CT-001 masa albe alba
1717787		MSTR24-H2X2-albastru albastra albe alba
1717795		MSTR24-H2X0,5-albastru albastra albe alba
1717796		MSTR24-H2X0,5-roz