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 (
    157878, 
    131244, 
    163555, 
    142795, 
    152834, 
    139304, 
    140470, 
    161677, 
    137204, 
    150431, 
    173467, 
    122494, 
    174303, 
    176633, 
    155460, 
    152788, 
    159979, 
    152387, 
    177902, 
    146542, 
    148127, 
    155163, 
    146233, 
    130037, 
    130745, 
    151021, 
    128287, 
    143111, 
    155514, 
    124685, 
    170152, 
    148944, 
    151780, 
    133106, 
    145497, 
    145180, 
    173179, 
    128213, 
    174680, 
    146818, 
    170999, 
    131696, 
    171673, 
    131951, 
    166209, 
    165386, 
    172481, 
    141152, 
    123413, 
    128274, 
    167042, 
    171994, 
    166489, 
    154484, 
    128340, 
    166263, 
    135458, 
    155044, 
    148326, 
    143307, 
    139706, 
    124396, 
    172334, 
    121219, 
    173565, 
    147677, 
    177514, 
    141410, 
    122327, 
    142464, 
    155085, 
    164296, 
    136827, 
    176060, 
    130512, 
    149075, 
    137444, 
    142067, 
    136299, 
    135240, 
    137144, 
    165641, 
    137493, 
    122588, 
    125079, 
    121137, 
    175250, 
    130713, 
    129259, 
    153437, 
    148372, 
    141211, 
    160027, 
    137205, 
    147933, 
    138696, 
    158978, 
    124484, 
    138587, 
    130862, 
    149784, 
    136011, 
    136213, 
    142966, 
    165523, 
    118369, 
    139067, 
    129348, 
    165171, 
    119815, 
    136217, 
    170004, 
    123533, 
    126063, 
    155865, 
    161288, 
    136896, 
    135083, 
    176947, 
    166994, 
    134428, 
    175167, 
    162335, 
    137156, 
    143428, 
    130486, 
    151548, 
    142017
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00476

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.22335624,
    "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": 128,
          "cost": 0.22335624,
          "filtered": 100,
          "attached_condition": "cscart_product_descriptions.product_id in (157878,131244,163555,142795,152834,139304,140470,161677,137204,150431,173467,122494,174303,176633,155460,152788,159979,152387,177902,146542,148127,155163,146233,130037,130745,151021,128287,143111,155514,124685,170152,148944,151780,133106,145497,145180,173179,128213,174680,146818,170999,131696,171673,131951,166209,165386,172481,141152,123413,128274,167042,171994,166489,154484,128340,166263,135458,155044,148326,143307,139706,124396,172334,121219,173565,147677,177514,141410,122327,142464,155085,164296,136827,176060,130512,149075,137444,142067,136299,135240,137144,165641,137493,122588,125079,121137,175250,130713,129259,153437,148372,141211,160027,137205,147933,138696,158978,124484,138587,130862,149784,136011,136213,142966,165523,118369,139067,129348,165171,119815,136217,170004,123533,126063,155865,161288,136896,135083,176947,166994,134428,175167,162335,137156,143428,130486,151548,142017) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description unit_name
118369 Air Phone 195 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
119815 Air Phone 683 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
121137 Air Laptop 343 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
121219 Air Grinder 614 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
122327 Air Headphones 169 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
122494 Air Book 717 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
122588 Air Laptop 261 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
123413 Air Drone 464 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
123533 Air Phone 906 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
124396 Air Grinder 476 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
124484 Air Mixer 537 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
124685 Air Camera 644 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
125079 Air Laptop 336 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
126063 Air Router 182 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
128213 Air Chair 357 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
128274 Air Drone 637 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
128287 Air Camera 398 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
128340 Air Drone 976 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
129259 Air Laptop 453 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
129348 Air Phone 437 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
130037 Air Camera 232 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
130486 Air Shirt 362 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
130512 Air Headphones 537 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
130713 Air Laptop 407 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
130745 Air Camera 319 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
130862 Air Mixer 618 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
131244 Air Backpack 726 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
131696 Air Chair 855 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
131951 Air Drone 162 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
133106 Air Chair 104 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
134428 Air Router 381 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
135083 Air Router 277 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
135240 Air Headphones 823 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
135458 Air Grinder 133 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
136011 Air Mixer 810 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
136213 Air Mixer 870 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
136217 Air Phone 761 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
136299 Air Headphones 773 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
136827 Air Headphones 359 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
136896 Air Router 244 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
137144 Air Headphones 860 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
137156 Air Router 703 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
137204 Air Book 506 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
137205 Air Mixer 124 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
137444 Air Headphones 719 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
137493 Air Laptop 204 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
138587 Air Mixer 594 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
138696 Air Mixer 239 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
139067 Air Phone 236 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
139304 Air Book 387 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
139706 Air Grinder 321 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
140470 Air Book 410 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
141152 Air Drone 285 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
141211 Air Laptop 766 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
141410 Air Grinder 858 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
142017 Air Shirt 438 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
142067 Air Headphones 756 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
142464 Air Headphones 184 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
142795 Air Backpack 859 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
142966 Air Phone 104 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
143111 Air Camera 503 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
143307 Air Grinder 272 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
143428 Air Router 996 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
145180 Air Chair 334 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
145497 Air Chair 203 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
146233 Air Bottle 857 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
146542 Air Bottle 700 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
146818 Air Chair 813 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
147677 Air Grinder 816 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
147933 Air Mixer 129 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
148127 Air Bottle 715 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
148326 Air Grinder 198 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
148372 Air Laptop 626 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
148944 Air Camera 920 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
149075 Air Headphones 697 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
149784 Air Mixer 773 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
150431 Air Book 612 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
151021 Air Camera 339 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
151548 Air Shirt 373 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
151780 Air Camera 999 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
152387 Air Bottle 516 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
152788 Air Bottle 381 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
152834 Air Book 213 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
153437 Air Laptop 609 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
154484 Air Drone 938 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
155044 Air Grinder 147 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
155085 Air Headphones 274 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
155163 Air Bottle 841 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
155460 Air Book 987 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
155514 Air Camera 599 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
155865 Air Router 190 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
157878 Air Backpack 474 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
158978 Air Mixer 367 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
159979 Air Bottle 465 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
160027 Air Laptop 874 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
161288 Air Router 227 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
161677 Air Book 477 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
162335 Air Router 621 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
163555 Air Backpack 768 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
164296 Air Headphones 294 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
165171 Air Phone 632 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
165386 Air Drone 241 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
165523 Air Phone 180 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
165641 Air Laptop 147 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
166209 Air Drone 203 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
166263 Air Grinder 128 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
166489 Air Drone 847 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
166994 Air Router 352 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
167042 Air Drone 666 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
170004 Air Phone 793 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
170152 Air Camera 796 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
170999 Air Chair 840 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
171673 Air Chair 978 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
171994 Air Drone 723 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
172334 Air Grinder 535 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
172481 Air Drone 277 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
173179 Air Chair 344 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
173467 Air Book 641 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
173565 Air Grinder 782 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
174303 Air Book 823 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
174680 Air Chair 717 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
175167 Air Router 471 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
175250 Air Laptop 351 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
176060 Air Headphones 491 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
176633 Air Book 862 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
176947 Air Router 302 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
177514 Air Grinder 829 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
177902 Air Bottle 624 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.