Array
(
[show_master_products_only] =>
[area] => C
[features_hash] => 28-28264
[sort_order] => asc
[sl] => en
[dispatch] => categories.view
[category_id] => 2778
[save_view_results] => product_id
[items_per_page] => 24
[sort_by] => bestsellers
[cid] => 2778
[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 (28264)) AND ?:categories.category_id IN (2778) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY ?:product_sales.amount asc, products.product_id ASC LIMIT 0, 24
before end of oxn
Array
(
[29508] => Array
(
[product_id] => 29508
[product] => Natural Roll-On Deodorant White Musk - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 549
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Necessary_1
[hsn_code] => 3304
[status] => A
[list_price] => 795.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1683012675
[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] => 755.250000
[short_description] => Neutralizes odors & minimizes bumps
[full_description] => <p>Natural Roll-On Deodorant’s unique formula is made of clean ingredients, offers 24-hour effectiveness, neutralizes odors, reduces bacteria responsible for odors, treats discoloration, minimizes bumps and hydrates the under-arms. It is free from aluminum, alcohol, silicone and bicarbonate of soda. The roll-on format offers easy application without leaving traces or blocking pores. It is stain-free and mess-free.</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => natural-roll-on-deodorant-white-musk-50ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => Necessary
)
[29509] => Array
(
[product_id] => 29509
[product] => Natural Roll-On Deodorant Aloe-Vera & Cucucmber - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 549
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Necessary_2
[hsn_code] => 3304
[status] => A
[list_price] => 795.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1683012675
[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] => 755.250000
[short_description] => Neutralizes odors & minimizes bumps
[full_description] => <p>Natural Roll-On Deodorant’s unique formula is made of clean ingredients, offers 24-hour effectiveness, neutralizes odors, reduces bacteria responsible for odors, treats discoloration, minimizes bumps and hydrates the under-arms. It is free from aluminum, alcohol, silicone and bicarbonate of soda. The roll-on format offers easy application without leaving traces or blocking pores. It is stain-free and mess-free.</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => natural-roll-on-deodorant-aloe-vera-and-cucucmber-50ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => Necessary
)
[30398] => Array
(
[product_id] => 30398
[product] => Luxury Perfume Mortal Pour Homme Eau De Perfume Body Spray for men - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench035
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 96
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Grape chocolaty scent; Middle Note: musky oud; Base Note: distinctive floral and caramel aroma</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-mortal-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
[30399] => Array
(
[product_id] => 30399
[product] => Luxury Perfume War Zone Pour Homme Eau De Perfume Body Spray for men - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench036
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Apple, bergamot, blackcurrant, pineapple, lemon; Middle Note: Rose, birch, jasmine; Base Note: Musk, ambergris, patchouli, vanilla</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-war-zone-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
[30400] => Array
(
[product_id] => 30400
[product] => Luxury Perfume Resist Pour Homme Eau De Perfume Body Spray for men -100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench037
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 98
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Cognac; Heart Note: Tonka Bean, Cinnamon, Oak; Base Note: Vanilla, Praline, Sandalwood</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-resist-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
)
Array
(
[29508] => Array
(
[product_id] => 29508
[product] => Natural Roll-On Deodorant White Musk - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 549
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Necessary_1
[hsn_code] => 3304
[status] => A
[list_price] => 795.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1683012675
[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] => 755.250000
[short_description] => Neutralizes odors & minimizes bumps
[full_description] => <p>Natural Roll-On Deodorant’s unique formula is made of clean ingredients, offers 24-hour effectiveness, neutralizes odors, reduces bacteria responsible for odors, treats discoloration, minimizes bumps and hydrates the under-arms. It is free from aluminum, alcohol, silicone and bicarbonate of soda. The roll-on format offers easy application without leaving traces or blocking pores. It is stain-free and mess-free.</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => natural-roll-on-deodorant-white-musk-50ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => Necessary
)
[29509] => Array
(
[product_id] => 29509
[product] => Natural Roll-On Deodorant Aloe-Vera & Cucucmber - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 549
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Necessary_2
[hsn_code] => 3304
[status] => A
[list_price] => 795.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1683012675
[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] => 755.250000
[short_description] => Neutralizes odors & minimizes bumps
[full_description] => <p>Natural Roll-On Deodorant’s unique formula is made of clean ingredients, offers 24-hour effectiveness, neutralizes odors, reduces bacteria responsible for odors, treats discoloration, minimizes bumps and hydrates the under-arms. It is free from aluminum, alcohol, silicone and bicarbonate of soda. The roll-on format offers easy application without leaving traces or blocking pores. It is stain-free and mess-free.</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => natural-roll-on-deodorant-aloe-vera-and-cucucmber-50ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => Necessary
)
[30398] => Array
(
[product_id] => 30398
[product] => Luxury Perfume Mortal Pour Homme Eau De Perfume Body Spray for men - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench035
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 96
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Grape chocolaty scent; Middle Note: musky oud; Base Note: distinctive floral and caramel aroma</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-mortal-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
[30399] => Array
(
[product_id] => 30399
[product] => Luxury Perfume War Zone Pour Homme Eau De Perfume Body Spray for men - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench036
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Apple, bergamot, blackcurrant, pineapple, lemon; Middle Note: Rose, birch, jasmine; Base Note: Musk, ambergris, patchouli, vanilla</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-war-zone-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
[30400] => Array
(
[product_id] => 30400
[product] => Luxury Perfume Resist Pour Homme Eau De Perfume Body Spray for men -100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench037
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 98
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Cognac; Heart Note: Tonka Bean, Cinnamon, Oak; Base Note: Vanilla, Praline, Sandalwood</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-resist-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[features_hash] => 28-28264
[sort_order] => asc
[sl] => en
[dispatch] => categories.view
[category_id] => 2778
[save_view_results] => product_id
[items_per_page] => 24
[sort_by] => bestsellers
[cid] => 2778
[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 (28264)) AND ?:categories.category_id IN (2778) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY ?:product_sales.amount asc, products.product_id ASC LIMIT 0, 24
before end of oxn
Array
(
[29508] => Array
(
[product_id] => 29508
[product] => Natural Roll-On Deodorant White Musk - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 549
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Necessary_1
[hsn_code] => 3304
[status] => A
[list_price] => 795.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1683012675
[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] => 755.250000
[short_description] => Neutralizes odors & minimizes bumps
[full_description] => <p>Natural Roll-On Deodorant’s unique formula is made of clean ingredients, offers 24-hour effectiveness, neutralizes odors, reduces bacteria responsible for odors, treats discoloration, minimizes bumps and hydrates the under-arms. It is free from aluminum, alcohol, silicone and bicarbonate of soda. The roll-on format offers easy application without leaving traces or blocking pores. It is stain-free and mess-free.</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => natural-roll-on-deodorant-white-musk-50ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => Necessary
)
[29509] => Array
(
[product_id] => 29509
[product] => Natural Roll-On Deodorant Aloe-Vera & Cucucmber - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 549
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Necessary_2
[hsn_code] => 3304
[status] => A
[list_price] => 795.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1683012675
[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] => 755.250000
[short_description] => Neutralizes odors & minimizes bumps
[full_description] => <p>Natural Roll-On Deodorant’s unique formula is made of clean ingredients, offers 24-hour effectiveness, neutralizes odors, reduces bacteria responsible for odors, treats discoloration, minimizes bumps and hydrates the under-arms. It is free from aluminum, alcohol, silicone and bicarbonate of soda. The roll-on format offers easy application without leaving traces or blocking pores. It is stain-free and mess-free.</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => natural-roll-on-deodorant-aloe-vera-and-cucucmber-50ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => Necessary
)
[30398] => Array
(
[product_id] => 30398
[product] => Luxury Perfume Mortal Pour Homme Eau De Perfume Body Spray for men - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench035
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 96
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Grape chocolaty scent; Middle Note: musky oud; Base Note: distinctive floral and caramel aroma</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-mortal-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
[30399] => Array
(
[product_id] => 30399
[product] => Luxury Perfume War Zone Pour Homme Eau De Perfume Body Spray for men - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench036
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Apple, bergamot, blackcurrant, pineapple, lemon; Middle Note: Rose, birch, jasmine; Base Note: Musk, ambergris, patchouli, vanilla</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-war-zone-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
[30400] => Array
(
[product_id] => 30400
[product] => Luxury Perfume Resist Pour Homme Eau De Perfume Body Spray for men -100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench037
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 98
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Cognac; Heart Note: Tonka Bean, Cinnamon, Oak; Base Note: Vanilla, Praline, Sandalwood</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-resist-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
)
Array
(
[29508] => Array
(
[product_id] => 29508
[product] => Natural Roll-On Deodorant White Musk - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 549
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Necessary_1
[hsn_code] => 3304
[status] => A
[list_price] => 795.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1683012675
[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] => 755.250000
[short_description] => Neutralizes odors & minimizes bumps
[full_description] => <p>Natural Roll-On Deodorant’s unique formula is made of clean ingredients, offers 24-hour effectiveness, neutralizes odors, reduces bacteria responsible for odors, treats discoloration, minimizes bumps and hydrates the under-arms. It is free from aluminum, alcohol, silicone and bicarbonate of soda. The roll-on format offers easy application without leaving traces or blocking pores. It is stain-free and mess-free.</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => natural-roll-on-deodorant-white-musk-50ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => Necessary
)
[29509] => Array
(
[product_id] => 29509
[product] => Natural Roll-On Deodorant Aloe-Vera & Cucucmber - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 549
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Necessary_2
[hsn_code] => 3304
[status] => A
[list_price] => 795.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1683012675
[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] => 755.250000
[short_description] => Neutralizes odors & minimizes bumps
[full_description] => <p>Natural Roll-On Deodorant’s unique formula is made of clean ingredients, offers 24-hour effectiveness, neutralizes odors, reduces bacteria responsible for odors, treats discoloration, minimizes bumps and hydrates the under-arms. It is free from aluminum, alcohol, silicone and bicarbonate of soda. The roll-on format offers easy application without leaving traces or blocking pores. It is stain-free and mess-free.</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => natural-roll-on-deodorant-aloe-vera-and-cucucmber-50ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => Necessary
)
[30398] => Array
(
[product_id] => 30398
[product] => Luxury Perfume Mortal Pour Homme Eau De Perfume Body Spray for men - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench035
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 96
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Grape chocolaty scent; Middle Note: musky oud; Base Note: distinctive floral and caramel aroma</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-mortal-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
[30399] => Array
(
[product_id] => 30399
[product] => Luxury Perfume War Zone Pour Homme Eau De Perfume Body Spray for men - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench036
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Apple, bergamot, blackcurrant, pineapple, lemon; Middle Note: Rose, birch, jasmine; Base Note: Musk, ambergris, patchouli, vanilla</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-war-zone-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
[30400] => Array
(
[product_id] => 30400
[product] => Luxury Perfume Resist Pour Homme Eau De Perfume Body Spray for men -100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 557
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => LaFrench037
[hsn_code] => 3304
[status] => A
[list_price] => 650.00
[amount] => 98
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1684231496
[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] => 617.500000
[short_description] => Long lasting daily wear fragances
[full_description] => <p>La French Happiness is a Classy Scent that embodies the unique magnetism and playfully attractive style synonymous with the Guess brand. Infused with refreshing notes of Mandarin, Cinnamon, White Musk & Sandalwood. The carnal fragrance that evokes the essence of the iconic fashion brand, channeling the edgy, trendsetting designs that have set Guess apart throughout its history. The Bottle is Charming and the fragrance enchanting, adding up to the perfect mix for the perfect personality. Brand with a Premium Heritage acquired through over many years of experience and know-how in the art of perfumery, La French Perfumes Lordly presents the Excellent collection of Ultra Modern fragrances with Enthralling scents. Perfecting the science, art and craft of redolence, the brand believes that well-crafted fragrances say a lot about you and the way you emerge yourself.Top Note: Cognac; Heart Note: Tonka Bean, Cinnamon, Oak; Base Note: Vanilla, Praline, Sandalwood</p>
[category_ids] => Array
(
[0] => 2778
)
[position] => 0
[seo_name] => luxury-perfume-resist-pour-homme-eau-de-perfume-body-spray-for-men-100ml
[seo_path] => 2768/2769/2778
[main_category] => 2778
[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] => La' French
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 29508
[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 = 29508 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] => 29509
[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 = 29509 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] => 30398
[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 = 30398 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] => 30399
[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 = 30399 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] => 30400
[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 = 30400 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Cannot create references to/from string offsets
app/Tygh/Registry.php, line: 221
| File: | app/Tygh/Registry.php |
| Line: | 89 |
| Function: | _varByKey |
| File: | app/addons/seo/Tygh/SeoCache.php |
| Line: | 111 |
| Function: | set |
| File: | app/addons/seo/Tygh/SeoCache.php |
| Line: | 49 |
| Function: | setStatic |
| File: | app/addons/seo/func.php |
| Line: | 1329 |
| Function: | set |
| File: | app/addons/seo/func.php |
| Line: | 1563 |
| Function: | fn_seo_get_name |
| File: | app/functions/fn.control.php |
| Line: | 123 |
| Function: | fn_seo_url_post |
| File: | app/functions/fn.common.php |
| Line: | 3921 |
| Function: | fn_set_hook |
| File: | app/Tygh/BlockManager/Container.php |
| Line: | 496 |
| Function: | fn_url |
| File: | app/Tygh/BlockManager/Container.php |
| Line: | 517 |
| Function: | getConfigurationUrl |
| File: | app/Tygh/BlockManager/Container.php |
| Line: | 120 |
| Function: | addBlockManagerProperties |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 127 |
| Function: | getListByArea |
| File: | app/functions/smarty_plugins/function.render_location.php |
| Line: | 50 |
| Function: | __construct |
| File: | var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php |
| Line: | 191 |
| Function: | smarty_function_render_location |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 188 |
| Function: | content_689464c1dbc0b1_26812820 |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 81 |
| Function: | fetch |
| File: | app/functions/fn.control.php |
| Line: | 636 |
| Function: | fetch |
| File: | index.php |
| Line: | 39 |
| Function: | fn_dispatch |