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 (381767, 276870, 276871) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00088

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.21"
    },
    "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": 3,
      "rows_produced_per_join": 3,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "3.62",
        "eval_cost": "0.60",
        "prefix_cost": "4.22",
        "data_read_per_join": "20K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (381767,276870,276871)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
276870 <p><strong>Deepway® Antiaging Mask</strong></p> <ul><li>Removes wrinkles and delays the effects of aging</li><li>Made with 100% natural oils and nano clays.</li><li>It provides the mineral and oil balance that the skin needs.</li>< li>Tightens the skin and makes it look smooth</li></ul> <p><b>Detailed Information</b> </p> <ul><li>Deepway® Anti-aging clay mask is produced from volcanic clay (calcium bentonite), which naturally contains six different clay forms, and accordingly has a very rich mineral content, and unique phytotherapeutic oils known for their anti-aging properties.</ li><li>Calcium bentonite clay is formed over millions of years as a result of natural geological and biological events such as chemical weathering and alteration of mineral-rich volcanic ash, tuff and lava. Although the number of minerals in it varies, it is a substance and mineral that naturally exists in nature. It is definitely not a chemical substance or compound. On the contrary, it is a natural substance that nature offers as a cure.</li><li>Calcium bentonite's skin-repairing effect and detox feature have been used as a source of healing and beauty by humans for thousands of years, primarily animals. These effects of calcium bentonite clay are due to its mineral richness and thermal, chemical and mechanical properties. As a matter of fact, Hunza Turks living in the region where Karakoram Mountains and Hindu Kush Mountains meet in Gilgit-Baltistan province of Pakistan are known worldwide for their healthy and long life span. Researches of scientists have revealed the importance of bentonite clay regarding the secrets of healthy and long life of Hunza Turks. There are some basic criteria that should be considered in the selection of these oils. These can be summarized as not being adulterated, being cold pressed and meeting the desired quality criteria. In particular, the "cold pressed" oils to be used in the products are at the top of the important quality criteria in ensuring high quality. In this way, vegetable oils will contain high levels of antioxidants, phenolics, phosphatide, carotenoids and plant sterols, vitamins A, D, E and K. These properties of phytotherapeutic oils used in Deepway skin masks are taken into consideration, based on the reasons stated. It has been known to be used for years. It is best used as a restorative and purifying agent in naturopathy. It contains natural minerals and elements that have a very high effect on the body. With aging, our body's capacity to produce minerals decreases and the mineral level in our body naturally decreases. Our skin, which is considered the largest organ of our body, is the part that is most affected by this negative situation and the earliest. Therefore, different agents are needed to provide these minerals and elements apart from water and food. At this point, calcium bentonite clay is an important solution against this problem when applied to the skin thanks to its mineral and elemental richness. In addition, the main known effects of calcium bentonite clay can be listed as follows.</li><li>Calcium bentonite clay is an important detox agent. Calcium bentonite clay absorbs bacteria, heavy metals, and toxins on and under the skin surface and removes them from the body thanks to its negative ion charge. It is delayed.</li><li>By accelerating the blood flow in the capillaries under the skin and feeding our skin, it draws the blood to the surface and helps our skin to be fed better, thus gaining a healthy appearance, preventing and reducing wrinkles.</li><li> Bentonite clay, by bringing the body's pH level to a better balance between acidity and alkalinity, protects our skin from possible skin disorders and ensures the formation of moisture balance.</li><li>Prevents and repairs acne that occurs or may occur on the skin.</li><li> It removes dead skin from the skin. In this way, it contributes to the formation of a smooth and youthful skin.</li><li>It allows the skin to return to its normal color (toning).</li><li>It makes the skin feel more silky and clean.</li><li>Cleansing Thanks to its feature, it contributes to the formation of new cells instead of dead cells and tightens the skin.</li><li>As it is a natural substance, it does not have any side effects. In addition, there is no harm in taking it orally as a food supplement. As a matter of fact, it is coded with the code E558 in the list of food additives and has no known side effects.</li><li>Calcium bentonite clay has a remarkable rejuvenating, relaxing, germ-busting, edema-relieving and pain-reducing effect.</li><li>An allergic effect of calcium bentonite clay has not been observed. Mud application should not be applied to acute inflammations, bleeding organ disorders, tuberculosis, tumors, chronic infections and varicose veins.</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>When your skin is dry and clean, apply it on your face as a thin layer with the help of hand or brush. Let it dry for 15-20 minutes. While waiting for it to dry, avoid movements such as laughing and talking that will definitely activate your facial muscles. Clean by washing with lukewarm water. You can use it twice a week depending on the skin's needs. Since it has a moisturizing feature, you may not feel the need for a moisturizer for a while. </p> <p><b>Content</b> </p> <ul><li>Bentonite Clay</li><li>Aloa Vera</li><li>Vitamin E</li><li>Almond Oil</li><li>Jojoba Oil</li><li >Argan Oil</li><li>Grape Seed Oil</li><li>Herbal Preservative</li></ul> <p><b>Features</b> </p> <ul><li>Providing the necessary minerals for our skin</li><li>Fighting premature aging and wrinkles,</li><li>Eczema, acne, acne etc. It is aimed to eliminate skin disorders,</li><li>It is aimed to make our skin look tighter, smoother and brighter.</li><li>It is suitable for all skin types</li></ul> <p><br /></p>
276871 <p></p> <p><strong>Deepway Face Masks</strong> </p> <ul><li>Produced for Normal", "Dry and Sensitive", "Oily and Acne" skin types.</li><li>Made with 100% natural oils and nano clays.</li><li>Acne They are also very successful in healing acne, black spots, sun spots, burns and scars.</li><li>Tightens the skin and makes it look smooth.</li></ul> <p><b>Detailed Information</b> </p> <ul><li>Deepway® Clay Mask is produced from volcanic clay (calcium bentonite) and unique phytotherapeutic oils, which naturally contain six different clay forms and accordingly have very rich mineral content.</li><li>Calcium bentonite clay It is formed over millions of years as a result of natural geological and biological events such as chemical weathering and alteration of mineral-rich volcanic ash, tuff and lava. Although the number of minerals in it varies, it is a substance and mineral that naturally exists in nature. It is definitely not a chemical substance or compound. On the contrary, it is a natural substance that nature offers as a cure. Calcium bentonite clay has been used as a source of healing and beauty for thousands of years by humans, primarily animals, for its skin-repairing effect and detox feature. These effects of calcium bentonite clay are due to its mineral richness, thermal, chemical and mechanical properties. . There are some basic criteria that should be considered in the selection of these oils. These can be summarized as not being adulterated, being cold pressed and meeting the desired quality criteria. In particular, the "cold pressed" oils to be used in the products are at the top of the important quality criteria in ensuring high quality. In this way, vegetable oils will contain high levels of antioxidants, phenolics, phosphatide, carotenoids and plant sterols, vitamins A, D, E and K. Based on the stated reasons, these properties of the phytotherapeutic oils used in Deepway skin masks are taken into consideration. The properties of the oils and vitamins used in skin masks are explained below.</li><li>It is known that the high rate (95-97%) calcium bentonite clay, which is the main content of Deepway® clay masks and in the products, has been used for thousands of years both in beauty and medical issues. It is best used as a restorative and purifying agent in naturopathy. It contains natural minerals and elements that have a very high effect on the body. With aging, our body's capacity to produce minerals decreases and the mineral level in our body naturally decreases. Our skin, which is considered the largest organ of our body, is the part that is most affected by this negative situation and the earliest. Therefore, different agents are needed to provide these minerals and elements apart from water and food. At this point, calcium bentonite clay is an important solution against this problem when applied to the skin thanks to its mineral and elemental richness. In addition, the main known effects of calcium bentonite clay can be listed as follows.</li><li>Calcium bentonite clay is an important detox agent. Calcium bentonite clay absorbs bacteria, heavy metals, and toxins on and under the skin surface and removes them from the body thanks to its negative ion charge. /li><li>Clay, when applied to the skin as a mud, can help calm skin infections and speed up the healing time of wounds or eczema, even when prescription antibiotics don't help solve the problem, thanks to its antibiotic treatment capabilities.</li><li> and by accelerating the blood flow in the capillaries that feed our skin, it draws the blood to the surface and helps our skin to be fed better and thus to gain a healthy appearance.</li><li>Bentonite clay brings the body's pH level to a better balance between acidity and alkalinity.< /li><li>The effects of hormonal balance positively affect immunity on the surfaces it is applied to.</li><li>Skin It prevents and repairs acne that occurs or may occur on the skin.</li><li>It removes the dead skin from the skin. In this way, it contributes to the formation of a smooth and youthful skin.</li><li>Returns the normal color of the skin (toning).</li><li>Makes the skin feel more silky and clean.</li><li>Cleansing Thanks to its feature, it contributes to the formation of new cells instead of dead cells and tightens the skin.</li><li>As it is a natural substance, it does not have any side effects. In addition, there is no harm in taking it orally as a food supplement. As a matter of fact, it is coded with the code E558 in the list of food additives and has no known side effects.</li><li>Calcium bentonite clay has a remarkable regenerative, relaxing, germ-busting, edema-reducing and pain-reducing effect.</li><li>An allergic effect of calcium bentonite clay has not been observed. Mud application should not be applied to acute inflammations, bleeding organ disorders, tuberculosis, tumors, chronic infections and varicose veins on the feet.</li><li>Deepway® clay mask is not a new form of beauty care, but its value has only been recognized in our country in recent years. This healing clay has recently become an important market in our country as a reliable product that can be added to any detoxification program in the USA and Europe. The fact that the calcium bentonite clay, which we use as the basic raw material of our products, is one of the best clays in the world within the smectite clay group, distinguishes our products from the products of other brands.</li><li>It should not be used in areas with open wounds and on sensitive skin. It is not medicine. For external use. It should be kept out of reach of children.</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>Using Deepway® Face Masks</b></p> <p>It is applied to clean and dry skin as a thin layer with the help of hand or brush (for a much better result, the skin can be steamed before the application). It is kept for approximately 12-15 minutes to dry to a large extent (60% of the face). Dry and sensitive skin should be kept for 8-10 minutes by providing less drying. Afterwards, it should be cleaned by washing with warm water. It can be used 1-2 times a week according to the needs of the skin. After the application, factors such as cold and wind should be avoided. </p> <p><b>Content of Deepway® Face Masks</b></p> <p>Calcium bentonite clay, phytotherapeutic oils and preservatives </p> <p><b><i>Aloe Vera:</i></b> Based on research results, Aloe Vera extract is known to moisturize and soothe the skin, and maintain sebum balance. It has been shown to have positive effects on skin problems such as redness, crusting and acne. Aloe Vera extract helps our skin to maintain its moisture balance, flexible structure and density thanks to the antioxidants, beta carotene and vitamins it contains. It prevents the formation of scars that may appear as cracks (marks) that may occur due to obesity and pregnancy, and provides a significant reduction in the formed scars. </p> <p><b><u>Lavender Oil:</u></b> It is an antioxidant that protects our skin from negative environmental factors. It reduces the fine lines and wrinkles on our skin caused by external factors, thanks to its antioxidant properties. It has the feature of providing skin disinfection, preventing acne and increasing blood circulation. In addition, thanks to its anti-fungal and anti-inflammatory effects, it provides relaxation to the skin. Again, due to its antibacterial properties and anti-inflammatory effects, it has the ability to prevent and heal acne. It does this thanks to beta-caryophyllene, which is a natural anti-inflammatory in its drink. </p> <p><b><u>Lemon Oil: </u></b>It is very effective against acne and acne on our skin. In addition, when used regularly, it stops the formation of acne and pimples. It is a good cleanser and can also be used as a facial cleansing agent. It removes the dead skin from the skin, which is formed in the upper layer of our skin and prevents our skin from breathing. It is very effective against blemishes on the skin. It is also stated to be effective against sun-induced spots. It is also stated that when used regularly in darkening areas such as the armpits, it causes darkening. In addition, thanks to its blood circulation-enhancing feature, it helps the skin to be fed naturally and to disperse cellulite. </p> <p><b><u>Bıttım Oil:</u></b> It is highly effective against skin disorders such as eczema, psoriasis, fungus, acne, allergies, itching, flaking, and redness that occur in our body, thanks to its antiseptic and microbicide properties. . It ensures that various pathogens that are on our skin and harmful are removed from our skin. It is rich in vitamin E. It contributes to the formation of moisture and oil balance in the skin. By showing a peeling effect on the skin, it opens the pores and allows our skin to breathe better. It is especially effective in removing stretch marks that occur after pregnancy. It helps to remove scars on our skin. </p> <p><b><u>Vitamin E: </u></b>Vitamin E oil, which is a strong source of antioxidants, has many positive contributions to our physical health. Vitamin E oil primarily shows anti-aging properties and helps to reduce and delay the signs of aging. It neutralizes the effects of external factors on the skin that cause aging and wrinkling. It contributes to the elimination of cell damage due to cell oxidation. Support the body's collagen productionIt contributes to the preservation of the elasticity structure of the skin. It contributes to the development of new skin cells formed. It prevents the spread of damage to the skin. By expanding the capillaries, it contributes to the acceleration of blood circulation. It is very effective in removing scars and stretch marks. Contributes to the removal of brown spots on the skin. Provides hydration for damaged and dry skin. It is stated to be effective against inflammation. It contributes to reducing the effects of eczema and psoriasis type diseases. It makes the skin brighter and illuminates. It strengthens the skin barrier. </p> <p><b><u>Almond Oil:</u></b> It is a natural oil that is frequently used in pharmacy and is used to eliminate many skin problems. Content; It is very rich in vitamin E, calcium, phosphorus, selenium, copper, zinc, iron, magnesium. Almond oil helps our skin to be moisturized and renewed and to gain a lively and bright appearance. It provides very good moisturizing thanks to the rich vitamins, minerals and natural acid regulators in its content. Again, thanks to its rich content, it contributes to the formation of the oil and mineral balance that our skin needs. It helps the skin to repair itself against cracks, flaking, itching, redness and various sensitivities on the skin. It contributes to the regeneration of the skin. However, almond oil stands out with its anti-aging properties. Almond oil is a very good moisturizing agent and restorative. Therefore, it contributes to the repair and renewal of our skin itself. In this way, our skin will regain a youthful appearance by renewing itself and the formation of wrinkles will be prevented. </p> <p><b><u>Jojoba Oil: </u></b>Has valuable essential fatty acids for skin health. In this respect, it is an excellent anti-wrinkle. It contributes to the regeneration of skin elasticity by positively affecting the production of collagen. Thanks to its content of vitamins A and E and strong fatty acids, it helps to prevent and reduce wrinkles. In this way, it contributes to the youthful appearance of the skin. It is a good moisturizer and helps nourish the skin by preventing moisture loss from the skin. Thanks to its antibacterial feature, it prevents the formation of bacteria and fungi. It prevents the formation of acne and acne and helps to remove it. It is very similar to our skin's own oil. In this way, it is suitable for many skin types. It helps prevent cracks. </p> <p><b><u>Argan Oil:</u></b> It has an important area of ​​use in the fields of health and cosmetics. Thanks to the vitamins in its content, it strengthens the skin barrier and contributes to the tightening of the skin. Thanks to the vitamin E in its content, it provides the moisture that our skin needs and accordingly contributes to a more vibrant and healthy appearance of our skin. Vitamin E, which also comes together with its antioxidant properties, supports and accelerates the formation of new cells in the skin. The fatty acids in it help maintain and strengthen skin elasticity. Based on these effects, it creates a protective effect against wrinkles and eliminates the signs of premature aging. It acts as a highly effective moisturizer for the skin. Contributes to the removal of acne and acne. It helps to remove stretch marks after weight loss and pregnancy. In addition, it is effective in preventing and removing the damage caused by harmful sun rays on the skin. </p> <p><b><u>Grape Seed Oil:</u></b> Grape seed oil contains a high amount of the lipid component necessary for the cell membrane. Grape seed oil, which is very rich in beta-carotene and vitamins D, C, E; It also has essential fatty acids such as stearic, palmitic and linoleic acid. These fatty acids are known for their anti-wrinkle properties, making grapeseed oil an excellent cosmetic ingredient used to control skin moisture. In addition, grape seed oil can be used as a supplement for acne treatment due to its antimicrobial properties. This oil acts on your skin by attacking bacteria that can get into your pores and cause acne. Grape seed oil can make the skin softer and supple. It contains a powerful antioxidant component called proanthocyanidin. This antioxidant evens out skin tone when used continuously on the skin. Another benefit of the powerful antioxidants in grape seed oil is that it protects the skin from damage by UV rays. It helps to repair and strengthen damaged capillaries and blood vessels. It has skin moisturizing and tightening properties. It has antiseptic properties on the skin. Based on these properties, it repairs the skin. The linoleic acid in its content is effective against acne and pimples and skin inflammation. It is good for bruises and eye circles under the eyes. It shows anti-aging properties. It prevents pores from clogging. It nourishes and repairs the skin. indicate agingslows down.</p> <p></p> <p><b>Features of Deepway® Face Masks</b> </p> <ul><li>Providing the necessary minerals for our skin,</li><li>Fighting premature aging and wrinkles,</li><li>Eczema, acne, acne etc. </li></ul>
381767 <p>Aloe Vera Krem Mbrojtës me Propolis - kujdes i pasur, qetësues dhe hidratues për lëkurën e thatë dhe të lodhur. Ky krem i pasur me 79% Aloe Vera dhe ekstrakt dylli bletësh është veçanërisht i përshtatshëm për lëkurën e thatë. Ai forcon lëkurën dhe vendos një film mbrojtës. Ekstrakti i propolisit me funksionin e tij të izolimit të nxehtësisë dhe efektin hidratues të Aloe Vera-s, i japin një ndjesi të shëndetshme dhe të relaksuar lëkurës. Kujdesi i veçantë i LR ALOE VIA është veçanërisht i dobishëm dhe rigjenerues me lëkurën e lodhur dhe te acaruar. Produktet vendosen si një film mbrojtës në lëkurën e lodhur, e freskojnë, e zbutin dhe nxtin rigjenerimin<br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p>