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 (94732,94736,94740,94744,94748,96305,96306,96307,96309,96312,96315,96317,96320,96322,96324,96326,96328,96330,96332,96335,96339,97016,97022,97023,97026,97030,97032,97039,97045,97833,97843,97847,97852,97856,97860,97864,97868,97872,97890,97891,97892,97893,97894,97895,97896,97897,97898,97899,97900,97901,97902,97915,97916,97917,97918,97919,97920,97921,97922,97923,97924,97925,97926,97927,97928,97929,97930,97931,97932,97933,97934,97947,97948,97949,97950,97951,97960,97961,97964,97965,97966,97969,97974,97976,97977,97980,97981,97984,97985,98040,98042,98044,98046,98048,98050,98085)) 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 |
|---|---|---|---|
| 94732 | B | 102904 | |
| 94736 | B | 102908 | |
| 94740 | B | 102912 | |
| 94744 | B | 102916 | |
| 94748 | B | 102920 | |
| 96305 | B | 104477 | |
| 96306 | B | 104478 | |
| 96307 | B | 104479 | |
| 96309 | B | 104481 | |
| 96312 | B | 104484 | |
| 96315 | B | 104487 | |
| 96317 | B | 104489 | |
| 96320 | B | 104492 | |
| 96322 | B | 104494 | |
| 96324 | B | 104496 | |
| 96326 | B | 104498 | |
| 96328 | B | 104500 | |
| 96330 | B | 104502 | |
| 96332 | B | 104504 | |
| 96335 | B | 104507 | |
| 96339 | B | 104511 | |
| 97016 | B | 105197 | |
| 97022 | B | 105203 | |
| 97023 | B | 105204 | |
| 97026 | B | 105207 | |
| 97030 | B | 105211 | |
| 97032 | B | 105213 | |
| 97039 | B | 105220 | |
| 97045 | B | 105226 | |
| 97833 | B | 106014 | |
| 97843 | B | 106024 | |
| 97847 | B | 106028 | |
| 97852 | B | 106033 | |
| 97856 | B | 106037 | |
| 97860 | B | 106041 | |
| 97864 | B | 106045 | |
| 97868 | B | 106049 | |
| 97872 | B | 106053 | |
| 97890 | B | 106071 | |
| 97891 | B | 106072 | |
| 97892 | B | 106073 | |
| 97893 | B | 106074 | |
| 97894 | B | 106075 | |
| 97895 | B | 106076 | |
| 97896 | B | 106077 | |
| 97897 | B | 106078 | |
| 97898 | B | 106079 | |
| 97899 | B | 106080 | |
| 97900 | B | 106081 | |
| 97901 | B | 106082 | |
| 97902 | B | 106083 | |
| 97915 | B | 106096 | |
| 97916 | B | 106097 | |
| 97917 | B | 106098 | |
| 97918 | B | 106099 | |
| 97919 | B | 106100 | |
| 97920 | B | 106101 | |
| 97921 | B | 106102 | |
| 97922 | B | 106103 | |
| 97923 | B | 106104 | |
| 97924 | B | 106105 | |
| 97925 | B | 106106 | |
| 97926 | B | 106107 | |
| 97927 | B | 106108 | |
| 97928 | B | 106109 | |
| 97929 | B | 106110 | |
| 97930 | B | 106111 | |
| 97931 | B | 106112 | |
| 97932 | B | 106113 | |
| 97933 | B | 106114 | |
| 97934 | B | 106115 | |
| 97947 | B | 106128 | |
| 97948 | B | 106129 | |
| 97949 | B | 106130 | |
| 97950 | B | 106131 | |
| 97951 | B | 106132 | |
| 97960 | B | 106141 | |
| 97961 | B | 106142 | |
| 97964 | B | 106145 | |
| 97965 | B | 106146 | |
| 97966 | B | 106147 | |
| 97969 | B | 106150 | |
| 97974 | B | 106155 | |
| 97976 | B | 106157 | |
| 97977 | B | 106158 | |
| 97980 | B | 106161 | |
| 97981 | B | 106162 | |
| 97984 | B | 106165 | |
| 97985 | B | 106166 | |
| 98040 | B | 106221 | |
| 98042 | B | 106223 | |
| 98044 | B | 106225 | |
| 98046 | B | 106227 | |
| 98048 | B | 106229 | |
| 98050 | B | 106231 | |
| 98085 | B | 106266 |