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 (
    115, 116, 117, 118, 119, 120, 121, 122, 
    123, 124, 125, 126, 127, 128, 129, 130, 
    131, 62, 63, 64, 65, 66, 67, 68, 69, 70, 
    71, 72, 73, 74
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00072

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "72.01"
    },
    "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": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,62,63,64,65,66,67,68,69,70,71,72,73,74)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "66.01",
        "eval_cost": "6.00",
        "prefix_cost": "72.01",
        "data_read_per_join": "114K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
62 <ul><li>Introducing Silk & Jasmine, one of five exclusive new fragrances from BOSS The Collection for men. A scent of unspeakable luxury, it is inspired by the fine quality of BOSS tailoring and a world where fabric and scent are fused. To capture the sheer opulence of silk, jasmine, a bloom favored in the royal Chinese gardens for many dynasties, was chosen as the signature note. The fragrance is balanced with accords of clove and honey at the heart and a smooth vanilla base, creating a truly opulent scent.</li></ul>
63 <p>BOSS Bottled Intense' reveals the strength of character that is masculinity. The fragrance is an exquisite composition of wood tones, spices and a powerful concentration of precious oils. For men who redefine the meaning of success. As sensitive as it is self-assured: The tangy and vibrant top notes of citrus fruits combine with the sweetness of cinnamon and an emphatically masculine base of sandalwood and vetiver. Luxurious, and unapologetically masculine.</p>
64 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Launched by the design house of hugo boss</span></li><li><span class="a-list-item">This woody spicy fragrance has a blend of plum, apple, bergamot, geranium, cloves, cinnamon, mahogany, sandalwood, olive wood, vanilla, vetiver, and cedar</span></li><li><span class="a-list-item">Suitable for sensitive skin</span></li></ul>
65 <p>A generous 200ml bottle of BOSS Bottled Night eau de toilette. Destined to become the secret weapon in the BOSS mans armoury of seduction, BOSS Bottled Night instills in him the same compelling presence that underpins his success by day. A unique composition of elegance and seduction, the scent is intense and spicy with a purposeful, edgy, masculine character. Woods are essential to the fragrance: BOSS Bottled Night introduces a scent replica of a rich and exotic new wood, Louro Amarelo. Dab it at pulse points in the evening for a distinctive and lasting allure.</p>
66 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Eau de Parfum</span></li><li><span class="a-list-item">Size : 100ML</span></li><li><span class="a-list-item">Top Notes : crisp apple and various citruses</span></li><li><span class="a-list-item">Middle notes: labdanum, potent clove, spicy saffron and cinnamon</span></li><li><span class="a-list-item">Base notes : cypriol oil, oud and sandalwood</span></li></ul>
67 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand: Hugo Boss</span></li><li><span class="a-list-item">Fragrance Type: Eau de Toilette</span></li><li><span class="a-list-item">Size: 200ml</span></li><li><span class="a-list-item">Targeted Group: Men</span></li><li><span class="a-list-item">Fragrance Family: Woody & Musky</span></li><li><span class="a-list-item">Perfume Name: Boss Bottled Unlimited</span></li><li><span class="a-list-item">Country of origin: UAE</span></li></ul>
68 <p>Introducing Cashmere & Patchouli, one of five exclusive new fragrances from BOSS The Collection for men. A modern scent with vintage sensibilities, it is inspired by the fine quality of BOSS tailoring and a world where fabric and scent are fused. The fragrance opens with a delicate and airy accord of leafy patchouli and is highlighted by the soft and delicate base notes. Like the finest cashmere, this scent is warm and embracing for a distinctive and earthy effect.</p>
69 <p>HUGO Dark Blue coolness meets passion in this unique, provocative fragrance. The flacon, in the shape of a cocktail shaker, represents the perfect blend of cool, tangy lime and pink grapefruit top notes with spicy heart notes and a resin base with accords of suede and tobacco.</p>
70 <p>A 50ml bottle of HUGO Deep Red eau de parfum. HUGO Deep Red is for women who revel in the night. They feel free to express their passion and sensuality. Explore the darker side of HUGO and add this warm, intoxicating scent to your collection.</p>
71 <p>A 60ml bottle of HUGO Man Extreme eau de parfum. Created for the HUGO man who lives life by his own terms, HUGO Man Extreme gains its individual scent from a blend of lavender, sage and geranium, combined with aromatic cedar wood and fir resin for an unmistakably masculine character. Bring a dose of HUGO attitude to your fragrance collection with this original scent.</p>
72 <p>A 30ml bottle of HUGO Woman Extreme eau de parfum. This women's fragrance from HUGO is both energising and graciously feminine at the same time. It is a blend of refreshing black tea and a bouquet of delicate flowers, while the irresistibly fruity scent of boysenberries and a hint of red Himalayan grasses guarantees an adventurous spirit. This confident fragrance suits the modern, self-determined HUGO woman perfectly with its many facets. Spritz on pulse points at the beginning of the day for an enticing scent that lasts.</p>
73 <p>A 75ml bottle of HUGO Woman Extreme eau de parfum. This women's fragrance from HUGO is both energising and graciously feminine at the same time. It is a blend of refreshing black tea and a bouquet of delicate flowers, while the irresistibly fruity scent of boysenberries and a hint of red Himalayan grasses guarantees an adventurous spirit. This confident fragrance suits the modern, self-determined HUGO woman perfectly with its many facets. Spritz on pulse points at the beginning of the day for an enticing scent that lasts.</p>
74 <p>A 30ml bottle of Femme by BOSS eau de parfum. An enticing experience and the most liberatingly feminine fragrance from BOSS, Femme by BOSS is harmony in a bottle; a scent metaphor for modern femininity. Projected by the fruity top notes of tangerine and blackcurrant, the fragrance is grounded in a creamy, musk-like base. This works with the white floral trio of stephanotis, rose and oriental lily to leave behind just a subtle, warm aura of the scent. Treat your collection to this compact bottle for feminine fragrance on the go.</p>
115
116
117
118
119 <p>L'Eau d'Issey Pure Eau de Toilette by Issey Miyake is a Floral Aquatic fragrance for women. L'Eau d'Issey Pure Eau de Toilette was launched in 2016. Top note is sea notes; middle notes are orange blossom, jasmine, lily and damask rose; base notes are cashmere wood and ambergris.</p>
120
121
122
123
124
125
126
127
128
129
130
131