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": "90.30"
},
"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": 100,
"rows_produced_per_join": 100,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "10.30",
"eval_cost": "10.00",
"prefix_cost": "20.30",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
],
"attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (87354,87352,87353,87378,87376,87377,87374,82509,87373,82508,82537,82547,91482,82532,82545,82546,89571,82544,89569,92584,92585,92586,92590,92591,92592,93951,93952,93953,93954,93955,93956,94838,95004,95005,95006,95007,95008,95009,95046,95047,95048,95057,95058,95059,95060,95061,95062,95066,95067,95068,95328,95329,95330,95344,95345,95346,95349,95352,95358,95359,95452,95536,95537,95538,95539,95540,95541,95552,95553,95554,96177,96178,96179,96180,96191,96192,96828,96829,96830,96831,96834,96835,96836,96837,96838,96887,96888,96889,96890,96891,96892,96931,96932,96933,96942,96943))"
}
},
{
"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": 100,
"filtered": "100.00",
"cost_info": {
"read_cost": "25.00",
"eval_cost": "10.00",
"prefix_cost": "55.30",
"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": "25.00",
"eval_cost": "0.50",
"prefix_cost": "90.30",
"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 |
|---|---|---|
| 82508 | 7165,7168,7176M | 0 |
| 82509 | 7165,7176M,7168 | 0 |
| 82532 | 7176M | 0 |
| 82537 | 7176M | 0 |
| 82544 | 7176M | 0 |
| 82545 | 7176M | 0 |
| 82546 | 7176M | 0 |
| 82547 | 7176M | 0 |
| 87352 | 7176M | 0 |
| 87353 | 7176M | 0 |
| 87354 | 7176M | 0 |
| 87373 | 7176M | 0 |
| 87374 | 7176M | 0 |
| 87376 | 7176M | 0 |
| 87377 | 7176M | 0 |
| 87378 | 7176M | 0 |
| 89569 | 7176M | 0 |
| 89571 | 7176M | 0 |
| 91482 | 7176M | 0 |
| 92584 | 7176M | 0 |
| 92585 | 7176M | 0 |
| 92586 | 7176M | 0 |
| 92590 | 7176M | 0 |
| 92591 | 7176M | 0 |
| 92592 | 7176M | 0 |
| 93951 | 7176M | 0 |
| 93952 | 7176M | 0 |
| 93953 | 7176M | 0 |
| 93954 | 7176M | 0 |
| 93955 | 7176M | 0 |
| 93956 | 7176M | 0 |
| 94838 | 7176M | 0 |
| 95004 | 7176M | 0 |
| 95005 | 7176M | 0 |
| 95006 | 7176M | 0 |
| 95007 | 7176M | 0 |
| 95008 | 7176M | 0 |
| 95009 | 7176M | 0 |
| 95046 | 7176M | 0 |
| 95047 | 7176M | 0 |
| 95048 | 7176M | 0 |
| 95057 | 7176M | 0 |
| 95058 | 7176M | 0 |
| 95059 | 7176M | 0 |
| 95060 | 7176M | 0 |
| 95061 | 7176M | 0 |
| 95062 | 7176M | 0 |
| 95066 | 7176M | 0 |
| 95067 | 7176M | 0 |
| 95068 | 7176M | 0 |
| 95328 | 7176M | 0 |
| 95329 | 7176M | 0 |
| 95330 | 7176M | 0 |
| 95344 | 7176M | 0 |
| 95345 | 7176M | 0 |
| 95346 | 7176M | 0 |
| 95349 | 7176M | 0 |
| 95352 | 7176M | 0 |
| 95358 | 7176M | 0 |
| 95359 | 7176M | 0 |
| 95452 | 7176M | 0 |
| 95536 | 7176M | 0 |
| 95537 | 7176M | 0 |
| 95538 | 7176M | 0 |
| 95539 | 7176M | 0 |
| 95540 | 7176M | 0 |
| 95541 | 7176M | 0 |
| 95552 | 7176M | 0 |
| 95553 | 7176M | 0 |
| 95554 | 7176M | 0 |
| 96177 | 7176M | 0 |
| 96178 | 7176M | 0 |
| 96179 | 7176M | 0 |
| 96180 | 7176M | 0 |
| 96191 | 7176M | 0 |
| 96192 | 7176M | 0 |
| 96828 | 7176M | 0 |
| 96829 | 7176M | 0 |
| 96830 | 7176M | 0 |
| 96831 | 7176M | 0 |
| 96834 | 7176M | 0 |
| 96835 | 7176M | 0 |
| 96836 | 7176M | 0 |
| 96837 | 7176M | 0 |
| 96838 | 7176M | 0 |
| 96887 | 7176M | 0 |
| 96888 | 7176M | 0 |
| 96889 | 7176M | 0 |
| 96890 | 7176M | 0 |
| 96891 | 7176M | 0 |
| 96892 | 7176M | 0 |
| 96931 | 7176M | 0 |
| 96932 | 7176M | 0 |
| 96933 | 7176M | 0 |
| 96942 | 7176M | 0 |
| 96943 | 7176M | 0 |