Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => USD
    [features_hash] => 28-34540
    [sort_order] => desc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2706
    [save_view_results] => product_id
    [items_per_page] => 24
    [sort_by] => bestsellers
    [cid] => 2706
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

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

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

    [custom_extend] => Array
        (
        )

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

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

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

    [get_frontend_urls] => 
    [items_per_page] => 24
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

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

before end of oxn

Array
(
    [10736] => Array
        (
            [product_id] => 10736
            [product] => Mama Cica Dark Spot Correcting Ampoule | Korean Skin care - 30gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => #8904320717582
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 1
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1652076058
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => 5
            [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] => 664.050000
            [short_description] => Removes dark spots, pimples, dullness and irritation
            [full_description] => <p>1. Tackles blemishes and fades dark spots: a quick-absorbing, concentrated serum packed with potent actives that target skin concerns such as dark spots, uneven skin tone, and dullness. This ampoule has lotus root which is a great source of vitamin c, it brightens the complexion and fades dark spots. </p>
<p>2. Prevents acne: this ampoule also has cica and tamanu oil both of which are known to strengthen the skin barrier, heal pimples, and control oiliness. They also soothe troubled and damaged skin.</p>
<p>3. Nourishes: this active concentrate relieves dry and flaky skin. Its formulated with hyaluronic acid which is known for its moisture retention properties. It delivers intense hydration to deeper layers of skin, leaving you with visibly plump and soft skin. This ampoule also has Korean ginseng which helps to brighten skin, reduce fine lines and enhance skin firmness.</p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p>  <br /><strong>How To Use:-</strong></p>
<p> Use 2-3 times a week. Use the dropper to pour 3-4 drops of the ampoule on the areas of concern and gently press onto the skin. Let the product fully absorb into the skin before moving on to the next step of your skincare routine.</p>
            [category_ids] => Array
                (
                    [0] => 2706
                )

            [position] => 0
            [seo_name] => mama-cica-dark-spot-correcting-ampoule-korean-skin-care-30gm
            [seo_path] => 2685/2705/2706
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2706
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => 5
            [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
                (
                )

            [brand_name] => Quench Botanics
            [ratting_count] => 1
        )

)

Array
(
    [10736] => Array
        (
            [product_id] => 10736
            [product] => Mama Cica Dark Spot Correcting Ampoule | Korean Skin care - 30gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => #8904320717582
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 1
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1652076058
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => 5
            [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] => 664.050000
            [short_description] => Removes dark spots, pimples, dullness and irritation
            [full_description] => <p>1. Tackles blemishes and fades dark spots: a quick-absorbing, concentrated serum packed with potent actives that target skin concerns such as dark spots, uneven skin tone, and dullness. This ampoule has lotus root which is a great source of vitamin c, it brightens the complexion and fades dark spots. </p>
<p>2. Prevents acne: this ampoule also has cica and tamanu oil both of which are known to strengthen the skin barrier, heal pimples, and control oiliness. They also soothe troubled and damaged skin.</p>
<p>3. Nourishes: this active concentrate relieves dry and flaky skin. Its formulated with hyaluronic acid which is known for its moisture retention properties. It delivers intense hydration to deeper layers of skin, leaving you with visibly plump and soft skin. This ampoule also has Korean ginseng which helps to brighten skin, reduce fine lines and enhance skin firmness.</p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p>  <br /><strong>How To Use:-</strong></p>
<p> Use 2-3 times a week. Use the dropper to pour 3-4 drops of the ampoule on the areas of concern and gently press onto the skin. Let the product fully absorb into the skin before moving on to the next step of your skincare routine.</p>
            [category_ids] => Array
                (
                    [0] => 2706
                )

            [position] => 0
            [seo_name] => mama-cica-dark-spot-correcting-ampoule-korean-skin-care-30gm
            [seo_path] => 2685/2705/2706
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2706
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => 5
            [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
                (
                )

            [brand_name] => Quench Botanics
            [ratting_count] => 1
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => USD
    [features_hash] => 28-34540
    [sort_order] => desc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2706
    [save_view_results] => product_id
    [items_per_page] => 24
    [sort_by] => bestsellers
    [cid] => 2706
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

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

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

    [custom_extend] => Array
        (
        )

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

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

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

    [get_frontend_urls] => 
    [items_per_page] => 24
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

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

before end of oxn

Array
(
    [10736] => Array
        (
            [product_id] => 10736
            [product] => Mama Cica Dark Spot Correcting Ampoule | Korean Skin care - 30gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => #8904320717582
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 1
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1652076058
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => 5
            [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] => 664.050000
            [short_description] => Removes dark spots, pimples, dullness and irritation
            [full_description] => <p>1. Tackles blemishes and fades dark spots: a quick-absorbing, concentrated serum packed with potent actives that target skin concerns such as dark spots, uneven skin tone, and dullness. This ampoule has lotus root which is a great source of vitamin c, it brightens the complexion and fades dark spots. </p>
<p>2. Prevents acne: this ampoule also has cica and tamanu oil both of which are known to strengthen the skin barrier, heal pimples, and control oiliness. They also soothe troubled and damaged skin.</p>
<p>3. Nourishes: this active concentrate relieves dry and flaky skin. Its formulated with hyaluronic acid which is known for its moisture retention properties. It delivers intense hydration to deeper layers of skin, leaving you with visibly plump and soft skin. This ampoule also has Korean ginseng which helps to brighten skin, reduce fine lines and enhance skin firmness.</p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p>  <br /><strong>How To Use:-</strong></p>
<p> Use 2-3 times a week. Use the dropper to pour 3-4 drops of the ampoule on the areas of concern and gently press onto the skin. Let the product fully absorb into the skin before moving on to the next step of your skincare routine.</p>
            [category_ids] => Array
                (
                    [0] => 2706
                )

            [position] => 0
            [seo_name] => mama-cica-dark-spot-correcting-ampoule-korean-skin-care-30gm
            [seo_path] => 2685/2705/2706
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2706
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => 5
            [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
                (
                )

            [brand_name] => Quench Botanics
            [ratting_count] => 1
        )

)

Array
(
    [10736] => Array
        (
            [product_id] => 10736
            [product] => Mama Cica Dark Spot Correcting Ampoule | Korean Skin care - 30gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => #8904320717582
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 1
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1652076058
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => 5
            [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] => 664.050000
            [short_description] => Removes dark spots, pimples, dullness and irritation
            [full_description] => <p>1. Tackles blemishes and fades dark spots: a quick-absorbing, concentrated serum packed with potent actives that target skin concerns such as dark spots, uneven skin tone, and dullness. This ampoule has lotus root which is a great source of vitamin c, it brightens the complexion and fades dark spots. </p>
<p>2. Prevents acne: this ampoule also has cica and tamanu oil both of which are known to strengthen the skin barrier, heal pimples, and control oiliness. They also soothe troubled and damaged skin.</p>
<p>3. Nourishes: this active concentrate relieves dry and flaky skin. Its formulated with hyaluronic acid which is known for its moisture retention properties. It delivers intense hydration to deeper layers of skin, leaving you with visibly plump and soft skin. This ampoule also has Korean ginseng which helps to brighten skin, reduce fine lines and enhance skin firmness.</p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p>  <br /><strong>How To Use:-</strong></p>
<p> Use 2-3 times a week. Use the dropper to pour 3-4 drops of the ampoule on the areas of concern and gently press onto the skin. Let the product fully absorb into the skin before moving on to the next step of your skincare routine.</p>
            [category_ids] => Array
                (
                    [0] => 2706
                )

            [position] => 0
            [seo_name] => mama-cica-dark-spot-correcting-ampoule-korean-skin-care-30gm
            [seo_path] => 2685/2705/2706
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2706
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => 5
            [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
                (
                )

            [brand_name] => Quench Botanics
            [ratting_count] => 1
        )

)

end of fxn

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

before end of oxn

Array
(
)

Array
(
)

end of fxn