₹ $ € £

($)

Extra 5% off on all Kbeauty orders above ₹999

KLOVE

Copied

Discover with Ai

Community

KLOVE | Extra 5% off on all Kbeauty orders above ₹999

SUMVIBE10 | Extra 10% off on orders on orders ₹1,999+

SUNKISS5 | Extra 5% off on orders ₹999+

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

LIGHT UP: Ace The Glow Vitamin C Skin Brightening Set - 50gm

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

```
C
```

Array
(
    [0] => Array
        (
            [product_id] => 28339
            [product] => Ace The Glow Vitamin C Skin Brightening Set - 50gm
            [supplier_id] => 516
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (28339)) AND prices.usergroup_id IN (0))

Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 28339
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)

LIGHT UP

Ace The Glow Vitamin C Skin Brightening Set - 50gm

Increase hydration, Reduce dark spots

Write a review

Compare

Vitamin C

Good For:

Skin Pigmentation Anti-Aging Sun Damage

$49.98

$52.62

Save: ₹171 (5%)

Price details

Maximum retail price incl. of all taxes
$52.62
Total Discount 171

Special Price

$49.98

kinders earned

$49.98

+ −

Delivery

Your box of happiness will be shipped in 2-4 business days.

Cash on delivery available on orders above ₹499

100% recyclable packaging

10 Days Return Policy

Available offers

Use SUMVIBE10 & Get Flat 10% off on orders above Rs. 1999.
Use SUNKISS5 & Get Flat 5% off on orders above Rs. 999.

Details

Featured Ingredient

Good For

Features

How to use

Related to watch

Reviews

kindcode

Details

THD Ascorbate (Vitamin C ) is a stable oil soluable derivative which makes it penetrate 3X faster than traditional Vitamin C. Contains a unique combination of natural skin brighteners like Alpha-Arbutin, Liqorice, Kiwi and Kakadu Plum which infuse a natural radiance tackling discoloration and dark spots. Advanced Anti-Oxidant support is provided by nutrient rich Sea Buckthorn Oil, Chia Seed and Blackcurrant Seed Oil. This power couple also blend perfectly well to increase hydration with Hyaluronic Acid, Milk Peptides, Evening Primrose, Shea Butter and Pumpkin Seed Oil. This set is sure to rewind the clock with anti-ageing wonders like Bio-Retinols, Beetroot and Chinese Ginger.

Featured Ingredient

Vitamin C

Fair

Score key

10-9

Low hazard

8-5

Moderate hazard

4-1

High hazard

Data score key

Best

Good

Fair

Average

Limited

Data availability rating: the scope of ingredient safety data contains in the skin deep, and the number of studies available In the open scientific literature.

Ascorbic acid (Vitamin C) is a naturally occurring antioxidant.

Functions: It can help neutralize free radicals, protect the...

Good For

Features

KLEEN Score

Brand:

LIGHT UP

Key Ingredients:

Vitamin C (THD Ascorbate),"Alpha-Arbutin, Bio-retinols

Ingredients:

Vitamin C (THD Ascorbate), Alpha-Arbutin,Milk Peptides,Bio-Retinols, Kiwi, Liqorice,Evening Primrose, Cocoa Butter,Sea Buckthorn Oil, Shea Butter,Niacinamide, Rosehip Oil, Vitamin E, THD...Read more Read less

For Concerns:

Anti-Aging
Skin Pigmentation
Sun Damage

kindcode

Cruelty Free
Toxin Free

Additional Information

Net Content:

Pack Unit(s)

Net Weight:

50gm

Net Volume:

30ml

Expiry or Best Before Date:

Sep-24

Expiry or Best Before Month:

01-03-2026

Dimensions

Breadth:

15.88cm

Height:

9.53cm

Length:

22.86cm

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND ?:product_required_products.product_id = 28339 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC

```
C
```

```
Array
(
)
```

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND ?:product_required_products.product_id = 28339 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC

SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND ?:product_required_products.product_id = 28339

Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => categories
            [4] => sales
            [5] => companies
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [for_required_product] => 28339
    [include_child_variations] => 1
    [group_child_variations] => 
    [runtime_company_id] => 13
    [hide_out_of_stock_products] => 
    [sort_by] => bestsellers
    [sort_order] => desc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [sort_order_rev] => asc
    [total_items] => 0
)

How to use

Apply just 1-2 pumps of BLAZE Vitamin C Glow Serum evenly on face and neck in the morning. Apply a thin layer of PRISM Vitamin C Glow Cream at night before sleeping. Apply on face and neck in upward circular motions. Pat skin until absorbed.

Related to watch

Reviews

No reviews found

kindcode

Cruelty Free

“Cruelty-Free” is a PETA provided certification to brands which do not conduct product tests on animals prior to sales. Considering the vulnerability of animals and their lack of ability to give consent doesn’t make it ethical to test products meant for human use on them. Hence products that are natural or plant based could be cruelty free only if they have not been tested on animals.
Toxin Free

Toxin free products indicate that the ingredients used in it do not exist in amounts that are known or proven to be harmful and affect the consumer negatively. It does not always mean that there are no chemicals in it.