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 (
    427330, 402409, 403669, 423506, 426608, 
    458274, 436405, 444831, 403215, 414680, 
    410940, 433452, 418550, 457581, 427170, 
    452077, 424079, 404004, 456880, 452598, 
    445874, 453013, 426987, 449964, 429702, 
    407837, 423377, 402780, 444233, 411115, 
    440099, 424538, 401632, 437229, 408818, 
    424420, 422451, 420718, 420738, 440135, 
    427608, 428894, 445601, 420381, 430254, 
    422033, 405045, 420628, 445650, 452876, 
    409275, 417856, 421213, 459072, 434781, 
    451373, 459407, 430283, 442733, 428634, 
    447088, 450307, 434158, 436478, 422140, 
    425868, 428560, 456487, 453428, 437879, 
    415402, 446901, 408969, 411199, 428916, 
    403278, 449543, 407451, 428967, 444439, 
    446577, 417175, 460402, 428173, 453165, 
    438135, 446053, 448865, 440677, 427174, 
    414574, 454722, 431067, 434263, 439645, 
    401030
  ) 
  AND cscart_product_descriptions.lang_code = 'ar'

Query time 0.00242

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 (427330,402409,403669,423506,426608,458274,436405,444831,403215,414680,410940,433452,418550,457581,427170,452077,424079,404004,456880,452598,445874,453013,426987,449964,429702,407837,423377,402780,444233,411115,440099,424538,401632,437229,408818,424420,422451,420718,420738,440135,427608,428894,445601,420381,430254,422033,405045,420628,445650,452876,409275,417856,421213,459072,434781,451373,459407,430283,442733,428634,447088,450307,434158,436478,422140,425868,428560,456487,453428,437879,415402,446901,408969,411199,428916,403278,449543,407451,428967,444439,446577,417175,460402,428173,453165,438135,446053,448865,440677,427174,414574,454722,431067,434263,439645,401030) and cscart_product_descriptions.lang_code = 'ar'"
        }
      }
    ]
  }
}

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.
401632 Max Drone 995 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
402409 Max Chair 168 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
402780 Max Drone 652 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
403215 Max Chair 693 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
403278 Max Mixer 345 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
403669 Max Chair 243 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
404004 Max Drone 183 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
405045 Max Grinder 914 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407451 Max Mixer 430 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407837 Max Drone 629 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
408818 Max Grinder 226 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
408969 Max Mixer 166 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
409275 Max Headphones 204 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
410940 Max Chair 743 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
411115 Max Drone 865 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
411199 Max Mixer 256 — 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.
414680 Max Chair 733 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
415402 Max Mixer 115 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
417175 Max Mixer 808 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
417856 Max Headphones 279 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
418550 Max Chair 757 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
420381 Max Grinder 703 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
420628 Max Grinder 929 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
420718 Max Grinder 368 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
420738 Max Grinder 392 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
421213 Max Headphones 281 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422033 Max Grinder 850 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422140 Max Laptop 250 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422451 Max Grinder 316 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
423377 Max Drone 640 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
423506 Max Chair 267 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424079 Max Drone 164 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424420 Max Grinder 290 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424538 Max Drone 963 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
425868 Max Laptop 351 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
426608 Max Chair 326 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
426987 Max Drone 472 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
427170 Max Chair 905 — 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.
427330 Max Chair 127 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
427608 Max Grinder 490 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428173 Max Phone 182 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428560 Max Laptop 394 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428634 Max Headphones 715 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428894 Max Grinder 531 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428916 Max Mixer 296 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428967 Max Mixer 447 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
429702 Max Drone 567 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
430254 Max Grinder 848 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
430283 Max Headphones 665 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
431067 Max Phone 778 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
433452 Max Chair 747 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
434158 Max Laptop 206 — 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.
434781 Max Headphones 399 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436405 Max Chair 539 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436478 Max Laptop 223 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
437229 Max Grinder 208 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
437879 Max Laptop 687 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
438135 Max Phone 452 — 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.
440099 Max Drone 962 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
440135 Max Grinder 475 — 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.
442733 Max Headphones 701 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
444233 Max Drone 832 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
444439 Max Mixer 593 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
444831 Max Chair 643 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
445601 Max Grinder 603 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
445650 Max Headphones 108 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
445874 Max Drone 354 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
446053 Max Phone 476 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
446577 Max Mixer 672 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
446901 Max Mixer 151 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
447088 Max Headphones 798 — 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.
449543 Max Mixer 346 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
449964 Max Drone 503 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
450307 Max Headphones 963 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
451373 Max Headphones 481 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
452077 Max Chair 939 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
452598 Max Drone 274 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
452876 Max Headphones 145 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
453013 Max Drone 406 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
453165 Max Phone 399 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
453428 Max Laptop 631 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
454722 Max Phone 706 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
456487 Max Laptop 607 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
456880 Max Drone 189 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
457581 Max Chair 802 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
458274 Max Chair 501 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
459072 Max Headphones 385 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
459407 Max Headphones 547 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460402 Max Mixer 990 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.