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 (91727,91728,91729,91730,91731,91732,91733,91734,91755,91756,91757,91758,91759,91760,91761,91762,91763,91812,91813,91814,91815,84942,84934,92167,84737,84739,84725,87980,87983,84715,84741,92161,92162,92163,87984,87970,92164,92165,92166,84714,84713,88023,84947,88032,84848,87985,84912,84736,84688,84712,87979,84960,87976,87978,84850,84743,84849,84951,84747,84761,84711,84710,84911,84717,87969,87967,88038,84846,84910,87981,87982,85274,84687,84709,87977,87918,87919,87920,87924,87926,87930,87931,87932,88027,88089,84940,84941,88024,87898,87899,87902,87968,84728,84729,84730,88022)) 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 |
|---|---|---|---|
| 84687 | D | 92725 | |
| 84688 | D | 92726 | |
| 84709 | D | 92747 | |
| 84710 | D | 92748 | |
| 84711 | D | 92749 | |
| 84712 | D | 92750 | |
| 84713 | D | 92751 | |
| 84714 | D | 92752 | |
| 84715 | D | 92753 | |
| 84717 | D | 92755 | |
| 84725 | D | 92763 | |
| 84728 | D | 92766 | |
| 84729 | D | 92767 | |
| 84730 | D | 92768 | |
| 84736 | D | 92774 | |
| 84737 | D | 92775 | |
| 84739 | D | 92777 | |
| 84741 | D | 92779 | |
| 84743 | D | 92781 | |
| 84747 | D | 92785 | |
| 84761 | D | 92799 | |
| 84846 | D | 92884 | |
| 84848 | D | 92886 | |
| 84849 | D | 92887 | |
| 84850 | D | 92888 | |
| 84910 | D | 92948 | |
| 84911 | D | 92949 | |
| 84912 | D | 92950 | |
| 84934 | D | 92972 | |
| 84940 | D | 92978 | |
| 84941 | D | 92979 | |
| 84942 | D | 92980 | |
| 84947 | D | 92985 | |
| 84951 | D | 92989 | |
| 84960 | D | 92998 | |
| 85274 | D | 93312 | |
| 87898 | D | 95936 | |
| 87899 | D | 95937 | |
| 87902 | D | 95940 | |
| 87918 | D | 95956 | |
| 87919 | D | 95957 | |
| 87920 | D | 95958 | |
| 87924 | D | 95962 | |
| 87926 | D | 95964 | |
| 87930 | D | 95968 | |
| 87931 | D | 95969 | |
| 87932 | D | 95970 | |
| 87967 | D | 96005 | |
| 87968 | D | 96006 | |
| 87969 | D | 96007 | |
| 87970 | D | 96008 | |
| 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 | |
| 88022 | D | 96060 | |
| 88023 | D | 96061 | |
| 88024 | D | 96062 | |
| 88027 | D | 96065 | |
| 88032 | D | 96070 | |
| 88038 | D | 96076 | |
| 88089 | D | 96127 | |
| 91727 | D | 99800 | |
| 91728 | D | 99801 | |
| 91729 | D | 99802 | |
| 91730 | D | 99803 | |
| 91731 | D | 99804 | |
| 91732 | D | 99805 | |
| 91733 | D | 99806 | |
| 91734 | D | 99807 | |
| 91755 | D | 99828 | |
| 91756 | D | 99829 | |
| 91757 | D | 99830 | |
| 91758 | D | 99831 | |
| 91759 | D | 99832 | |
| 91760 | D | 99833 | |
| 91761 | D | 99834 | |
| 91762 | D | 99835 | |
| 91763 | D | 99836 | |
| 91812 | D | 99890 | |
| 91813 | D | 99891 | |
| 91814 | D | 99892 | |
| 91815 | D | 99893 | |
| 92161 | D | 100239 | |
| 92162 | D | 100240 | |
| 92163 | D | 100241 | |
| 92164 | D | 100242 | |
| 92165 | D | 100243 | |
| 92166 | D | 100244 | |
| 92167 | D | 100245 |