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 (
    1233005, 1233008, 1233011, 1233012, 
    1233004, 1233001, 1232994, 1232998, 
    1232999, 1233020, 1233022, 1238147, 
    1238155, 1238164, 1238132, 1238131, 
    1233023, 1238120, 1238126, 1232993, 
    1232979, 1232940, 1232935, 1232906, 
    1232897, 1232946, 1232908, 1232977, 
    1232975, 1232947, 1232971, 1232966, 
    1232953, 1232965, 1232973
  ) 
  AND cscart_product_descriptions.lang_code = 'ro'

Query time 0.00093

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "41.50"
    },
    "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": 35,
      "rows_produced_per_join": 35,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "38.01",
        "eval_cost": "3.50",
        "prefix_cost": "41.51",
        "data_read_per_join": "133K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text"
      ],
      "attached_condition": "((`maniamall_cscart`.`cscart_product_descriptions`.`product_id` in (1233005,1233008,1233011,1233012,1233004,1233001,1232994,1232998,1232999,1233020,1233022,1238147,1238155,1238164,1238132,1238131,1233023,1238120,1238126,1232993,1232979,1232940,1232935,1232906,1232897,1232946,1232908,1232977,1232975,1232947,1232971,1232966,1232953,1232965,1232973)) and (`maniamall_cscart`.`cscart_product_descriptions`.`lang_code` = 'ro'))"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
1232897 sticker jante - seat (set 4 buc.) maniastiker Sticker jante - Seat (set 4 buc.) ManiaStiker STY-SM-SEAT1
1232906 stickere auto mercedes maniastiker Stickere auto Mercedes ManiaStiker STY-SN-BRAND015
1232908 stickere auto baiat piss maniastiker Stickere auto Baiat Piss ManiaStiker STY-SN-MES057
1232935 sticker auto pentru grila aer model bmw ///m power (3 buc - 35cm x 7cm) maniastiker Sticker auto pentru grila aer model BMW ///M Power (3 buc - 35cm x 7cm) ManiaStiker STY-SM-MPS35
1232940 sticker ornament auto model bmw ///m power (20cm x 18cm) maniastiker Sticker ornament auto model BMW ///M Power (20cm x 18cm) ManiaStiker STY-SM-MPS30a
1232946 sticker sports mind - bmw sport maniastiker Sticker Sports Mind - BMW SPORT ManiaStiker STY-SN-SPMN7
1232947 sticker sports mind - golf maniastiker Sticker Sports Mind - GOLF ManiaStiker STY-SN-SPMN8
1232953 sticker sports mind - amg maniastiker Sticker Sports Mind - AMG ManiaStiker STY-SN-SPMN17
1232965 sticker sports mind - skoda maniastiker Sticker Sports Mind - SKODA ManiaStiker STY-SN-SPMN37
1232966 sticker sports mind - opel maniastiker Sticker Sports Mind - OPEL ManiaStiker STY-SN-SPMN42
1232971 sticker prag alfa romeo (set 2 buc) maniastiker Sticker prag ALFA ROMEO (set 2 buc) ManiaStiker STY-SN-SAPL31
1232973 sticker prag audi (set 2 buc) maniastiker Sticker prag AUDI (set 2 buc) ManiaStiker STY-SN-SAPL12
1232975 sticker prag mitsubishi (set 2 buc) maniastiker Sticker prag MITSUBISHI (set 2 buc) ManiaStiker STY-SN-SAPL16
1232977 sticker prag quattro (set 2 buc) maniastiker Sticker prag QUATTRO (set 2 buc) ManiaStiker STY-SN-SAPL20
1232979 sticker tetiera piele bmw x5 (set 5 buc) maniastiker Sticker tetiera piele BMW X5 (set 5 buc) ManiaStiker STY-SA-STP18
1232993 sticker capota sau luneta - seat maniastiker Sticker capota sau luneta - SEAT ManiaStiker STY-SN-SCL10
1232994 sticker capota sau luneta - volkswagen maniastiker Sticker capota sau luneta - VOLKSWAGEN ManiaStiker STY-SN-SCL14
1232998 sticker capota opel - cpt39 maniastiker Sticker capota OPEL - CPT39 ManiaStiker STY-SN-CPT39
1232999 sticker performance - alfa romeo maniastiker Sticker Performance - ALFA ROMEO ManiaStiker STY-SN-PERF01
1233001 sticker performance - ford maniastiker Sticker Performance - FORD ManiaStiker STY-SN-PERF11
1233004 sticker performance - mitsubishi maniastiker Sticker Performance - MITSUBISHI ManiaStiker STY-SN-PERF19
1233005 sticker performance - opel maniastiker Sticker Performance - OPEL ManiaStiker STY-SN-PERF21
1233008 sticker performance - saab maniastiker Sticker Performance - SAAB ManiaStiker STY-SN-PERF24
1233011 sticker performance - smart maniastiker Sticker Performance - SMART ManiaStiker STY-SN-PERF27
1233012 sticker performance - suzuki maniastiker Sticker Performance - SUZUKI ManiaStiker STY-SN-PERF29
1233020 sticker sports mind skoda motorsport maniastiker Sticker Sports Mind SKODA Motorsport ManiaStiker STY-SN-SM001
1233022 sticker auto laterale bmw m power (set 2 buc.) maniastiker Sticker auto laterale BMW M POWER (set 2 buc.) ManiaStiker STY-SN-SAL03
1233023 sticker auto laterale bmw motorsport (set 2 buc.) maniastiker Sticker auto laterale BMW MOTORSPORT (set 2 buc.) ManiaStiker STY-SN-SAL06
1238120 sticker auto parbriz because audi, alb Sticker auto parbriz Because Audi, alb STY2-STKBCAUDI albe alba becuri
1238126 set stickere auto protectie praguri skoda octavia, negru/rosu, 4buc Set Stickere Auto Protectie Praguri Skoda Octavia, negru/rosu, 4buc STY2-STKOCNR rosie neagra
1238131 sticker auto capota auto wrc Sticker Auto Capota auto WRC STY2-SN-WRCC
1238132 set 5 stickere dacia aplicare pe capota – luneta – laterale modern tuning Set 5 stickere Dacia aplicare pe capota – luneta – laterale Modern Tuning STY2-KS004
1238147 sticker auto sport mind passat, negru/rosu Sticker auto Sport Mind Passat, negru/rosu STY2-STKSMPS rosie neagra
1238155 set stickere auto caroserie powered by audi, scris alb, 2buc Set Stickere auto caroserie Powered by Audi, scris alb, 2buc STY2-PWRAU120AB albe alba
1238164 set stickere manere usa mazda, culoare alb, 4 buc maniastiker Set Stickere manere usa MAZDA, culoare Alb, 4 buc ManiaStiker STY2-SM-MMAZ1 albe alba