SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (
    802, 207, 205, 206, 201, 204, 203, 202, 
    597, 589, 1750, 713, 466, 535, 423, 534, 
    501, 1493, 531, 465, 588, 644, 640, 646, 
    643, 642, 641, 645, 507, 814, 815, 218, 
    1119, 1120, 1121, 861, 859, 437, 428, 
    843, 862, 1108, 267, 857, 1749, 396, 
    1659, 791, 474, 426, 793, 794, 1147, 
    849, 850, 852, 853, 851, 855, 854, 856, 
    208, 209, 210, 886, 555, 630, 554, 1109, 
    320, 318, 319, 969, 970, 252, 454, 639, 
    49
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00117

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id", "company_id"],
      "key": "PRIMARY",
      "key_length": "13",
      "used_key_parts": ["product_id", "lang_code", "company_id"],
      "rows": 78,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.product_id in (802,207,205,206,201,204,203,202,597,589,1750,713,466,535,423,534,501,1493,531,465,588,644,640,646,643,642,641,645,507,814,815,218,1119,1120,1121,861,859,437,428,843,862,1108,267,857,1749,396,1659,791,474,426,793,794,1147,849,850,852,853,851,855,854,856,208,209,210,886,555,630,554,1109,320,318,319,969,970,252,454,639,49) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
49
201
202
203
204
205
206
207
208
209
210
218
252
267
318
319
320
396
423
426
428
437
454
465
466
474
501
507
531
534
535
554
555
588
589
597
630
639
640
641
642
643
644
645
646
713
791
793
794
802
814
815
843
849
850
851
852
853
854
855
856
857
859
861
862
886
969
970
1108
1109
1119
1120
1121
1147
1493
1659
1749
1750