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 (
    435351, 456510, 404001, 413818, 442117, 
    433550, 450230, 439049, 414690, 448070, 
    414544, 431904, 404473, 422990, 448236, 
    413068, 425901, 407405, 406178, 437072, 
    430766, 447574, 460572, 460325, 406193, 
    451309, 446162, 438117, 439044, 406083, 
    415033, 460158, 422354, 409660, 453640, 
    424754, 410340, 417422, 422439, 422004, 
    421990, 446415, 436834, 440447, 410009, 
    439533, 411516, 442635, 442715, 430741, 
    406089, 410471, 409489, 412459, 424229, 
    448141, 452096, 435935, 450361, 410461, 
    454777, 444113, 417555, 428819, 454049, 
    459252, 405167, 401806, 425534, 458860, 
    447690, 422606, 413386, 442183, 419735, 
    432464, 440571, 426931, 418909, 439791, 
    454556, 443028, 452359, 449330, 402443, 
    418233, 438218, 431841, 439184, 457686, 
    448158, 426138, 428377, 411651, 455838, 
    431788
  ) 
  AND cscart_product_descriptions.lang_code = 'ja'

Query time 0.00188

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 (435351,456510,404001,413818,442117,433550,450230,439049,414690,448070,414544,431904,404473,422990,448236,413068,425901,407405,406178,437072,430766,447574,460572,460325,406193,451309,446162,438117,439044,406083,415033,460158,422354,409660,453640,424754,410340,417422,422439,422004,421990,446415,436834,440447,410009,439533,411516,442635,442715,430741,406089,410471,409489,412459,424229,448141,452096,435935,450361,410461,454777,444113,417555,428819,454049,459252,405167,401806,425534,458860,447690,422606,413386,442183,419735,432464,440571,426931,418909,439791,454556,443028,452359,449330,402443,418233,438218,431841,439184,457686,448158,426138,428377,411651,455838,431788) and cscart_product_descriptions.lang_code = 'ja'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description unit_name
401806 Prime Shirt 347 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
402443 Prime Sofa 104 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
404001 Prime Book 145 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
404473 Prime Bottle 914 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
405167 Prime Shirt 337 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
406083 Prime Grinder 366 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
406089 Prime Mixer 235 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
406178 Prime Camera 681 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
406193 Prime Drone 302 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407405 Prime Camera 498 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
409489 Prime Mixer 374 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
409660 Prime Grinder 771 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
410009 Prime Laptop 827 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
410340 Prime Headphones 375 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
410461 Prime Phone 857 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
410471 Prime Mixer 317 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
411516 Prime Laptop 918 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
411651 Pro Backpack 821 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
412459 Prime Mixer 544 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
413068 Prime Camera 120 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
413386 Prime Shirt 594 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
413818 Prime Book 263 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
414544 Prime Bottle 483 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
414690 Prime Bottle 329 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
415033 Prime Grinder 451 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
417422 Prime Headphones 463 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
417555 Prime Router 204 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
418233 Prime Sofa 610 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
418909 Prime Sneakers 397 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
419735 Prime Shirt 736 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
421990 Prime Laptop 332 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422004 Prime Headphones 813 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422354 Prime Grinder 753 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422439 Prime Headphones 746 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422606 Prime Shirt 586 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422990 Prime Bottle 949 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424229 Prime Phone 223 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424754 Prime Headphones 264 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
425534 Prime Shirt 357 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
425901 Prime Camera 492 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
426138 Prime Watch 725 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
426931 Prime Sneakers 223 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428377 Prime Watch 992 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428819 Prime Router 886 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
430741 Prime Mixer 154 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
430766 Prime Camera 877 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
431788 Pro Book 195 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
431841 Prime Sofa 879 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
431904 Prime Bottle 508 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
432464 Prime Shirt 785 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
433550 Prime Book 556 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
435351 Prime Backpack 673 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
435935 Prime Phone 434 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436834 Prime Laptop 518 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
437072 Prime Camera 786 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
438117 Prime Drone 851 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
438218 Prime Sofa 754 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
439044 Prime Drone 976 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
439049 Prime Bottle 216 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
439184 Prime Sofa 890 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
439533 Prime Laptop 867 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
439791 Prime Sneakers 587 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
440447 Prime Laptop 635 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
440571 Prime Shirt 870 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
442117 Prime Book 509 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
442183 Prime Shirt 605 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
442635 Prime Laptop 971 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
442715 Prime Laptop 978 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
443028 Prime Sneakers 942 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
444113 Prime Router 164 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
446162 Prime Drone 736 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
446415 Prime Laptop 516 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
447574 Prime Camera 973 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
447690 Prime Shirt 499 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
448070 Prime Bottle 435 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
448141 Prime Phone 234 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
448158 Prime Watch 442 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
448236 Prime Bottle 986 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
449330 Prime Sneakers 981 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
450230 Prime Book 899 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
450361 Prime Phone 519 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
451309 Prime Drone 583 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
452096 Prime Phone 250 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
452359 Prime Sneakers 969 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
453640 Prime Headphones 215 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
454049 Prime Shirt 202 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
454556 Prime Sneakers 644 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
454777 Prime Phone 925 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
455838 Pro Book 138 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
456510 Prime Backpack 685 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
457686 Prime Watch 390 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
458860 Prime Shirt 454 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
459252 Prime Shirt 303 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460158 Prime Grinder 748 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460325 Prime Chair 899 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460572 Prime Camera 981 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.