Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => INR
    [items_per_page] => 12
    [sort_order] => asc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 875
    [page] => 6
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

    [subcats] => Y
    [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] => 9126,10370,10371,8899,8900,8901,8902,8903,9056,9057,9059,9060,9062,9063,11120,11163,11164,11179,11184,8911,8912,10650,10651,10652,10683,12083,12084,8262,10621,9112,9113,9114,9115,12492,12502,12504,8915,8920,8921,8969,9158,10616,10617,11146,35834,35835,35836,23379,9055,9058,9061,9133,9766,9809,9810,9912,12871,16117,16118,16119,16120,16121,17297,17399,17761,19969,21283,21788,23376,23377,23378,23380,23381,23382,23383,23627,24580,25450,25455,25456,26057,26058,29773,29774,29775,30223,31418,31436,31437,31449,31450,31452,31460,31461,31646,31857,33413,33628,33730,34891,35312,35349,35710,35717,35718,35722,35723,35725,35726,35727,35729,35731,35745,35746,35880,35887,35889,35898,35900,36174,36244,36318,36319,36336,36360,36361,36362,36363,36463,36464,36465,36611,36740,36741,36742
                        )

                )

        )

)

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_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 (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) AND (1 AND products.product_id IN (9126,10370,10371,8899,8900,8901,8902,8903,9056,9057,9059,9060,9062,9063,11120,11163,11164,11179,11184,8911,8912,10650,10651,10652,10683,12083,12084,8262,10621,9112,9113,9114,9115,12492,12502,12504,8915,8920,8921,8969,9158,10616,10617,11146,35834,35835,35836,23379,9055,9058,9061,9133,9766,9809,9810,9912,12871,16117,16118,16119,16120,16121,17297,17399,17761,19969,21283,21788,23376,23377,23378,23380,23381,23382,23383,23627,24580,25450,25455,25456,26057,26058,29773,29774,29775,30223,31418,31436,31437,31449,31450,31452,31460,31461,31646,31857,33413,33628,33730,34891,35312,35349,35710,35717,35718,35722,35723,35725,35726,35727,35729,35731,35745,35746,35880,35887,35889,35898,35900,36174,36244,36318,36319,36336,36360,36361,36362,36363,36463,36464,36465,36611,36740,36741,36742)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount asc, products.product_id ASC  LIMIT 60, 12

before end of oxn

Array
(
    [9115] => Array
        (
            [product_id] => 9115
            [product] => Skin Fuel - 90 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => WBN18
            [hsn_code] => 2106
            [status] => A
            [list_price] => 5994.00
            [amount] => 97
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1648624583
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => 2
            [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] => 5394.600000
            [short_description] => <p>Reduces dark circles & preserves elasticity</p>
            [full_description] => <p>Wellbeing Nutrition Skin Fuel is a Dermatologist Formulated Beauty Clear Skin Hydrator with Skin Peptides that support smooth, luminous, and nourished skin. This unique formula includes plant collagen boosters, Antioxidants, botanicals, and nutrients to enhance your body's collagen production naturally to keep skin firm, radiant and hydrated. Pure Japanese Collagen and OPITAC L-Glutathione protect skin fibers to preserve elasticity and suppleness for smoother, brighter skin and can reduce dark under-eye circles, leaving you looking rested and refreshed. Hyaluronic acid and Aloe Vera naturally hydrate skin, while powerful antioxidants vitamins C, E, and Matcha Green tea protect the skin. Antioxidants like Blueberry, Goji Berry, and Grapeseed protect the skin from damage, free radicals, and pollution for a brighter inner glow.</p>
<p>Products will be shipped with in a week.</p>
            [category_ids] => Array
                (
                    [0] => 2682
                )

            [seo_name] => skin-fuel-90-tabs
            [seo_path] => 2669/2678/2682
            [average_rating] => 5.00
            [reviews_count] => 4
            [main_category] => 2682
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => 2
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
            [ratting_count] => 4
        )

)

Array
(
    [9115] => Array
        (
            [product_id] => 9115
            [product] => Skin Fuel - 90 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => WBN18
            [hsn_code] => 2106
            [status] => A
            [list_price] => 5994.00
            [amount] => 97
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1648624583
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => 2
            [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] => 5394.600000
            [short_description] => <p>Reduces dark circles & preserves elasticity</p>
            [full_description] => <p>Wellbeing Nutrition Skin Fuel is a Dermatologist Formulated Beauty Clear Skin Hydrator with Skin Peptides that support smooth, luminous, and nourished skin. This unique formula includes plant collagen boosters, Antioxidants, botanicals, and nutrients to enhance your body's collagen production naturally to keep skin firm, radiant and hydrated. Pure Japanese Collagen and OPITAC L-Glutathione protect skin fibers to preserve elasticity and suppleness for smoother, brighter skin and can reduce dark under-eye circles, leaving you looking rested and refreshed. Hyaluronic acid and Aloe Vera naturally hydrate skin, while powerful antioxidants vitamins C, E, and Matcha Green tea protect the skin. Antioxidants like Blueberry, Goji Berry, and Grapeseed protect the skin from damage, free radicals, and pollution for a brighter inner glow.</p>
<p>Products will be shipped with in a week.</p>
            [category_ids] => Array
                (
                    [0] => 2682
                )

            [seo_name] => skin-fuel-90-tabs
            [seo_path] => 2669/2678/2682
            [average_rating] => 5.00
            [reviews_count] => 4
            [main_category] => 2682
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => 2
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
            [ratting_count] => 4
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [group_child_variations] => 
    [include_child_variations] => 1
    [skip_rating] => 1
    [load_products_extra_data] => 
    [sort_by] => null
    [variation_group_id] => Array
        (
            [391] => 391
        )

    [get_amount] => 1
    [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, products.amount, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, variation_group_products.group_id AS variation_group_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'  INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id 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 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 variation_group_products.group_id IN (391) 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 NULL asc 

before end of oxn

Array
(
    [9112] => Array
        (
            [product_id] => 9112
            [amount] => 586
            [product] => Skin Fuel - 15 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9113] => Array
        (
            [product_id] => 9113
            [amount] => 293
            [product] => Skin Fuel - 30 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9115] => Array
        (
            [product_id] => 9115
            [amount] => 97
            [product] => Skin Fuel - 90 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9114] => Array
        (
            [product_id] => 9114
            [amount] => 146
            [product] => Skin Fuel - 60 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

)

Array
(
    [9112] => Array
        (
            [product_id] => 9112
            [amount] => 586
            [product] => Skin Fuel - 15 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9113] => Array
        (
            [product_id] => 9113
            [amount] => 293
            [product] => Skin Fuel - 30 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9115] => Array
        (
            [product_id] => 9115
            [amount] => 97
            [product] => Skin Fuel - 90 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9114] => Array
        (
            [product_id] => 9114
            [amount] => 146
            [product] => Skin Fuel - 60 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => INR
    [items_per_page] => 12
    [sort_order] => asc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 875
    [page] => 6
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

    [subcats] => Y
    [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] => 9126,10370,10371,8899,8900,8901,8902,8903,9056,9057,9059,9060,9062,9063,11120,11163,11164,11179,11184,8911,8912,10650,10651,10652,10683,12083,12084,8262,10621,9112,9113,9114,9115,12492,12502,12504,8915,8920,8921,8969,9158,10616,10617,11146,35834,35835,35836,23379,9055,9058,9061,9133,9766,9809,9810,9912,12871,16117,16118,16119,16120,16121,17297,17399,17761,19969,21283,21788,23376,23377,23378,23380,23381,23382,23383,23627,24580,25450,25455,25456,26057,26058,29773,29774,29775,30223,31418,31436,31437,31449,31450,31452,31460,31461,31646,31857,33413,33628,33730,34891,35312,35349,35710,35717,35718,35722,35723,35725,35726,35727,35729,35731,35745,35746,35880,35887,35889,35898,35900,36174,36244,36318,36319,36336,36360,36361,36362,36363,36463,36464,36465,36611,36740,36741,36742
                        )

                )

        )

)

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_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 (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) AND (1 AND products.product_id IN (9126,10370,10371,8899,8900,8901,8902,8903,9056,9057,9059,9060,9062,9063,11120,11163,11164,11179,11184,8911,8912,10650,10651,10652,10683,12083,12084,8262,10621,9112,9113,9114,9115,12492,12502,12504,8915,8920,8921,8969,9158,10616,10617,11146,35834,35835,35836,23379,9055,9058,9061,9133,9766,9809,9810,9912,12871,16117,16118,16119,16120,16121,17297,17399,17761,19969,21283,21788,23376,23377,23378,23380,23381,23382,23383,23627,24580,25450,25455,25456,26057,26058,29773,29774,29775,30223,31418,31436,31437,31449,31450,31452,31460,31461,31646,31857,33413,33628,33730,34891,35312,35349,35710,35717,35718,35722,35723,35725,35726,35727,35729,35731,35745,35746,35880,35887,35889,35898,35900,36174,36244,36318,36319,36336,36360,36361,36362,36363,36463,36464,36465,36611,36740,36741,36742)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount asc, products.product_id ASC  LIMIT 60, 12

before end of oxn

Array
(
    [9115] => Array
        (
            [product_id] => 9115
            [product] => Skin Fuel - 90 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => WBN18
            [hsn_code] => 2106
            [status] => A
            [list_price] => 5994.00
            [amount] => 97
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1648624583
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => 2
            [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] => 5394.600000
            [short_description] => <p>Reduces dark circles & preserves elasticity</p>
            [full_description] => <p>Wellbeing Nutrition Skin Fuel is a Dermatologist Formulated Beauty Clear Skin Hydrator with Skin Peptides that support smooth, luminous, and nourished skin. This unique formula includes plant collagen boosters, Antioxidants, botanicals, and nutrients to enhance your body's collagen production naturally to keep skin firm, radiant and hydrated. Pure Japanese Collagen and OPITAC L-Glutathione protect skin fibers to preserve elasticity and suppleness for smoother, brighter skin and can reduce dark under-eye circles, leaving you looking rested and refreshed. Hyaluronic acid and Aloe Vera naturally hydrate skin, while powerful antioxidants vitamins C, E, and Matcha Green tea protect the skin. Antioxidants like Blueberry, Goji Berry, and Grapeseed protect the skin from damage, free radicals, and pollution for a brighter inner glow.</p>
<p>Products will be shipped with in a week.</p>
            [category_ids] => Array
                (
                    [0] => 2682
                )

            [seo_name] => skin-fuel-90-tabs
            [seo_path] => 2669/2678/2682
            [average_rating] => 5.00
            [reviews_count] => 4
            [main_category] => 2682
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => 2
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
            [ratting_count] => 4
        )

)

Array
(
    [9115] => Array
        (
            [product_id] => 9115
            [product] => Skin Fuel - 90 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => WBN18
            [hsn_code] => 2106
            [status] => A
            [list_price] => 5994.00
            [amount] => 97
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1648624583
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => 2
            [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] => 5394.600000
            [short_description] => <p>Reduces dark circles & preserves elasticity</p>
            [full_description] => <p>Wellbeing Nutrition Skin Fuel is a Dermatologist Formulated Beauty Clear Skin Hydrator with Skin Peptides that support smooth, luminous, and nourished skin. This unique formula includes plant collagen boosters, Antioxidants, botanicals, and nutrients to enhance your body's collagen production naturally to keep skin firm, radiant and hydrated. Pure Japanese Collagen and OPITAC L-Glutathione protect skin fibers to preserve elasticity and suppleness for smoother, brighter skin and can reduce dark under-eye circles, leaving you looking rested and refreshed. Hyaluronic acid and Aloe Vera naturally hydrate skin, while powerful antioxidants vitamins C, E, and Matcha Green tea protect the skin. Antioxidants like Blueberry, Goji Berry, and Grapeseed protect the skin from damage, free radicals, and pollution for a brighter inner glow.</p>
<p>Products will be shipped with in a week.</p>
            [category_ids] => Array
                (
                    [0] => 2682
                )

            [seo_name] => skin-fuel-90-tabs
            [seo_path] => 2669/2678/2682
            [average_rating] => 5.00
            [reviews_count] => 4
            [main_category] => 2682
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => 2
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
            [ratting_count] => 4
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [for_required_product] => 9115
    [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 = 9115 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 

before end of oxn

Array
(
)

Array
(
)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [group_child_variations] => 
    [include_child_variations] => 1
    [skip_rating] => 1
    [load_products_extra_data] => 
    [sort_by] => null
    [variation_group_id] => Array
        (
            [391] => 391
        )

    [get_amount] => 1
    [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, products.amount, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, variation_group_products.group_id AS variation_group_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'  INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id 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 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 variation_group_products.group_id IN (391) 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 NULL asc 

before end of oxn

Array
(
    [9112] => Array
        (
            [product_id] => 9112
            [amount] => 586
            [product] => Skin Fuel - 15 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9113] => Array
        (
            [product_id] => 9113
            [amount] => 293
            [product] => Skin Fuel - 30 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9115] => Array
        (
            [product_id] => 9115
            [amount] => 97
            [product] => Skin Fuel - 90 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9114] => Array
        (
            [product_id] => 9114
            [amount] => 146
            [product] => Skin Fuel - 60 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

)

Array
(
    [9112] => Array
        (
            [product_id] => 9112
            [amount] => 586
            [product] => Skin Fuel - 15 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9113] => Array
        (
            [product_id] => 9113
            [amount] => 293
            [product] => Skin Fuel - 30 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9115] => Array
        (
            [product_id] => 9115
            [amount] => 97
            [product] => Skin Fuel - 90 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

    [9114] => Array
        (
            [product_id] => 9114
            [amount] => 146
            [product] => Skin Fuel - 60 Tabs
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [variation_group_id] => 391
            [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
                (
                    [912] => Array
                        (
                            [video_id] => 912
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1698604200
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1035
                            [community_url] => https://www.kindlife.in/sipping-collagen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1035/dd39e6e6aaeca3a169d87d8e236f2e9f.mp4
                            [community_last_sync_timestamp] => 1713163217
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Skip the Spoon! Sip Your Way to Younger Skin with Wellbeing's Drinkable Skincare!
                            [description] => <p>Forget potions and powders!  Wellbeing Nutrition's Drinkable Skincare is the fun and easy way to get your collagen fix.  Just pop a fizzy tablet in water, and you're on your way to radiant, youthful-looking skin.  No mess, no fuss, just delicious hydration and beauty benefits in every sip! Say hello to smoother, younger-looking skin, all while enjoying a tasty beverage!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [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] => Wellbeing Nutrition
        )

)

end of fxn