Array
(
[show_master_products_only] =>
[area] => C
[currency] => GBP
[features_hash] => 28-35661
[sort_order] => desc
[sl] => en
[dispatch] => categories.view
[category_id] => 2209
[save_view_results] => product_id
[items_per_page] => 24
[sort_by] => bestsellers
[extend] => Array
(
[0] => categories
[1] => description
[2] => description
[3] => full_description
)
[subcats] => Y
[runtime_company_id] => 0
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[2] => Array
(
[operator] => in
[condition] => products
[value] => 1505,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2227,2228,2230,2231,2232,2233,2234,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2434,2435,2436,2510,2511,2512,2515,2516,3195,3306,3307,3308,3309,3312,3314,3315,4195,4196,4197,4199,4202,4203,4204,4205,4213,4944,5679,5680,5682,5683,6491,7306,7310,8685,9102,9103,9104,9105,10155,12133,12135,12136,12137,12139,12140,12141,12142,12143,12147,12148,12149,12150,12639,12640,12641,12642,12691,12692,12840,12842,12844,12845,13558,13576,14166,14346,14707,14708,14709,14710,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,16056,16072,16770,16771,16857,16858,16861,16863,16864,16866,16867,16868,16869,16872,16875,16876,16877,16878,16879,16880,16881,16882,17763,17765,17766,17769,17809,17812,17813,17819,17821,18580,18581,19829,19830,19831,21565,21566,21568,21569,21685,21686,21688,21689,27487,27488,27489,27490,27493,29500,29818,29821,29823,29824,29828,33211,33213,33214,33215,33216,33831,33832,33837,34313,34571,34574,34581,34592,35798,2437,2438,2439,2506,2507,2508,2509,2513,2514,2517,2518,2519,2541,3047,3048,3049,3193,3194,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3310,3311,3313,3479,3480,3481,3495,3496,3513,3526,3845,4094,4095,4096,4217,4218,4759,4774,5681,5690,7307,7308,7309,7810,7811,7927,8265,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,8286,8287,8288,8289,8290,8291,8292,8293,8684,8686,8892,8893,8894,9190,10156,10157,12134,12138,12144,12145,12146,12841,12843,12846,12847,12848,13557,13559,13560,13561,14163,14164,14165,14662,14663,14664,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,14675,14676,14677,14678,14679,14680,14681,14682,14683,16059,16862,16865,16870,16871,17768,17770,17810,17811,17814,17815,17816,17817,17818,17820,18825,19249,21094,21567,21687,26803,27491,27492,27494,29819,29820,29822,29825,29826,29827,29829,33212,33824,33825,33826,33827,33828,33829,33830,33833,33834,33835,33836,33838,34020,34021,34312,34314,34567,34568,34569,34570,34572,34573,34575,34576,34577,34578,34579,34580,34582,34583,34584,34585,34586,34587,34588,34589,34590,34591,34593,34594,34595,34596,34597,34598,34599,34600,34604,34605,34606,34607,34608,35797,3299,3300,3301,3302,3303,3304,3305,4214,4765,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,7416,7417,7418,7928,7929,8310,8311,8312,8313,8314,8315,8316,8317,8318,8319,8320,8321,8322,8323,8324,8325,8326,8687,8688,8689,8690,8691,11899,11900,11901,14398,16057,16380,16381,16382,16383,16384,16385,16386,16387,16388,16389,16390,16391,16392,16393,16394,16395,16396,16397,16398,16399,16400,16401,16402,16403,16404,16405,16406,16407,16408,16409,16410,16411,16412,16772,16773,16859,16860,16873,16874,17767,17822,18103,24697,24698,24699,25192,25193,25610,26806,31617,32908,32909,32910,32911,32912,32913,32914,32915,32916,32917,32918,32919,35285,35286,35287,35288,35289,35290,35773,17747,17748,17749,17750,17751,17752,17753,17754,17755,17756,17757,17758,17759
)
)
)
)
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 (35661)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (1505,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2227,2228,2230,2231,2232,2233,2234,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2434,2435,2436,2510,2511,2512,2515,2516,3195,3306,3307,3308,3309,3312,3314,3315,4195,4196,4197,4199,4202,4203,4204,4205,4213,4944,5679,5680,5682,5683,6491,7306,7310,8685,9102,9103,9104,9105,10155,12133,12135,12136,12137,12139,12140,12141,12142,12143,12147,12148,12149,12150,12639,12640,12641,12642,12691,12692,12840,12842,12844,12845,13558,13576,14166,14346,14707,14708,14709,14710,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,16056,16072,16770,16771,16857,16858,16861,16863,16864,16866,16867,16868,16869,16872,16875,16876,16877,16878,16879,16880,16881,16882,17763,17765,17766,17769,17809,17812,17813,17819,17821,18580,18581,19829,19830,19831,21565,21566,21568,21569,21685,21686,21688,21689,27487,27488,27489,27490,27493,29500,29818,29821,29823,29824,29828,33211,33213,33214,33215,33216,33831,33832,33837,34313,34571,34574,34581,34592,35798,2437,2438,2439,2506,2507,2508,2509,2513,2514,2517,2518,2519,2541,3047,3048,3049,3193,3194,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3310,3311,3313,3479,3480,3481,3495,3496,3513,3526,3845,4094,4095,4096,4217,4218,4759,4774,5681,5690,7307,7308,7309,7810,7811,7927,8265,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,8286,8287,8288,8289,8290,8291,8292,8293,8684,8686,8892,8893,8894,9190,10156,10157,12134,12138,12144,12145,12146,12841,12843,12846,12847,12848,13557,13559,13560,13561,14163,14164,14165,14662,14663,14664,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,14675,14676,14677,14678,14679,14680,14681,14682,14683,16059,16862,16865,16870,16871,17768,17770,17810,17811,17814,17815,17816,17817,17818,17820,18825,19249,21094,21567,21687,26803,27491,27492,27494,29819,29820,29822,29825,29826,29827,29829,33212,33824,33825,33826,33827,33828,33829,33830,33833,33834,33835,33836,33838,34020,34021,34312,34314,34567,34568,34569,34570,34572,34573,34575,34576,34577,34578,34579,34580,34582,34583,34584,34585,34586,34587,34588,34589,34590,34591,34593,34594,34595,34596,34597,34598,34599,34600,34604,34605,34606,34607,34608,35797,3299,3300,3301,3302,3303,3304,3305,4214,4765,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,7416,7417,7418,7928,7929,8310,8311,8312,8313,8314,8315,8316,8317,8318,8319,8320,8321,8322,8323,8324,8325,8326,8687,8688,8689,8690,8691,11899,11900,11901,14398,16057,16380,16381,16382,16383,16384,16385,16386,16387,16388,16389,16390,16391,16392,16393,16394,16395,16396,16397,16398,16399,16400,16401,16402,16403,16404,16405,16406,16407,16408,16409,16410,16411,16412,16772,16773,16859,16860,16873,16874,17767,17822,18103,24697,24698,24699,25192,25193,25610,26806,31617,32908,32909,32910,32911,32912,32913,32914,32915,32916,32917,32918,32919,35285,35286,35287,35288,35289,35290,35773,17747,17748,17749,17750,17751,17752,17753,17754,17755,17756,17757,17758,17759)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
before end of oxn
Array
(
[14165] => Array
(
[product_id] => 14165
[product] => Masala Iced Tea - 200 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 305
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => GM-FG-03
[hsn_code] => 3304
[status] => A
[list_price] => 440.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1658141934
[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] => 418.000000
[short_description] => Boosts Immunity Wth A Refreshing Taste
[full_description] => <p>Guppy Moms is an Indian homegrown brand that specialises in crafting quality masala chai. Our signature Masala Iced Tea is an instant mix that turns into refreshing and flavorful iced tea when simply mixed with water.</p>
[category_ids] => Array
(
[0] => 2659
)
[seo_name] => masala-iced-tea-200-g
[seo_path] => 458/2640/2659
[main_category] => 2659
[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] => Guppy Moms
)
[14166] => Array
(
[product_id] => 14166
[product] => Masala Chai Frappe - 200 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 305
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => GM-FG-04
[hsn_code] => 3304
[status] => A
[list_price] => 450.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1658141934
[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] => 427.500000
[short_description] => Boosts Immunity Wth A Refreshing Taste
[full_description] => <p>Guppy Moms is an Indian homegrown brand that specialises in crafting quality masala chai. Our signature Masala Chai Frappe is an instant mix that turns into an indulgent, aromatic frappe when simply mixed with water.</p>
[category_ids] => Array
(
[0] => 2659
)
[seo_name] => masala-chai-frappe-200-g
[seo_path] => 458/2640/2659
[main_category] => 2659
[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] => Guppy Moms
)
)
Array
(
[14165] => Array
(
[product_id] => 14165
[product] => Masala Iced Tea - 200 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 305
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => GM-FG-03
[hsn_code] => 3304
[status] => A
[list_price] => 440.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1658141934
[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] => 418.000000
[short_description] => Boosts Immunity Wth A Refreshing Taste
[full_description] => <p>Guppy Moms is an Indian homegrown brand that specialises in crafting quality masala chai. Our signature Masala Iced Tea is an instant mix that turns into refreshing and flavorful iced tea when simply mixed with water.</p>
[category_ids] => Array
(
[0] => 2659
)
[seo_name] => masala-iced-tea-200-g
[seo_path] => 458/2640/2659
[main_category] => 2659
[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] => Guppy Moms
)
[14166] => Array
(
[product_id] => 14166
[product] => Masala Chai Frappe - 200 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 305
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => GM-FG-04
[hsn_code] => 3304
[status] => A
[list_price] => 450.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1658141934
[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] => 427.500000
[short_description] => Boosts Immunity Wth A Refreshing Taste
[full_description] => <p>Guppy Moms is an Indian homegrown brand that specialises in crafting quality masala chai. Our signature Masala Chai Frappe is an instant mix that turns into an indulgent, aromatic frappe when simply mixed with water.</p>
[category_ids] => Array
(
[0] => 2659
)
[seo_name] => masala-chai-frappe-200-g
[seo_path] => 458/2640/2659
[main_category] => 2659
[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] => Guppy Moms
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[currency] => GBP
[features_hash] => 28-35661
[sort_order] => desc
[sl] => en
[dispatch] => categories.view
[category_id] => 2209
[save_view_results] => product_id
[items_per_page] => 24
[sort_by] => bestsellers
[extend] => Array
(
[0] => categories
[1] => description
[2] => description
[3] => full_description
)
[subcats] => Y
[runtime_company_id] => 0
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[2] => Array
(
[operator] => in
[condition] => products
[value] => 1505,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2227,2228,2230,2231,2232,2233,2234,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2434,2435,2436,2510,2511,2512,2515,2516,3195,3306,3307,3308,3309,3312,3314,3315,4195,4196,4197,4199,4202,4203,4204,4205,4213,4944,5679,5680,5682,5683,6491,7306,7310,8685,9102,9103,9104,9105,10155,12133,12135,12136,12137,12139,12140,12141,12142,12143,12147,12148,12149,12150,12639,12640,12641,12642,12691,12692,12840,12842,12844,12845,13558,13576,14166,14346,14707,14708,14709,14710,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,16056,16072,16770,16771,16857,16858,16861,16863,16864,16866,16867,16868,16869,16872,16875,16876,16877,16878,16879,16880,16881,16882,17763,17765,17766,17769,17809,17812,17813,17819,17821,18580,18581,19829,19830,19831,21565,21566,21568,21569,21685,21686,21688,21689,27487,27488,27489,27490,27493,29500,29818,29821,29823,29824,29828,33211,33213,33214,33215,33216,33831,33832,33837,34313,34571,34574,34581,34592,35798,2437,2438,2439,2506,2507,2508,2509,2513,2514,2517,2518,2519,2541,3047,3048,3049,3193,3194,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3310,3311,3313,3479,3480,3481,3495,3496,3513,3526,3845,4094,4095,4096,4217,4218,4759,4774,5681,5690,7307,7308,7309,7810,7811,7927,8265,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,8286,8287,8288,8289,8290,8291,8292,8293,8684,8686,8892,8893,8894,9190,10156,10157,12134,12138,12144,12145,12146,12841,12843,12846,12847,12848,13557,13559,13560,13561,14163,14164,14165,14662,14663,14664,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,14675,14676,14677,14678,14679,14680,14681,14682,14683,16059,16862,16865,16870,16871,17768,17770,17810,17811,17814,17815,17816,17817,17818,17820,18825,19249,21094,21567,21687,26803,27491,27492,27494,29819,29820,29822,29825,29826,29827,29829,33212,33824,33825,33826,33827,33828,33829,33830,33833,33834,33835,33836,33838,34020,34021,34312,34314,34567,34568,34569,34570,34572,34573,34575,34576,34577,34578,34579,34580,34582,34583,34584,34585,34586,34587,34588,34589,34590,34591,34593,34594,34595,34596,34597,34598,34599,34600,34604,34605,34606,34607,34608,35797,3299,3300,3301,3302,3303,3304,3305,4214,4765,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,7416,7417,7418,7928,7929,8310,8311,8312,8313,8314,8315,8316,8317,8318,8319,8320,8321,8322,8323,8324,8325,8326,8687,8688,8689,8690,8691,11899,11900,11901,14398,16057,16380,16381,16382,16383,16384,16385,16386,16387,16388,16389,16390,16391,16392,16393,16394,16395,16396,16397,16398,16399,16400,16401,16402,16403,16404,16405,16406,16407,16408,16409,16410,16411,16412,16772,16773,16859,16860,16873,16874,17767,17822,18103,24697,24698,24699,25192,25193,25610,26806,31617,32908,32909,32910,32911,32912,32913,32914,32915,32916,32917,32918,32919,35285,35286,35287,35288,35289,35290,35773,17747,17748,17749,17750,17751,17752,17753,17754,17755,17756,17757,17758,17759
)
)
)
)
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 (35661)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (1505,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2227,2228,2230,2231,2232,2233,2234,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2434,2435,2436,2510,2511,2512,2515,2516,3195,3306,3307,3308,3309,3312,3314,3315,4195,4196,4197,4199,4202,4203,4204,4205,4213,4944,5679,5680,5682,5683,6491,7306,7310,8685,9102,9103,9104,9105,10155,12133,12135,12136,12137,12139,12140,12141,12142,12143,12147,12148,12149,12150,12639,12640,12641,12642,12691,12692,12840,12842,12844,12845,13558,13576,14166,14346,14707,14708,14709,14710,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,16056,16072,16770,16771,16857,16858,16861,16863,16864,16866,16867,16868,16869,16872,16875,16876,16877,16878,16879,16880,16881,16882,17763,17765,17766,17769,17809,17812,17813,17819,17821,18580,18581,19829,19830,19831,21565,21566,21568,21569,21685,21686,21688,21689,27487,27488,27489,27490,27493,29500,29818,29821,29823,29824,29828,33211,33213,33214,33215,33216,33831,33832,33837,34313,34571,34574,34581,34592,35798,2437,2438,2439,2506,2507,2508,2509,2513,2514,2517,2518,2519,2541,3047,3048,3049,3193,3194,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3310,3311,3313,3479,3480,3481,3495,3496,3513,3526,3845,4094,4095,4096,4217,4218,4759,4774,5681,5690,7307,7308,7309,7810,7811,7927,8265,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,8286,8287,8288,8289,8290,8291,8292,8293,8684,8686,8892,8893,8894,9190,10156,10157,12134,12138,12144,12145,12146,12841,12843,12846,12847,12848,13557,13559,13560,13561,14163,14164,14165,14662,14663,14664,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,14675,14676,14677,14678,14679,14680,14681,14682,14683,16059,16862,16865,16870,16871,17768,17770,17810,17811,17814,17815,17816,17817,17818,17820,18825,19249,21094,21567,21687,26803,27491,27492,27494,29819,29820,29822,29825,29826,29827,29829,33212,33824,33825,33826,33827,33828,33829,33830,33833,33834,33835,33836,33838,34020,34021,34312,34314,34567,34568,34569,34570,34572,34573,34575,34576,34577,34578,34579,34580,34582,34583,34584,34585,34586,34587,34588,34589,34590,34591,34593,34594,34595,34596,34597,34598,34599,34600,34604,34605,34606,34607,34608,35797,3299,3300,3301,3302,3303,3304,3305,4214,4765,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,7416,7417,7418,7928,7929,8310,8311,8312,8313,8314,8315,8316,8317,8318,8319,8320,8321,8322,8323,8324,8325,8326,8687,8688,8689,8690,8691,11899,11900,11901,14398,16057,16380,16381,16382,16383,16384,16385,16386,16387,16388,16389,16390,16391,16392,16393,16394,16395,16396,16397,16398,16399,16400,16401,16402,16403,16404,16405,16406,16407,16408,16409,16410,16411,16412,16772,16773,16859,16860,16873,16874,17767,17822,18103,24697,24698,24699,25192,25193,25610,26806,31617,32908,32909,32910,32911,32912,32913,32914,32915,32916,32917,32918,32919,35285,35286,35287,35288,35289,35290,35773,17747,17748,17749,17750,17751,17752,17753,17754,17755,17756,17757,17758,17759)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
before end of oxn
Array
(
[14165] => Array
(
[product_id] => 14165
[product] => Masala Iced Tea - 200 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 305
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => GM-FG-03
[hsn_code] => 3304
[status] => A
[list_price] => 440.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1658141934
[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] => 418.000000
[short_description] => Boosts Immunity Wth A Refreshing Taste
[full_description] => <p>Guppy Moms is an Indian homegrown brand that specialises in crafting quality masala chai. Our signature Masala Iced Tea is an instant mix that turns into refreshing and flavorful iced tea when simply mixed with water.</p>
[category_ids] => Array
(
[0] => 2659
)
[seo_name] => masala-iced-tea-200-g
[seo_path] => 458/2640/2659
[main_category] => 2659
[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] => Guppy Moms
)
[14166] => Array
(
[product_id] => 14166
[product] => Masala Chai Frappe - 200 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 305
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => GM-FG-04
[hsn_code] => 3304
[status] => A
[list_price] => 450.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1658141934
[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] => 427.500000
[short_description] => Boosts Immunity Wth A Refreshing Taste
[full_description] => <p>Guppy Moms is an Indian homegrown brand that specialises in crafting quality masala chai. Our signature Masala Chai Frappe is an instant mix that turns into an indulgent, aromatic frappe when simply mixed with water.</p>
[category_ids] => Array
(
[0] => 2659
)
[seo_name] => masala-chai-frappe-200-g
[seo_path] => 458/2640/2659
[main_category] => 2659
[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] => Guppy Moms
)
)
Array
(
[14165] => Array
(
[product_id] => 14165
[product] => Masala Iced Tea - 200 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 305
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => GM-FG-03
[hsn_code] => 3304
[status] => A
[list_price] => 440.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1658141934
[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] => 418.000000
[short_description] => Boosts Immunity Wth A Refreshing Taste
[full_description] => <p>Guppy Moms is an Indian homegrown brand that specialises in crafting quality masala chai. Our signature Masala Iced Tea is an instant mix that turns into refreshing and flavorful iced tea when simply mixed with water.</p>
[category_ids] => Array
(
[0] => 2659
)
[seo_name] => masala-iced-tea-200-g
[seo_path] => 458/2640/2659
[main_category] => 2659
[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] => Guppy Moms
)
[14166] => Array
(
[product_id] => 14166
[product] => Masala Chai Frappe - 200 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 305
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => GM-FG-04
[hsn_code] => 3304
[status] => A
[list_price] => 450.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1658141934
[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] => 427.500000
[short_description] => Boosts Immunity Wth A Refreshing Taste
[full_description] => <p>Guppy Moms is an Indian homegrown brand that specialises in crafting quality masala chai. Our signature Masala Chai Frappe is an instant mix that turns into an indulgent, aromatic frappe when simply mixed with water.</p>
[category_ids] => Array
(
[0] => 2659
)
[seo_name] => masala-chai-frappe-200-g
[seo_path] => 458/2640/2659
[main_category] => 2659
[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] => Guppy Moms
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 14165
[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 = 14165 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] => 14166
[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 = 14166 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 |