Gesicht

Schimmer-Gel (Booster)

Shimmering Facial Whip

Beschreibung

Durch feine Schimmerpartikel bringt dieses leichte Booster-Gel die Wangen, Lippen und Lider zum Strahlen und lässt den Teint durch die Vitamine B, C und E glatt und prall wirken, ohne einen spürbaren Film zu hinterlassen. Hautberuhigend und nicht fettend.

Anwendung

Etwas Gel auf den Finger geben und sanft auf die gewünschten Partien verteilen.

Inhaltsstoffe

Cetyl Alcohol, Propylene Glycol, Glyceryl Stearate, Mineral Oil Aqua (Water), Cetyl Alcohol, Propylene Glycol, Glyceryl Stearate, Stearate Acid, Paraffinium Liquidum (Mineral Oil), Glycerin, Carbomer, Tocopheryl Acetate, Triethanolamine, Disodium EDTA, Methylparaben, Propylparaben, Fragrance(Aroma), Diazolidinyl Urea, kann [±]Iron Oxides (CI 77491, CI 77492, CI 77499), Manganese Violet (CI 77742), Mica (CI 77019), Red No.33 Lake (CI 17200), Blue No.1 (CI 42090), Yellow No.5 Lake (CI 19140), Titanium Dioxide (CI 77491), Red No.40 Lake (CI 16035) enthalten.

Details / Duft	Inhalt	ArtNr	Preis
Pink Lemonade	9.5 g 18,84 EUR/100g	1201	1,79 EUR*
Citrus	9.5 g 18,84 EUR/100g	1202	1,79 EUR*
Persimmon	9.5 g 18,84 EUR/100g	1203	1,79 EUR*
Camilia	9.5 g 18,84 EUR/100g	1204	1,79 EUR*
Lilac Petal	9.5 g 18,84 EUR/100g	1205	1,79 EUR*
Toasted	9.5 g 18,84 EUR/100g	1206	1,79 EUR*
Golden Peach	9.5 g 18,84 EUR/100g	1207	1,79 EUR*
Spotlight	9.5 g 18,84 EUR/100g	1208	1,79 EUR*

Kunden, die diesen Artikel gekauft haben, kauften auch

Lidschatten-Pinsel,
1,79 EUR

3-in-1 Farbstift,
1,79 EUR

Lidstrich-Pinsel,
1,79 EUR

Duo-Mascara, Schwarz
1,79 EUR

Nagel-Lack, Nude
1,79 EUR

* Alle Preise inkl. MwSt., ggf. zuzüglich Zahlungs- und Versandkosten, ab 25 EUR Bestellwert in Deutschland versandkostenfrei.
ausreichend auf Lager nur noch geringe Menge auf Lager Nicht auf Lager, in ca. 2 Wochen wieder verfügbar

(default) 3 queries took 361 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `productgroup`.`anwendung`, `productgroup`.`beschreibung`, `productgroup`.`inhaltsstoffe`, `productgroup`.`name_en` FROM `productgroups` AS `productgroup` LEFT JOIN `productmaingroups` AS `Productmaingroup` ON (`productgroup`.`productmaingroup_id` = `Productmaingroup`.`id`) WHERE `productgroup`.`id` = 89 LIMIT 1	1	1	0
2	SELECT id, name_de, inhalt_g, inhalt_ml, farbe_de, farbe_en, duft, preis_ev, preis_ret, bestand, bestellt, DATE_FORMAT(created, '%d.%m.%Y') AS created, IF(DATE_ADD(Product.created, INTERVAL 30 day) > NOW(), 1, 0) AS neu FROM products As Product JOIN productgroups_products AS pp ON Product.id = pp.product_id LEFT JOIN product_open_from_orders AS ProductOpenFromOrder ON Product.id = ProductOpenFromOrder.product_id WHERE pp.productgroup_id = 89 AND Product.aktiv = 1 ORDER BY order_no, id	8	8	325
3	SELECT oi2.product_id, CONCAT(pg.name_de, ', ', IF(p.farbe_de IS NULL, farbe_en, farbe_de)) AS name_de, count(DISTINCT o.id) AS anzahl, pg.id, p.preis_ev, p.preis_ret FROM order_items AS oi JOIN orders AS o ON oi.order_id = o.id AND o.bestelldatum >= DATE_SUB(CURRENT_DATE(), INTERVAL 42 DAY) JOIN order_items AS oi2 ON o.id = oi2.order_id JOIN products AS p ON oi2.product_id = p.id AND p.aktiv = 1 AND p.bestand >= 5 JOIN productgroups_products AS pgp ON p.id = pgp.product_id JOIN productgroups AS pg ON pgp.productgroup_id = pg.id AND pg.aktiv = 1 WHERE oi.product_id IN(1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208) AND oi2.product_id NOT IN(1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5	5	5	36

(default) 3 queries took 361 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `productgroup`.`anwendung`, `productgroup`.`beschreibung`, `productgroup`.`inhaltsstoffe`, `productgroup`.`name_en` FROM `productgroups` AS `productgroup` LEFT JOIN `productmaingroups` AS `Productmaingroup` ON (`productgroup`.`productmaingroup_id` = `Productmaingroup`.`id`) WHERE `productgroup`.`id` = 89 LIMIT 1

SELECT id, name_de, inhalt_g, inhalt_ml, farbe_de, farbe_en, duft, preis_ev, preis_ret, bestand, bestellt, DATE_FORMAT(created, '%d.%m.%Y') AS created, IF(DATE_ADD(Product.created, INTERVAL 30 day) > NOW(), 1, 0) AS neu FROM products As Product JOIN productgroups_products AS pp ON Product.id = pp.product_id LEFT JOIN product_open_from_orders AS ProductOpenFromOrder ON Product.id = ProductOpenFromOrder.product_id WHERE pp.productgroup_id = 89 AND Product.aktiv = 1 ORDER BY order_no, id

325

SELECT oi2.product_id, CONCAT(pg.name_de, ', ', IF(p.farbe_de IS NULL, farbe_en, farbe_de)) AS name_de, count(DISTINCT o.id) AS anzahl, pg.id, p.preis_ev, p.preis_ret FROM order_items AS oi JOIN orders AS o ON oi.order_id = o.id AND o.bestelldatum >= DATE_SUB(CURRENT_DATE(), INTERVAL 42 DAY) JOIN order_items AS oi2 ON o.id = oi2.order_id JOIN products AS p ON oi2.product_id = p.id AND p.aktiv = 1 AND p.bestand >= 5 JOIN productgroups_products AS pgp ON p.id = pgp.product_id JOIN productgroups AS pg ON pgp.productgroup_id = pg.id AND pg.aktiv = 1 WHERE oi.product_id IN(1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208) AND oi2.product_id NOT IN(1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5