Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  cscart_product_descriptions.full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    8023, 8024, 8025, 8026, 8027, 8494, 8838, 
    8842, 8845, 9480, 10734, 11422, 12000, 
    12001, 12002, 12644, 12647, 12651, 
    12657, 13091, 13106, 13470, 13621, 
    13677
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00113

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "18.44"
    },
    "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": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.04",
        "eval_cost": "2.40",
        "prefix_cost": "18.44",
        "data_read_per_join": "109K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`cscart_db`.`cscart_product_descriptions`.`product_id` in (8023,8024,8025,8026,8027,8494,8838,8842,8845,9480,10734,11422,12000,12001,12002,12644,12647,12651,12657,13091,13106,13470,13621,13677)) and (`cscart_db`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id	short_description	full_description
8023	Get yourself the perfectly hydrated & glowing skin.	<p>Are you troubled by dull & blemish-prone skin, enlarged & clogged pores and frequent breakouts? Well, worry not - for our nutrient-rich powerhouse; multi action Sandalwood & 4-Clay Detox Mask is here! Product Benefits Enriched with sandalwood & 4 types of clay - Green , kaolin, bentonite & fuller's earth Detoxifies & gently exfoliates your skin Soothes skin irritation Absorbs excess sebum & unclogs pores Brightens & tones your skin Minimizes pores and rejuvenates the...</p>
8024	Get yourself the perfectly hydrated & glowing skin.	<p>Our Facial Ubtan is a potent formula made with a blend of 36 sun-dried & hand-pounded ingredients. Suitable for all skin types, the ubtan has been designed to uncover the natural brightness of your skin and give you a beautiful glow. It gently exfoliates away dead skin cells, dirt and grime, giving your skin a much-needed boost. This one is a versatile product - a cleanser, exfoliant and face pack all rolled into one. Mix...</p><p><br /></p><p><br /></p><p><br /></p><p><br /><strong>How to use:-</strong></p><p> Take a spoonful of the Facial Ubtan in a bowl and mix it with a hydrosol or any other ingredient (milk/curd/tomato juice/aloe vera etc.) of your choice. Apply the face pack all over your cleansed skin and wash off in 10-15 minutes. Follow up with your usual skincare routine. You can also use the Ubtan as a cleanser. Since this product contains mild preservatives, so to avoid bacterial growth kindly keep it in the refrigerator when not in use.</p>
8025	Get yourself the perfectly hydrated & glowing skin.	<p>Our Anti Tan Powder Face Mask is a versatile product prepared from a unique and ancient recipe including fennel seeds, star anise, fenugreek, saffron, lodhra, rakt chandan, vetiver & lemon peel! It immediately brightens your skin, exfoliates gently & gives you a beautiful, healthy glow. This beautiful product lets you create some fabulous DIY remedies - mix it with rosewater/aloe vera for normal skin; milk for dry skin; curd for oily skin; fresh tomato juice...<br />How to use:- Take a spoonful of the Anti Tan Powder Face Mask in a bowl and mix it with a hydrosol or any other ingredient (milk/curd/tomato juice/aloe vera etc.) of your choice. Apply the face pack all over your cleansed skin and wash off in 10-15 minutes. Follow up with your usual skincare routine. Since this product contains mild preservatives , so to avoid bacterial growth kindly keep it in refrigerator when not in use.</p>
8026	Get yourself the perfectly hydrated & glowing skin.	<p>Our Rose Blush Face Mask is the perfect product for all skin types. With willow-bark extracts (a natural BHA), rose extracts, kaolin clay & calamine as its key ingredients - this one hydrates & tones, cleanses & gently exfoliates and gives you glowing, blemish-free skin in no time at all. Start using it twice a week & let the natural blush on your face be visible to all! Product Benefits Hydrates and tones the skin...</p>
8027	Get yourself the perfectly hydrated & glowing skin.	<p>Every climate change what also changes is our skin's requirements. Maintaining balance and harmony is the essence of Mother nature, and we are blessed to have this privilege of acquiring the best benefits out of its organic treasure, in every season. Introducing our new addition to skin reviving range, Vit. C face mask, to counter the damage that occurs due to exposure to ultraviolet rays, be it summer or winter, sudden environmental changes, like going...</p>
8494	Makes skin softer, smoother & refreshed	<p>Pure hypoallergenic green tea extract gives moisture to dry skin. It adheres to skin perfectly allowing serum to be absorbed thoroughly and skin appears purer, softer, smoother & refreshed</p>
8838	Cleanses pores, exfoliates and soothes skin	<p>Teal and Terra 3-in-1 Face Mask contains Activated Charcoal that pulls out impurities, bacteria and oil from skin. Sandalwood reduces tanning and brightens skin. Rose oil hydrates, tones and helps reduce wrinkles. With Bentonite and Kaolin clay, the face mask cleanses pores, exfoliates and soothes skin.</p>
8842	Reduces active acne and lightens blemishes	<p>Teal & Terra's 3- In-1 Coffe Arabica Face Mask acts as a scrub, mask and cleanser. Made from Coffee Arabica it's exfoliates dead skin to unveil your natural glow. It de-tans and unclog pores with the help of Walnut extract, Vitamin E, Multani Mitti and Aloe Vera reduces active acne and lightens blemishes. It pulls out excess oil to tighten the skin making it look youthful and healthy.</p>
8845	Maintains the skin's natural hydration, Protects the skin from sun damage	<p>Teal and Terras Red Algae Mask is known for its anti-aging properties and unique ability to make skin firm. This reduces the appearance of wrinkles and fine lines. It maintains the skin's natural hydration level and boosts collagen production. Regular application protects the skin from sun damage. Thyme oil helps in reducing acne, by eliminating acne causing bacteria. Kaolin powder detoxifies the pores by pulling out impurities and excess oil. It also contains Natural Green Clay which is known for firming the skin and healing blemishes. Make your skin youthful and healthy after every application.</p>
9480	<p>Soothes the skin, Improves skin tone</p>	<p>Containing avocado extract helps supply moisture to dry skin, manages old dead skin cells and wastes, and provides nutrients necessary for skin activity, helping to keep the skin fresh and fresh. Containing avocado extract helps supply moisture to dry skin, manages old dead skin cells and wastes, and provides nutrients necessary for skin activity, helping to keep the skin fresh and fresh.After peeling, the active ingredients of the avocado extract supply moisture and nutrients to make the skin elastic and elastic. Helps to care for blackheads by managing sebum as well as dead skin cells damaged by external stimuli and even in pores. It is a peeling gel that helps remove old dead skin cells without pulling it with a thin gel-type texture that is not a scrub grain type that irritates the skin.</p>
10734		<p>1. Prevents & Heals Acne: Small, Circular Hydrocolloid Adhesive Patches That Heal And Conceal Acne And Calm Inflammation. These Patches Are Enriched With Tea Tree Leaf Oil Which Is An Extremely Beneficial Ingredient For Oily And Acne Prone Skin. It Helps To Soothe And Heal Damaged Skin. Suitable For Sensitive Skin, Cica Extracts In These Patches Help To Heal And Shrink Pimples.</p> <p> 2. Gently Exfoliates & Clears Pores: Clogged Pores And Excess Sebum Can Lead To Acne. This Oil Absorbing Formula Targets Acne-Causing Bacteria And Removes Impurities From The Skin. Super Star Ingredients Such As Glycolic Acid And Salicylic Acid Gently Exfoliate, Unclog Pores And Soothe Any Redness. </p> <p>3. Reduces Blemishes: Witch Hazel Extracts In These Patches Help Shrink Pores, Treat Blemishes And Prevent Acne. Further Lotus Root Extracts Hydrate Skin And Even Skin Tone. A Rich Source Of Vitamin C, It Brightens Complexion And Fades Dark Spots.</p> <p><br /></p> <p><br /></p> <p> <br /><strong>How To Use:-</strong><br /> Gently Cleanse Your Face And Make Sure It'S Dry. Find A Fitting Size Patch To Cover The Pimple. Firmly Press For 2-3 Seconds. For Better Results, Use It For 8-9 Hours Or Leave It Overnight. Remove And Replace As Needed.</p>
11422	Dead Skin Removal	<p>French clay based all natural formula in The Skin Story Re- Mineralizing Witch Hazel Face Pack absorbs excess sebum, clogged dirt, blackheads & atmospheric pollutants. Witch hazel fights acne causing bacteria and tightens skin pores leaving behind clearer and smoother skin.</p>
12000	Removes balckheads	<p>These nose strips unclogs pores, removes unwanted blackheads, whiteheads, dead skin, and oil from the nose. Made from all-natural ingredients such as charcoal, witch hazel extract, green tea extract and aloe vera. This product works on all skin types and promises deep pore cleansing and nourishment.</p>
12001	<p>Removes balckheads</p>	<p>These nose strips unclogs pores, removes unwanted blackheads, whiteheads, dead skin, and oil from the nose. Made from all-natural ingredients such as charcoal, witch hazel extract, green tea extract and aloe vera. This product works on all skin types and promises deep pore cleansing and nourishment.</p>
12002	Invisible acne pimple patches	<p>Too Invisible to Notice! these small yet mighty patches have a "0.01cm ultra-thin edge" design and a matte finish, which makes pimples look invisible under your makeup. So comfortable that you forget they exist. With medical-grade hydrocolloid texture, the Invisible patches can absorb up to 6 times more pus than its own volume and protects your pimples from infections. Just tear it off, put it on, and you're good to go in less than 5 seconds! Our patches are non-drugged, non-irritating, hypoallergenic and suitable for all skin types. This package comes with 3 sizes for all-day care. 8mm, 10mm, 12mm in total 47 patches.</p>
12644	SOS ringer amino sheet mask (Pack of 4)	<p>S.O.S ringer amino mask is a 2- STEP MASK that provides moisture and relieves sensitive skin with nourishment from amino acid and glucose. Amino acid, the smallest unit of protein, is an important nutrient that makes up our body. Unlike proteins that require a metabolic process in the body, amino acid is applied directly to the muscles to provide energy to the body faster and more effectively, helping to synthesize proteins. It provides moisture and relieves sensitive skin & delivers moisture effectively. It delivers nourishment without skin irritation.</p>
12647	<p>Provides vitality and moisture, Makes skin firm</p>	<p>Jellyfish vital mask with the essence which contains Jellyfish Extract provides vitality and moisture. The replenishing jelly essence with rich hydration makes skin firm. Tightening sheet fits your facial lines firmly and delivers nourishment of the essence. Jellyfish Extract with moisture and collagen and Artemisia Princeps Leaf Extract gives moisture and relief at once. Provides elasticity to your skin through water-filled jelly essence to improve aging, rough and weak skin. The mushy jelly essence with jellyfish extract makes your skin firm and full of energy.</p>
12651	Silky cocoon sheet mask (Pack of 4)	<p>Silky cocoons refine skin well and keep moisture deep. It can enhance the skins brightness and make skin feel more soft and comfortable. A transparent hydrating essence mask with a nourishing coating barrier holds moisture tight. White silk film method, refreshing and elastic supplement. Cocoon extract that is full of nourishment makes a coating barrier for a clear and plump-looking complexion. Triple hyaluronic acids and clear moisture effect make a hydrating layer for a water luminous skin. Synergy effect from deep hydrating essence and soft sheet for a plump-looking complexion.</p>
12657	<p>Provides deep and rich moisturization</p>	<p>The Birds Nest Moisture Mask is made with birds nest extract that fills your dry skin with powerful moisture from the surface to the roots. The mask provides moisture & energy with the power of birds' nests with concentrated essence in every sheet mask helps to reveal softly radiant skin. An intensive hydration sheet mask improves the skin's moisture barrier, the rich, silky essence saturates the skin with moisture. Birds' nest deep hydration restores healthy radiance and helps dull, tired skin get a second chance with a renewed glow.</p>
13091	For a naturally glowing skin	<p>This face pack leaves a very cooling effect and especially if your skin has been exposed to the sun for a long time. You can also use it on your body, it works wonders on the skin everywhere.You can use our completely organic product up to 1-2 times a week. Check out all the descriptions down below.</p>
13106	Intense skin hydration	<p>With our Love Earth Vitamin C Glutathione Glow Sleeping Mask, we present to you a new and healthier path to getting luminous and youthful skin. This is purely gel-based so no oily sticky feeling afterward. It has the benefits of pure vitamin C, Glutathione, roses, and aloe vera. Our mask comes in a matte cloudy texture. It is super lightweight and you wonât even know that itâs there. People with oily skin should really try it because you are going to be blown away by the results. The mask hydrates and repairs your skin while boosting collagen and elastin overnight. It also evens out the complexion and improves skin luminosity. This can be used on all skin types.</p>
13470	<p>Smoothes out fine lines & Removes dark spots</p>	<p>This miracle mask is formulated with gentle pore refining AHA - Lactic Acid, and moisture magnet Hyaluronic Acid that exfoliate and hydrate skin while you sleep. Also containing natural botanicals extracted from borage flower and fruit acids from pineapple, pumpkin & grapefruit, this luxuriously bouncy gel smoothes and perfects skin overnight along with brightening, smoothening out fine lines & removing dark spots, all while firming the skin overnight.</p>
13621	Clears pimples, soothes redness, and protects skin.	One step, easy to use pimple patch combines hydrocolloid polymer technology with tea tree oil and calendula oil to minimise breakouts overnight.Its available in 10 cute and effective shapes to choose from!
13677	Clears pimples, soothes redness, and protects skin.	One step, easy to use pimple patch combines hydrocolloid polymer technology with tea tree oil and calendula oil to minimise breakouts overnight.Its available in 10 cute and effective shapes to choose from!