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 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    415311, 415232, 185461, 185460, 415213, 
    185457, 185459, 185462, 185458, 276865
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00097

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "14.03"
    },
    "table": {
      "table_name": "cscart_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": 10,
      "rows_produced_per_join": 10,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "12.03",
        "eval_cost": "2.00",
        "prefix_cost": "14.03",
        "data_read_per_join": "68K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (415311,415232,185461,185460,415213,185457,185459,185462,185458,276865)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
185457 Eci Barber Series Ultra Strong Hair Sprey 400 Ml
185458 Eci Barber Series 3 in 1 Shaveing Gel 700 Ml
185459 Eci Barber Series After Shave Cream Cologne White Pearl 400 Ml
185460 Eci Barber Series Extra Strong Hair Gel 400 Ml
185461 Eci Barber Series Matte Hold Hair Wax 150 Ml
185462 Eci Barber Series Mega Hold Hair Wax 150 Ml
276865 <p><strong>Deepway Clay Shampoo</strong></p> <ul><li> It is effective against eczema and acne on the scalp. </li><li> It significantly stops hair loss and prevents the formation of dandruff. </li><li> It makes your hair soft and comfortable to comb. </li><li> Nourishes and volumizes your hair </li><li> Relieves electrification in hair. </li><li> Constructed from herbal preservatives and natural plant oils </li><li> Contains no paraben and food coloring </li></ul> <p><b>Detailed Information</b></p> <ul><li>Deepway Clay Shampoo is a shampoo specially formulated in Deepway R&D laboratories with its unique combination of calcium bentonite clay, vitamins, phytotherapeutic oils and flower essences. </li><li>Deepway® Shampoo has been developed for those who have eczema, psoriasis, acne on the scalp, itching and rash on the scalp, dandruff, hair loss, electrification in the hair, lack of volume and those who want to have stronger and more resistant hair. </li><li>The homogeneous mixture of calcium bentonite clay, phytotherapeutic oils and polyphenols is perfectly provided in Deepway ® Shampoo. </li><li>It has been developed for those who want to have stronger and more resistant hair. </li><li> While calcium bentonite clay minerals in nano size, minerals naturally found in phytotherapeutic oils and active ingredients nourish the hair, at the same time, it helps the hair to be fed naturally by stimulating the capillaries at the bottom of the hair. In this way, it makes the hair more lively, shiny, voluminous and soft. It gives a much healthier appearance to the hair and scalp. </li><li>Deepway ® shampoo, in addition to its positive features, is extremely simple and effortless to use when compared to other hair care methods and shampoos. </li><li>The effects of Deepway ® shampoo inhibit enzymes that cause eczema, psoriasis, dandruff, itching, crusting, acne and hair loss with the calcium bentonite clay in its content. Thanks to this effect, while minimizing the negativities in the scalp, on the other hand, it prevents the hormonal activities that cause the hair follicles to become lifeless. </li><li>It nourishes the capillary blood vessels in the scalp. Thus, it prevents hair loss. It thickens and strengthens the hair strands. With regular and continuous use, it helps to revitalize undead hair follicles. It prevents hair loss with continuous and regular use. </li><li>It revitalizes the weakened hair follicles and gives the hair resistance, fullness, shine and vitality. It reduces dandruff and prevents its recurrence. </li><li>By regulating the melanin cells that give the hair its color, it ensures that the hair maintains its original color. In this way, it prevents premature whitening. </li><li>The 100% natural black garlic oil contained in Deepway ® shampoo nourishes and strengthens the hair follicles. It helps to stop shedding. It repairs hair splits and nourishes hair. It thickens the hair strands. It supports you to get full and voluminous hair. </li><li>As Deepway ® shampoo contains 100% natural almond oil and minerals such as vitamins, zinc, magnesium, calcium; minimizes hair loss. It allows the hair to be repaired. The lively and bright appearance gains a natural softness. Thanks to its feature of cleaning dead cells, it helps you get rid of the problem of dandruff. </li></ul> <p><b>How Can I Buy The Product</b></p> <p>The product is currently only sold on Trendyol. Click the link below to buy </p> <p><b>Use</b></p> <p>Two washes are recommended for a normal shower. The amount that is used normally and you think is sufficient for your hair is applied to the previously wet hair. The foaming shampoo is applied to the scalp by massaging. After waiting for 2-3 minutes, the hair is rinsed with plenty of water. </p> <p></p> <p><b>Features</b></p> <p></p> <ul><li>Rinses easily. </li><li>Provides voluminous and straight-forward hair after washing </li><li>Leaves a pleasant scent composed of natural flower essences on your hair. </li><li>There is no poisoning or toxic effect as it is made up of natural substances at a high rate. </li><li>Creates a creamy texture on the hair. It provides easy combing of hair without using conditioner. </li></ul> <p><br /></p> <p><b>Content</b></p> <ul><li>Calcium Bentonite Clay </li><li>100% Natural Black Garlic Oil </li><li>100% Natural Almond Oil </li><li>Glycerin </li><li>Surface actives with high cleaning properties </li><li>Provitamin B5 </li><li>Conditioner materials </li><li>Herbal preservatives </li><li>No colorants are used in its content. Natural clay color </li></ul> <p><br /></p>
415213 <p>Hair dryer Nova N-6130, 1800 W, black. It is essential to always keep the hair dry, after every shower, the hair dryer has always been an indispensable accessory, especially for women. Today, the hair dryer is a necessity, both for women and for men.<br /></p> <p>Thanks to its innovative design, with a simple connection to the 220V outlet and the push of a button, in just a few moments, your hair will be completely dry, all thanks to its very high power that reaches up to 1800 W.</p> <p>Specifications:<br />Two speeds;<br />Three temperature levels;<br />Overheating protection;<br />Power: 1800 W;<br />Power source 220-240 V;<br />Color: Black.</p> <p></p>
415232 <p>Hair and Beard Straightening Plate</p> <p>MODERN TECHNOLOGY<br />WITH THE HELP OF THIS MINI PLATES FOR HAIR AND BEARD, YOU CAN STYLE YOUR LOOK, YOU CAN GIVE VOLUME TO YOUR HAIR OR STRAIGHTEN YOUR BEARD.<br /> <br />THIS PLATE IS RECOMMENDED FOR ANY TYPE OF HAIR.</p> <p>THE PLATE HEATS UP QUICKLY (AROUND 15 SECONDS) AND HAS A COMB-TYPE BRUSH THAT YOU CAN USE TO STRAIGHTEN YOUR BEARD OR HAIR, FOR EFFECTIVE STYLING.</p> <p>DUE TO THE POWER OF NEGATIVE IONS, IRON MOISTURIZES AND SMOOTHENS THE BEARD, PREVENTS HEAT DAMAGE AND ENSURES THEIR HEALTHY AND SHINY APPEARANCE.</p> <p>THE HAIR OF THE COMB PROTECTS THE FACE AND HEAD SKIN FROM OVERHEATING, THE NEGATIVE IONS ENSURE A UNIFORM DISTRIBUTION AND PREVENT HAIR DAMAGE.</p> <p>THE IRON IS SUITABLE FOR MOST HAIR…</p><p></p>
415311 <p>DEVICE FOR BRAIDING HAIR, SECRET TWIST</p> <p>: Hair braiding device, Twist Secret<br />With the Twist Secret hair braiding device, you can create thick braids, tangled fancy threads, loose strands, luxurious braids, hair in a retro style, and many others limited only by your imagination.<br />This device has an innovative hair braiding system, for a precise styling, with an ergonomic shape that allows the quick and easy creation of the dream hairstyle you want, so you can create types of hairstyles such as: Romantic, Natural Hippie Chic , Chic headbands or any other style you want<br />With the help of the creative kit with 30 accessories available, you can create a fashionable hairstyle in just 3 simple steps.<br />Divide the hair into thin or thick pigtails, according to your preferences, put them in the pink Twister pins of the Twist Secret device and turn on the device to form them according to the style you have chosen. Specifications:<br />modern and ergonomic design<br />battery operation mode: 2 x AA<br />Hair accessories are NOT included.</p><p></p>