Sandbox

SELECT 
  product_id, 
  short_description, 
  full_description 
FROM 
  q_product_descriptions 
WHERE 
  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 lang_code = 'en'

Query time 0.00068

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		<ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Issey Miyake</span></li><li><span class="a-list-item">Fragrance Type : Eau de Toilette</span></li><li><span class="a-list-item">Size : 50ml</span></li><li><span class="a-list-item">Targeted Group : Women</span></li><li><span class="a-list-item">Fragrance Family : Fresh</span></li><li><span class="a-list-item">Perfume Name : L'Eau D'Issey 50 ml</span></li></ul>
116		<p>Nuit d'Issey Bleu Astral comes out in February 2017 as a new edition of the Issey Miyake masculine L'Eau d'Issey Pour Homme line, namely its Nuit d'Issey subcollection. The new Nuit d'Issey Bleu Astral is announced as a romantic scent evoking the dark blue starry night sky. Inspired by the night and scents of nature, Nuit d'Issey Bleu Astral offers a "new olfactory journey" with aromas of lime, Russian coriander, skin and amber wood.</p>
117		<p>Nuit d'Issey Bleu Astral comes out in February 2017 as a new edition of the Issey Miyake masculine L'Eau d'Issey Pour Homme line, namely its Nuit d'Issey subcollection. The new Nuit d'Issey Bleu Astral is announced as a romantic scent evoking the dark blue starry night sky. Inspired by the night and scents of nature, Nuit d'Issey Bleu Astral offers a "new olfactory journey" with aromas of lime, Russian coriander, skin and amber wood.</p>
118		<p>Issey Miyake presented Nuit d'Issey Eau de Toilette for men in 2014, as a flanker of L'Eau d'Issey Pour Homme fragrance from 1994. In October 2015, Nuit d'Issey Parfum, the enhanced and more intensive version, is launched. A magnetic, mysterious, and vivid composition that evokes a dark night opens with accords of grapefruit and pink pepper. Leather and vanilla in the heart give an elegant touch to the composition. The rich and textured base consists of tonka bean absolute and patchouli.</p>
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		<p>L'Eau d'Issey Pour Homme Summer 2017 by Issey Miyake is a Aromatic Spicy fragrance for men. This is a new fragrance. L'Eau d'Issey Pour Homme Summer 2017 was launched in 2017. The nose behind this fragrance is Alberto Morillas. Top notes are coriander, grapefruit and kiwi; middle notes are pineapple and nutmeg; base notes are vetiver and cypress.</p>
121		<p>Intense is an edition introduced in 2007 in woody composition, designed by Jacques Cavallier. Top notes bring sweet and fresh waves of tangerine, bergamot, yuzu and orange. Heart notes create rhythm of blue lotus, camphor, cardamom, cinnamon and saffron, together with nutmeg, while base notes finish the composition with accords of incense, amber, benzoin, papyrus and grey amber. It available as 75 and 125 ml edt. Two editions in new flacons but with the same compositions were introduced in 2009 - L'Eau d'Issey Pour Homme and L'Eau d'Issey Pour Homme Intense. Colours of the flacons - light grey and dark grey colour of asphalt make an impression of a union of water and concrete.</p>
122		<p>At the beginning of 2018, the new flanker launches, called L'Eau d'Issey Pure Nectar de Parfum, which represents a bottled drop of blossoming flower nectar. L'Eau d'Issey Pure Nectar de Parfum is developed by perfumers Fanny Bal and Dominique Ropion as a floral-woody scent. The Nectar edition represents "the ultimate stage in the metamorphosis of water, from sea to dew and from dew to rose." The composition begins with a sweet pear accord. Rose absolute forms the floral heart of the perfume, described as honeyed. The base contains sandalwood, ambergris and signature cashmeran.</p>
123		<p>The new masculine scent from Issey Miyake, which comes out late in the late summer of 2018, is called L'Eau Super Majeure d'Issey, a new version of the L'Eau Majeure d'Issey edition from 2017. The compositions are signed by perfumers Aurélien Guichard and Fabrice Pellegrin. Top notes: citruses, clary sage, rosemary Heart: dark patchouli, cashmerean, woods, marine notes, black salt Base: tonka, Madagascar vanilla, leather, amber wood</p>
124		<p>Nuit DIssey Noir Argent by Issey Miyake is a Woody Spicy fragrance for men. This is a new fragrance. Nuit DIssey Noir Argent was launched in 2018. The nose behind this fragrance is Dominique Ropion. Top notes are grapefruit, pink pepper, black pepper and nutmeg; middle notes are leather, saffron and olibanum; base notes are patchouli, labdanum, myrrh and vetiver.</p>
125		<p>Issey Miyake launches a new fragrance for men in March 2012. That will be a new version of the popular men's edition L'Eau d'Issey Pour Homme from 1994. Name of the new fragrance is L'Eau d'Issey Pour Homme Sport and is created as an energetic, unconventional edition ideal for everyday use. L'Eau d'Issey Pour Homme Sport offers a luminous opening full of sparkling citruses and energy. Bergamot and grapefruit provide a strong and dynamic beginning in the opening notes. A heart of the composition offers spicy shades of nutmeg combined with leather, while a base features elegant woody accords of cedar and vetiver.</p>
126		<p>LEau dIssey Pour Homme Sport Mint by Issey Miyake is a Citrus Aromatic fragrance for men. LEau dIssey Pour Homme Sport Mint was launched in 2014. The nose behind this fragrance is Alberto Morillas. Top notes are pink grapefruit and bergamot; middle notes are mint and geranium; base notes are vetiver and white woods.</p>
127		<ul><li>Set Includes EDT 100 ml, Deo Stick 75 gm</li><li>Notes Verbena, Tangerine, Yuzu Zest, Clary Sage, </li><li>Geranium Bourbon, Blue Water Lily, Nutmeg, Saffron, Cinammon Bark, Amber Tobacco, Vetiver, Sandalwood, Musk</li></ul>
128		<ul><li>Issey Miyake Classic Nuit For Men Edt 125Ml+40Ml Set</li><li class="jsx-1889249662">The neutral-shaded bottle adds a dash of charm</li><li class="jsx-1889249662">The fragrance is developed by Dominique ropion and loc dong</li></ul><p><br /></p>
129		<p>Issey Miyake L'Eau Majeure For Men Edt 100Ml+Edt 20Ml+75Ml Sg Set</p>
130		<ul><li> Department Men</li><li>Size (1 EDT 125 ml, 1 After Shave Balm 50ml, 1 Shower Gel 75 ml)</li><li>Notes Bergamot, Grapefruit, Leather Accords, Spices, Black Pepper, Woods, Vetiver, Dark Woods, Patchouli, Incense And Tonka Bean</li><li>Dispenser Type Splash</li><li>Aromatherapy Type Body</li></ul>
131		<p>Issey Miyake Nuit D'Issey For Men Edt 125Ml+75Ml Sg+Toiletry Bag Set</p>