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 (
    6957, 6958, 6959, 6960, 6961, 6962, 6963, 
    6964, 6965, 6966, 6967, 6968, 6969, 
    6970, 6971, 6972, 6974, 6977, 6978, 
    6979, 4497, 4498, 4499, 4500, 4501, 
    4502, 4503, 4504, 4505, 4506, 4507, 
    4509
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00074

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "76.81"
    },
    "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": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (6957,6958,6959,6960,6961,6962,6963,6964,6965,6966,6967,6968,6969,6970,6971,6972,6974,6977,6978,6979,4497,4498,4499,4500,4501,4502,4503,4504,4505,4506,4507,4509)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "70.41",
        "eval_cost": "6.40",
        "prefix_cost": "76.81",
        "data_read_per_join": "122K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
4497 <p>Blood Pressure Monitor by Laica is non invasive and fully automatic. Use this BP monitor to measure your heartbeat and blood pressure at home. Keep your heart in check and live a healthy life with the full automatic inflation and deflation with Laica BM1004 Wrist Blood Pressure Monitor. It features a large LCD display to facilitate an easy reading of the value measured. This non invasive BP monitor measures the arterial pressure values i.e. systolic and diastolic, heartbeat frequency, and irregular heartbeats. In addition, this BP monitor also shows the classification of BP levels according to WHO. Furthermore, the Laica monitor is capable of storing 60 memories for future analysis.</p><p><strong>ACCURACY AND RELIABILITY</strong></p><p>The Laica Wrist BP Monitor utilizes Oscillometric technology to offer an accurate reading. It does so by recording the oscillations of the arteries and measures both systolic and diastolic values for a better understanding of your heart.</p><p><strong>EASY CHECK AND ANALYSIS</strong></p><p>Featuring a large LCD display, the Laica blood pressure monitor facilitates easy reading. Its memory stores systolic and diastolic pressure, pulse, date, and time of 60 measurements for future use. It also notifies any irregularities in the heartbeat and blood pressure in accordance with the classification set by WHO.</p>
4498 <ul><li>The Spectrum Heating Pad is designed for warming the human body and allows you to apply targeted warmth promoting increased circulation and relaxing muscles.</li> <li>The Heating Pad has a safety system in-built. This prevents overheating by automatically switching off in the event of a fault.</li> <li>Heating element : wipeable plastic protective coverRemovable and washable cotton coverOverheating protection.</li> <li>Temperature regulation - 3 temperature settings.</li> </ul>
4499 <ul><li>Effectively Provides Relief to Muscular Aches and Pain.</li> <li>It Uses Infrared Heat Which Penetrates Into Tissues, Muscles and Bones and Speeds up Blood Circulation to Help Body Detoxify and Increases Blood Vessel Resilience to Ease Muscle Soreness and Relieve Back Pain.</li> <li>Infrared Lamp: 300 Watt Radiant Warmth.</li> <li>Uv Proof.</li> <li>With Countdown Timer and Auto Off Function.</li> <li>Adjustable Lamp Angle for Comfort Use.</li> <li>With Hands Off Glass Warning Indicator.</li> <li>With Built in Cool Down Ventilator.</li> <li>Recommended Treatment Body Areas: Shoulder, Lower Back, Arm, Leg.</li> <li>Recommended Treatment Distance: 30cm.</li> <li>Power: Ac Plug.</li> </ul>
4500 <p>Laica Pocket Mesh Nebulizer</p><p>The Laica NE1005 ultrasound aerosol therapy unit guarantees a rapid and extremely silent spray. Its small size and compact shape make it particularly handy and suitable for travel. Easy to use, its silent operation makes it the perfect solution for children.</p><ul><li>Extremely quiet.</li> <li>Battery and mains operation (transformer not included).</li> <li>Compact and handy.</li> </ul>
4501 <ul><li>The Laica Bm2006 Blood Pressure Monitor Is a Fully Automatic Medical Device for Home Use.</li> <li>It Allows Rapid Measurement of Blood Pressure (systolic and Diastolic) and Heart Rate.</li> <li>Easy to Use, It Lets You Monitor Your Blood Pressure Quickly Every Day, at Home.</li> <li>120 Records.</li> <li>Practical Cover Included.</li> </ul>
4502 <ul><li>Laica Electrical Muscle Stimulators Are Based On Low Frequency Electrical Stimulation That Reproduces The Natural Mechanism Of Muscular Contraction.</li> <li>Body Shapelaica Medical Approved Electro-Stimulators For Effective Physical Therapy, Maintaining Physical Fitness, Muscle Relaxation And Built-Up With A Wide Range Of Pre-Programmed Functions For Effectively Enhancing Your Well-Being</li> <li>Sport 4500.</li> <li>4 Channels.</li> <li>8 Electrodes.</li> <li>30 Programs.</li> <li>10 Intensity Levels.</li> </ul>
4503 <ul><li>Uses the Beneficial Action of Steam to Deep Cleanse Facal Skin.</li> <li>Ideal for Use in The Home.</li> <li>Supplied with Inhaler and Measuring Beaker.</li> <li>On/off Indicator Ligh.</li> </ul>
4504 <p><span class="redactor-selection-marker"></span></p><ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Model Number : PC1017B</span></li><li><span class="a-list-item">Power Source : Corded Electric</span></li><li><span class="a-list-item">Brand : LAICA</span></li><li><span class="a-list-item">Type : Foot</span></li><li><span class="a-list-item">Messaging Technique : Vibration</span></li><li><span class="a-list-item">Anti‐splash cover  Roll massager with knots  Heated bottom keeps water at a constant temperature  Vibrations and water bubbles quickly restore a feeling of wellbeing and relaxation </span></li></ul>
4505 <ul><li>The Th2002 Laica Infrared Ear Thermometer Detects Body Temperature Quickly with Infrared Technology.</li> <li>It Is Especially Suitable for Monitoring Children, as It Takes the Temperature Quickly.</li> <li>Easy and Handy, the Laica Infrared Ear Thermometer Stores the Last Measurement Taken and Is Equipped with A Beep Indicator.</li> <li>Infrared Technology.</li> <li>Quick Measuring.</li> <li>Large Lcd Display for Easy Reading.</li> </ul>
4506 <ul><li>Smart electronic scale with body composition calculator.</li> <li>Measures weight.</li> <li>Calculates fat %.</li> <li>Water %.</li> <li>Skeletal muscle mass %.</li> <li>Skeletal system weight.</li> <li>Base metabolism.</li> <li>Body mass index.</li> <li>Automatically sends body composition data to your Smartphone or tablet.</li> <li>Compatible with Bluetooth 4.0 and above technology.</li> </ul>
4507 <ul><li>Parades a mechanical display that allows users to conveniently read data</li> <li>Equipped with an automatic zero setting to bring the reading down to zero after use</li> <li>Profuse material construction ensures corrosion resistant longevity</li> </ul>
4509 <ul><li>Hard Skin Remover for Foot Care.</li> <li>Removes Dry, Hardened Skin from Feet and Heels, for Soft, Smooth Skin.</li> <li>Equipped with Switch with Lock.</li> </ul>
6957 <div>Helps to monitor the growth of your baby</div> <div>Large LCD display for easy reading</div> <div>TARE function allows you to zero the scale if a blanket/nappy</div> <div>is used</div> <div>WEIGHT-BLOCK function allows a steady weight to be displayed</div> <div>even with a wriggling child</div> <div>Unit of measure: kg and lb</div> <div>Weight capacity 20 kg / 44.09 lb / 705.4 oz</div> <div>Range of measurement 20 g - 20 kg</div> <div>Division 5 g / 0.01 lb / 0.1 oz</div> <div>4 replaceable alkaline batteries (type 1.5V AAA LR03) not inclu</div> <div>ded</div> <div>Low battery warning</div> <div>Over maximum weight warning</div> <div>High quality construction which meets European Safety Regulation</div> <div>Packed in a custom designed display box</div>
6958 <div>For infants and children LAICA developed a full line of medical approved scales and thermometers as well as humidifiers manufactured under the strictest quality and safety controls with special attention to the specific needs and care of this age group.</div> <div> </div> <ul><li>Large LCD display for easy reading</li> <li>TARE function allows you to zero the scale if a blanket/nappy is used</li> <li>WEIGHT-BLOCK function allows a steady weight to be displayed even with a wriggling child</li> <li>Unit of measure : kg and lb</li> <li>Weight capacity 20 kg / 44:40 lb</li> <li>Range of measurement 1 kg – 20 kg / 2.2 lb – 44:40 lb</li> <li>Division 10 g / 1/2 oz</li> <li>1 replaceable alkaline battery (9V 6LR61)- not included</li> <li>Low battery warning</li> <li>Over maximum weight warning</li> </ul>
6959 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Adjustable cold steam jet - gives very fine and longlasting vaporisation</li> <li class="jsx-1889249662">Orientable steam atomizer can be manually rotated 360</li> <li class="jsx-1889249662">Steam emission lasts for approximately 10 hours</li> </ul>
6960 <ul><li> <div style="text-align:left;">Fast and accurate measurement of temperature in a contactless way (at a distance) Measurement of body temperature, baby food, room temperature, surface temperature and water temperature (in the bathroom)</div> </li> </ul><div style="text-align:left;"> <ul><li>Large backlit LCD display. Memory results of the last 32 measurements.</li> </ul><ul><li>Audible end of measurement.</li> </ul></div> <ul><li> <div style="text-align:left;">Auto power off.</div> </li> </ul>
6961 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Total Capacity 2.3 L Filtered Water 1.2 L Capacity, Hand Wash with Warm Water/detergent for Dishes with The Exception of The Cartridge.</span></li> <li><span class="a-list-item">You can always have water for drinking/prepare food without the inconvenience of transport, the taste of food/drinks prepared with filtered water greatly improves.</span></li> <li><span class="a-list-item">The filtered water with Caraffe/EUR Laica Only costs a few pence per litre cartridges, one cartridge is equivalent to 1 month of filtered water.</span></li> <li><span class="a-list-item">Significantly reduces the amount of plastic bottle.</span></li> </ul>
6962 <p>The Th3601 Laica Digital Thermometer Detects Body Temperature with Simplicity. the Lcd Display Allows for Easy Reading of The Detected Temperature (oral, Under Arm and Rectal).</p> <p>The Flexible Probe Makes It More Comfortable to Use. It Emits a Beep to Indicate when The Temperature Measurement Is Complete and Stores the Last Measurement Taken. It Has a Practical Cover that Keeps It Safe and Hygienic. in Addition to This It Is Washable Also.</p>
6963 <span>This Baby Digital Thermometer from Laica Features an Easy to Read Digital Lcd Display with An Automatic Shut Off Function and Measures Temperature in Celsius (c°) & Fahrenheit (f°).</span>
6964 Effectively Converts Liquid Medicines Into Easily Inhaled Micro-Droplets. Silent Remedy to Treat Pulmonary Disorders, Tracheitis, Bronchitis, Sinusitis. Ensures that The Micro-Droplets Reach the Respiratory Tracts for Quick and Intense Action.
6965 <br /><ul><li>Converts liquid medicine into a fine mist that can be easily inhaled.</li> <li>Ideal for young children & people who have difficulty using metered dose inhalers and people who have severe asthma.</li> <li>Ideal for the treatment of: Pulmonary disorders, tracheitis, bronchitis, sinusitis, allergies & colds.</li> <li>Very quick and silent.</li> <li>The transducer produces high frequency sound waves which activate liquid micro-drops (nebulisation).</li> <li>The nebulised drug is blown directly into the throat/nose by an electric fan</li> <li>Micro-drops reach all respiratory tracts.</li> <li>Equipped with: adult mask, pediatric mask, mouthpiece, tube, ampoules.</li> <li>On/off indicator light.</li> <li>Mains powered.</li> <li>Exclusive Italian design.</li> <li>Product certified in compliance with directive for 93/42/EEC “medical device”.</li> <li>Packed in a custom designed display box.</li> <li>Full instructions provided.</li> </ul>
6966 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Sterilizes baby's bottles and feeding accessories without using any chemicals</li> <li class="jsx-1889249662">Features a tight and compact sealing lid that keeps bacteria and germs out</li> <li class="jsx-1889249662">Outfitted with a digital display that keeps you notified about the sterilisation process</li> </ul>
6967 <span>Our Breast Pump Is the Ideal Appliance Which Can Imitate Rhythm of Baby’s Sucking and Its Soft Silicone Can Give Your Breast a Massage, Alleviate Pain and Avoid the Mammilla Collapses.</span>
6968 <ul><li>Comfortable electric breast pump tp express and store breast milk</li> <li>9 Levels of suction</li> <li>5 Levels of breast massage fit different needs</li> <li>Designed to mimic sucking pattern of a baby</li> <li>Soft silicone suchion helps alleviate pain</li> <li>Digital pain with mode, timing and battery status for easy navigation</li> <li>Can be used with power adapter or on battery</li> <li>Fully charged built in battery provides up to 45 minutes of operation</li> </ul>
6969 <span>Our Breast Pump Is the Ideal Appliance Which Can Imitate Rhythm of Baby’s Sucking and Its Soft Silicone Can Give Your Breast a Massage, Alleviate Pain and Avoid the Mammilla Collapses.</span>
6970 <span>- Contact-type infrared measurement </span><br /><span>- Forehead, ear and object temperature, three modes of measurement </span><br /><span>- Dual color LED backlit, clearly and softly display </span><br /><span>- Fever alarm function ( default alarm value is 38 Deg.C and above ) </span><br /><span>- Capacity of storing 20 sets measurement</span><br /><span>- Dual temperature units: Deg.C and Deg.F options</span><br /><span>- Automatic shut-down and power-saving</span><br /><span>- Battery: 2 x AAA battery ( not included ), DC1.5V</span>
6971 <ul><li>Mesh nebulizer, hand-held design with humanized appearance</li> <li>Automatic shut-off without medicine</li> <li>Automatic cleaning before medicine treatment</li> <li>One button operation for easy use</li> <li>Low battery indicator</li> <li>Advanced mesh technology</li> <li>Light weight</li> <li>Silent operation and effective drug delivery</li> <li>Low medication residue</li> </ul>
6972 <p>Blender with take-away bottle and containers.</p><p>• It turns already cooked ingredients into puree to quickly prepare healthy and nutritious baby food<br />• Blend liquids and fresh fruit to prepare healthy family drinks<br />• Easy to use: just place the ingredients in the containers: blend them, pour them out and serve<br />• Thanks to the practical lid with handle and spout, the upturned container becomes a travel bottle<br />• Works instantly with pulse function<br />• Equipped with safety shut off</p>
6974 <p>Electric Steam Steriliser. </p> <p>Fully Automatic </p> <p>Sterilises up To 6 Bottles Simultaneously</p>
6977 <p>The TH1001 LAICA infrared forehead thermometer detects body temperature quickly and in a non-invasive manner.<br />It is particularly suitable for measuring the temperature of small children, even while they are sleeping.<br />To detect the temperature, simply place the thermometer probe on the forehead and wait for the beep to indicate that the measurement is complete.<br />It also detects room temperature.<br />The large LCD display ensures the data is easy to read. The LAICA infrared thermometer stores up to 25 measurements.</p> <p>– Quick measuring<br />– Detects room and body temperature<br />– Large LCD display for easy reading<br />– Stores up to 25 measurements.</p>
6978 <br /><span>- High temperature warning light - red indicator light when the temperature is higher than 39 ° C </span><br /><span>- Measuring range 0 ° - 50 ° C </span><br /><span>- Battery operation 1x CR2032 (battery can not be replaced, included) - Battery life is 2-3 years, assuming everyday use </span><br /><span>- Frog shape </span><br /><span>- Product dimensions: 8.5 x 7.5 x 2 cm </span><br /><br /><span>- Auto power off after 60 minutes of inactivity </span><br /><br /><span>Handy helper before bathing a small child.</span>
6979 <p>Battery operated nasal aspirator: To remove excess mucous easily and conveniently.</p> <p>Compact size for easy storage.</p> <p>Constant aspiration for safe cleaning.</p> <p>Quickly removes mucous from your baby.</p> <p> </p> <p><strong>FEATURES: </strong></p> <p>Designed with vertical support.</p> <p>Easy to store.</p> <p>Smooth operation.</p> <p>Safe operation.</p> <p>Fast and convenient.</p> <p>Easy operation and cleaning.</p>