Array
(
    [show_master_products_only] => 
    [area] => C
    [features_hash] => 28-21614
    [items_per_page] => 48
    [sort_order] => asc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2821
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [cid] => 2821
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

    [subcats] => Y
    [runtime_company_id] => 0
)

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] => 24
    [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_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (var_val_73.variant_id IN (21614)) AND ?:categories.category_id IN (2821) 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.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY ?:product_sales.amount asc, products.product_id ASC  LIMIT 0, 48

```
before end of oxn
```

Array
(
    [24425] => Array
        (
            [product_id] => 24425
            [product] => Glycolic Acid 08% Exfoliating Liquid - 150ml
            [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] => 8906128100740
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 17
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1673957019
            [updated_timestamp] => 1750240342
            [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] => 2
            [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] => 474.000000
            [short_description] => <p>Deep Exfoliation For Even Skin Tone, Texture & Glow</p>
            [full_description] => <p>A multi-purpose exfoliator formulated with Glycolic Acid in free acid form (at 8%) to help in natural cell turnover and effective exfoliation. Combined with bamboo water for hydrating and soothing skin.</p>
<p><b>What makes it special</b></p>
<ul><li>Multi-purpose exfoliator for face, body, underarms & scalp</li><li>Delivers an optimal concentration of 8% Glycolic Acid in the free acid form to promote effective exfoliation and natural cell turnover. The free acid form represents how much acid is available in a non-ionized form and is actually able to work effectively on the skin</li><li>Formulated with Bamboo Water that has regenerative properties that help soothe & calm skin. It also doubles up as an excellent hydrator</li></ul>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => glycolic-acid-08-exfoliating-liquid-150ml
            [seo_path] => 2685/2686/2821
            [average_rating] => 4.67
            [reviews_count] => 3
            [main_category] => 2821
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 2
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [776] => Array
                        (
                            [video_id] => 776
                            [video_type] => C
                            [company_id] => 0
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1685903400
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 812
                            [community_url] => https://www.kindlife.in/unleash-the-magic-of-glycolic-acid-with-beminimalist
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/812/dfa52e78b648d2b34a0051baffca55d9.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/812/0b45f3c206311e703f5a142637a9f196.mp4
                            [community_last_sync_timestamp] => 1713162379
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unleash the Magic of Glycolic Acid with @beminimalist
                            [description] => <p class="MsoNormal">Believe us, these hacks will leave your skin grateful in the future<span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">??</span></p>
<p class="MsoNormal">Get ready to be shaken by some mind-blowing skincare hacks using @beminimalist__'s <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@"><a id="product_24425" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=24425" data-value="24425">Glycolic Acid 08% Exfoliating Liquid - 150ml</a></span>&nbsp;Glycolic Acid that will totally slay! <br />Ditch the basic routines and add some epic glycolic acid magic to your skincare game! <span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">✨<br /></span>No joke, these hacks will make your skin thank you later! <span style="font-family: 'Segoe UI Emoji', sans-serif;">??</span></p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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] => Minimalist
            [ratting_count] => 3
        )

)

Array
(
    [24425] => Array
        (
            [product_id] => 24425
            [product] => Glycolic Acid 08% Exfoliating Liquid - 150ml
            [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] => 8906128100740
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 17
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1673957019
            [updated_timestamp] => 1750240342
            [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] => 2
            [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] => 474.000000
            [short_description] => <p>Deep Exfoliation For Even Skin Tone, Texture & Glow</p>
            [full_description] => <p>A multi-purpose exfoliator formulated with Glycolic Acid in free acid form (at 8%) to help in natural cell turnover and effective exfoliation. Combined with bamboo water for hydrating and soothing skin.</p>
<p><b>What makes it special</b></p>
<ul><li>Multi-purpose exfoliator for face, body, underarms & scalp</li><li>Delivers an optimal concentration of 8% Glycolic Acid in the free acid form to promote effective exfoliation and natural cell turnover. The free acid form represents how much acid is available in a non-ionized form and is actually able to work effectively on the skin</li><li>Formulated with Bamboo Water that has regenerative properties that help soothe & calm skin. It also doubles up as an excellent hydrator</li></ul>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => glycolic-acid-08-exfoliating-liquid-150ml
            [seo_path] => 2685/2686/2821
            [average_rating] => 4.67
            [reviews_count] => 3
            [main_category] => 2821
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 2
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [776] => Array
                        (
                            [video_id] => 776
                            [video_type] => C
                            [company_id] => 0
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1685903400
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 812
                            [community_url] => https://www.kindlife.in/unleash-the-magic-of-glycolic-acid-with-beminimalist
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/812/dfa52e78b648d2b34a0051baffca55d9.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/812/0b45f3c206311e703f5a142637a9f196.mp4
                            [community_last_sync_timestamp] => 1713162379
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unleash the Magic of Glycolic Acid with @beminimalist
                            [description] => <p class="MsoNormal">Believe us, these hacks will leave your skin grateful in the future<span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">??</span></p>
<p class="MsoNormal">Get ready to be shaken by some mind-blowing skincare hacks using @beminimalist__'s <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@"><a id="product_24425" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=24425" data-value="24425">Glycolic Acid 08% Exfoliating Liquid - 150ml</a></span>&nbsp;Glycolic Acid that will totally slay! <br />Ditch the basic routines and add some epic glycolic acid magic to your skincare game! <span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">✨<br /></span>No joke, these hacks will make your skin thank you later! <span style="font-family: 'Segoe UI Emoji', sans-serif;">??</span></p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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] => Minimalist
            [ratting_count] => 3
        )

)

```
end of fxn
```

Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 24425
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => products
                            [value] => 3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282
                        )

                )

        )

)

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] => 1
    [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 ?: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  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  ((1  AND  products.product_id IN (24425)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

```
before end of oxn
```
```
Array
(
)
```

```
Array
(
)
```
```
end of fxn
```

Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 24425
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [condition_element] => 62
                            [operator] => nin
                            [condition] => feature
                            [value] => 49321,40971,38308
                            [value_name] => 
                        )

                )

        )

    [include_child_variations] => 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] => 1
    [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 ?: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_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 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  ((1  AND  products.product_id IN (24425)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

```
before end of oxn
```

Array
(
    [24425] => Array
        (
            [product_id] => 24425
            [product] => Glycolic Acid 08% Exfoliating Liquid - 150ml
            [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
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [776] => Array
                        (
                            [video_id] => 776
                            [video_type] => C
                            [company_id] => 0
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1685903400
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 812
                            [community_url] => https://www.kindlife.in/unleash-the-magic-of-glycolic-acid-with-beminimalist
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/812/dfa52e78b648d2b34a0051baffca55d9.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/812/0b45f3c206311e703f5a142637a9f196.mp4
                            [community_last_sync_timestamp] => 1713162379
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unleash the Magic of Glycolic Acid with @beminimalist
                            [description] => <p class="MsoNormal">Believe us, these hacks will leave your skin grateful in the future<span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">??</span></p>
<p class="MsoNormal">Get ready to be shaken by some mind-blowing skincare hacks using @beminimalist__'s <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@"><a id="product_24425" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=24425" data-value="24425">Glycolic Acid 08% Exfoliating Liquid - 150ml</a></span>&nbsp;Glycolic Acid that will totally slay! <br />Ditch the basic routines and add some epic glycolic acid magic to your skincare game! <span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">✨<br /></span>No joke, these hacks will make your skin thank you later! <span style="font-family: 'Segoe UI Emoji', sans-serif;">??</span></p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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] => Minimalist
        )

)

Array
(
    [24425] => Array
        (
            [product_id] => 24425
            [product] => Glycolic Acid 08% Exfoliating Liquid - 150ml
            [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
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [776] => Array
                        (
                            [video_id] => 776
                            [video_type] => C
                            [company_id] => 0
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1685903400
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 812
                            [community_url] => https://www.kindlife.in/unleash-the-magic-of-glycolic-acid-with-beminimalist
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/812/dfa52e78b648d2b34a0051baffca55d9.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/812/0b45f3c206311e703f5a142637a9f196.mp4
                            [community_last_sync_timestamp] => 1713162379
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unleash the Magic of Glycolic Acid with @beminimalist
                            [description] => <p class="MsoNormal">Believe us, these hacks will leave your skin grateful in the future<span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">??</span></p>
<p class="MsoNormal">Get ready to be shaken by some mind-blowing skincare hacks using @beminimalist__'s <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@"><a id="product_24425" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=24425" data-value="24425">Glycolic Acid 08% Exfoliating Liquid - 150ml</a></span>&nbsp;Glycolic Acid that will totally slay! <br />Ditch the basic routines and add some epic glycolic acid magic to your skincare game! <span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">✨<br /></span>No joke, these hacks will make your skin thank you later! <span style="font-family: 'Segoe UI Emoji', sans-serif;">??</span></p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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] => Minimalist
        )

)

```
end of fxn
```

Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 24425
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => categories
                            [value] => 274,275,276,277,278,281,282,284,285,287,288,290,296,432,508,579,620,621,745,1011,1096,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1214,1215,1216,1217,1218,1238,1270,1364,1632,1648,1703,1704,1977,2040,2116,2117,2118,2141,2191,2242,2250,2251,2322,2366,2421,2437,2439,2440,2444,2445,2456,2457,2458,2465,2468,2469,2472,2474,2476,2477,2481,2483,2485,2486,2489,2492,2497,2498,458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                        )

                )

        )

)

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] => 1
    [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 ?: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  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  ((1  AND  products.product_id IN (24425)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 1648, 274, 275, 276, 277, 278, 281, 282, 284, 285, 287, 288, 290, 296, 432, 2662, 508, 579, 1632, 620, 621, 745, 1011, 1096, 1218, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1214, 1215, 1216, 1217, 1238, 1270, 1364, 1704, 1703, 1977, 2040, 2116, 2117, 2118, 2141, 2191, 2242, 2661, 2250, 2251, 2488, 2421, 2322, 2366, 2656, 2437, 2438, 2439, 2440, 2645, 2659, 2444, 2445, 2663, 2658, 2654, 2453, 2643, 2644, 2456, 2457, 2458, 2653, 2651, 2652, 2463, 2465, 2640, 2468, 2469, 2649, 2650, 2472, 2473, 2474, 2646, 2476, 2477, 2648, 2684, 2481, 2660, 2642, 2483, 2485, 2486, 2489, 2647, 2641, 2492, 2494, 2655, 2497, 2498, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

```
before end of oxn
```
```
Array
(
)
```

```
Array
(
)
```
```
end of fxn
```

Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 24425
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => categories
                            [value] => 458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                        )

                )

        )

)

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] => 1
    [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 ?: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  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  ((1  AND  products.product_id IN (24425)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

```
before end of oxn
```
```
Array
(
)
```

```
Array
(
)
```
```
end of fxn
```

Array
(
    [show_master_products_only] => 
    [area] => C
    [features_hash] => 28-21614
    [items_per_page] => 48
    [sort_order] => asc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2821
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [cid] => 2821
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

    [subcats] => Y
    [runtime_company_id] => 0
)

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] => 24
    [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_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (var_val_73.variant_id IN (21614)) AND ?:categories.category_id IN (2821) 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.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY ?:product_sales.amount asc, products.product_id ASC  LIMIT 0, 48

```
before end of oxn
```

Array
(
    [24425] => Array
        (
            [product_id] => 24425
            [product] => Glycolic Acid 08% Exfoliating Liquid - 150ml
            [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] => 8906128100740
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 17
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1673957019
            [updated_timestamp] => 1750240342
            [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] => 2
            [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] => 474.000000
            [short_description] => <p>Deep Exfoliation For Even Skin Tone, Texture & Glow</p>
            [full_description] => <p>A multi-purpose exfoliator formulated with Glycolic Acid in free acid form (at 8%) to help in natural cell turnover and effective exfoliation. Combined with bamboo water for hydrating and soothing skin.</p>
<p><b>What makes it special</b></p>
<ul><li>Multi-purpose exfoliator for face, body, underarms & scalp</li><li>Delivers an optimal concentration of 8% Glycolic Acid in the free acid form to promote effective exfoliation and natural cell turnover. The free acid form represents how much acid is available in a non-ionized form and is actually able to work effectively on the skin</li><li>Formulated with Bamboo Water that has regenerative properties that help soothe & calm skin. It also doubles up as an excellent hydrator</li></ul>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => glycolic-acid-08-exfoliating-liquid-150ml
            [seo_path] => 2685/2686/2821
            [average_rating] => 4.67
            [reviews_count] => 3
            [main_category] => 2821
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 2
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [776] => Array
                        (
                            [video_id] => 776
                            [video_type] => C
                            [company_id] => 0
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1685903400
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 812
                            [community_url] => https://www.kindlife.in/unleash-the-magic-of-glycolic-acid-with-beminimalist
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/812/dfa52e78b648d2b34a0051baffca55d9.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/812/0b45f3c206311e703f5a142637a9f196.mp4
                            [community_last_sync_timestamp] => 1713162379
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unleash the Magic of Glycolic Acid with @beminimalist
                            [description] => <p class="MsoNormal">Believe us, these hacks will leave your skin grateful in the future<span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">??</span></p>
<p class="MsoNormal">Get ready to be shaken by some mind-blowing skincare hacks using @beminimalist__'s <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@"><a id="product_24425" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=24425" data-value="24425">Glycolic Acid 08% Exfoliating Liquid - 150ml</a></span>&nbsp;Glycolic Acid that will totally slay! <br />Ditch the basic routines and add some epic glycolic acid magic to your skincare game! <span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">✨<br /></span>No joke, these hacks will make your skin thank you later! <span style="font-family: 'Segoe UI Emoji', sans-serif;">??</span></p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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] => Minimalist
            [ratting_count] => 3
        )

)

Array
(
    [24425] => Array
        (
            [product_id] => 24425
            [product] => Glycolic Acid 08% Exfoliating Liquid - 150ml
            [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] => 8906128100740
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 17
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1673957019
            [updated_timestamp] => 1750240342
            [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] => 2
            [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] => 474.000000
            [short_description] => <p>Deep Exfoliation For Even Skin Tone, Texture & Glow</p>
            [full_description] => <p>A multi-purpose exfoliator formulated with Glycolic Acid in free acid form (at 8%) to help in natural cell turnover and effective exfoliation. Combined with bamboo water for hydrating and soothing skin.</p>
<p><b>What makes it special</b></p>
<ul><li>Multi-purpose exfoliator for face, body, underarms & scalp</li><li>Delivers an optimal concentration of 8% Glycolic Acid in the free acid form to promote effective exfoliation and natural cell turnover. The free acid form represents how much acid is available in a non-ionized form and is actually able to work effectively on the skin</li><li>Formulated with Bamboo Water that has regenerative properties that help soothe & calm skin. It also doubles up as an excellent hydrator</li></ul>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => glycolic-acid-08-exfoliating-liquid-150ml
            [seo_path] => 2685/2686/2821
            [average_rating] => 4.67
            [reviews_count] => 3
            [main_category] => 2821
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 2
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [776] => Array
                        (
                            [video_id] => 776
                            [video_type] => C
                            [company_id] => 0
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1685903400
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 812
                            [community_url] => https://www.kindlife.in/unleash-the-magic-of-glycolic-acid-with-beminimalist
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/812/dfa52e78b648d2b34a0051baffca55d9.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/812/0b45f3c206311e703f5a142637a9f196.mp4
                            [community_last_sync_timestamp] => 1713162379
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unleash the Magic of Glycolic Acid with @beminimalist
                            [description] => <p class="MsoNormal">Believe us, these hacks will leave your skin grateful in the future<span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">??</span></p>
<p class="MsoNormal">Get ready to be shaken by some mind-blowing skincare hacks using @beminimalist__'s <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@"><a id="product_24425" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&amp;product_id=24425" data-value="24425">Glycolic Acid 08% Exfoliating Liquid - 150ml</a></span>&nbsp;Glycolic Acid that will totally slay! <br />Ditch the basic routines and add some epic glycolic acid magic to your skincare game! <span style="font-family: 'Segoe UI Emoji',sans-serif; mso-bidi-font-family: 'Segoe UI Emoji';">✨<br /></span>No joke, these hacks will make your skin thank you later! <span style="font-family: 'Segoe UI Emoji', sans-serif;">??</span></p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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] => Minimalist
            [ratting_count] => 3
        )

)

```
end of fxn
```

Array
(
    [show_master_products_only] => 
    [area] => C
    [for_required_product] => 24425
    [include_child_variations] => 1
    [group_child_variations] => 
    [runtime_company_id] => 0
)

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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 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 products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 24425 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC

```
before end of oxn
```
```
Array
(
)
```

```
Array
(
)
```
```
end of fxn
```

Scrubs & Exfoliators:Cleansers:Skin

Ctrl+Alt+D - show/hide toolbar

Page generating time 0.7923 s
Memory usage 10 373.49 KB

Server

✖

Request

✖

Config

✖

SQL

✖

Cache queries

✖

Logging

✖

Templates

✖

Blocks

✖