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 (89712,89713,89670,88106,88118,88130,88264,88273,88274,88270,88302,88303,89708,89709,89666,88268,88269,89669,89705,89662,89672,89673,88267,89667,89668,89710,89711,88348,88349,88350,89665,88300,88301,88265,88266,88272,89706,89707,88344,88345,88346,88347,89663,89664,89671,89701,89702,88105,88117,88129,88263,89660,89659,89661,88343,88365,89658,88296,88297,88115,88127,88139,88299,89699,89700,88342,89704,88381,88382,88104,88116,88128,88262,88338,88377,88378,88114,88126,88138,88298,88334,88337,88364,88374,89657,88330,88340,88341,88261,88335,88336,88379,88380,89703,89721,88333)) 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 |
|---|---|---|---|
| 88104 | D | 96142 | |
| 88105 | D | 96143 | |
| 88106 | D | 96144 | |
| 88114 | D | 96152 | |
| 88115 | D | 96153 | |
| 88116 | D | 96154 | |
| 88117 | D | 96155 | |
| 88118 | D | 96156 | |
| 88126 | D | 96164 | |
| 88127 | D | 96165 | |
| 88128 | D | 96166 | |
| 88129 | D | 96167 | |
| 88130 | D | 96168 | |
| 88138 | D | 96176 | |
| 88139 | D | 96177 | |
| 88261 | D | 96299 | |
| 88262 | D | 96300 | |
| 88263 | D | 96301 | |
| 88264 | D | 96302 | |
| 88265 | D | 96303 | |
| 88266 | D | 96304 | |
| 88267 | D | 96305 | |
| 88268 | D | 96306 | |
| 88269 | D | 96307 | |
| 88270 | D | 96308 | |
| 88272 | D | 96310 | |
| 88273 | D | 96311 | |
| 88274 | D | 96312 | |
| 88296 | D | 96334 | |
| 88297 | D | 96335 | |
| 88298 | D | 96336 | |
| 88299 | D | 96337 | |
| 88300 | D | 96338 | |
| 88301 | D | 96339 | |
| 88302 | D | 96340 | |
| 88303 | D | 96341 | |
| 88330 | D | 96368 | |
| 88333 | D | 96371 | |
| 88334 | D | 96372 | |
| 88335 | D | 96373 | |
| 88336 | D | 96374 | |
| 88337 | D | 96375 | |
| 88338 | D | 96376 | |
| 88340 | D | 96378 | |
| 88341 | D | 96379 | |
| 88342 | D | 96380 | |
| 88343 | D | 96381 | |
| 88344 | D | 96382 | |
| 88345 | D | 96383 | |
| 88346 | D | 96384 | |
| 88347 | D | 96385 | |
| 88348 | D | 96386 | |
| 88349 | D | 96387 | |
| 88350 | D | 96388 | |
| 88364 | D | 96402 | |
| 88365 | D | 96403 | |
| 88374 | D | 96412 | |
| 88377 | D | 96415 | |
| 88378 | D | 96416 | |
| 88379 | D | 96417 | |
| 88380 | D | 96418 | |
| 88381 | D | 96419 | |
| 88382 | D | 96420 | |
| 89657 | D | 97695 | |
| 89658 | D | 97696 | |
| 89659 | D | 97697 | |
| 89660 | D | 97698 | |
| 89661 | D | 97699 | |
| 89662 | D | 97700 | |
| 89663 | D | 97701 | |
| 89664 | D | 97702 | |
| 89665 | D | 97703 | |
| 89666 | D | 97704 | |
| 89667 | D | 97705 | |
| 89668 | D | 97706 | |
| 89669 | D | 97707 | |
| 89670 | D | 97708 | |
| 89671 | D | 97709 | |
| 89672 | D | 97710 | |
| 89673 | D | 97711 | |
| 89699 | D | 97737 | |
| 89700 | D | 97738 | |
| 89701 | D | 97739 | |
| 89702 | D | 97740 | |
| 89703 | D | 97741 | |
| 89704 | D | 97742 | |
| 89705 | D | 97743 | |
| 89706 | D | 97744 | |
| 89707 | D | 97745 | |
| 89708 | D | 97746 | |
| 89709 | D | 97747 | |
| 89710 | D | 97748 | |
| 89711 | D | 97749 | |
| 89712 | D | 97750 | |
| 89713 | D | 97751 | |
| 89721 | D | 97759 |