SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    416375, 433436, 448865, 440677, 450681, 
    427174, 414574, 425369, 405856, 434263, 
    451926, 439645, 448556, 456247, 445779, 
    458775, 401030, 403121, 444029, 435106, 
    401667, 431036, 442622, 435820, 407055, 
    420457, 403050, 436192, 430271, 405021, 
    405943, 440774, 431667, 420500, 433248, 
    424749, 412815, 403456, 407007, 422237, 
    447976, 430068, 414625, 409183, 428416, 
    415063, 446914, 406030, 454186, 436812, 
    457461, 406194, 441207, 438933, 435721, 
    442119, 424436, 428287, 402786, 436483, 
    401987, 428175, 439527, 401876, 445083, 
    424624, 449431, 436892, 405580, 411806, 
    417229, 411014, 410058, 447757, 438526, 
    442767, 430212, 441225, 436067, 451189, 
    444386, 419181, 432455, 413694, 419036, 
    421751, 412255, 423736, 421594, 426721, 
    424267, 447785, 439588, 450100, 432761, 
    441299
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00699

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.16771496,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_descriptions",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["product_id", "lang_code"],
          "loops": 1,
          "rows": 96,
          "cost": 0.16771496,
          "filtered": 100,
          "attached_condition": "cscart_product_descriptions.product_id in (416375,433436,448865,440677,450681,427174,414574,425369,405856,434263,451926,439645,448556,456247,445779,458775,401030,403121,444029,435106,401667,431036,442622,435820,407055,420457,403050,436192,430271,405021,405943,440774,431667,420500,433248,424749,412815,403456,407007,422237,447976,430068,414625,409183,428416,415063,446914,406030,454186,436812,457461,406194,441207,438933,435721,442119,424436,428287,402786,436483,401987,428175,439527,401876,445083,424624,449431,436892,405580,411806,417229,411014,410058,447757,438526,442767,430212,441225,436067,451189,444386,419181,432455,413694,419036,421751,412255,423736,421594,426721,424267,447785,439588,450100,432761,441299) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description unit_name
401030 Max Router 479 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
401667 Max Router 612 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
401876 Max Sneakers 947 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
401987 Max Sneakers 831 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
402786 Max Sneakers 765 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
403050 Max Shirt 138 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
403121 Max Router 493 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
403456 Max Shirt 666 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
405021 Max Shirt 298 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
405580 Max Sofa 601 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
405856 Max Phone 897 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
405943 Max Shirt 348 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
406030 Max Sneakers 151 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
406194 Max Sneakers 328 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407007 Max Shirt 726 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407055 Max Shirt 114 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
409183 Max Shirt 927 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
410058 Max Sofa 756 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
411014 Max Sofa 682 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
411806 Max Sofa 657 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
412255 Mini Backpack 380 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
412815 Max Shirt 640 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
413694 Max Watch 978 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
414574 Max Phone 646 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
414625 Max Shirt 900 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
415063 Max Sneakers 128 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
416375 Max Phone 238 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
417229 Max Sofa 668 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
419036 Max Watch 996 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
419181 Max Watch 843 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
420457 Max Shirt 129 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
420500 Max Shirt 502 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
421594 Mini Backpack 449 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
421751 Mini Backpack 192 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422237 Max Shirt 815 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
423736 Mini Backpack 447 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424267 Mini Backpack 526 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424436 Max Sneakers 572 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424624 Max Sofa 317 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424749 Max Shirt 626 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
425369 Max Phone 858 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
426721 Mini Backpack 510 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
427174 Max Phone 636 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428175 Max Sneakers 868 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428287 Max Sneakers 744 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428416 Max Shirt 992 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
430068 Max Shirt 872 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
430212 Max Watch 207 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
430271 Max Shirt 277 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
431036 Max Router 655 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
431667 Max Shirt 466 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
432455 Max Watch 951 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
432761 Mini Backpack 654 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
433248 Max Shirt 582 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
433436 Max Phone 257 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
434263 Max Phone 905 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
435106 Max Router 532 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
435721 Max Sneakers 490 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
435820 Max Router 761 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436067 Max Watch 622 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436192 Max Shirt 213 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436483 Max Sneakers 779 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436812 Max Sneakers 206 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436892 Max Sofa 598 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
438526 Max Sofa 963 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
438933 Max Sneakers 353 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
439527 Max Sneakers 885 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
439588 Mini Backpack 538 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
439645 Max Router 171 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
440677 Max Phone 591 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
440774 Max Shirt 460 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
441207 Max Sneakers 348 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
441225 Max Watch 569 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
441299 Mini Backpack 702 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
442119 Max Sneakers 504 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
442622 Max Router 727 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
442767 Max Watch 174 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
444029 Max Router 503 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
444386 Max Watch 748 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
445083 Max Sofa 229 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
445779 Max Router 334 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
446914 Max Sneakers 148 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
447757 Max Sofa 846 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
447785 Mini Backpack 530 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
447976 Max Shirt 815 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
448556 Max Router 256 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
448865 Max Phone 502 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
449431 Max Sofa 452 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
450100 Mini Backpack 571 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
450681 Max Phone 633 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
451189 Max Watch 626 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
451926 Max Router 113 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
454186 Max Sneakers 163 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
456247 Max Router 299 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
457461 Max Sneakers 277 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
458775 Max Router 435 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.