0

You have no items in your shopping cart.

By PRODUCT LIST

  • Face Wash/Toners
  • Serums and Treatments
  • Moisturizers
  • Masks and Exfoliators
  • Product Enhancers
  • Eye creams
  • Gift Cards

By SKIN TYPE

  • Normal to Dry
  • Normal to Oily
  • Dry or Sensitive
  • Oily
  • For all Skin Types

By CONCERN

  • Wrinkles/Anti-Aging
  • Acne Breakouts
  • Pigmentation
  • Very Dry Skin
  • Sensitive Skin
(default) 9 queries took 390 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `products`13134
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `categories`10104
4SHOW FULL COLUMNS FROM `categories_products`443
5SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`codcategory`, `Category`.`name`, `Category`.`level`, `Category`.`lft`, `Category`.`rght`, `Category`.`order`, `Category`.`status`, `Category`.`discount` FROM `categories` AS `Category` WHERE `Category`.`status` = 1 AND (`Category`.`parent_id` = 0 OR `Category`.`parent_id` IS NULL) ORDER BY `Category`.`order` ASC, `Category`.`parent_id` ASC 332
6SELECT `Child`.`id`, `Child`.`parent_id`, `Child`.`codcategory`, `Child`.`name`, `Child`.`level`, `Child`.`lft`, `Child`.`rght`, `Child`.`order`, `Child`.`status`, `Child`.`discount` FROM `categories` AS `Child` WHERE `Child`.`status` = 1 AND `Child`.`parent_id` IN (1, 2, 3) ORDER BY `Child`.`order` ASC 17170
7SELECT COUNT(DISTINCT Product.id) AS `count` FROM `products` AS `Product` INNER JOIN categories_products AS `CatFilter` ON (`CatFilter`.`product_id` = `Product`.`id` AND `CatFilter`.`status` = 1) INNER JOIN categories_products AS `SkinType` ON (`SkinType`.`product_id` = `Product`.`id` AND `SkinType`.`status` = 1) INNER JOIN categories_products AS `Concern` ON (`Concern`.`product_id` = `Product`.`id` AND `Concern`.`status` = 1) WHERE `Product`.`status` = 1 11167
8SELECT `Product`.`id`, `Product`.`name`, `Product`.`code`, `Product`.`excerpt`, `Product`.`price`, `Product`.`stock`, `Product`.`default_image` FROM `products` AS `Product` INNER JOIN categories_products AS `CatFilter` ON (`CatFilter`.`product_id` = `Product`.`id` AND `CatFilter`.`status` = 1) INNER JOIN categories_products AS `SkinType` ON (`SkinType`.`product_id` = `Product`.`id` AND `SkinType`.`status` = 1) INNER JOIN categories_products AS `Concern` ON (`Concern`.`product_id` = `Product`.`id` AND `Concern`.`status` = 1) WHERE `Product`.`status` = 1 GROUP BY `Product`.`id` ORDER BY `Product`.`name` ASC LIMIT 888208
9SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`codcategory`, `Category`.`name`, `Category`.`level`, `Category`.`lft`, `Category`.`rght`, `Category`.`order`, `Category`.`status`, `Category`.`discount`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`status` FROM `categories` AS `Category` JOIN `categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` IN (17, 48, 53, 30, 42, 43, 33, 39) AND `CategoriesProduct`.`product_id` = `Category`.`id`) 14141