Gesicht

Make-up Schwämmchen

Blending Wedges

Beschreibung

Die weichen Schwamm-Ecken sind elastisch aber robust!
Ideal für ein feines und makelloses Auftragen des Make-ups.
8 Stück in der praktischen Box.

Bild	Ausführung	Details / Duft	Inhalt	ArtNr	L	Anzahl	Preis	Warenkorb
		Make-up Schwämmchen		1702			1,79 EUR*

Kunden, die diesen Artikel gekauft haben, kauften auch

Lidschatten-Pinsel,
1,79 EUR

3-in-1 Präzisions-Pinsel,
1,79 EUR

Flüssig-Abdeck-Stift, Apricot Beige (Fair)
1,79 EUR

Nagel-Lack, Nude
1,79 EUR

Grundierungs-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 484 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `productgroups`	12	12	1
2	DESCRIBE `productmaingroups`	7	7	64
3	DESCRIBE `products`	18	18	56
4	DESCRIBE `productgroups_products`	2	2	23
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` = 33 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 = 33 AND Product.aktiv = 1 ORDER BY order_no, id	1	1	334
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(1702) AND oi2.product_id NOT IN(1702) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5	5	5	6

(default) 7 queries took 484 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` = 33 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 = 33 AND Product.aktiv = 1 ORDER BY order_no, id

334

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