Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    939, 937, 938, 940, 936, 3733, 3736, 3735, 
    3734
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00028

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 9,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (939,937,938,940,936,3733,3736,3735,3734)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	search_words
936	<ul><li>HD VIDEO RECORDING</li><li>4 HD CHANNELS + 1 IP CHANNEL</li><li>H.265 VIDEO COMPRESSION</li><li>DUAL SD CARD SLOTS - UP TO 512 GB EACH (1 TB TOTAL)</li><li>MIRROR RECORDING OPTIONAL ON SECONDARY SD CARD</li><li>8 CUSTOMIZABLE SENSOR INPUTS</li><li>INTEGRATED GPS</li><li>BUILT-IN G-FORCE SENSOR</li><li>WIFI AND CELL NETWORKING</li></ul><p><br></p><p><br></p>		SVR-4401, SVR4401, SVR-4401-1C, 4401-HVR-128KIT, school bus camera, school bus cameras, school bus camera system, school bus video recorder, school bus recorder system, bus camera system
937	<ul><li>HD VIDEO RECORDING</li><li>4 HD CHANNELS + 1 IP CHANNEL</li><li>H.265 VIDEO COMPRESSION</li><li>DUAL SD CARD SLOTS - UP TO 512 GB EACH (1 TB TOTAL)</li><li>MIRROR RECORDING OPTIONAL ON SECONDARY SD CARD</li><li>8 CUSTOMIZABLE SENSOR INPUTS</li><li>INTEGRATED GPS</li><li>BUILT-IN G-FORCE SENSOR</li><li>WIFI AND CELL NETWORKING</li></ul>		school bus cameras, school bus camera system, bus recorder, school bus recorder, school bus recorder system
938	<ul><li>HD VIDEO RECORDING</li><li>4 HD CHANNELS + 1 IP CHANNEL</li><li>H.265 VIDEO COMPRESSION</li><li>DUAL SD CARD SLOTS - UP TO 512 GB EACH (1 TB TOTAL)</li><li>MIRROR RECORDING OPTIONAL ON SECONDARY SD CARD</li><li>8 CUSTOMIZABLE SENSOR INPUTS</li><li>INTEGRATED GPS</li><li>BUILT-IN G-FORCE SENSOR</li><li>WIFI AND CELL NETWORKING</li></ul>		school bus camera system, school bus cameras, bus camera kit, bus recorder system, school bus recorder system, 4401-HVR-256KIT
939	<ul><li>HD VIDEO RECORDING</li><li>4 HD CHANNELS + 1 IP CHANNEL</li><li>H.265 VIDEO COMPRESSION</li><li>DUAL SD CARD SLOTS - UP TO 512 GB EACH (1 TB TOTAL)</li><li>MIRROR RECORDING OPTIONAL ON SECONDARY SD CARD</li><li>8 CUSTOMIZABLE SENSOR INPUTS</li><li>INTEGRATED GPS</li><li>BUILT-IN G-FORCE SENSOR</li><li>WIFI AND CELL NETWORKING</li></ul>		school bus camera system, school bus camera, school bus cameras, school bus video recorder, school bus video camera, 4401-HVR-256KIT, 4401-HVR-512KIT
940	<ul><li>HD VIDEO RECORDING</li><li>4 HD CHANNELS + 1 IP CHANNEL</li><li>H.265 VIDEO COMPRESSION</li><li>DUAL SD CARD SLOTS - UP TO 512 GB EACH (1 TB TOTAL)</li><li>MIRROR RECORDING OPTIONAL ON SECONDARY SD CARD</li><li>8 CUSTOMIZABLE SENSOR INPUTS</li><li>INTEGRATED GPS</li><li>BUILT-IN G-FORCE SENSOR</li><li>WIFI AND CELL NETWORKING</li></ul>
3733		<table border="0" cellpadding="0" cellspacing="0" style="width:733px;" width="1100"> <tbody> <tr> <td style="width:462px;height:39px;"> <p> 1 Camera Complete kit – includes solid state DVR, (1) 32GB SD card, main wiring harness, (3) sensor inputs, (1) high res day/night color cameras with built-in microphone, IR illuminators & choice of cable lengths. 3 year warranty.</p> </td> </tr> </tbody> </table>
3734		<p> <span style="font-size: 11pt; line-height: 115%; font-family: Calibri, sans-serif;">2 Camera Complete kit – includes solid state DVR, (1) 32GB SD card, main wiring harness, (3) sensor inputs, (2) high res day/night color cameras with built-in microphone, IR illuminators & choice of cable lengths. 3 year warranty.</span></p>
3735		<p> <span style="font-size: 11pt; line-height: 115%; font-family: Calibri, sans-serif;">3 Camera Complete kit – includes solid state DVR, (1) 128 GB SD card, main wiring harness, (3) sensor inputs, (3) high res day/night color cameras with built-in microphone, IR illuminators & choice of cable lengths. <strong><i>3 year warranty.</i></strong></span></p>
3736		<p> <span style="font-size: 11pt; line-height: 115%; font-family: Calibri, sans-serif;">4 Camera Complete kit – includes solid state DVR, (1) 256 GB SD card, main wiring harness, (3) sensor inputs, (4) HD wide view day/night color cameras with built-in microphone, IR illuminators & choice of cable lengths. Also includes a copy of Foresight PRO video management software. <strong><i>3 year warranty.</i></strong></span></p>