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 (88295,89695,88289,88294,88113,88125,88137,89689,89694,88111,88112,88123,88124,88135,88136,88110,88122,88134,88287,88288,88290,88291,88292,88293,89687,89688,89690,89691,89692,89693,88285,88286,88283,88284,89685,89686,89683,89684,88363,88109,88121,88133,88280,88281,88282,88357,89680,89681,89682,88362,88108,88120,88132,88276,88277,88278,88279,89676,89677,89678,89679,88355,88356,88358,88359,88360,88361,89675,88107,88119,88131,88275,88353,88354,88271,89674,88351,88352,89670,88106,88118,88130,88264,88273,88274,88270,88268,88269,89669,89662,89672,89673,88267,89667,89668,88348)) 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 |
|---|---|---|---|
| 88106 | D | 96144 | |
| 88107 | D | 96145 | |
| 88108 | D | 96146 | |
| 88109 | D | 96147 | |
| 88110 | D | 96148 | |
| 88111 | D | 96149 | |
| 88112 | D | 96150 | |
| 88113 | D | 96151 | |
| 88118 | D | 96156 | |
| 88119 | D | 96157 | |
| 88120 | D | 96158 | |
| 88121 | D | 96159 | |
| 88122 | D | 96160 | |
| 88123 | D | 96161 | |
| 88124 | D | 96162 | |
| 88125 | D | 96163 | |
| 88130 | D | 96168 | |
| 88131 | D | 96169 | |
| 88132 | D | 96170 | |
| 88133 | D | 96171 | |
| 88134 | D | 96172 | |
| 88135 | D | 96173 | |
| 88136 | D | 96174 | |
| 88137 | D | 96175 | |
| 88264 | D | 96302 | |
| 88267 | D | 96305 | |
| 88268 | D | 96306 | |
| 88269 | D | 96307 | |
| 88270 | D | 96308 | |
| 88271 | D | 96309 | |
| 88273 | D | 96311 | |
| 88274 | D | 96312 | |
| 88275 | D | 96313 | |
| 88276 | D | 96314 | |
| 88277 | D | 96315 | |
| 88278 | D | 96316 | |
| 88279 | D | 96317 | |
| 88280 | D | 96318 | |
| 88281 | D | 96319 | |
| 88282 | D | 96320 | |
| 88283 | D | 96321 | |
| 88284 | D | 96322 | |
| 88285 | D | 96323 | |
| 88286 | D | 96324 | |
| 88287 | D | 96325 | |
| 88288 | D | 96326 | |
| 88289 | D | 96327 | |
| 88290 | D | 96328 | |
| 88291 | D | 96329 | |
| 88292 | D | 96330 | |
| 88293 | D | 96331 | |
| 88294 | D | 96332 | |
| 88295 | D | 96333 | |
| 88348 | D | 96386 | |
| 88351 | D | 96389 | |
| 88352 | D | 96390 | |
| 88353 | D | 96391 | |
| 88354 | D | 96392 | |
| 88355 | D | 96393 | |
| 88356 | D | 96394 | |
| 88357 | D | 96395 | |
| 88358 | D | 96396 | |
| 88359 | D | 96397 | |
| 88360 | D | 96398 | |
| 88361 | D | 96399 | |
| 88362 | D | 96400 | |
| 88363 | D | 96401 | |
| 89662 | D | 97700 | |
| 89667 | D | 97705 | |
| 89668 | D | 97706 | |
| 89669 | D | 97707 | |
| 89670 | D | 97708 | |
| 89672 | D | 97710 | |
| 89673 | D | 97711 | |
| 89674 | D | 97712 | |
| 89675 | D | 97713 | |
| 89676 | D | 97714 | |
| 89677 | D | 97715 | |
| 89678 | D | 97716 | |
| 89679 | D | 97717 | |
| 89680 | D | 97718 | |
| 89681 | D | 97719 | |
| 89682 | D | 97720 | |
| 89683 | D | 97721 | |
| 89684 | D | 97722 | |
| 89685 | D | 97723 | |
| 89686 | D | 97724 | |
| 89687 | D | 97725 | |
| 89688 | D | 97726 | |
| 89689 | D | 97727 | |
| 89690 | D | 97728 | |
| 89691 | D | 97729 | |
| 89692 | D | 97730 | |
| 89693 | D | 97731 | |
| 89694 | D | 97732 | |
| 89695 | D | 97733 |