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 (99891,99892,99893,99894,99895,99896,99897,99898,99899,99900,99901,99902,99903,99904,99905,99906,99907,99908,99909,99910,99911,99912,99913,99914,99915,99916,99917,99918,99919,99920,99921,99922,99923,99924,99925,99926,99927,99928,99929,99930,99931,99932,99933,99934,99935,99936,99937,99938,99939,99940,99941,99942,99943,99944,99945,99946,99947,99948,99949,99950,99951,99952,99953,99954,99955,99956,99957,99958,99959,99960,99961,99962,99963,99964,99965,99966,99967,99968,99969,99970,99971,99972,99973,99974,99975,99976,99977,99978,99979,99980,99981,99982,99983,99984,99985,99986)) 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 |
|---|---|---|---|
| 99891 | B | 108071 | |
| 99892 | B | 108072 | |
| 99893 | B | 108073 | |
| 99894 | B | 108074 | |
| 99895 | B | 108075 | |
| 99896 | B | 108076 | |
| 99897 | B | 108077 | |
| 99898 | B | 108078 | |
| 99899 | B | 108079 | |
| 99900 | B | 108080 | |
| 99901 | B | 108081 | |
| 99902 | B | 108082 | |
| 99903 | B | 108083 | |
| 99904 | B | 108084 | |
| 99905 | B | 108085 | |
| 99906 | B | 108086 | |
| 99907 | B | 108087 | |
| 99908 | B | 108088 | |
| 99909 | B | 108089 | |
| 99910 | B | 108090 | |
| 99911 | B | 108091 | |
| 99912 | B | 108092 | |
| 99913 | B | 108093 | |
| 99914 | B | 108094 | |
| 99915 | B | 108095 | |
| 99916 | B | 108096 | |
| 99917 | B | 108097 | |
| 99918 | B | 108098 | |
| 99919 | B | 108099 | |
| 99920 | B | 108100 | |
| 99921 | B | 108101 | |
| 99922 | B | 108102 | |
| 99923 | B | 108103 | |
| 99924 | B | 108104 | |
| 99925 | B | 108105 | |
| 99926 | B | 108106 | |
| 99927 | B | 108107 | |
| 99928 | B | 108108 | |
| 99929 | B | 108109 | |
| 99930 | B | 108110 | |
| 99931 | B | 108111 | |
| 99932 | B | 108112 | |
| 99933 | B | 108113 | |
| 99934 | B | 108114 | |
| 99935 | B | 108115 | |
| 99936 | B | 108116 | |
| 99937 | B | 108117 | |
| 99938 | B | 108118 | |
| 99939 | B | 108119 | |
| 99940 | B | 108120 | |
| 99941 | B | 108121 | |
| 99942 | B | 108122 | |
| 99943 | B | 108123 | |
| 99944 | B | 108124 | |
| 99945 | B | 108125 | |
| 99946 | B | 108126 | |
| 99947 | B | 108127 | |
| 99948 | B | 108128 | |
| 99949 | B | 108129 | |
| 99950 | B | 108130 | |
| 99951 | B | 108131 | |
| 99952 | B | 108132 | |
| 99953 | B | 108133 | |
| 99954 | B | 108134 | |
| 99955 | B | 108135 | |
| 99956 | B | 108136 | |
| 99957 | B | 108137 | |
| 99958 | B | 108138 | |
| 99959 | B | 108139 | |
| 99960 | B | 108140 | |
| 99961 | B | 108141 | |
| 99962 | B | 108142 | |
| 99963 | B | 108143 | |
| 99964 | B | 108144 | |
| 99965 | B | 108145 | |
| 99966 | B | 108146 | |
| 99967 | B | 108147 | |
| 99968 | B | 108148 | |
| 99969 | B | 108149 | |
| 99970 | B | 108150 | |
| 99971 | B | 108151 | |
| 99972 | B | 108152 | |
| 99973 | B | 108153 | |
| 99974 | B | 108154 | |
| 99975 | B | 108155 | |
| 99976 | B | 108156 | |
| 99977 | B | 108157 | |
| 99978 | B | 108158 | |
| 99979 | B | 108159 | |
| 99980 | B | 108160 | |
| 99981 | B | 108161 | |
| 99982 | B | 108162 | |
| 99983 | B | 108163 | |
| 99984 | B | 108164 | |
| 99985 | B | 108165 | |
| 99986 | B | 108166 |