Studio

Contouring Rouge & Bronzer Puder

Contouring Blush & Bronzing Powder

Beschreibung

Für einen gesunden und natürlichen Look - das ganze Jahr über!
Farbe für Wange und Gesicht mit intrigiertem Bronzer.
Mit der Rouge-Seite einfach Farbe auf die Wangen geben.
Mit der Bronzer-Seite können Sie das Gesicht konturieren.

Inhaltsstoffe

Talc, Mica, Magnesium Stearate, Ethylhexyl Methoxycinnamate, Paraffinium Liquidum (Mineral Oil), Hydrogenated Polyisobutene, Sodium Dehydroacetate, Iron Oxides (CI 77491 CI 77492 CI 77499), Titanium Dioxide (CI 77981), Red No.40 Lake (CI 16035), Ultramarine Blue (CI 77007).

Bild	Ausführung	Details / Duft	Inhalt	ArtNr	L	Anzahl	Preis	Warenkorb
		blushed/bronzed	4 g 112,25 EUR/100g	83601			4,49 EUR*

Kunden, die diesen Artikel gekauft haben, kauften auch

Lidschatten-Pinsel,
1,79 EUR

Kaschierungs-Pinsel,
1,79 EUR

Schimmer-Gel (Booster), Spotlight
1,79 EUR

Grundierungs-Pinsel,
1,79 EUR

Augen Make-up Pinsel,
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) 7 queries took 451 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `productgroups`	12	12	1
2	DESCRIBE `productmaingroups`	7	7	44
3	DESCRIBE `products`	18	18	36
4	DESCRIBE `productgroups_products`	2	2	36
5	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` = 205 LIMIT 1	1	1	0
6	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 = 205 AND Product.aktiv = 1 ORDER BY order_no, id	1	1	328
7	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(83601) AND oi2.product_id NOT IN(83601) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5	5	5	6

(default) 7 queries took 451 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `productgroups`

DESCRIBE `productmaingroups`

DESCRIBE `products`

DESCRIBE `productgroups_products`

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` = 205 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 = 205 AND Product.aktiv = 1 ORDER BY order_no, id

328

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(83601) AND oi2.product_id NOT IN(83601) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5