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 (
    187, 312419, 312881, 436374, 441927, 
    437733, 433372, 429338, 404315, 403114, 
    434319, 455492, 457298, 426898, 435154, 
    454872, 429201, 431252, 460123, 456772, 
    447624, 418357, 417083, 423074, 422315, 
    445550, 413493, 406571, 419858, 437062, 
    428608, 440002, 420919, 454421, 413105, 
    439177, 437268, 450216, 405994, 437380, 
    438012, 406160, 440620, 447721, 416159, 
    420047, 413235, 424041, 404972, 422227, 
    417626, 435762, 438672, 426360, 451505, 
    407258, 423749, 412845, 443252, 420293, 
    425061, 452721, 423069, 441632, 406091, 
    423199, 438052, 454478, 417088, 453292, 
    445552, 424505, 442602, 458311, 410066, 
    413649, 418646, 449188, 457164, 449416, 
    428005, 448854, 450236, 456268, 440745, 
    443518, 428934, 408752, 444980, 458748, 
    432096, 408335, 430862, 427822, 419800, 
    432348
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

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 (187,312419,312881,436374,441927,437733,433372,429338,404315,403114,434319,455492,457298,426898,435154,454872,429201,431252,460123,456772,447624,418357,417083,423074,422315,445550,413493,406571,419858,437062,428608,440002,420919,454421,413105,439177,437268,450216,405994,437380,438012,406160,440620,447721,416159,420047,413235,424041,404972,422227,417626,435762,438672,426360,451505,407258,423749,412845,443252,420293,425061,452721,423069,441632,406091,423199,438052,454478,417088,453292,445552,424505,442602,458311,410066,413649,418646,449188,457164,449416,428005,448854,450236,456268,440745,443518,428934,408752,444980,458748,432096,408335,430862,427822,419800,432348) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description unit_name
187 <p>Used by Cleveland Golf tour staff players worldwide</p>
312419
312881
403114 Classic Backpack 746 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
404315 Classic Backpack 716 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
404972 Classic Bottle 670 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
405994 Classic Bottle 127 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
406091 Classic Camera 633 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
406160 Classic Bottle 317 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
406571 Classic Book 714 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
407258 Classic Bottle 871 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
408335 Classic Grinder 405 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
408752 Classic Grinder 219 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
410066 Classic Drone 423 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
412845 Classic Bottle 989 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
413105 Classic Book 873 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
413235 Classic Bottle 503 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
413493 Classic Book 666 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
413649 Classic Drone 438 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
416159 Classic Bottle 424 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
417083 Classic Book 491 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
417088 Classic Camera 968 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
417626 Classic Bottle 704 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
418357 Classic Book 440 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
418646 Classic Drone 490 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
419800 Classic Grinder 681 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
419858 Classic Book 714 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
420047 Classic Bottle 455 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
420293 Classic Camera 205 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
420919 Classic Book 796 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422227 Classic Bottle 683 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
422315 Classic Book 631 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
423069 Classic Camera 331 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
423074 Classic Book 556 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
423199 Classic Camera 670 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
423749 Classic Bottle 943 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424041 Classic Bottle 565 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
424505 Classic Drone 318 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
425061 Classic Camera 209 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
426360 Classic Bottle 733 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
426898 Classic Backpack 868 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
427822 Classic Grinder 531 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428005 Classic Drone 654 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428608 Classic Book 751 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
428934 Classic Grinder 148 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
429201 Classic Book 187 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
429338 Classic Backpack 708 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
430862 Classic Grinder 439 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
431252 Classic Book 294 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
432096 Classic Grinder 356 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
432348 Classic Grinder 842 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
433372 Classic Backpack 575 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
434319 Classic Backpack 765 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
435154 Classic Backpack 934 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
435762 Classic Bottle 708 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
436374 Classic Backpack 265 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
437062 Classic Book 734 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
437268 Classic Book 922 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
437380 Classic Bottle 231 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
437733 Classic Backpack 503 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
438012 Classic Bottle 295 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
438052 Classic Camera 909 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
438672 Classic Bottle 724 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
439177 Classic Book 900 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
440002 Classic Book 776 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
440620 Classic Bottle 395 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
440745 Classic Grinder 117 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
441632 Classic Camera 373 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
441927 Classic Backpack 403 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
442602 Classic Drone 370 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
443252 Classic Camera 109 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
443518 Classic Grinder 138 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
444980 Classic Grinder 258 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
445550 Classic Book 634 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
445552 Classic Drone 230 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
447624 Classic Book 414 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
447721 Classic Bottle 418 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
448854 Classic Drone 844 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
449188 Classic Drone 514 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
449416 Classic Drone 615 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
450216 Classic Book 924 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
450236 Classic Drone 879 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
451505 Classic Bottle 769 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
452721 Classic Camera 223 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
453292 Classic Drone 107 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
454421 Classic Book 871 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
454478 Classic Camera 953 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
454872 Classic Backpack 983 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
455492 Classic Backpack 789 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
456268 Classic Drone 893 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
456772 Classic Book 388 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
457164 Classic Drone 517 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
457298 Classic Backpack 850 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
458311 Classic Drone 406 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
458748 Classic Grinder 355 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460123 Classic Book 384 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.