SELECT 
  q_product_descriptions.product_id, 
  q_product_descriptions.short_description, 
  IF(
    q_product_descriptions.short_description = '', 
    q_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  q_product_descriptions 
WHERE 
  q_product_descriptions.product_id IN (
    30685, 30686, 30687, 30688, 30689, 30690, 
    30691, 30692, 30693, 30694, 30695, 
    30696, 30697, 30699, 30700, 30701
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00072

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "38.41"
    },
    "table": {
      "table_name": "q_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 16,
      "rows_produced_per_join": 16,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (30685,30686,30687,30688,30689,30690,30691,30692,30693,30694,30695,30696,30697,30699,30700,30701)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "35.21",
        "eval_cost": "3.20",
        "prefix_cost": "38.41",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
30685 <p>Features:<br />1. Available for cars with OBD2 and EUOBD port(Car automatic diagnosis system) ,plug and play<br />2. Multi-color design makes the screen more abundant and easier to read<br />3. Rich Contents: speed,RPM,water temperature,voltage,instantaneous fuel consumption,average fuel consumption,driving distance measurement, shift reminders,fatigue driving reminders,low voltage alarm,high water temperature alarm,over speed alarm, engine failure alarm, eliminate the fault code,freely switch between kilometers&miles.<br />4. Auto power on/off: it start and off with vehicle started and shutdown, effective protection of the car battery;retaining the manual switch mode,more easy to control.<br /><br />Display Function:<br />1. Multi-function area :fuel consumption,voltage,water temperature,single driving time(Minutes), single driving distance(KM,Mile),Engine RPM<br />2. Unit for multi-functional area<br />3. Light sensor<br />4. Engine RPM<br />5. Alarm icon: high water temperature alarm,low voltage alarm,over speed alarm,shifting reminding<br />6. Setting,fatigue alarm,fault code<br />7. Buzzer mark<br />8. Speed<br />9. Speed Unit in MPH<br />10. Speed Unit in KM/H<br />Technical Parameters:<br />Environment temperature: -40 + 80 Degree<br />Atmospheric pressure: 86-106KPa<br />Relative Humidity: 10% -95% <br />Environmental noise: ≤60dB (A)<br />Alarm sound level: ≥30dB (A)<br />Working voltage: 9V ~ 16Vdc (12Vdc / 400mA)<br />Package Includes:<br />1 x HUD Car Head Up Display<br />1 x Anti Slip Pad<br />1 x OBD Cable</p><p> </p>
30686 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">1. Listen to the correct song, record songs and phone calls,</span></li> <li><span class="a-list-item">2. Remember the call number, the last call, all the Chinese and English smart voice messages, boot, pair, turn off the phone power will send a low voice message;</span></li> <li><span class="a-list-item">3. The power capacity will be displayed on your Iphone, you can see the energy status at any time, don't worry about the power, let your life worry-free;</span></li> <li><span class="a-list-item">4. After the Bluetooth headset is turned off, connect to the mobile phone, connect the Bluetooth headset and then automatically turn on the mobile phone, which is more convenient;</span></li> <li><span class="a-list-item">5.Smart compatibility: compatible with all mobile phones, including Bluetooth, tablets, notebooks, singing,, movies, etc., universal mobile phones</span></li> </ul>
30687 <div>Product Description:</div> <div>External portable drive for PC.</div> <div>Suitable for USB 3.0 connector.</div> <div>Have reading information function.</div> <div>Compatible for Windows xp / 2003 / for Vista / 7 / 8.1 / 10, for Linux, for Mac OS system.</div> <div>No need to install the driver program, support plug and play.</div> <div> </div> <div>Descriptions:</div> <div>USB 3.0 transmission standard.</div> <div>Strong and stable data transmission.</div> <div> </div> <div>Specifications:    </div> <div>Material: Aluminum alloy + Plastic</div> <div>Port: USB 3.0</div> <div>USB cable length: 23cm</div> <div>Cache: 2MB</div> <div>Voltage: DC 5V</div> <div>Operating temperature: 5℃-35℃</div> <div>Compatible: for Windows xp / 2003 / for Vista / 7 / 8.1 / 10, for Linux, for Mac OS</div> <div>Supported disc formats: DVD-RAM, DVD-R, DVD-RW, DVD+R, DVD+RW, CD-R, CD-RW, CD-ROM</div> <div>Size:140*140*15mm</div> <div> </div> <div>Package included:    </div> <div>1 x USB External Drive</div> <div>1 x User Manual</div>
30688 <div>Product Description:</div> <div>.Bilateral zippers, designed for conveniently taking out the camera.</div> <div>.Equipped with a rain cover, super water resistant performance and safety protection.</div> <div>.Enough space and pockets to store your accessories such as filters, battery, charger, memory cards, cables, twin-lens, etc.</div> <div>.Can be used for DSLR camera, like Nikon, Sony, Canon etc.</div> <div>.One piece special padded shoulder strap and ergonomic design, comfortable to use</div> <div>.Two quick release buckles on the bottom, can tie a tripod or monopod stably</div> <div>.With triangle physical symmetric structures, 10mm thick layers of clapboard, one-piece aglet, adjustable belt</div> <div>.Protect your camera against damage, dust and scratches with its tough and durable foam exterior and its padded anti-shock interior</div> <div> </div> <div>Type: Single shoulder</div> <div>Material: Nylon</div> <div>Product size (L x W x H): 27 x 30 x 11 cm /10.61 x 11.79 x 4.32 inches</div> <div> </div> <div>Package contents:</div> <div>1 x Caden K1 Triangle Shoulder Camera Bag</div> <div>1 x Rain Cover</div>
30689 <div><span style="font-family:Arial, Verdana;"><span>Product Description:  </span></span></div> <div><span style="font-family:Arial, Verdana;"><span>-Type: 3.5mm Microphone Adapter Cable</span></span></div> <div><span style="font-family:Arial, Verdana;"><span>-Interface: Mini USB to 3.5mm audio jack</span></span></div> <div><span style="font-family:Arial, Verdana;"><span>-Cable Length: Approx. 6.75in (17cm)</span></span></div> <div><span style="font-family:Arial, Verdana;"><span>-Compatibility: For GoPro Hero 3 3 4 Camera Only, NOT for other Model</span></span></div> <div><span style="font-family:Arial, Verdana;"><span>Accessories Only, the GoPro Camera in the pictures above NOT included</span></span></div> <div><span style="font-family:Arial, Verdana;"><span> </span></span></div> <div><span style="font-family:Arial, Verdana;"><span>Package Included:</span></span></div> <div><span style="font-family:Arial, Verdana;"><span>1 x 3.5mm Microphone Adapter Cable for GoPro Hero 3 3 4 </span></span></div>
30690 <div><span style="font-family:Arial, Verdana;font-size:10pt;">Product Description: </span></div> <div><span style="font-family:Arial, Verdana;font-size:10pt;">1) an Organize and Custom Designed Storage Case for Your Gopro Camera & Accessories  </span></div> <div><span style="font-family:Arial, Verdana;font-size:10pt;">2) Perfect for Gopro Storage when Not in Use  </span></div> <div><span style="font-family:Arial, Verdana;font-size:10pt;">3) Perfect as A Protective Travel Case  </span></div> <div><span style="font-family:Arial, Verdana;font-size:10pt;">4) Sleek, Lightweight, Padded, and Compact!  </span></div> <div><span style="font-family:Arial, Verdana;font-size:10pt;">5) Perfectly Shaped Compartments for A Gopro Camera, Outer Housing, and Accessories  </span></div> <div><span style="font-family:Arial, Verdana;font-size:10pt;">6) Compatible with Gopro Hero Hd 3 / 2  </span></div> <div><span style="font-family:Arial, Verdana;font-size:10pt;">7) Outer Size: 21 Cm X 16 Cm X 6.5 Cm, Inter Size: 20.5 Cm X 15.5 Cm X 5 Cm</span></div> <div><span style="font-family:Arial, Verdana;font-size:10pt;"> </span></div> <div><span style="font-family:Arial, Verdana;font-size:10pt;">Package Includes: </span></div> <div><span style="font-family:Arial, Verdana;font-size:10pt;">1 X Bag</span></div>
30691 <div>Product Description:</div> <div>●Input ports: HDMI; Output ports: 3RCA (Yellow,White,Red)</div> <div>●No need to install drivers, portable, flexible, plug and play</div> <div>●Support NTSC and PAL two standard TV formats</div> <div>●High-Speed HDMI Cable, Supports Ethernet, 3D, and Audio Return</div> <div>●Compatible HDMI1.3</div> <div> </div> <div>Product Descriptions:</div> <div>.MINI HDMI to AV signal converter which will convert HDM video signal or audio signal to AV (CVBS) composite video signal and the FL / FR stereo audio signals, while support DVI system sideline signals.</div> <div>.To help users convert the HDMI video signal into normal CVBS signal (standard-definition 480i, 576i,)</div> <div>.it can play on TV, VHS VCR, DVD recorders, etc and support NTSC and PAL two TV format.</div> <div>.Can not be used in cars!</div> <div>.No need to install drivers, portable, flexible, plug and play.</div> <div>.Support NTSC and PAL two standard TV formats output</div> <div>.Compatible HDMI1.3</div> <div>.Input ports: 1xRCA (Yellow,White,Red).</div> <div>.Output ports: 1xRCA (Yellow,White,Red).</div> <div>.Dimensions(mm): 72(D)x55(W)x20(H)</div> <div>.Wight (g): 40</div> <div>.Composite input:PAL,NTSC3.58,NTSC4.43,SECAM,PAL/M,PAL/N. 6</div> <div>.Composite output: PAL,NTSC.</div> <div>NOTE:not support 1080p</div>
30692 <ul class="generatedBullets"><li>Brand : SunnyLife</li> <li>Type : Camera Bags</li> <li>Material : Polyethylene</li> </ul><div> <div>Portable Waterproof Hard Carrying Case Storage Bag Compatible with DJI Osmo Pocket and Expansion Kit</div> <div>High-grade PU fabric shell, waterproof & Sturdy; Exquisite craftsmanship, smooth and delicate. High quality velvet fabric one-piece module interior, tenderly care for your OSMO POCKET</div> <div>Can freely divide the storage space to accommodate the SD card, Adapter mount, portable charger, extra batteries, cable, camera filters and other accessories according to your needs</div> <div> </div> <div>Specifications:</div> <div>Brand: SunnyLife</div> <div>Material: PU</div> <div>Type: Bag Case</div> <div>Compatible with: DJI Osmo Pocket</div> <div> </div> <div>Please note that the Gimble is not included in the package</div> <div> </div> <div>Package Includes:</div> <div>1x Sunnylife DJI OSMO POCKET Handheld Gimbal Camera Waterproof Portable Protective Storage Bag Case</div> <div> </div> </div>
30693 <div>Description:</div> <div>DJI OSMO MOBILE 2  Nylon Carrying Bag </div> <div>Hard carry case for DJI Osmo Mobile 2 Gimbal and accessories</div> <div>Keeps for your OSMO Mobile 2 Gimbal and accessories safe ,protected, and organized</div> <div>EVA foam padding with pre-cut slots to hold your Osmo Mobile 2 Gimbal and accessories</div> <div>Shock proof, scratches proof and water resistant</div> <div>Designed with Carry handle, easy to carry outdoor</div> <div>Easy to access to your device with durable zipper opening</div> <div>Size:35x16x9.5cm</div> <div>Weight:429.5g</div> <div> </div> <div>Packing includes:</div> <div>1* For DJI Osmo Mobile 2 Storage Carry Bag</div>
30694 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Directview innovative design, no obstruction of sight</span></li> <li><span class="a-list-item">No trace and stable</span></li> <li><span class="a-list-item">No breaking bending</span></li> <li><span class="a-list-item">Gift choice; safe driving home</span></li> <li><span class="a-list-item">ABS material, reasonable design, easy to install and use</span></li> </ul>
30695 <p class="a-size-large a-spacing-none"><span class="a-size-large">ISKIL i12 TWS Bluetooth 5.0 Earphone True Wireless Sports Touch Earbuds Sweatproof headset 3D Stereo Air pod (White)</span></p>
30696 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Is Adult Product : Yes</span></li> <li><span class="a-list-item">Type : G-String</span></li> <li><span class="a-list-item">Targeted Group : Women</span></li> <li><span class="a-list-item">Material : Lace</span></li> <li><span class="a-list-item">Material Composition : Nylon</span></li> <li><span class="a-list-item">Brand : Other</span></li> </ul>
30697 <br />Watch Face Diameter: About 4.2cm <br />Shell Thickness: About 0.8cm <br />Band Material: Stainless Steel <br />Band Width: About 1.8cm <br />Total Length: About 20.5cm <br />Band Color: Silver
30699 <ul class="generatedBullets"><li>Manufacturer Number : 1</li> <li>Accessory Type : Cases & Covers</li> <li>Screen Size : 10 Inch</li> <li>Color Family : Blue</li> <li>Brand : Other</li> <li>Compatible with : huawei mediapad t5</li> </ul>
30700 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Other</span></li> <li><span class="a-list-item">Type : Beds & Furniture</span></li> <li><span class="a-list-item">Sub Type : Beds & Mats</span></li> <li><span class="a-list-item">Species : Cats & Dogs</span></li> <li><span class="a-list-item">Are batteries needed to power the product or is this product a battery : No</span></li> <li><span class="a-list-item">Is this a Dangerous Good or a Hazardous Material, Substance or Waste that is regulated for transportation, storage, and/or disposal? : No</span></li> </ul>
30701 <ul class="generatedBullets"><li>Manufacturer Number : 1</li> <li>Accessory Type : Cases & Covers</li> <li>Screen Size : 10.1 Inch</li> <li>Color Family : Multi Color</li> <li>Brand : Other</li> <li>Compatible with : lenovo tab M10</li> </ul>