unserialize(): Passing null to parameter #1 ($data) of type string is deprecated
app/addons/hybrid_auth/func.php, line: 200
| File: | app/addons/hybrid_auth/func.php |
| Line: | 200 |
| Function: | {closure} |
| File: | app/Tygh/Registry.php |
| Line: | 800 |
| Function: | {closure} |
| File: | app/addons/hybrid_auth/func.php |
| Line: | 222 |
| Function: | getOrSetCache |
| File: | app/addons/hybrid_auth/controllers/frontend/init.post.php |
| Line: | 17 |
| Function: | fn_hybrid_auth_get_providers_list |
| File: | app/functions/fn.control.php |
| Line: | 727 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 458 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 19 |
| Function: | fn_dispatch |
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "96.60"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"link_type",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 107,
"rows_produced_per_join": 107,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "11.00",
"eval_cost": "10.70",
"prefix_cost": "21.70",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
],
"attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (99396,99397,99398,100358,100395,100396,100397,100398,100400,100401,100402,100403,100404,100405,100406,100407,100408,100409,100410,100411,100412,100413,100414,100415,100416,100417,100418,100419,100420,100421,100422,100423,100424,100425,100426,100427,100428,100429,100430,100477,100478,100500,100503,100849,100850,100851,100852,100857,100858,100859,100860,100861,100862,100867,100868,100869,100870,100877,100878,101055,101056,101057,101058,101059,101060,101061,101062,101063,101064,101065,101066,101067,101068,101069,101070,101071,101072,101073,101074,101075,101076,101077,101078,101079,101080,101081,101082,101083,101084,101085,101086,101087,101088,101089,101090,101091))"
}
},
{
"table": {
"table_name": "product_position_source",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"nuie_scalesta_net.cscart_products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 107,
"filtered": "100.00",
"cost_info": {
"read_cost": "26.75",
"eval_cost": "10.70",
"prefix_cost": "59.15",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"category_id",
"position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"nuie_scalesta_net.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 5,
"filtered": "5.00",
"cost_info": {
"read_cost": "26.75",
"eval_cost": "0.54",
"prefix_cost": "96.60",
"data_read_per_join": "13K"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`nuie_scalesta_net`.`cscart_categories`.`storefront_id` in (0,1)) and ((`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids`))) and (`nuie_scalesta_net`.`cscart_categories`.`status` in ('A','H')))"
}
}
]
}
}
}
| product_id | category_ids | position |
|---|---|---|
| 99396 | 7222M | |
| 99397 | 7222M | |
| 99398 | 7222M | |
| 100358 | 7222M | |
| 100395 | 7285M,7330 | |
| 100396 | 7285M,7330 | |
| 100397 | 7196M | |
| 100398 | 7196M | |
| 100400 | 7254M | |
| 100401 | 7254M | |
| 100402 | 7254M | |
| 100403 | 7254M | |
| 100404 | 7254M | |
| 100405 | 7254M | |
| 100406 | 7254M | |
| 100407 | 7254M | |
| 100408 | 7254M | |
| 100409 | 7254M | |
| 100410 | 7254M | |
| 100411 | 7254M | |
| 100412 | 7254M | |
| 100413 | 7252M | |
| 100414 | 7196M | |
| 100415 | 7285M,7330 | |
| 100416 | 7285M,7330 | |
| 100417 | 7254M | |
| 100418 | 7254M | |
| 100419 | 7254M | |
| 100420 | 7254M | |
| 100421 | 7254M | |
| 100422 | 7254M | |
| 100423 | 7254M | |
| 100424 | 7254M | |
| 100425 | 7254M | |
| 100426 | 7254M | |
| 100427 | 7254M | |
| 100428 | 7253M,7331 | |
| 100429 | 7252M | |
| 100430 | 7252M | |
| 100477 | 7287M | |
| 100478 | 7287M | |
| 100500 | 7196M | |
| 100503 | 7196M | |
| 100849 | 7286M | |
| 100850 | 7286M | |
| 100851 | 7286M | |
| 100852 | 7286M | |
| 100857 | 7286M | |
| 100858 | 7287M | |
| 100859 | 7287M | |
| 100860 | 7287M | |
| 100861 | 7287M | |
| 100862 | 7287M | |
| 100867 | 7285M,7330 | |
| 100868 | 7285M,7330 | |
| 100869 | 7285M,7330 | |
| 100870 | 7285M,7330 | |
| 100877 | 7285M,7330 | |
| 100878 | 7285M,7330 | |
| 101055 | 7254M | |
| 101056 | 7254M | |
| 101057 | 7254M | |
| 101058 | 7254M | |
| 101059 | 7254M | |
| 101060 | 7254M | |
| 101061 | 7254M | |
| 101062 | 7254M | |
| 101063 | 7254M | |
| 101064 | 7254M | |
| 101065 | 7254M | |
| 101066 | 7254M | |
| 101067 | 7254M | |
| 101068 | 7254M | |
| 101069 | 7254M | |
| 101070 | 7254M | |
| 101071 | 7254M | |
| 101072 | 7254M | |
| 101073 | 7254M | |
| 101074 | 7254M | |
| 101075 | 7254M | |
| 101076 | 7254M | |
| 101077 | 7254M | |
| 101078 | 7254M | |
| 101079 | 7254M | |
| 101080 | 7254M | |
| 101081 | 7254M | |
| 101082 | 7254M | |
| 101083 | 7254M | |
| 101084 | 7254M | |
| 101085 | 7254M | |
| 101086 | 7254M | |
| 101087 | 7254M | |
| 101088 | 7254M | |
| 101089 | 7254M | |
| 101090 | 7254M | |
| 101091 | 7254M |