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 (
    454572, 450411, 428039, 444761, 429912, 
    420188, 424206, 407306, 428074, 418172, 
    410488, 432848, 436654, 442418, 440178, 
    403102, 407983, 446645, 403027, 424154, 
    407388, 442807, 440814, 407763, 422443, 
    404639, 402405, 456168, 439861, 426164, 
    458074, 423893, 421671, 450937, 432839, 
    441211, 407193, 406544, 425690, 408244, 
    436662, 405337, 419836, 438212, 447927, 
    433468, 426945, 409284, 441349, 429101, 
    413884, 422954, 444490, 453668, 415810, 
    448981, 438027, 427590, 452812, 431070, 
    455014, 451830, 460460, 415931, 401798, 
    423061, 441431, 408605, 430102, 455206, 
    431661, 456097, 426037, 432328, 419677, 
    402123, 424736, 414301, 414111, 454261, 
    414904, 416994, 415347, 416119, 408593, 
    405205, 449548, 416483, 422144, 418477, 
    429319, 415762, 434095, 411652, 460288, 
    435044
  ) 
  AND cscart_product_descriptions.lang_code = 'zh'

Query time 0.00671

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 (454572,450411,428039,444761,429912,420188,424206,407306,428074,418172,410488,432848,436654,442418,440178,403102,407983,446645,403027,424154,407388,442807,440814,407763,422443,404639,402405,456168,439861,426164,458074,423893,421671,450937,432839,441211,407193,406544,425690,408244,436662,405337,419836,438212,447927,433468,426945,409284,441349,429101,413884,422954,444490,453668,415810,448981,438027,427590,452812,431070,455014,451830,460460,415931,401798,423061,441431,408605,430102,455206,431661,456097,426037,432328,419677,402123,424736,414301,414111,454261,414904,416994,415347,416119,408593,405205,449548,416483,422144,418477,429319,415762,434095,411652,460288,435044) and cscart_product_descriptions.lang_code = 'zh'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description unit_name
401798 Mini Chair 920 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
402123 Mini Drone 552 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
402405 Mini Bottle 310 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
403027 Mini Book 566 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
403102 Mini Book 435 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
404639 Mini Bottle 307 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
405205 Mini Drone 872 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
405337 Mini Camera 576 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
406544 Mini Camera 254 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407193 Mini Camera 108 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407306 Mini Book 218 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407388 Mini Book 762 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407763 Mini Bottle 112 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407983 Mini Book 496 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
408244 Mini Camera 520 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
408593 Mini Drone 869 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
408605 Mini Drone 188 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
409284 Mini Camera 809 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
410488 Mini Book 279 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
411652 Mini Grinder 268 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
413884 Mini Camera 953 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
414111 Mini Drone 619 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
414301 Mini Drone 613 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
414904 Mini Drone 716 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
415347 Mini Drone 819 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
415762 Mini Grinder 163 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
415810 Mini Chair 291 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
415931 Mini Chair 859 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
416119 Mini Drone 839 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
416483 Mini Drone 900 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
416994 Mini Drone 801 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
418172 Mini Book 271 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
418477 Mini Drone 918 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
419677 Mini Drone 429 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
419836 Mini Camera 579 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
420188 Mini Book 194 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
421671 Mini Bottle 845 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422144 Mini Drone 908 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422443 Mini Bottle 179 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422954 Mini Camera 962 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
423061 Mini Chair 983 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
423893 Mini Bottle 668 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424154 Mini Book 706 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424206 Mini Book 214 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424736 Mini Drone 609 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
425690 Mini Camera 339 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
426037 Mini Drone 360 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
426164 Mini Bottle 577 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
426945 Mini Camera 804 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
427590 Mini Chair 414 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428039 Mini Backpack 900 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428074 Mini Book 254 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
429101 Mini Camera 941 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
429319 Mini Grinder 142 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
429912 Mini Book 113 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
430102 Mini Drone 198 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
431070 Mini Chair 627 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
431661 Mini Drone 229 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
432328 Mini Drone 360 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
432839 Mini Bottle 994 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
432848 Mini Book 291 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
433468 Mini Camera 790 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
434095 Mini Grinder 193 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
435044 Mini Grinder 322 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436654 Mini Book 362 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436662 Mini Camera 545 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
438027 Mini Chair 360 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
438212 Mini Camera 600 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
439861 Mini Bottle 464 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
440178 Mini Book 418 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
440814 Mini Book 904 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
441211 Mini Camera 102 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
441349 Mini Camera 928 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
441431 Mini Drone 143 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
442418 Mini Book 385 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
442807 Mini Book 856 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
444490 Mini Chair 123 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
444761 Mini Backpack 969 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
446645 Mini Book 554 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
447927 Mini Camera 636 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
448981 Mini Chair 300 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
449548 Mini Drone 895 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
450411 Mini Backpack 819 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
450937 Mini Bottle 991 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
451830 Mini Chair 778 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
452812 Mini Chair 601 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
453668 Mini Chair 283 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
454261 Mini Drone 619 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
454572 Mini Backpack 771 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
455014 Mini Chair 638 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
455206 Mini Drone 202 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
456097 Mini Drone 260 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
456168 Mini Bottle 397 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
458074 Mini Bottle 597 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460288 Mini Grinder 295 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460460 Mini Chair 783 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.