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": "110.66"
},
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_discussion",
"access_type": "range",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"rows_examined_per_scan": 96,
"rows_produced_per_join": 96,
"filtered": "100.00",
"index_condition": "((`nuie_scalesta_net`.`cscart_discussion`.`object_id` in (88349,88350,89665,88265,88266,88272,88344,88345,88346,88347,89663,89664,89671,89660,89659,88343,89658,88342,88338,88337,88330,88340,88341,88335,88336,88333,88331,88332,88339,88328,88327,88326,94384,94385,94386,94388,94389,94390,94391,94392,94393,94394,94395,94398,94401,94402,94403,94404,94405,94406,94407,94408,94409,94410,94411,94412,94413,94414,94415,94416,94417,94418,94420,94421,94422,94425,94854,94855,94856,94857,94861,94862,94863,94864,94865,94866,94869,94872,94873,94874,94875,94876,94877,94878,94879,94880,94881,94882,94883,94884,94885,94886,94887,94888,94889,94890)) and (`nuie_scalesta_net`.`cscart_discussion`.`object_type` = 'P'))",
"cost_info": {
"read_cost": "57.61",
"eval_cost": "9.60",
"prefix_cost": "67.21",
"data_read_per_join": "2K"
},
"used_columns": [
"thread_id",
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id",
"used_key_parts": [
"thread_id"
],
"key_length": "3",
"ref": [
"nuie_scalesta_net.cscart_discussion.thread_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 96,
"filtered": "100.00",
"cost_info": {
"read_cost": "24.00",
"eval_cost": "9.60",
"prefix_cost": "100.81",
"data_read_per_join": "42K"
},
"used_columns": [
"post_id",
"thread_id",
"status"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_posts), (`nuie_scalesta_net`.`cscart_discussion_posts`.`status` = 'A'), true)"
}
},
{
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "ALL",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 96,
"filtered": "100.00",
"using_join_buffer": "hash join",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "9.60",
"prefix_cost": "110.66",
"data_read_per_join": "1K"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_rating), ((`nuie_scalesta_net`.`cscart_discussion_rating`.`post_id` = `nuie_scalesta_net`.`cscart_discussion_posts`.`post_id`) and (`nuie_scalesta_net`.`cscart_discussion_rating`.`thread_id` = `nuie_scalesta_net`.`cscart_discussion`.`thread_id`) and (`nuie_scalesta_net`.`cscart_discussion_rating`.`rating_value` <> 0)), true)"
}
}
]
}
}
}
| product_id | average_rating | discussion_type | discussion_thread_id |
|---|---|---|---|
| 88265 | D | 96303 | |
| 88266 | D | 96304 | |
| 88272 | D | 96310 | |
| 88326 | D | 96364 | |
| 88327 | D | 96365 | |
| 88328 | D | 96366 | |
| 88330 | D | 96368 | |
| 88331 | D | 96369 | |
| 88332 | D | 96370 | |
| 88333 | D | 96371 | |
| 88335 | D | 96373 | |
| 88336 | D | 96374 | |
| 88337 | D | 96375 | |
| 88338 | D | 96376 | |
| 88339 | D | 96377 | |
| 88340 | D | 96378 | |
| 88341 | D | 96379 | |
| 88342 | D | 96380 | |
| 88343 | D | 96381 | |
| 88344 | D | 96382 | |
| 88345 | D | 96383 | |
| 88346 | D | 96384 | |
| 88347 | D | 96385 | |
| 88349 | D | 96387 | |
| 88350 | D | 96388 | |
| 89658 | D | 97696 | |
| 89659 | D | 97697 | |
| 89660 | D | 97698 | |
| 89663 | D | 97701 | |
| 89664 | D | 97702 | |
| 89665 | D | 97703 | |
| 89671 | D | 97709 | |
| 94384 | B | 102529 | |
| 94385 | B | 102530 | |
| 94386 | B | 102531 | |
| 94388 | B | 102533 | |
| 94389 | B | 102534 | |
| 94390 | B | 102535 | |
| 94391 | B | 102536 | |
| 94392 | B | 102537 | |
| 94393 | B | 102538 | |
| 94394 | B | 102539 | |
| 94395 | B | 102540 | |
| 94398 | B | 102543 | |
| 94401 | B | 102546 | |
| 94402 | B | 102547 | |
| 94403 | B | 102548 | |
| 94404 | B | 102549 | |
| 94405 | B | 102550 | |
| 94406 | B | 102551 | |
| 94407 | B | 102552 | |
| 94408 | B | 102553 | |
| 94409 | B | 102554 | |
| 94410 | B | 102555 | |
| 94411 | B | 102556 | |
| 94412 | B | 102557 | |
| 94413 | B | 102558 | |
| 94414 | B | 102559 | |
| 94415 | B | 102560 | |
| 94416 | B | 102561 | |
| 94417 | B | 102562 | |
| 94418 | B | 102563 | |
| 94420 | B | 102565 | |
| 94421 | B | 102566 | |
| 94422 | B | 102567 | |
| 94425 | B | 102570 | |
| 94854 | B | 103026 | |
| 94855 | B | 103027 | |
| 94856 | B | 103028 | |
| 94857 | B | 103029 | |
| 94861 | B | 103033 | |
| 94862 | B | 103034 | |
| 94863 | B | 103035 | |
| 94864 | B | 103036 | |
| 94865 | B | 103037 | |
| 94866 | B | 103038 | |
| 94869 | B | 103041 | |
| 94872 | B | 103044 | |
| 94873 | B | 103045 | |
| 94874 | B | 103046 | |
| 94875 | B | 103047 | |
| 94876 | B | 103048 | |
| 94877 | B | 103049 | |
| 94878 | B | 103050 | |
| 94879 | B | 103051 | |
| 94880 | B | 103052 | |
| 94881 | B | 103053 | |
| 94882 | B | 103054 | |
| 94883 | B | 103055 | |
| 94884 | B | 103056 | |
| 94885 | B | 103057 | |
| 94886 | B | 103058 | |
| 94887 | B | 103059 | |
| 94888 | B | 103060 | |
| 94889 | B | 103061 | |
| 94890 | B | 103062 |