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": "103.76"
},
"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": 90,
"rows_produced_per_join": 90,
"filtered": "100.00",
"index_condition": "((`nuie_scalesta_net`.`cscart_discussion`.`object_id` in (92067,92068,92069,92070,92071,92072,92073,92083,92084,92085,92086,92087,92088,92089,84018,84019,84020,84021,83974,83975,83976,83977,92066,92082,90073,89179,86383,83095,84101,93039,93040,93041,93042,93043,93044,93045,93046,94718,94722,94727,94731,94735,94739,94743,94747,97025,97842,97846,97851,97855,97859,97863,97867,97871,97911,97912,97913,97914,97943,97944,97945,97946,97968,98107,98108,98109,98110,98111,98112,98113,98114,98351,98352,98353,98354,98355,98356,98357,98358,98359,98360,98361,98362,98363,98364,98365,98366,98685,100145,100891)) and (`nuie_scalesta_net`.`cscart_discussion`.`object_type` = 'P'))",
"cost_info": {
"read_cost": "54.01",
"eval_cost": "9.00",
"prefix_cost": "63.01",
"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": 90,
"filtered": "100.00",
"cost_info": {
"read_cost": "22.50",
"eval_cost": "9.00",
"prefix_cost": "94.51",
"data_read_per_join": "39K"
},
"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": 90,
"filtered": "100.00",
"using_join_buffer": "hash join",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "9.00",
"prefix_cost": "103.76",
"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 |
|---|---|---|---|
| 83095 | D | 91133 | |
| 83974 | D | 92012 | |
| 83975 | D | 92013 | |
| 83976 | D | 92014 | |
| 83977 | D | 92015 | |
| 84018 | D | 92056 | |
| 84019 | D | 92057 | |
| 84020 | D | 92058 | |
| 84021 | D | 92059 | |
| 84101 | D | 92139 | |
| 86383 | D | 94421 | |
| 89179 | D | 97217 | |
| 90073 | D | 98111 | |
| 92066 | D | 100144 | |
| 92067 | D | 100145 | |
| 92068 | D | 100146 | |
| 92069 | D | 100147 | |
| 92070 | D | 100148 | |
| 92071 | D | 100149 | |
| 92072 | D | 100150 | |
| 92073 | D | 100151 | |
| 92082 | D | 100160 | |
| 92083 | D | 100161 | |
| 92084 | D | 100162 | |
| 92085 | D | 100163 | |
| 92086 | D | 100164 | |
| 92087 | D | 100165 | |
| 92088 | D | 100166 | |
| 92089 | D | 100167 | |
| 93039 | B | 101179 | |
| 93040 | B | 101180 | |
| 93041 | B | 101181 | |
| 93042 | B | 101182 | |
| 93043 | B | 101183 | |
| 93044 | B | 101184 | |
| 93045 | B | 101185 | |
| 93046 | B | 101186 | |
| 94718 | B | 102890 | |
| 94722 | B | 102894 | |
| 94727 | B | 102899 | |
| 94731 | B | 102903 | |
| 94735 | B | 102907 | |
| 94739 | B | 102911 | |
| 94743 | B | 102915 | |
| 94747 | B | 102919 | |
| 97025 | B | 105206 | |
| 97842 | B | 106023 | |
| 97846 | B | 106027 | |
| 97851 | B | 106032 | |
| 97855 | B | 106036 | |
| 97859 | B | 106040 | |
| 97863 | B | 106044 | |
| 97867 | B | 106048 | |
| 97871 | B | 106052 | |
| 97911 | B | 106092 | |
| 97912 | B | 106093 | |
| 97913 | B | 106094 | |
| 97914 | B | 106095 | |
| 97943 | B | 106124 | |
| 97944 | B | 106125 | |
| 97945 | B | 106126 | |
| 97946 | B | 106127 | |
| 97968 | B | 106149 | |
| 98107 | B | 106288 | |
| 98108 | B | 106289 | |
| 98109 | B | 106290 | |
| 98110 | B | 106291 | |
| 98111 | B | 106292 | |
| 98112 | B | 106293 | |
| 98113 | B | 106294 | |
| 98114 | B | 106295 | |
| 98351 | B | 106532 | |
| 98352 | B | 106533 | |
| 98353 | B | 106534 | |
| 98354 | B | 106535 | |
| 98355 | B | 106536 | |
| 98356 | B | 106537 | |
| 98357 | B | 106538 | |
| 98358 | B | 106539 | |
| 98359 | B | 106540 | |
| 98360 | B | 106541 | |
| 98361 | B | 106542 | |
| 98362 | B | 106543 | |
| 98363 | B | 106544 | |
| 98364 | B | 106545 | |
| 98365 | B | 106546 | |
| 98366 | B | 106547 | |
| 98685 | B | 106866 | |
| 100145 | B | 108325 | |
| 100891 | B | 109071 |