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

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

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

    [custom_extend] => Array
        (
        )

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

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

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

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

```
Advanced and feature filters
```

```
before hook
```

```
after hook
```
```
C
```

```
1
```

```
before 2nd hook
```

```
after 2nd hook
```

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

```
before end of oxn
```

Array
(
    [11265] => Array
        (
            [product_id] => 11265
            [product] => Protein Powered Deep Conditioning Mask - 150 gm
            [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] => PROTEINPOWERED336820MEDIUM
            [hsn_code] => 3304
            [status] => A
            [list_price] => 880.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1653287934
            [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] => 836.000000
            [short_description] => Restores, repairs and hydrates hair
            [full_description] => <p>Bond Repairing Magic: Rough, Dry, Damaged Hair That Needs Saving? Our Protein Deep Conditioner Is Literally A Powerhouse! With Bond Repairing Groups Of Proteins Like Quinoa, Corn, And Wheat Protein, Our Mask Is Made To Bind Your Hair Strands, Making Them Visibly Healthier In The First Two Washes. </p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p>
</p>
<p><strong>How to use:-</strong></p>
<p>Apply to clean, freshly shampooed hair that is damp/slightly wet. Rake in 2 coin-sized amounts of the deep conditioner from your root to your ends. Finger detangle, or use a wide-tooth comb to spread the product evenly. Leave it in for 10-20 minutes with a shower cap. Rinse out thoroughly. Enjoy shiny clumps that have just enough boing! Use upto once a week for chemically damaged hair, and once in 2 weeks for normal hair.</p>
            [category_ids] => Array
                (
                    [0] => 2756
                )

            [position] => 0
            [seo_name] => protein-powered-deep-conditioning-mask-with-amla-quinoa-avocado-oil-and-brown-algae-extract-for-curly-and-wavy-hair-150gm
            [seo_path] => 2743/2753/2756
            [average_rating] => 4.83
            [reviews_count] => 6
            [main_category] => 2756
            [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] => Fix My Curls 
            [ratting_count] => 6
        )

)

Array
(
    [11265] => Array
        (
            [product_id] => 11265
            [product] => Protein Powered Deep Conditioning Mask - 150 gm
            [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] => PROTEINPOWERED336820MEDIUM
            [hsn_code] => 3304
            [status] => A
            [list_price] => 880.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1653287934
            [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] => 836.000000
            [short_description] => Restores, repairs and hydrates hair
            [full_description] => <p>Bond Repairing Magic: Rough, Dry, Damaged Hair That Needs Saving? Our Protein Deep Conditioner Is Literally A Powerhouse! With Bond Repairing Groups Of Proteins Like Quinoa, Corn, And Wheat Protein, Our Mask Is Made To Bind Your Hair Strands, Making Them Visibly Healthier In The First Two Washes. </p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p>
</p>
<p><strong>How to use:-</strong></p>
<p>Apply to clean, freshly shampooed hair that is damp/slightly wet. Rake in 2 coin-sized amounts of the deep conditioner from your root to your ends. Finger detangle, or use a wide-tooth comb to spread the product evenly. Leave it in for 10-20 minutes with a shower cap. Rinse out thoroughly. Enjoy shiny clumps that have just enough boing! Use upto once a week for chemically damaged hair, and once in 2 weeks for normal hair.</p>
            [category_ids] => Array
                (
                    [0] => 2756
                )

            [position] => 0
            [seo_name] => protein-powered-deep-conditioning-mask-with-amla-quinoa-avocado-oil-and-brown-algae-extract-for-curly-and-wavy-hair-150gm
            [seo_path] => 2743/2753/2756
            [average_rating] => 4.83
            [reviews_count] => 6
            [main_category] => 2756
            [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] => Fix My Curls 
            [ratting_count] => 6
        )

)

```
end of fxn
```

Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 11265
    [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 (11265)) 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] => 11265
    [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 (11265)) 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
(
    [11265] => Array
        (
            [product_id] => 11265
            [product] => Protein Powered Deep Conditioning Mask - 150 gm
            [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] => Fix My Curls 
        )

)

Array
(
    [11265] => Array
        (
            [product_id] => 11265
            [product] => Protein Powered Deep Conditioning Mask - 150 gm
            [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] => Fix My Curls 
        )

)

```
end of fxn
```

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

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

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

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

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

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

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

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

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

    [custom_extend] => Array
        (
        )

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

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

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

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

```
Advanced and feature filters
```

```
before hook
```

```
after hook
```
```
C
```

```
1
```

```
before 2nd hook
```

```
after 2nd hook
```

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

```
before end of oxn
```

Array
(
    [11265] => Array
        (
            [product_id] => 11265
            [product] => Protein Powered Deep Conditioning Mask - 150 gm
            [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] => PROTEINPOWERED336820MEDIUM
            [hsn_code] => 3304
            [status] => A
            [list_price] => 880.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1653287934
            [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] => 836.000000
            [short_description] => Restores, repairs and hydrates hair
            [full_description] => <p>Bond Repairing Magic: Rough, Dry, Damaged Hair That Needs Saving? Our Protein Deep Conditioner Is Literally A Powerhouse! With Bond Repairing Groups Of Proteins Like Quinoa, Corn, And Wheat Protein, Our Mask Is Made To Bind Your Hair Strands, Making Them Visibly Healthier In The First Two Washes. </p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p>
</p>
<p><strong>How to use:-</strong></p>
<p>Apply to clean, freshly shampooed hair that is damp/slightly wet. Rake in 2 coin-sized amounts of the deep conditioner from your root to your ends. Finger detangle, or use a wide-tooth comb to spread the product evenly. Leave it in for 10-20 minutes with a shower cap. Rinse out thoroughly. Enjoy shiny clumps that have just enough boing! Use upto once a week for chemically damaged hair, and once in 2 weeks for normal hair.</p>
            [category_ids] => Array
                (
                    [0] => 2756
                )

            [position] => 0
            [seo_name] => protein-powered-deep-conditioning-mask-with-amla-quinoa-avocado-oil-and-brown-algae-extract-for-curly-and-wavy-hair-150gm
            [seo_path] => 2743/2753/2756
            [average_rating] => 4.83
            [reviews_count] => 6
            [main_category] => 2756
            [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] => Fix My Curls 
            [ratting_count] => 6
        )

)

Array
(
    [11265] => Array
        (
            [product_id] => 11265
            [product] => Protein Powered Deep Conditioning Mask - 150 gm
            [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] => PROTEINPOWERED336820MEDIUM
            [hsn_code] => 3304
            [status] => A
            [list_price] => 880.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1653287934
            [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] => 836.000000
            [short_description] => Restores, repairs and hydrates hair
            [full_description] => <p>Bond Repairing Magic: Rough, Dry, Damaged Hair That Needs Saving? Our Protein Deep Conditioner Is Literally A Powerhouse! With Bond Repairing Groups Of Proteins Like Quinoa, Corn, And Wheat Protein, Our Mask Is Made To Bind Your Hair Strands, Making Them Visibly Healthier In The First Two Washes. </p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p>
</p>
<p><strong>How to use:-</strong></p>
<p>Apply to clean, freshly shampooed hair that is damp/slightly wet. Rake in 2 coin-sized amounts of the deep conditioner from your root to your ends. Finger detangle, or use a wide-tooth comb to spread the product evenly. Leave it in for 10-20 minutes with a shower cap. Rinse out thoroughly. Enjoy shiny clumps that have just enough boing! Use upto once a week for chemically damaged hair, and once in 2 weeks for normal hair.</p>
            [category_ids] => Array
                (
                    [0] => 2756
                )

            [position] => 0
            [seo_name] => protein-powered-deep-conditioning-mask-with-amla-quinoa-avocado-oil-and-brown-algae-extract-for-curly-and-wavy-hair-150gm
            [seo_path] => 2743/2753/2756
            [average_rating] => 4.83
            [reviews_count] => 6
            [main_category] => 2756
            [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] => Fix My Curls 
            [ratting_count] => 6
        )

)

```
end of fxn
```

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

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

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

Gels and waxes:Hair Styling:Hair

Ctrl+Alt+D - show/hide toolbar

Page generating time 1.5109 s
Memory usage 15 476.54 KB

Server

✖

Request

✖

Config

✖

SQL

✖

Cache queries

✖

Logging

✖

Templates

✖

Blocks

✖