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 (91061,84716,88063,84738,92171,84726,84742,91063,91062,91057,84935,91060,91055,91058,84858,92175,91056,84740,91059,84942,84934,92167,84737,84739,84725,87980,87983,84741,87984,87970,88023,84947,88032,84848,87985,84912,84736,84688,87979,84960,87976,87978,84850,84743,84849,84951,84747,84761,84911,84717,87969,87967,88038,84846,84910,87981,87982,85274,84687,84709,87977,88027,88089,88024,87968,88022,84708,84749,88042,87974,84271,87991,87966,88017,88039,91064,84270,88033,88007,84269,88016,93150,93151,93152,93153,93154,93155,93156,93157,93158,93159,93789,93795,93796,93797,94448)) 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 |
|---|---|---|---|
| 84269 | D | 92307 | |
| 84270 | D | 92308 | |
| 84271 | D | 92309 | |
| 84687 | D | 92725 | |
| 84688 | D | 92726 | |
| 84708 | D | 92746 | |
| 84709 | D | 92747 | |
| 84716 | D | 92754 | |
| 84717 | D | 92755 | |
| 84725 | D | 92763 | |
| 84726 | D | 92764 | |
| 84736 | D | 92774 | |
| 84737 | D | 92775 | |
| 84738 | D | 92776 | |
| 84739 | D | 92777 | |
| 84740 | D | 92778 | |
| 84741 | D | 92779 | |
| 84742 | D | 92780 | |
| 84743 | D | 92781 | |
| 84747 | D | 92785 | |
| 84749 | D | 92787 | |
| 84761 | D | 92799 | |
| 84846 | D | 92884 | |
| 84848 | D | 92886 | |
| 84849 | D | 92887 | |
| 84850 | D | 92888 | |
| 84858 | D | 92896 | |
| 84910 | D | 92948 | |
| 84911 | D | 92949 | |
| 84912 | D | 92950 | |
| 84934 | D | 92972 | |
| 84935 | D | 92973 | |
| 84942 | D | 92980 | |
| 84947 | D | 92985 | |
| 84951 | D | 92989 | |
| 84960 | D | 92998 | |
| 85274 | D | 93312 | |
| 87966 | D | 96004 | |
| 87967 | D | 96005 | |
| 87968 | D | 96006 | |
| 87969 | D | 96007 | |
| 87970 | D | 96008 | |
| 87974 | D | 96012 | |
| 87976 | D | 96014 | |
| 87977 | D | 96015 | |
| 87978 | D | 96016 | |
| 87979 | D | 96017 | |
| 87980 | D | 96018 | |
| 87981 | D | 96019 | |
| 87982 | D | 96020 | |
| 87983 | D | 96021 | |
| 87984 | D | 96022 | |
| 87985 | D | 96023 | |
| 87991 | D | 96029 | |
| 88007 | D | 96045 | |
| 88016 | D | 96054 | |
| 88017 | D | 96055 | |
| 88022 | D | 96060 | |
| 88023 | D | 96061 | |
| 88024 | D | 96062 | |
| 88027 | D | 96065 | |
| 88032 | D | 96070 | |
| 88033 | D | 96071 | |
| 88038 | D | 96076 | |
| 88039 | D | 96077 | |
| 88042 | D | 96080 | |
| 88063 | D | 96101 | |
| 88089 | D | 96127 | |
| 91055 | D | 99128 | |
| 91056 | D | 99129 | |
| 91057 | D | 99130 | |
| 91058 | D | 99131 | |
| 91059 | D | 99132 | |
| 91060 | D | 99133 | |
| 91061 | D | 99134 | |
| 91062 | D | 99135 | |
| 91063 | D | 99136 | |
| 91064 | D | 99137 | |
| 92167 | D | 100245 | |
| 92171 | D | 100249 | |
| 92175 | D | 100253 | |
| 93150 | B | 101290 | |
| 93151 | B | 101291 | |
| 93152 | B | 101292 | |
| 93153 | B | 101293 | |
| 93154 | B | 101294 | |
| 93155 | B | 101295 | |
| 93156 | B | 101296 | |
| 93157 | B | 101297 | |
| 93158 | B | 101298 | |
| 93159 | B | 101299 | |
| 93789 | B | 101929 | |
| 93795 | B | 101935 | |
| 93796 | B | 101936 | |
| 93797 | B | 101937 | |
| 94448 | B | 102594 |