Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 28559
[include_child_variations] => 1
[group_child_variations] =>
[runtime_company_id] => 13
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[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] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
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)) 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 = 28559 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
SPECIAL25 | Extra 25% off on selected brands
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+
All orders 
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 28559
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[runtime_company_id] => 13
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[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] =>
)
Advanced and feature filters
before hook
after hook
C
before 2nd hook
after 2nd hook
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)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' WHERE 1 AND companies.status IN ('A') 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) AND ((1 AND products.product_id IN (28559)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[28559] => Array
(
[product_id] => 28559
[product] => Aloe Soothing Hybrid Sun Cream SPF 50 PA+++- 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => CR043
[hsn_code] => 3304
[status] => A
[list_price] => 1050.00
[amount] => 254
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1681555720
[updated_timestamp] => 1750427211
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 10
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 630.000000
[category_ids] => Array
(
[0] => 2368
[1] => 2813
)
[seo_name] => aloe-soothing-sun-cream-spf-50-pa-22
[seo_path] => 2685/2708/2813
[main_category] => 2813
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 10
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
[1367] => Array
(
[video_id] => 1367
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720592870
[status] => A
[user_id] => 151514
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/sunscreen-i-am-loving-this-summer
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1367_SaveInsta.App - 3344122120413702559_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1367_SaveInsta.App - 3344122120413702559.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Sunscreen I am loving this summer !
[description] => I am so much in loveeee with all three of these ! Can't help using it daily without skipping! You know what the best part is ? It is suitable for all skin types and is soooo light weight yet non-tacky! Leaves no white cast but yet gives me a healthy natural glow :)
[short_description] =>
[privacy] => 1
[like_count] => 6
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 10451,53620,10438
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1122] => Array
(
[video_id] => 1122
[video_type] => C
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1711614639
[status] => A
[user_id] => 229317
[extra_params] =>
[community_video_id] => 1228
[community_url] => https://www.kindlife.in/whitehead-power-liquid
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1228/84f70d85f3260b23ef27a908f7ef3f80.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1228/84f70d85f3260b23ef27a908f7ef3f80.mp4
[community_last_sync_timestamp] => 1711686620
[lang_code] => en
[youtube_id] =>
[video] => Whitehead power liquid
[description] => Control the production of whiteheads using AHA 7 whitehead power essence.
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => COSRX
)
)
Array
(
[28559] => Array
(
[product_id] => 28559
[product] => Aloe Soothing Hybrid Sun Cream SPF 50 PA+++- 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => CR043
[hsn_code] => 3304
[status] => A
[list_price] => 1050.00
[amount] => 254
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1681555720
[updated_timestamp] => 1750427211
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 10
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 630.000000
[category_ids] => Array
(
[0] => 2368
[1] => 2813
)
[seo_name] => aloe-soothing-sun-cream-spf-50-pa-22
[seo_path] => 2685/2708/2813
[main_category] => 2813
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 10
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
[1367] => Array
(
[video_id] => 1367
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720592870
[status] => A
[user_id] => 151514
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/sunscreen-i-am-loving-this-summer
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1367_SaveInsta.App - 3344122120413702559_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1367_SaveInsta.App - 3344122120413702559.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Sunscreen I am loving this summer !
[description] => I am so much in loveeee with all three of these ! Can't help using it daily without skipping! You know what the best part is ? It is suitable for all skin types and is soooo light weight yet non-tacky! Leaves no white cast but yet gives me a healthy natural glow :)
[short_description] =>
[privacy] => 1
[like_count] => 6
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 10451,53620,10438
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1122] => Array
(
[video_id] => 1122
[video_type] => C
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1711614639
[status] => A
[user_id] => 229317
[extra_params] =>
[community_video_id] => 1228
[community_url] => https://www.kindlife.in/whitehead-power-liquid
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1228/84f70d85f3260b23ef27a908f7ef3f80.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1228/84f70d85f3260b23ef27a908f7ef3f80.mp4
[community_last_sync_timestamp] => 1711686620
[lang_code] => en
[youtube_id] =>
[video] => Whitehead power liquid
[description] => Control the production of whiteheads using AHA 7 whitehead power essence.
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => COSRX
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 28559
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[runtime_company_id] => 13
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[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] =>
)
Advanced and feature filters
before hook
after hook
C
before 2nd hook
after 2nd hook
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)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' WHERE 1 AND companies.status IN ('A') 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) AND ((1 AND products.product_id IN (28559)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[28559] => Array
(
[product_id] => 28559
[product] => Aloe Soothing Hybrid Sun Cream SPF 50 PA+++- 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => CR043
[hsn_code] => 3304
[status] => A
[list_price] => 1050.00
[amount] => 254
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1681555720
[updated_timestamp] => 1750427211
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 10
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 630.000000
[category_ids] => Array
(
[0] => 2368
[1] => 2813
)
[seo_name] => aloe-soothing-sun-cream-spf-50-pa-22
[seo_path] => 2685/2708/2813
[main_category] => 2813
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 10
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
[1367] => Array
(
[video_id] => 1367
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720592870
[status] => A
[user_id] => 151514
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/sunscreen-i-am-loving-this-summer
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1367_SaveInsta.App - 3344122120413702559_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1367_SaveInsta.App - 3344122120413702559.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Sunscreen I am loving this summer !
[description] => I am so much in loveeee with all three of these ! Can't help using it daily without skipping! You know what the best part is ? It is suitable for all skin types and is soooo light weight yet non-tacky! Leaves no white cast but yet gives me a healthy natural glow :)
[short_description] =>
[privacy] => 1
[like_count] => 6
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 10451,53620,10438
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1122] => Array
(
[video_id] => 1122
[video_type] => C
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1711614639
[status] => A
[user_id] => 229317
[extra_params] =>
[community_video_id] => 1228
[community_url] => https://www.kindlife.in/whitehead-power-liquid
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1228/84f70d85f3260b23ef27a908f7ef3f80.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1228/84f70d85f3260b23ef27a908f7ef3f80.mp4
[community_last_sync_timestamp] => 1711686620
[lang_code] => en
[youtube_id] =>
[video] => Whitehead power liquid
[description] => Control the production of whiteheads using AHA 7 whitehead power essence.
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => COSRX
)
)
Array
(
[28559] => Array
(
[product_id] => 28559
[product] => Aloe Soothing Hybrid Sun Cream SPF 50 PA+++- 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => CR043
[hsn_code] => 3304
[status] => A
[list_price] => 1050.00
[amount] => 254
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1681555720
[updated_timestamp] => 1750427211
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 10
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 630.000000
[category_ids] => Array
(
[0] => 2368
[1] => 2813
)
[seo_name] => aloe-soothing-sun-cream-spf-50-pa-22
[seo_path] => 2685/2708/2813
[main_category] => 2813
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 10
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
[1367] => Array
(
[video_id] => 1367
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720592870
[status] => A
[user_id] => 151514
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/sunscreen-i-am-loving-this-summer
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1367_SaveInsta.App - 3344122120413702559_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1367_SaveInsta.App - 3344122120413702559.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Sunscreen I am loving this summer !
[description] => I am so much in loveeee with all three of these ! Can't help using it daily without skipping! You know what the best part is ? It is suitable for all skin types and is soooo light weight yet non-tacky! Leaves no white cast but yet gives me a healthy natural glow :)
[short_description] =>
[privacy] => 1
[like_count] => 6
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 10451,53620,10438
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1122] => Array
(
[video_id] => 1122
[video_type] => C
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1711614639
[status] => A
[user_id] => 229317
[extra_params] =>
[community_video_id] => 1228
[community_url] => https://www.kindlife.in/whitehead-power-liquid
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1228/84f70d85f3260b23ef27a908f7ef3f80.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1228/84f70d85f3260b23ef27a908f7ef3f80.mp4
[community_last_sync_timestamp] => 1711686620
[lang_code] => en
[youtube_id] =>
[video] => Whitehead power liquid
[description] => Control the production of whiteheads using AHA 7 whitehead power essence.
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => COSRX
)
)
end of fxn
Express Delivery
100% recyclable packaging
10 Days Return Policy
Details
The Cosrx Aloe Soothing Sun Cream SPF 50 PA+++ offers high UV protection with a hybrid formula of physical and chemical filters. Infused with 55,000 ppm of Aloe Leaf Extract, it soothes and hydrates sensitive skin, reducing redness and irritation. Its ultra-moisturizing, lotion-like texture absorbs easily with no white cast. Ideal for normal to dry skin, it’s perfect for summer and reapplication during outdoor activities. The travel-friendly tube makes it convenient to carry anywhere.
Featured Ingredient
Low hazard
Moderate hazard
High hazard
Best
Good
Fair
Average
Limited
Propylene Glycol
Low hazard
Moderate hazard
High hazard
Best
Good
Fair
Average
Limited
Features
Confused about what's kind on, in and around your body? We're here to decode some key terms and what it means when a brand declares them! If a brand doesn't have at least one of these codes, they won't be listed on kindlife! Know more
Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 28559
[include_child_variations] => 1
[group_child_variations] =>
[runtime_company_id] => 13
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[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] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
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)) 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 = 28559 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
How to use
1. Apply a generous amount to your face 30 minutes before sun exposure.
2. Reapply throughout the day as needed, especially during prolonged sun exposure.
Related to watch
Reviews
5.0
- Comment
5.0
- Comment
5.0
- Comment
Love the texture, very moisturizing. No need for a separate moisturizer. Great for dry skin. No white cast. Thank you KINDLIFE
5.0
- Comment
5.0
- Comment
4.0
- Comment
5.0
- Comment
5.0
- Comment
5.0
- Comment
5.0
- Comment
kindcode
“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.
Eco-conscious products are safe for the environment and do no harm to it when they are produced, used or disposed of. They produce no pollution and can be reused or recycled.
Top Korean beauty brand combining cosmetics and prescription with mild ingredients dermatologist-tested and popular snail mucin range
Shop the Brand
Hi, I am kiki.AI, unlock your gateway to global beauty and health with AI-powered insights.
0
5
Added To Cart
Cruelty Free
Eco Conscious
