Array ( [show_master_products_only] => [area] => C [currency] => EUR [features_hash] => 28-20876 [sl] => en [dispatch] => categories.view [category_id] => 2764 [save_view_results] => product_id [items_per_page] => 24 [sort_by] => bestsellers [sort_order] => desc [cid] => 2764 [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 (20876)) AND ?:categories.category_id IN (2764) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
before end of oxn
Array ( [30904] => Array ( [product_id] => 30904 [product] => Hair Wax Wet Look Glossy Finish - 100gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 560 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => MC_Wax Wet Look_100gm [hsn_code] => 3304 [status] => A [list_price] => 350.00 [amount] => 99 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1684834458 [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] => 332.500000 [short_description] => Wet look & glossy finish [full_description] => <p>Man code hair wax mega hold is made using a carefully selected blend of ingredients that give you the strong hold your hair needs to let you make thick, textured, and modern hairstyles that maintain their look throughout the day even during sports and heavy perspiration. There’s less of a slimy or greasy after-feel when you wash it out, which can also translate to needing less shampoo to do so. It has a very stable effect and generally tends to stay in the place where it is applied, giving that precision to your hairstyle. Man code hair wax men is specially designed, our hair styling wax paste to deliver a glossy finish that doesn’t leave behind any residue or damaged hair. Man code hair wax not only gives shiny glossy look and long lasting hold but also improves hair thickness and texture and enhances your styling. Mancode hair wax is made without any harmful chemicals or ingredients to ensure extra holding power while keeping your hair completely safe. We use a unique and healthy blend of waxes and oils to bring you a natural look hair wax that you can safely use all day.</p> [category_ids] => Array ( [0] => 1462 [1] => 2764 ) [position] => 0 [seo_name] => hair-wax-wet-look-glossy-finish-100gm [seo_path] => 2743/2759/2764 [main_category] => 2764 [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] => Mancode ) )
Array ( [30904] => Array ( [product_id] => 30904 [product] => Hair Wax Wet Look Glossy Finish - 100gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 560 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => MC_Wax Wet Look_100gm [hsn_code] => 3304 [status] => A [list_price] => 350.00 [amount] => 99 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1684834458 [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] => 332.500000 [short_description] => Wet look & glossy finish [full_description] => <p>Man code hair wax mega hold is made using a carefully selected blend of ingredients that give you the strong hold your hair needs to let you make thick, textured, and modern hairstyles that maintain their look throughout the day even during sports and heavy perspiration. There’s less of a slimy or greasy after-feel when you wash it out, which can also translate to needing less shampoo to do so. It has a very stable effect and generally tends to stay in the place where it is applied, giving that precision to your hairstyle. Man code hair wax men is specially designed, our hair styling wax paste to deliver a glossy finish that doesn’t leave behind any residue or damaged hair. Man code hair wax not only gives shiny glossy look and long lasting hold but also improves hair thickness and texture and enhances your styling. Mancode hair wax is made without any harmful chemicals or ingredients to ensure extra holding power while keeping your hair completely safe. We use a unique and healthy blend of waxes and oils to bring you a natural look hair wax that you can safely use all day.</p> [category_ids] => Array ( [0] => 1462 [1] => 2764 ) [position] => 0 [seo_name] => hair-wax-wet-look-glossy-finish-100gm [seo_path] => 2743/2759/2764 [main_category] => 2764 [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] => Mancode ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [currency] => EUR [features_hash] => 28-20876 [sl] => en [dispatch] => categories.view [category_id] => 2764 [save_view_results] => product_id [items_per_page] => 24 [sort_by] => bestsellers [sort_order] => desc [cid] => 2764 [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 (20876)) AND ?:categories.category_id IN (2764) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
before end of oxn
Array ( [30904] => Array ( [product_id] => 30904 [product] => Hair Wax Wet Look Glossy Finish - 100gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 560 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => MC_Wax Wet Look_100gm [hsn_code] => 3304 [status] => A [list_price] => 350.00 [amount] => 99 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1684834458 [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] => 332.500000 [short_description] => Wet look & glossy finish [full_description] => <p>Man code hair wax mega hold is made using a carefully selected blend of ingredients that give you the strong hold your hair needs to let you make thick, textured, and modern hairstyles that maintain their look throughout the day even during sports and heavy perspiration. There’s less of a slimy or greasy after-feel when you wash it out, which can also translate to needing less shampoo to do so. It has a very stable effect and generally tends to stay in the place where it is applied, giving that precision to your hairstyle. Man code hair wax men is specially designed, our hair styling wax paste to deliver a glossy finish that doesn’t leave behind any residue or damaged hair. Man code hair wax not only gives shiny glossy look and long lasting hold but also improves hair thickness and texture and enhances your styling. Mancode hair wax is made without any harmful chemicals or ingredients to ensure extra holding power while keeping your hair completely safe. We use a unique and healthy blend of waxes and oils to bring you a natural look hair wax that you can safely use all day.</p> [category_ids] => Array ( [0] => 1462 [1] => 2764 ) [position] => 0 [seo_name] => hair-wax-wet-look-glossy-finish-100gm [seo_path] => 2743/2759/2764 [main_category] => 2764 [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] => Mancode ) )
Array ( [30904] => Array ( [product_id] => 30904 [product] => Hair Wax Wet Look Glossy Finish - 100gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 560 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => MC_Wax Wet Look_100gm [hsn_code] => 3304 [status] => A [list_price] => 350.00 [amount] => 99 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1684834458 [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] => 332.500000 [short_description] => Wet look & glossy finish [full_description] => <p>Man code hair wax mega hold is made using a carefully selected blend of ingredients that give you the strong hold your hair needs to let you make thick, textured, and modern hairstyles that maintain their look throughout the day even during sports and heavy perspiration. There’s less of a slimy or greasy after-feel when you wash it out, which can also translate to needing less shampoo to do so. It has a very stable effect and generally tends to stay in the place where it is applied, giving that precision to your hairstyle. Man code hair wax men is specially designed, our hair styling wax paste to deliver a glossy finish that doesn’t leave behind any residue or damaged hair. Man code hair wax not only gives shiny glossy look and long lasting hold but also improves hair thickness and texture and enhances your styling. Mancode hair wax is made without any harmful chemicals or ingredients to ensure extra holding power while keeping your hair completely safe. We use a unique and healthy blend of waxes and oils to bring you a natural look hair wax that you can safely use all day.</p> [category_ids] => Array ( [0] => 1462 [1] => 2764 ) [position] => 0 [seo_name] => hair-wax-wet-look-glossy-finish-100gm [seo_path] => 2743/2759/2764 [main_category] => 2764 [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] => Mancode ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [for_required_product] => 30904 [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 = 30904 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 |