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 (
    18673, 18681, 15384, 15385, 15387, 15388, 
    15389, 15391, 15392, 15393, 15394, 
    15395, 15396, 15397, 15398, 15400, 
    15401, 15403
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00064

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.21"
    },
    "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": 18,
      "rows_produced_per_join": 18,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (18673,18681,15384,15385,15387,15388,15389,15391,15392,15393,15394,15395,15396,15397,15398,15400,15401,15403)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "39.61",
        "eval_cost": "3.60",
        "prefix_cost": "43.21",
        "data_read_per_join": "68K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
15384 <ul><li>Made of resin material, ensure its stability and durability Non-toxic, harmless, uneasy to deform Material: resin Product Size: 13 x 9 x 5cm Platform Size: 9 x 8cm Cave Size: 6 x 3.5cm Package: 1 x Reptile Cave</li></ul>
15385 <ul><li>Inspired by nature, the Fluval Chi Grass Aquarium Plant adds a level of beauty to your Fluval Chi. </li><li>The grass ornament is designed to fit in the top filter cube or bottom baskets of your Fluval Chi aquarium. </li><li><span></span>The Fluval Chi decor fits in the 5.5- and 6-gallon Chi aquariums and adds just the right touch to your aquarium.</li></ul>
15387 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Simulates light you would see in deeper sea water</span></li><li><span class="a-list-item">Produces refracted shimmering, dappled-lighting properties of natural sunlight</span></li><li><span class="a-list-item">Brings out vibrant colors</span></li><li><span class="a-list-item">Perfectly-balanced lighting for all types of coral and marine life</span></li></ul>
15388 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Easy to Use</span></li><li><span class="a-list-item">For fresh water and marine salt water tanks</span></li><li><span class="a-list-item">Doesn't loosen with pressure</span></li></ul>
15389 <p>Manually control the flow of vital O2 by switching an air pump on or off.<br />Made of 304 Stainless Steel and nickel-plated material, will not get rust easily.<br />Lever valve makes it easy to operate.<br />Control the flow of vital O2 from your pond aerator or aquarium air pump with this handy Air Control Valve.<br />Used for aquarium and aquaculture applications.<br />Air lever valve can be connected to aquarium tubing.<br />Package Include:6 x Air Flow Control Valve</p>
15391 <ul><li>Ceramic Bio-Filter Media with Vast Surface Area AND Open-Flow Porosity. </li><li>Designed for ammonia and nitrite removal in freshwater and marine aquariums. </li><li>Use in sumps or in tanks under gravel, easy to shape to fit in tight/custom places and filters.</li></ul>
15392 <ul><li>Clear and discrete, doesn't obstruct the beauty of your aquarium landscape Multipurpose,besides aquariums,</li><li>Ohaha 6mm x 4mm 9.8 Feet Air Tubing with 10 pcs</li><li>this air tubing is great as irrigation pipes in gardens</li></ul>
15393 <p>The Fluval Edge Carbon Clean & Clear Renewal Sachets are exclusively designed for the Fluval Edge aquarium to make sure your fish live in a healthy environment. The Carbon Clean & Clear Renewal Sachet is a premium-grade carbon providing superior adsorption qualities. The Fluval Edge Carbon Clean & Clear Renewal Sachets eliminate toxic impurities, odors and discoloration.</p>
15394 <ul><li>In-pond skimmer acts as a pre-filter for the pump. Easy to install. Use with flexible or preformed ponds.</li><li> Keeps the pond clean by skimming off the debris before it sinks.</li></ul>
15395 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Easy to install reptofilter Cartridges keep the water crystal clear.</span></li><li><span class="a-list-item">Disposable filter cartridge</span></li><li><span class="a-list-item">Ultra activated carbon</span></li></ul>
15396 <ul><li>API BIO-CHEM ZORB SIZE 10 cartridge uses superior resins and activated carbon to clean and clear aquarium water, removing aquarium pollutants such as colors, odors, and heavy metals. </li><li>The research-grade resin-carbon blend is up to 3x more effective in clearing water than carbon alone. BIO-CHEM ZORB corrects poor water quality caused by pollutants that can suppress a fish's immune system, leading to disease or death. </li><li>Replace monthly, or sooner if aquarium is heavily stocked or colors/odors are detected.</li><li> Can be used to remove medication from water once disease treatment is completed. Contains 2 filtration media cartridges. With API Aquarium products, it?s easy to keep a beautiful saltwater, freshwater or reef aquarium.</li><li> For over 50 years, API has been creating innovative, research-driven solutions that make it easier to care for your fish and aquarium. API Aquarium Treatment Supplies are designed to work in conjunction with each other to provide best results to control algae, promote healthy bacterial growth and help control and cure fish diseases and conditions such as ich and fin rot. They work to provide a safe, hospitable environment for fish such as tropical community fish, cichlids, goldfish and more. With API, you can spend more time admiring your fish, and less time scrubbing your tank. Make sure to use all products as directed in order to ensure the best results.</li></ul>
15397 <ul><li>For the ultimate in convenience and quiet, choose a Whisper In-Tank Filter. This filter mounts on the inside of the aquarium, rather than hanging from the outside -- making it possible to place the tank flush against a wall. The 3i In-Tank Filter uses air bubbles to move water up the airlift tube and through the filter cartridge making it ideal for keeping small fish and breeding fish. </li><li>The Whisper In-Tank filter adjusts easily to high or low water levels with mounting clamps. Each unit includes the filter, air pump, two feet of airline tubing and one Small Whisper Bio-Bag filter cartridge.</li></ul>
15398 <p>Provide the place, such as Guby, Killy fish to spawn.Self-floating and hang-on style design, exquisite.</p>
15400 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Contains one (1) API STRESS COAT Aquarium Water Conditioner 64-Ounce bottle</span></li><li><span class="a-list-item">Makes tap water safe and protects fish with dual-action formula</span></li><li><span class="a-list-item">Removes chemicals from tap water that are harmful to fish</span></li><li><span class="a-list-item">Replaces fish’s protective coat damaged by handling, shipping or fish Fighting with healing power of aloe Vera extract</span></li><li><span class="a-list-item">Use when adding or changing water, when adding new fish and when fish are sick or injured</span></li></ul>
15401 <ul><li>API TURTLE FIX Antibacterial Turtle Remedy rapidly treats aquatic turtles, newts, and aquatic frogs for bacterial infections, and repairs damaged tissue and wounds where fungus may grow. </li><li>Safe and all-natural treatment contains tea tree extract, and works on the body and limbs of aquatic/semi-aquatic reptiles and amphibians. API TURTLE FIX treats symptoms such as skin reddening, open wounds, damaged tissue, and white, cloudy film on the skin. Contains 8 fl oz of medication, and treats 474 US gallons of aquarium water. Dose according to directions on product label. </li><li>With API Aquarium products, it?s easy to keep a beautiful saltwater, freshwater or reef aquarium.</li><li> For over 50 years, API has been creating innovative, research-driven solutions that make it easier to care for your fish and aquarium. API Aquarium Treatment Supplies are designed to work in conjunction with each other to provide best results to control algae, promote healthy bacterial growth and help control and cure fish diseases and conditions such as ich and fin rot. They work to provide a safe, hospitable environment for fish such as tropical community fish, cichlids, goldfish and more. With API, you can spend more time admiring your fish, and less time scrubbing your tank. Make sure to use all products as directed in order to ensure the best results.</li></ul>
15403 <ul><li>Treat and heal wounds, diseases and infections with API BETTAFIX Antibacterial & Antifungal Betta Fish Infection and Fungus Treatment.</li><li> This natural antibacterial remedy promotes rapid re-growth of damaged fins and skin. Use it to treat ulcers, mouth fungus, fin and tail rot and when you see signs of bacterial and fungal diseases like red ulcers, slimy patches or cottony growths.</li><li> It can also be used to help heal wounds and tissue damaged by handling, netting or fighting.</li><li> Contains healing melaleuca, a variety of tea tree. API BETTAFIX Antibacterial & Antifungal Betta Fish Infection and Fungus Treatment also helps heal open wounds and tissue damaged by handling, netting and fighting, and it promotes rapid re-growth of damaged fins and skin.</li><li> With API Aquarium products, it?s easy to keep a beautiful saltwater, freshwater or reef aquarium. For over 50 years, API has been creating innovative, research-driven solutions that make it easier to care for your fish and aquarium. </li></ul>
18673 <ul><li> Maintains clean aquarium surfaces</li><li><span class="a-list-item">Revitalizes old, smelly brown water</span></li><li><span class="a-list-item">Safe for plants</span></li><li><span class="a-list-item">Reduces organics</span></li><li><span class="a-list-item">100% Natural</span></li></ul>
18681 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">4 in 1 Aquascaping tools - Straight Tweezer, Curved Tweezer, Aquatic Curved Scissor, Spatula. Comes with a decent velvet pouch, for you to package well when not in use.</span></li><li><span class="a-list-item">Forged Stainless Steel Material - Made of durable stainless steel material with excellent flexibility and will never suffer rust. The ridged handle will provide secure, comfortable grips on your fingers.</span></li><li><span class="a-list-item">Anti Slip Clips - Both the straight and curved tweezer has serrated tips to help grip stuff securely without ever slipping off. You can use these tweezers to feed and handle live food for larger aquatic pets or corals.</span></li><li><span class="a-list-item">Safe & Minimizing interference - Specially designed delicate clip end, no harm to your small or thin water plants, minimum water disturbance rather than use hand directly, helps prevent accidental injuries to your reptile's mouth.</span></li><li><span class="a-list-item">Versatile - Great for all types of aquarium plants, fish tank substrate, gravel and other Aquarium decorations. The key benefit is that it allows precision plant trimming and maintenance that does not disturb the rest of the decor/plants.</span></li></ul>