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 (
    611248, 698147, 611260, 695183, 697334, 
    992022, 992370, 612373, 697717, 697332, 
    991976, 1732072, 1282939, 1732198
  ) 
  AND cscart_product_descriptions.lang_code = 'ro'

Query time 0.09811

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "16.80"
    },
    "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": 14,
      "rows_produced_per_join": 14,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "15.41",
        "eval_cost": "1.40",
        "prefix_cost": "16.81",
        "data_read_per_join": "53K"
      },
      "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 (611248,698147,611260,695183,697334,992022,992370,612373,697717,697332,991976,1732072,1282939,1732198)) and (`maniamall_cscart`.`cscart_product_descriptions`.`lang_code` = 'ro'))"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
611248 Proiector LED CH059 Spot Beam 30° Tip LED: Cree cu lupa 6DLumina: ALB, 1800LM, 6000KDimensiune: 9.5 * 6.5 * 7.5cmVoltaj: 12-24VPutere: 20WAccesorii prindere incluse.Pret pe bucata. ... proiector led ch059 6d 20w 12/24v spot beam 30° geam transparent Proiector LED CH059 6D 20W 12/24V SPOT BEAM 30° geam transparent MRAM3-110119-2 leduri <font color='229d0'>Livrare in 3 zile</font>
611260 Banda flexibila DRL LED cu functie de semnalizare DINAMICA si lumina de zi.Lungime: 30cm.Flexibila si rezistenta la intemperiiCuloare pozitie alba si de semnalizare galbena.Pretul e pe set / 2 buc. ... banda flexibila led drl 30cm cu functie de semnalizare dinamica flowbo30cm Banda flexibila LED DRL 30cm cu functie de semnalizare DINAMICA FLOWBO30CM MRAM3-271218-1 leduri <font color='229d0'>Livrare in 3 zile</font>
612373 Bec SOFIT 6 LEDSoclu: SOFIT 36mm.Tensiune: 12V.Lumina: ALBA.Pret pe bucata.Compatibil pe majoritatea masinilor cu sistem CANBUS. ... bec 6 led sofit 36mm 12v alba cod: pt49 Bec 6 LED SOFIT 36MM 12V ALBA COD: PT49 MRAM3-120618-19 becuri albe alba leduri <font color='229d0'>Livrare in 3 zile</font>
695183 Bec bord 12V 1,2W (set 10 buc) - eChilipir bec bord 12v 1,2w (set 10 buc) Bec bord 12V 1,2W (set 10 buc) MRAM3-TCT-2767 becuri <font color='229d0'>Livrare in 3 zile</font>
697332 SET T4.7, 1 LED 5050 SMD 12V, Culoare ALBASTRU. Produs LUX - eChilipir set t4.7, 1 led 5050 smd 12v, culoare albastru. produs lux SET T4.7, 1 LED 5050 SMD 12V, Culoare ALBASTRU. Produs LUX MRAM3-TCT-5001 albe alba albastra leduri <font color='229d0'>Livrare in 3 zile</font>
697334 SET T3, 1 LED 3528SMD 12V, Culoare ALBASTRU. Produs LUX - eChilipir set t3, 1 led 3528smd 12v, culoare albastru. produs lux SET T3, 1 LED 3528SMD 12V, Culoare ALBASTRU. Produs LUX MRAM3-TCT-4996 albe alba leduri albastra <font color='229d0'>Livrare in 3 zile</font>
697717 Bec bord dulie plastic 24V, 1.2W (pret 10buc)Se vinde doar la set de 10 buc.Pentru a comanda mai multe bucati, exemplu il gasiti mai jos:1 = 10 buc.2 = 20 buc.3 = 30 buc. etc Poti comanda acum produsu... bec bord dulie plastic 24v, 1.2w (pret 10buc) Bec bord dulie plastic 24V, 1.2W (pret 10buc) MRAM3-TCT-2778 becuri <font color='229d0'>Livrare in 3 zile</font>
698147 LED SMD 5050 lumina albastra - eChilipir led smd 5050 lumina albastra LED SMD 5050 lumina albastra MRAM3-TCT-1560 albe alba leduri <font color='229d0'>Livrare in 3 zile</font>
991976 Becuri LED sofit 6 SMD CANBUS super luminoase.TIP LED: 3030Dimensiune: 11x36Putere: 10W 400LMTensiune: 12VPret pe set Produse din gama auto, tuning si accesorii la preturi ideale.... becuri led sofit canbus 6smd 36mm 3030 premium Becuri LED Sofit CANBUS 6SMD 36mm 3030 PREMIUM MRAM31-300719-1 leduri
992022 Proiector LED 180W - 14700LM COMBOLumina: GALBENADimensiune: 23.8 x 7.8 x 6.4cm.Alimentare : 10-30V60 LED-uri - 3W buc. EPISTAR Produse din gama auto, tuning si accesorii la preturi ideale.... proiector led 42083-y, combo, 180w, 12-24v lumina galbena Proiector LED 42083-Y, COMBO, 180W, 12-24V LUMINA GALBENA MRAM31-110619-2 albe alba leduri
992370 Banda flexibila DRL LED lumina alba.Tensiune: 24VSe poate monta in far ca si lumina de zi.Lungime: 30cm.Flexibila si rezistenta la intemperiiCuloare pozitie alba.Pretul e pe set / 2 buc. Produse din g... banda flexibila led drl lumina alba 30cm bo30w - 24v Banda flexibila LED DRL lumina alba 30cm BO30W - 24V MRAM31-070218-11 albe alba leduri
1282939 Bec o faza TV BA15S 5630 18SMD Alb Canbus 9v-30v nonpolar TopCars Bec o faza TV BA15S Canbus nonpolarCuloare : AlbLed :5630 18SMD Pini : simetric... bec o faza tv ba15s 5630 18smd alb canbus 9v-30v nonpolar topcars Bec o faza TV BA15S 5630 18SMD Alb Canbus 9v-30v nonpolar TopCars LPS1-MRA33-080817-5 becuri albe alba
1732072 MRA36-190321-13 leduri
1732198 MRA36-170221-7 albe alba leduri becuri