1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [for_required_product] => 16273
        [include_child_variations] => 1
        [group_child_variations] => 
        [runtime_company_id] => 13
    )
    
    
  1. 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] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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 = 16273 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
The Umbrella Store: Bubble Candle - Pink

Extra 5% off on all Kbeauty orders above ₹999

KLOVE

Copied

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+

The Umbrella Store: Bubble Candle - Pink
  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 16273
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  1. 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] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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 (16273)) 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 
    
  1. before end of oxn
    
  2. Array
    (
        [16273] => Array
            (
                [product_id] => 16273
                [product] => Bubble Candle - Pink
                [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] => BubbleCandlePink
                [hsn_code] => 3304
                [status] => A
                [list_price] => 999.00
                [amount] => 67
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1661251793
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [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] => 5
                [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] => 949.050000
                [category_ids] => Array
                    (
                        [0] => 451
                    )
    
                [seo_name] => bubble-candle-pink
                [seo_path] => 211/212/221/451
                [main_category] => 451
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                        [798] => Array
                            (
                                [video_id] => 798
                                [video_type] => C
                                [company_id] => 0
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1686825008
                                [status] => A
                                [user_id] => 21551
                                [extra_params] => 
                                [community_video_id] => 832
                                [community_url] => https://www.kindlife.in/global-beauty-secrets
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/832/1329fd3a88cfbd9432439b8992161044.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/832/d0274f4648f6e11f7bfb57b13433eae4.mp4
                                [community_last_sync_timestamp] => 1686825008
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Global Beauty Secrets 
                                [description] => <span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">If this is your vibe, you can&rsquo;t miss out on&nbsp;</span><a class="x1i10hfl xjbqb8w x6umtig x1b1mbwd xaqea5y xav7gou x9f619 x1ypdohk xt0psk2 xe8uvvx xdj266r x11i5rnm xat24cr x1mh8g0r xexx8yu x4uap5 x18d9i69 xkhd6sd x16tdsg8 x1hl2dhg xggy1nq x1a2a7pz  _aa9_ _a6hd" style="cursor: pointer; text-decoration-line: none; outline: none; list-style: none; margin: 0px; padding: 0px; -webkit-tap-highlight-color: transparent; box-sizing: border-box; touch-action: manipulation; background-color: #ffffff; display: inline; overflow-wrap: break-word; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; border: 0px initial initial;" tabindex="0" role="link" href="https://www.instagram.com/explore/tags/passporttobeauty/">#passporttobeauty</a><span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">&nbsp;✈️?</span><br style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;" /><span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">It&rsquo;s like unlocking all the global beauty secrets without even needing an actual passport✨<br /><br /></span><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#umbr"><a id="brandDesc_34490" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=34490" data-value="34490">The Umbrella Store</a></span>'s <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@bubble"><a id="product_16273" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=16273" data-value="16273">Bubble Candle - Pink</a></span>&nbsp;
                                [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
                                    )
    
                            )
    
                        [164] => Array
                            (
                                [video_id] => 164
                                [video_type] => C
                                [company_id] => 13
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1681669800
                                [status] => A
                                [user_id] => 146299
                                [extra_params] => 
                                [community_video_id] => 693
                                [community_url] => https://www.kindlife.in/self-care-day-with-kindlife
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/693/d06d084d0ae998e772edf4091d6eb643.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/693/2ca916638687f2d8d9f98f682a823075.mp4
                                [community_last_sync_timestamp] => 1713162127
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Self care day with kindlife 
                                [description] => @lipsleepingmask <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#ilana"><a id="brandDesc_19621" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=19621" data-value="19621">ilana</a></span>&nbsp;@bathingsalt <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#kae"><a id="brandDesc_24966" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=24966" data-value="24966">Kaefie</a></span>&nbsp;@anveyahaircolour <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#anv"><a id="brandDesc_27433" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=27433" data-value="27433">Anveya</a></span>&nbsp;@faceserum <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#lacu"><a id="brandDesc_29946" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=29946" data-value="29946">Lacuna Light</a></span>&nbsp;@freebies <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#klai"><a id="brandDesc_10438" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=10438" data-value="10438">Klairs</a></span>&nbsp;
                                [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
                                    )
    
                            )
    
                        [165] => Array
                            (
                                [video_id] => 165
                                [video_type] => C
                                [company_id] => 13
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1681669800
                                [status] => A
                                [user_id] => 146299
                                [extra_params] => 
                                [community_video_id] => 691
                                [community_url] => https://www.kindlife.in/self-care-day
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/691/ea3cc3efb9192dca67573d80ba65a821.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/691/8a60d644e3e2c720c2ff83a5bae0ef97.mp4
                                [community_last_sync_timestamp] => 1713162126
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Self care Day ?
                                [description] => <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@bub"><a id="product_16273" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=16273" data-value="16273">Bubble Candle - Pink</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@soothing"><a id="product_12327" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=12327" data-value="12327">Soothing Serum for Acne Prone &amp; Sensitive Skin with Niacinamide &amp; Hyaluronic Acid - 30 ml</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@snooz"><a id="product_21753" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=21753" data-value="21753">Lip Snooze - Strawberry Lemonade - 15gm</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@summ"><a id="product_22239" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=22239" data-value="22239">Summer Pink - 30ml</a></span>&nbsp;
                                [short_description] => 
                                [privacy] => 1
                                [like_count] => 0
                                [dislike_count] => 0
                                [comment_count] => 0
                                [meta_keywords] => 
                                [meta_description] => 
                                [page_title] => 
                                [tagged_brands] => 
                                [category_id] => 34
                                [link_type] => M
                                [preview] => Array
                                    (
                                        [default_icon] => 1
                                    )
    
                            )
    
                    )
    
                [cp_has_video] => 1
                [brand_name] => The Umbrella Store
            )
    
    )
    
    
  1. Array
    (
        [16273] => Array
            (
                [product_id] => 16273
                [product] => Bubble Candle - Pink
                [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] => BubbleCandlePink
                [hsn_code] => 3304
                [status] => A
                [list_price] => 999.00
                [amount] => 67
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1661251793
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [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] => 5
                [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] => 949.050000
                [category_ids] => Array
                    (
                        [0] => 451
                    )
    
                [seo_name] => bubble-candle-pink
                [seo_path] => 211/212/221/451
                [main_category] => 451
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                        [798] => Array
                            (
                                [video_id] => 798
                                [video_type] => C
                                [company_id] => 0
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1686825008
                                [status] => A
                                [user_id] => 21551
                                [extra_params] => 
                                [community_video_id] => 832
                                [community_url] => https://www.kindlife.in/global-beauty-secrets
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/832/1329fd3a88cfbd9432439b8992161044.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/832/d0274f4648f6e11f7bfb57b13433eae4.mp4
                                [community_last_sync_timestamp] => 1686825008
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Global Beauty Secrets 
                                [description] => <span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">If this is your vibe, you can&rsquo;t miss out on&nbsp;</span><a class="x1i10hfl xjbqb8w x6umtig x1b1mbwd xaqea5y xav7gou x9f619 x1ypdohk xt0psk2 xe8uvvx xdj266r x11i5rnm xat24cr x1mh8g0r xexx8yu x4uap5 x18d9i69 xkhd6sd x16tdsg8 x1hl2dhg xggy1nq x1a2a7pz  _aa9_ _a6hd" style="cursor: pointer; text-decoration-line: none; outline: none; list-style: none; margin: 0px; padding: 0px; -webkit-tap-highlight-color: transparent; box-sizing: border-box; touch-action: manipulation; background-color: #ffffff; display: inline; overflow-wrap: break-word; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; border: 0px initial initial;" tabindex="0" role="link" href="https://www.instagram.com/explore/tags/passporttobeauty/">#passporttobeauty</a><span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">&nbsp;✈️?</span><br style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;" /><span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">It&rsquo;s like unlocking all the global beauty secrets without even needing an actual passport✨<br /><br /></span><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#umbr"><a id="brandDesc_34490" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=34490" data-value="34490">The Umbrella Store</a></span>'s <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@bubble"><a id="product_16273" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=16273" data-value="16273">Bubble Candle - Pink</a></span>&nbsp;
                                [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
                                    )
    
                            )
    
                        [164] => Array
                            (
                                [video_id] => 164
                                [video_type] => C
                                [company_id] => 13
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1681669800
                                [status] => A
                                [user_id] => 146299
                                [extra_params] => 
                                [community_video_id] => 693
                                [community_url] => https://www.kindlife.in/self-care-day-with-kindlife
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/693/d06d084d0ae998e772edf4091d6eb643.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/693/2ca916638687f2d8d9f98f682a823075.mp4
                                [community_last_sync_timestamp] => 1713162127
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Self care day with kindlife 
                                [description] => @lipsleepingmask <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#ilana"><a id="brandDesc_19621" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=19621" data-value="19621">ilana</a></span>&nbsp;@bathingsalt <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#kae"><a id="brandDesc_24966" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=24966" data-value="24966">Kaefie</a></span>&nbsp;@anveyahaircolour <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#anv"><a id="brandDesc_27433" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=27433" data-value="27433">Anveya</a></span>&nbsp;@faceserum <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#lacu"><a id="brandDesc_29946" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=29946" data-value="29946">Lacuna Light</a></span>&nbsp;@freebies <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#klai"><a id="brandDesc_10438" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=10438" data-value="10438">Klairs</a></span>&nbsp;
                                [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
                                    )
    
                            )
    
                        [165] => Array
                            (
                                [video_id] => 165
                                [video_type] => C
                                [company_id] => 13
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1681669800
                                [status] => A
                                [user_id] => 146299
                                [extra_params] => 
                                [community_video_id] => 691
                                [community_url] => https://www.kindlife.in/self-care-day
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/691/ea3cc3efb9192dca67573d80ba65a821.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/691/8a60d644e3e2c720c2ff83a5bae0ef97.mp4
                                [community_last_sync_timestamp] => 1713162126
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Self care Day ?
                                [description] => <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@bub"><a id="product_16273" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=16273" data-value="16273">Bubble Candle - Pink</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@soothing"><a id="product_12327" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=12327" data-value="12327">Soothing Serum for Acne Prone &amp; Sensitive Skin with Niacinamide &amp; Hyaluronic Acid - 30 ml</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@snooz"><a id="product_21753" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=21753" data-value="21753">Lip Snooze - Strawberry Lemonade - 15gm</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@summ"><a id="product_22239" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=22239" data-value="22239">Summer Pink - 30ml</a></span>&nbsp;
                                [short_description] => 
                                [privacy] => 1
                                [like_count] => 0
                                [dislike_count] => 0
                                [comment_count] => 0
                                [meta_keywords] => 
                                [meta_description] => 
                                [page_title] => 
                                [tagged_brands] => 
                                [category_id] => 34
                                [link_type] => M
                                [preview] => Array
                                    (
                                        [default_icon] => 1
                                    )
    
                            )
    
                    )
    
                [cp_has_video] => 1
                [brand_name] => The Umbrella Store
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 16273
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  1. 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] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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 (16273)) 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 
    
  1. before end of oxn
    
  2. Array
    (
        [16273] => Array
            (
                [product_id] => 16273
                [product] => Bubble Candle - Pink
                [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] => BubbleCandlePink
                [hsn_code] => 3304
                [status] => A
                [list_price] => 999.00
                [amount] => 67
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1661251793
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [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] => 5
                [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] => 949.050000
                [category_ids] => Array
                    (
                        [0] => 451
                    )
    
                [seo_name] => bubble-candle-pink
                [seo_path] => 211/212/221/451
                [main_category] => 451
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                        [798] => Array
                            (
                                [video_id] => 798
                                [video_type] => C
                                [company_id] => 0
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1686825008
                                [status] => A
                                [user_id] => 21551
                                [extra_params] => 
                                [community_video_id] => 832
                                [community_url] => https://www.kindlife.in/global-beauty-secrets
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/832/1329fd3a88cfbd9432439b8992161044.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/832/d0274f4648f6e11f7bfb57b13433eae4.mp4
                                [community_last_sync_timestamp] => 1686825008
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Global Beauty Secrets 
                                [description] => <span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">If this is your vibe, you can&rsquo;t miss out on&nbsp;</span><a class="x1i10hfl xjbqb8w x6umtig x1b1mbwd xaqea5y xav7gou x9f619 x1ypdohk xt0psk2 xe8uvvx xdj266r x11i5rnm xat24cr x1mh8g0r xexx8yu x4uap5 x18d9i69 xkhd6sd x16tdsg8 x1hl2dhg xggy1nq x1a2a7pz  _aa9_ _a6hd" style="cursor: pointer; text-decoration-line: none; outline: none; list-style: none; margin: 0px; padding: 0px; -webkit-tap-highlight-color: transparent; box-sizing: border-box; touch-action: manipulation; background-color: #ffffff; display: inline; overflow-wrap: break-word; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; border: 0px initial initial;" tabindex="0" role="link" href="https://www.instagram.com/explore/tags/passporttobeauty/">#passporttobeauty</a><span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">&nbsp;✈️?</span><br style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;" /><span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">It&rsquo;s like unlocking all the global beauty secrets without even needing an actual passport✨<br /><br /></span><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#umbr"><a id="brandDesc_34490" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=34490" data-value="34490">The Umbrella Store</a></span>'s <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@bubble"><a id="product_16273" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=16273" data-value="16273">Bubble Candle - Pink</a></span>&nbsp;
                                [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
                                    )
    
                            )
    
                        [164] => Array
                            (
                                [video_id] => 164
                                [video_type] => C
                                [company_id] => 13
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1681669800
                                [status] => A
                                [user_id] => 146299
                                [extra_params] => 
                                [community_video_id] => 693
                                [community_url] => https://www.kindlife.in/self-care-day-with-kindlife
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/693/d06d084d0ae998e772edf4091d6eb643.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/693/2ca916638687f2d8d9f98f682a823075.mp4
                                [community_last_sync_timestamp] => 1713162127
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Self care day with kindlife 
                                [description] => @lipsleepingmask <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#ilana"><a id="brandDesc_19621" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=19621" data-value="19621">ilana</a></span>&nbsp;@bathingsalt <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#kae"><a id="brandDesc_24966" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=24966" data-value="24966">Kaefie</a></span>&nbsp;@anveyahaircolour <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#anv"><a id="brandDesc_27433" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=27433" data-value="27433">Anveya</a></span>&nbsp;@faceserum <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#lacu"><a id="brandDesc_29946" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=29946" data-value="29946">Lacuna Light</a></span>&nbsp;@freebies <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#klai"><a id="brandDesc_10438" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=10438" data-value="10438">Klairs</a></span>&nbsp;
                                [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
                                    )
    
                            )
    
                        [165] => Array
                            (
                                [video_id] => 165
                                [video_type] => C
                                [company_id] => 13
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1681669800
                                [status] => A
                                [user_id] => 146299
                                [extra_params] => 
                                [community_video_id] => 691
                                [community_url] => https://www.kindlife.in/self-care-day
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/691/ea3cc3efb9192dca67573d80ba65a821.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/691/8a60d644e3e2c720c2ff83a5bae0ef97.mp4
                                [community_last_sync_timestamp] => 1713162126
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Self care Day ?
                                [description] => <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@bub"><a id="product_16273" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=16273" data-value="16273">Bubble Candle - Pink</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@soothing"><a id="product_12327" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=12327" data-value="12327">Soothing Serum for Acne Prone &amp; Sensitive Skin with Niacinamide &amp; Hyaluronic Acid - 30 ml</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@snooz"><a id="product_21753" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=21753" data-value="21753">Lip Snooze - Strawberry Lemonade - 15gm</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@summ"><a id="product_22239" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=22239" data-value="22239">Summer Pink - 30ml</a></span>&nbsp;
                                [short_description] => 
                                [privacy] => 1
                                [like_count] => 0
                                [dislike_count] => 0
                                [comment_count] => 0
                                [meta_keywords] => 
                                [meta_description] => 
                                [page_title] => 
                                [tagged_brands] => 
                                [category_id] => 34
                                [link_type] => M
                                [preview] => Array
                                    (
                                        [default_icon] => 1
                                    )
    
                            )
    
                    )
    
                [cp_has_video] => 1
                [brand_name] => The Umbrella Store
            )
    
    )
    
    
  1. Array
    (
        [16273] => Array
            (
                [product_id] => 16273
                [product] => Bubble Candle - Pink
                [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] => BubbleCandlePink
                [hsn_code] => 3304
                [status] => A
                [list_price] => 999.00
                [amount] => 67
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1661251793
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [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] => 5
                [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] => 949.050000
                [category_ids] => Array
                    (
                        [0] => 451
                    )
    
                [seo_name] => bubble-candle-pink
                [seo_path] => 211/212/221/451
                [main_category] => 451
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                        [798] => Array
                            (
                                [video_id] => 798
                                [video_type] => C
                                [company_id] => 0
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1686825008
                                [status] => A
                                [user_id] => 21551
                                [extra_params] => 
                                [community_video_id] => 832
                                [community_url] => https://www.kindlife.in/global-beauty-secrets
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/832/1329fd3a88cfbd9432439b8992161044.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/832/d0274f4648f6e11f7bfb57b13433eae4.mp4
                                [community_last_sync_timestamp] => 1686825008
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Global Beauty Secrets 
                                [description] => <span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">If this is your vibe, you can&rsquo;t miss out on&nbsp;</span><a class="x1i10hfl xjbqb8w x6umtig x1b1mbwd xaqea5y xav7gou x9f619 x1ypdohk xt0psk2 xe8uvvx xdj266r x11i5rnm xat24cr x1mh8g0r xexx8yu x4uap5 x18d9i69 xkhd6sd x16tdsg8 x1hl2dhg xggy1nq x1a2a7pz  _aa9_ _a6hd" style="cursor: pointer; text-decoration-line: none; outline: none; list-style: none; margin: 0px; padding: 0px; -webkit-tap-highlight-color: transparent; box-sizing: border-box; touch-action: manipulation; background-color: #ffffff; display: inline; overflow-wrap: break-word; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; border: 0px initial initial;" tabindex="0" role="link" href="https://www.instagram.com/explore/tags/passporttobeauty/">#passporttobeauty</a><span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">&nbsp;✈️?</span><br style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;" /><span style="font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">It&rsquo;s like unlocking all the global beauty secrets without even needing an actual passport✨<br /><br /></span><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#umbr"><a id="brandDesc_34490" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=34490" data-value="34490">The Umbrella Store</a></span>'s <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@bubble"><a id="product_16273" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=16273" data-value="16273">Bubble Candle - Pink</a></span>&nbsp;
                                [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
                                    )
    
                            )
    
                        [164] => Array
                            (
                                [video_id] => 164
                                [video_type] => C
                                [company_id] => 13
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1681669800
                                [status] => A
                                [user_id] => 146299
                                [extra_params] => 
                                [community_video_id] => 693
                                [community_url] => https://www.kindlife.in/self-care-day-with-kindlife
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/693/d06d084d0ae998e772edf4091d6eb643.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/693/2ca916638687f2d8d9f98f682a823075.mp4
                                [community_last_sync_timestamp] => 1713162127
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Self care day with kindlife 
                                [description] => @lipsleepingmask <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#ilana"><a id="brandDesc_19621" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=19621" data-value="19621">ilana</a></span>&nbsp;@bathingsalt <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#kae"><a id="brandDesc_24966" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=24966" data-value="24966">Kaefie</a></span>&nbsp;@anveyahaircolour <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#anv"><a id="brandDesc_27433" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=27433" data-value="27433">Anveya</a></span>&nbsp;@faceserum <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#lacu"><a id="brandDesc_29946" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=29946" data-value="29946">Lacuna Light</a></span>&nbsp;@freebies <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="#klai"><a id="brandDesc_10438" class="bTagD" href="https://www.kindlife.in/index.php?dispatch=product_features.view&amp;variant_id=10438" data-value="10438">Klairs</a></span>&nbsp;
                                [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
                                    )
    
                            )
    
                        [165] => Array
                            (
                                [video_id] => 165
                                [video_type] => C
                                [company_id] => 13
                                [usergroup_ids] => 0
                                [position] => 0
                                [timestamp] => 1681669800
                                [status] => A
                                [user_id] => 146299
                                [extra_params] => 
                                [community_video_id] => 691
                                [community_url] => https://www.kindlife.in/self-care-day
                                [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/691/ea3cc3efb9192dca67573d80ba65a821.jpg
                                [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/691/8a60d644e3e2c720c2ff83a5bae0ef97.mp4
                                [community_last_sync_timestamp] => 1713162126
                                [lang_code] => en
                                [youtube_id] => 
                                [video] => Self care Day ?
                                [description] => <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@bub"><a id="product_16273" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=16273" data-value="16273">Bubble Candle - Pink</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@soothing"><a id="product_12327" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=12327" data-value="12327">Soothing Serum for Acne Prone &amp; Sensitive Skin with Niacinamide &amp; Hyaluronic Acid - 30 ml</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@snooz"><a id="product_21753" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=21753" data-value="21753">Lip Snooze - Strawberry Lemonade - 15gm</a></span>&nbsp;<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@summ"><a id="product_22239" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=22239" data-value="22239">Summer Pink - 30ml</a></span>&nbsp;
                                [short_description] => 
                                [privacy] => 1
                                [like_count] => 0
                                [dislike_count] => 0
                                [comment_count] => 0
                                [meta_keywords] => 
                                [meta_description] => 
                                [page_title] => 
                                [tagged_brands] => 
                                [category_id] => 34
                                [link_type] => M
                                [preview] => Array
                                    (
                                        [default_icon] => 1
                                    )
    
                            )
    
                    )
    
                [cp_has_video] => 1
                [brand_name] => The Umbrella Store
            )
    
    )
    
    
  2. end of fxn
    

Bubble Candle - Pink

Unscented candle
(2) Write a review

Compare

Share

Shipping:
Express Delivery
12.65
13.32
Save: ₹50 (5%)
i

Price details

  • Maximum retail price incl. of all taxes
    13.32
  • Total Discount 50
Special Price
12.65
28
kinders earned

Delivery

Your box of happiness will be shipped in 2-4 business days.
Cash on delivery available on orders above ₹499
Express Shipping Express Delivery
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
Features
How to use
Related to watch
Reviews
kindcode

Details

Give your space a revamp with our bubble candle that adds a fun minimalist touch to any room. This candle is unscented and made with 100% soy wax.




Read More

Featured Ingredient

10
Soy Wax
x

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.

Soy wax is a natural wax derived from soybean oil. It is used as a...

Functions: It is used as a sustainable and eco-friendly...

Features

KLEEN Score
:
8
Brand:
The Umbrella Store
Key Ingredients:
  • Soy wax
Ingredients:
  • Soy wax
kindcode
:
  • Cruelty Free
  • Toxin Free

Additional Information

Net Weight:
250gm
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [for_required_product] => 16273
        [include_child_variations] => 1
        [group_child_variations] => 
        [runtime_company_id] => 13
    )
    
    
  1. 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] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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 = 16273 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    

How to use

Related to watch

Self care day with kindlife

Self care Day ?

Reviews

Jeel Andharia
Bhavnagar
Verified purchase
4.0
Comment
Comes in great cotton bag. Shown as picture but colour is slightly darker
Jiya Sahani
rajkot
5.0
Comment
Nice product..it’s my favourite candle..

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.

The Umbrella Store

Sustainable affordable home goods crafted with the best materials for a greener lifestyle

Shop the Brand

kiki.AI

Hi, I am kiki.AI, unlock your gateway to global beauty and health with AI-powered insights.

Compare with similar items

Similar Products

Recently viewed

Server

Request

Config

SQL

Cache queries

Logging

Templates

Blocks