Array
(
    [show_master_products_only] => 
    [area] => C
    [features_hash] => 28-20933
    [sort_order] => asc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2222
    [save_view_results] => product_id
    [items_per_page] => 24
    [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] => 2193,2195,3369,3996,3999,4060,4061,4062,4063,4064,4065,4066,4067,4068,4069,4070,4071,4072,4721,4722,4723,4724,4725,4726,4769,4770,4890,4891,4964,4965,4967,4969,4982,4983,4984,5808,5809,5810,5811,5836,5837,5838,6202,6203,6204,6404,6406,6408,6410,6423,6424,6425,6426,6639,6646,6648,6649,6655,6656,6658,6662,6663,6664,6688,6689,6749,6750,6751,6753,7252,7253,7419,7521,7522,7523,7524,10716,10717,10718,12345,12346,12347,12348,12658,12659,12660,12661,12662,12663,12665,13743,13746,14085,14086,14167,15057,15846,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,18520,18521,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18533,19958,19959,19960,19961,19962,19963,19964,19965,19966,19967,21055,21056,21057,21058,21059,21879,21880,21881,21882,21883,21884,21885,21887,21888,21889,21890,21891,21892,21893,21894,21895,21896,21897,21898,21899,21900,21901,21902,21903,21904,21905,21906,21907,21908,21909,21911,21912,21913,21914,21915,21916,24684,24685,24686,24687,25194,25671,28497,28498,28499,28500,28501,28502,28503,28504,28505,28506,28507,28508,28509,30042,30419,30420,30421,30422,30423,30424,30425,31023,31293,31294,31502,31503,31504,31505,31506,31507,32068,32069,32651,32653,32656,32657,34085,34086,34087,34088,34089,34090,34446,34853,35132,35735,35822,36031,36032,36033,36034,36045,36553
                        )

                )

        )

)

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 (20933)) 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 (2193,2195,3369,3996,3999,4060,4061,4062,4063,4064,4065,4066,4067,4068,4069,4070,4071,4072,4721,4722,4723,4724,4725,4726,4769,4770,4890,4891,4964,4965,4967,4969,4982,4983,4984,5808,5809,5810,5811,5836,5837,5838,6202,6203,6204,6404,6406,6408,6410,6423,6424,6425,6426,6639,6646,6648,6649,6655,6656,6658,6662,6663,6664,6688,6689,6749,6750,6751,6753,7252,7253,7419,7521,7522,7523,7524,10716,10717,10718,12345,12346,12347,12348,12658,12659,12660,12661,12662,12663,12665,13743,13746,14085,14086,14167,15057,15846,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,18520,18521,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18533,19958,19959,19960,19961,19962,19963,19964,19965,19966,19967,21055,21056,21057,21058,21059,21879,21880,21881,21882,21883,21884,21885,21887,21888,21889,21890,21891,21892,21893,21894,21895,21896,21897,21898,21899,21900,21901,21902,21903,21904,21905,21906,21907,21908,21909,21911,21912,21913,21914,21915,21916,24684,24685,24686,24687,25194,25671,28497,28498,28499,28500,28501,28502,28503,28504,28505,28506,28507,28508,28509,30042,30419,30420,30421,30422,30423,30424,30425,31023,31293,31294,31502,31503,31504,31505,31506,31507,32068,32069,32651,32653,32656,32657,34085,34086,34087,34088,34089,34090,34446,34853,35132,35735,35822,36031,36032,36033,36034,36045,36553)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount asc, products.product_id ASC  LIMIT 0, 24

before end of oxn

Array
(
    [4890] => Array
        (
            [product_id] => 4890
            [product] => Gluten Free Crackers - 150g
            [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] => MOSB31
            [hsn_code] => 3304
            [status] => A
            [list_price] => 285.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1638886785
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 270.750000
            [short_description] => Snack for protein & calcium boost
            [full_description] => These gluten free crackers honour the large variety of flours that Indians have conventionally been consuming. Making chickpea flour the hero of this cracker, we also love how rosemary, a foreign herb pairs so well with our conventional besan like chickpea flour.
            [category_ids] => Array
                (
                    [0] => 1704
                    [1] => 2658
                )

            [seo_name] => gluten-free-crackers-150g
            [seo_path] => 458/2654/2658
            [main_category] => 2658
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

    [14085] => Array
        (
            [product_id] => 14085
            [product] => Nut and Seed Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => Brand_The Cinnamon Kitchen_20
            [hsn_code] => 3304
            [status] => A
            [list_price] => 380.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658121504
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 380.000000
            [short_description] => Ideal to aid in digestion
            [full_description] => <p>Crackers made using nuts and seeds and seasoned with salt. These contain psyllium husk (isabgol) to aid digestion.</p>
            [category_ids] => Array
                (
                    [0] => 2648
                )

            [seo_name] => nut-and-seed-crackers-150-gm
            [seo_path] => 458/2646/2648
            [main_category] => 2648
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

    [14086] => Array
        (
            [product_id] => 14086
            [product] => Cheddar Cheese Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => Brand_The Cinnamon Kitchen_21
            [hsn_code] => 3304
            [status] => A
            [list_price] => 420.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658121504
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 420.000000
            [short_description] => Ideal to aid in digestion
            [full_description] => <p>Flourless crackers made using nuts, seeds and sharp cheddar seasoned with oregano. Great on cheeseboards, with wine or even by themselves</p>
            [category_ids] => Array
                (
                    [0] => 2658
                )

            [seo_name] => cheddar-cheese-crackers-150-gm
            [seo_path] => 458/2654/2658
            [main_category] => 2658
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

    [4891] => Array
        (
            [product_id] => 4891
            [product] => Flax Seed Crunch - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 57
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => MOSB32
            [hsn_code] => 3304
            [status] => A
            [list_price] => 285.00
            [amount] => 999
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1638886785
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 270.750000
            [short_description] => Superfood Boost & has essential nutrients
            [full_description] => Made with all things good, our Flax seed Crackers contain millet flour, wheat bran, flax seeds and oats goodness. Flax seeds which is our main ingredient in these crackers is a superfood rich in fiber and various vitamins and minerals.The nutrients in it help lower the risk of diabetes, cancer, and heart disease. Flax seeds also help lower cholesterol, moderate blood sugar and maintaining a healthy gut by providing fiber.
            [category_ids] => Array
                (
                    [0] => 1704
                    [1] => 2648
                )

            [seo_name] => flax-seed-crunch-150g
            [seo_path] => 458/2646/2648
            [main_category] => 2648
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

)

Array
(
    [4890] => Array
        (
            [product_id] => 4890
            [product] => Gluten Free Crackers - 150g
            [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] => MOSB31
            [hsn_code] => 3304
            [status] => A
            [list_price] => 285.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1638886785
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 270.750000
            [short_description] => Snack for protein & calcium boost
            [full_description] => These gluten free crackers honour the large variety of flours that Indians have conventionally been consuming. Making chickpea flour the hero of this cracker, we also love how rosemary, a foreign herb pairs so well with our conventional besan like chickpea flour.
            [category_ids] => Array
                (
                    [0] => 1704
                    [1] => 2658
                )

            [seo_name] => gluten-free-crackers-150g
            [seo_path] => 458/2654/2658
            [main_category] => 2658
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

    [14085] => Array
        (
            [product_id] => 14085
            [product] => Nut and Seed Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => Brand_The Cinnamon Kitchen_20
            [hsn_code] => 3304
            [status] => A
            [list_price] => 380.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658121504
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 380.000000
            [short_description] => Ideal to aid in digestion
            [full_description] => <p>Crackers made using nuts and seeds and seasoned with salt. These contain psyllium husk (isabgol) to aid digestion.</p>
            [category_ids] => Array
                (
                    [0] => 2648
                )

            [seo_name] => nut-and-seed-crackers-150-gm
            [seo_path] => 458/2646/2648
            [main_category] => 2648
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

    [14086] => Array
        (
            [product_id] => 14086
            [product] => Cheddar Cheese Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => Brand_The Cinnamon Kitchen_21
            [hsn_code] => 3304
            [status] => A
            [list_price] => 420.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658121504
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 420.000000
            [short_description] => Ideal to aid in digestion
            [full_description] => <p>Flourless crackers made using nuts, seeds and sharp cheddar seasoned with oregano. Great on cheeseboards, with wine or even by themselves</p>
            [category_ids] => Array
                (
                    [0] => 2658
                )

            [seo_name] => cheddar-cheese-crackers-150-gm
            [seo_path] => 458/2654/2658
            [main_category] => 2658
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

    [4891] => Array
        (
            [product_id] => 4891
            [product] => Flax Seed Crunch - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 57
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => MOSB32
            [hsn_code] => 3304
            [status] => A
            [list_price] => 285.00
            [amount] => 999
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1638886785
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 270.750000
            [short_description] => Superfood Boost & has essential nutrients
            [full_description] => Made with all things good, our Flax seed Crackers contain millet flour, wheat bran, flax seeds and oats goodness. Flax seeds which is our main ingredient in these crackers is a superfood rich in fiber and various vitamins and minerals.The nutrients in it help lower the risk of diabetes, cancer, and heart disease. Flax seeds also help lower cholesterol, moderate blood sugar and maintaining a healthy gut by providing fiber.
            [category_ids] => Array
                (
                    [0] => 1704
                    [1] => 2648
                )

            [seo_name] => flax-seed-crunch-150g
            [seo_path] => 458/2646/2648
            [main_category] => 2648
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (4890)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
)

Array
(
)

end of fxn

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

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

                )

        )

    [include_child_variations] => 1
)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (4890)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
    [4890] => Array
        (
            [product_id] => 4890
            [product] => Gluten Free Crackers - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

)

Array
(
    [4890] => Array
        (
            [product_id] => 4890
            [product] => Gluten Free Crackers - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

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

before end of oxn

Array
(
    [4890] => Array
        (
            [product_id] => 4890
            [product] => Gluten Free Crackers - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

)

Array
(
    [4890] => Array
        (
            [product_id] => 4890
            [product] => Gluten Free Crackers - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (4890)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
    [4890] => Array
        (
            [product_id] => 4890
            [product] => Gluten Free Crackers - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

)

Array
(
    [4890] => Array
        (
            [product_id] => 4890
            [product] => Gluten Free Crackers - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (14085)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
)

Array
(
)

end of fxn

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

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

                )

        )

    [include_child_variations] => 1
)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (14085)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
    [14085] => Array
        (
            [product_id] => 14085
            [product] => Nut and Seed Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

Array
(
    [14085] => Array
        (
            [product_id] => 14085
            [product] => Nut and Seed Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

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

before end of oxn

Array
(
    [14085] => Array
        (
            [product_id] => 14085
            [product] => Nut and Seed Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

Array
(
    [14085] => Array
        (
            [product_id] => 14085
            [product] => Nut and Seed Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (14085)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
    [14085] => Array
        (
            [product_id] => 14085
            [product] => Nut and Seed Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

Array
(
    [14085] => Array
        (
            [product_id] => 14085
            [product] => Nut and Seed Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (14086)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
)

Array
(
)

end of fxn

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

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

                )

        )

    [include_child_variations] => 1
)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (14086)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
    [14086] => Array
        (
            [product_id] => 14086
            [product] => Cheddar Cheese Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

Array
(
    [14086] => Array
        (
            [product_id] => 14086
            [product] => Cheddar Cheese Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

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

before end of oxn

Array
(
    [14086] => Array
        (
            [product_id] => 14086
            [product] => Cheddar Cheese Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

Array
(
    [14086] => Array
        (
            [product_id] => 14086
            [product] => Cheddar Cheese Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (14086)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
    [14086] => Array
        (
            [product_id] => 14086
            [product] => Cheddar Cheese Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

Array
(
    [14086] => Array
        (
            [product_id] => 14086
            [product] => Cheddar Cheese Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [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
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (4891)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
)

Array
(
)

end of fxn

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

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

                )

        )

    [include_child_variations] => 1
)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (4891)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
    [4891] => Array
        (
            [product_id] => 4891
            [product] => Flax Seed Crunch - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 57
            [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
                (
                )

            [brand_name] => MOS Bakery
        )

)

Array
(
    [4891] => Array
        (
            [product_id] => 4891
            [product] => Flax Seed Crunch - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 57
            [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
                (
                )

            [brand_name] => MOS Bakery
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

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

before end of oxn

Array
(
    [4891] => Array
        (
            [product_id] => 4891
            [product] => Flax Seed Crunch - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 57
            [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
                (
                )

            [brand_name] => MOS Bakery
        )

)

Array
(
    [4891] => Array
        (
            [product_id] => 4891
            [product] => Flax Seed Crunch - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 57
            [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
                (
                )

            [brand_name] => MOS Bakery
        )

)

end of fxn

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

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

                )

        )

)

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

    [custom_extend] => Array
        (
        )

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

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

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

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

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (4891)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

before end of oxn

Array
(
    [4891] => Array
        (
            [product_id] => 4891
            [product] => Flax Seed Crunch - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 57
            [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
                (
                )

            [brand_name] => MOS Bakery
        )

)

Array
(
    [4891] => Array
        (
            [product_id] => 4891
            [product] => Flax Seed Crunch - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 57
            [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
                (
                )

            [brand_name] => MOS Bakery
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [features_hash] => 28-20933
    [sort_order] => asc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2222
    [save_view_results] => product_id
    [items_per_page] => 24
    [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] => 2193,2195,3369,3996,3999,4060,4061,4062,4063,4064,4065,4066,4067,4068,4069,4070,4071,4072,4721,4722,4723,4724,4725,4726,4769,4770,4890,4891,4964,4965,4967,4969,4982,4983,4984,5808,5809,5810,5811,5836,5837,5838,6202,6203,6204,6404,6406,6408,6410,6423,6424,6425,6426,6639,6646,6648,6649,6655,6656,6658,6662,6663,6664,6688,6689,6749,6750,6751,6753,7252,7253,7419,7521,7522,7523,7524,10716,10717,10718,12345,12346,12347,12348,12658,12659,12660,12661,12662,12663,12665,13743,13746,14085,14086,14167,15057,15846,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,18520,18521,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18533,19958,19959,19960,19961,19962,19963,19964,19965,19966,19967,21055,21056,21057,21058,21059,21879,21880,21881,21882,21883,21884,21885,21887,21888,21889,21890,21891,21892,21893,21894,21895,21896,21897,21898,21899,21900,21901,21902,21903,21904,21905,21906,21907,21908,21909,21911,21912,21913,21914,21915,21916,24684,24685,24686,24687,25194,25671,28497,28498,28499,28500,28501,28502,28503,28504,28505,28506,28507,28508,28509,30042,30419,30420,30421,30422,30423,30424,30425,31023,31293,31294,31502,31503,31504,31505,31506,31507,32068,32069,32651,32653,32656,32657,34085,34086,34087,34088,34089,34090,34446,34853,35132,35735,35822,36031,36032,36033,36034,36045,36553
                        )

                )

        )

)

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 (20933)) 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 (2193,2195,3369,3996,3999,4060,4061,4062,4063,4064,4065,4066,4067,4068,4069,4070,4071,4072,4721,4722,4723,4724,4725,4726,4769,4770,4890,4891,4964,4965,4967,4969,4982,4983,4984,5808,5809,5810,5811,5836,5837,5838,6202,6203,6204,6404,6406,6408,6410,6423,6424,6425,6426,6639,6646,6648,6649,6655,6656,6658,6662,6663,6664,6688,6689,6749,6750,6751,6753,7252,7253,7419,7521,7522,7523,7524,10716,10717,10718,12345,12346,12347,12348,12658,12659,12660,12661,12662,12663,12665,13743,13746,14085,14086,14167,15057,15846,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,18520,18521,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18533,19958,19959,19960,19961,19962,19963,19964,19965,19966,19967,21055,21056,21057,21058,21059,21879,21880,21881,21882,21883,21884,21885,21887,21888,21889,21890,21891,21892,21893,21894,21895,21896,21897,21898,21899,21900,21901,21902,21903,21904,21905,21906,21907,21908,21909,21911,21912,21913,21914,21915,21916,24684,24685,24686,24687,25194,25671,28497,28498,28499,28500,28501,28502,28503,28504,28505,28506,28507,28508,28509,30042,30419,30420,30421,30422,30423,30424,30425,31023,31293,31294,31502,31503,31504,31505,31506,31507,32068,32069,32651,32653,32656,32657,34085,34086,34087,34088,34089,34090,34446,34853,35132,35735,35822,36031,36032,36033,36034,36045,36553)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount asc, products.product_id ASC  LIMIT 0, 24

before end of oxn

Array
(
    [4890] => Array
        (
            [product_id] => 4890
            [product] => Gluten Free Crackers - 150g
            [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] => MOSB31
            [hsn_code] => 3304
            [status] => A
            [list_price] => 285.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1638886785
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 270.750000
            [short_description] => Snack for protein & calcium boost
            [full_description] => These gluten free crackers honour the large variety of flours that Indians have conventionally been consuming. Making chickpea flour the hero of this cracker, we also love how rosemary, a foreign herb pairs so well with our conventional besan like chickpea flour.
            [category_ids] => Array
                (
                    [0] => 1704
                    [1] => 2658
                )

            [seo_name] => gluten-free-crackers-150g
            [seo_path] => 458/2654/2658
            [main_category] => 2658
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

    [14085] => Array
        (
            [product_id] => 14085
            [product] => Nut and Seed Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => Brand_The Cinnamon Kitchen_20
            [hsn_code] => 3304
            [status] => A
            [list_price] => 380.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658121504
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 380.000000
            [short_description] => Ideal to aid in digestion
            [full_description] => <p>Crackers made using nuts and seeds and seasoned with salt. These contain psyllium husk (isabgol) to aid digestion.</p>
            [category_ids] => Array
                (
                    [0] => 2648
                )

            [seo_name] => nut-and-seed-crackers-150-gm
            [seo_path] => 458/2646/2648
            [main_category] => 2648
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

    [14086] => Array
        (
            [product_id] => 14086
            [product] => Cheddar Cheese Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => Brand_The Cinnamon Kitchen_21
            [hsn_code] => 3304
            [status] => A
            [list_price] => 420.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658121504
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 420.000000
            [short_description] => Ideal to aid in digestion
            [full_description] => <p>Flourless crackers made using nuts, seeds and sharp cheddar seasoned with oregano. Great on cheeseboards, with wine or even by themselves</p>
            [category_ids] => Array
                (
                    [0] => 2658
                )

            [seo_name] => cheddar-cheese-crackers-150-gm
            [seo_path] => 458/2654/2658
            [main_category] => 2658
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

    [4891] => Array
        (
            [product_id] => 4891
            [product] => Flax Seed Crunch - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 57
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => MOSB32
            [hsn_code] => 3304
            [status] => A
            [list_price] => 285.00
            [amount] => 999
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1638886785
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 270.750000
            [short_description] => Superfood Boost & has essential nutrients
            [full_description] => Made with all things good, our Flax seed Crackers contain millet flour, wheat bran, flax seeds and oats goodness. Flax seeds which is our main ingredient in these crackers is a superfood rich in fiber and various vitamins and minerals.The nutrients in it help lower the risk of diabetes, cancer, and heart disease. Flax seeds also help lower cholesterol, moderate blood sugar and maintaining a healthy gut by providing fiber.
            [category_ids] => Array
                (
                    [0] => 1704
                    [1] => 2648
                )

            [seo_name] => flax-seed-crunch-150g
            [seo_path] => 458/2646/2648
            [main_category] => 2648
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

)

Array
(
    [4890] => Array
        (
            [product_id] => 4890
            [product] => Gluten Free Crackers - 150g
            [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] => MOSB31
            [hsn_code] => 3304
            [status] => A
            [list_price] => 285.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1638886785
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 270.750000
            [short_description] => Snack for protein & calcium boost
            [full_description] => These gluten free crackers honour the large variety of flours that Indians have conventionally been consuming. Making chickpea flour the hero of this cracker, we also love how rosemary, a foreign herb pairs so well with our conventional besan like chickpea flour.
            [category_ids] => Array
                (
                    [0] => 1704
                    [1] => 2658
                )

            [seo_name] => gluten-free-crackers-150g
            [seo_path] => 458/2654/2658
            [main_category] => 2658
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

    [14085] => Array
        (
            [product_id] => 14085
            [product] => Nut and Seed Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => Brand_The Cinnamon Kitchen_20
            [hsn_code] => 3304
            [status] => A
            [list_price] => 380.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658121504
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 380.000000
            [short_description] => Ideal to aid in digestion
            [full_description] => <p>Crackers made using nuts and seeds and seasoned with salt. These contain psyllium husk (isabgol) to aid digestion.</p>
            [category_ids] => Array
                (
                    [0] => 2648
                )

            [seo_name] => nut-and-seed-crackers-150-gm
            [seo_path] => 458/2646/2648
            [main_category] => 2648
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

    [14086] => Array
        (
            [product_id] => 14086
            [product] => Cheddar Cheese Crackers - 150 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 303
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => Brand_The Cinnamon Kitchen_21
            [hsn_code] => 3304
            [status] => A
            [list_price] => 420.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658121504
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 420.000000
            [short_description] => Ideal to aid in digestion
            [full_description] => <p>Flourless crackers made using nuts, seeds and sharp cheddar seasoned with oregano. Great on cheeseboards, with wine or even by themselves</p>
            [category_ids] => Array
                (
                    [0] => 2658
                )

            [seo_name] => cheddar-cheese-crackers-150-gm
            [seo_path] => 458/2654/2658
            [main_category] => 2658
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => The Cinnamon Kitchen
        )

    [4891] => Array
        (
            [product_id] => 4891
            [product] => Flax Seed Crunch - 150g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 57
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => MOSB32
            [hsn_code] => 3304
            [status] => A
            [list_price] => 285.00
            [amount] => 999
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1638886785
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 270.750000
            [short_description] => Superfood Boost & has essential nutrients
            [full_description] => Made with all things good, our Flax seed Crackers contain millet flour, wheat bran, flax seeds and oats goodness. Flax seeds which is our main ingredient in these crackers is a superfood rich in fiber and various vitamins and minerals.The nutrients in it help lower the risk of diabetes, cancer, and heart disease. Flax seeds also help lower cholesterol, moderate blood sugar and maintaining a healthy gut by providing fiber.
            [category_ids] => Array
                (
                    [0] => 1704
                    [1] => 2648
                )

            [seo_name] => flax-seed-crunch-150g
            [seo_path] => 458/2646/2648
            [main_category] => 2648
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => MOS Bakery
        )

)

end of fxn

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

before end of oxn

Array
(
)

Array
(
)

end of fxn