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 (90187,90188,90284,90292,90145,90160,84052,84060,90130,85965,90299,90306,90144,90159,90249,90257,83941,84085,90283,90291,90143,90158,90200,90211,85968,90195,84089,90170,90171,90134,90135,85964,90298,90305,90230,90245,90184,90185,90136,83940,84084,90282,90290,90208,90219,85967,90248,90256,90227,84051,84059,90281,90289,85963,90177,90178,90247,90255,83939,84083,90207,90218,90179,90133,90229,90244,90280,90288,90194,90254,90262,85962,90228,90243,83938,84082,90169,90174,90175,90206,90217,90193,84050,84058,90226,90237,90242,90253,90261,90186,85961,90252,90260,90251,90259,90279)) 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 |
|---|---|---|---|
| 83938 | D | 91976 | |
| 83939 | D | 91977 | |
| 83940 | D | 91978 | |
| 83941 | D | 91979 | |
| 84050 | D | 92088 | |
| 84051 | D | 92089 | |
| 84052 | D | 92090 | |
| 84058 | D | 92096 | |
| 84059 | D | 92097 | |
| 84060 | D | 92098 | |
| 84082 | D | 92120 | |
| 84083 | D | 92121 | |
| 84084 | D | 92122 | |
| 84085 | D | 92123 | |
| 84089 | D | 92127 | |
| 85961 | D | 93999 | |
| 85962 | D | 94000 | |
| 85963 | D | 94001 | |
| 85964 | D | 94002 | |
| 85965 | D | 94003 | |
| 85967 | D | 94005 | |
| 85968 | D | 94006 | |
| 90130 | D | 98168 | |
| 90133 | D | 98171 | |
| 90134 | D | 98172 | |
| 90135 | D | 98173 | |
| 90136 | D | 98174 | |
| 90143 | D | 98181 | |
| 90144 | D | 98182 | |
| 90145 | D | 98183 | |
| 90158 | D | 98196 | |
| 90159 | D | 98197 | |
| 90160 | D | 98198 | |
| 90169 | D | 98207 | |
| 90170 | D | 98208 | |
| 90171 | D | 98209 | |
| 90174 | D | 98212 | |
| 90175 | D | 98213 | |
| 90177 | D | 98215 | |
| 90178 | D | 98216 | |
| 90179 | D | 98217 | |
| 90184 | D | 98222 | |
| 90185 | D | 98223 | |
| 90186 | D | 98224 | |
| 90187 | D | 98225 | |
| 90188 | D | 98226 | |
| 90193 | D | 98231 | |
| 90194 | D | 98232 | |
| 90195 | D | 98233 | |
| 90200 | D | 98238 | |
| 90206 | D | 98244 | |
| 90207 | D | 98245 | |
| 90208 | D | 98246 | |
| 90211 | D | 98249 | |
| 90217 | D | 98255 | |
| 90218 | D | 98256 | |
| 90219 | D | 98257 | |
| 90226 | D | 98264 | |
| 90227 | D | 98265 | |
| 90228 | D | 98266 | |
| 90229 | D | 98267 | |
| 90230 | D | 98268 | |
| 90237 | D | 98275 | |
| 90242 | D | 98280 | |
| 90243 | D | 98281 | |
| 90244 | D | 98282 | |
| 90245 | D | 98283 | |
| 90247 | D | 98285 | |
| 90248 | D | 98286 | |
| 90249 | D | 98287 | |
| 90251 | D | 98289 | |
| 90252 | D | 98290 | |
| 90253 | D | 98291 | |
| 90254 | D | 98292 | |
| 90255 | D | 98293 | |
| 90256 | D | 98294 | |
| 90257 | D | 98295 | |
| 90259 | D | 98297 | |
| 90260 | D | 98298 | |
| 90261 | D | 98299 | |
| 90262 | D | 98300 | |
| 90279 | D | 98317 | |
| 90280 | D | 98318 | |
| 90281 | D | 98319 | |
| 90282 | D | 98320 | |
| 90283 | D | 98321 | |
| 90284 | D | 98322 | |
| 90288 | D | 98326 | |
| 90289 | D | 98327 | |
| 90290 | D | 98328 | |
| 90291 | D | 98329 | |
| 90292 | D | 98330 | |
| 90298 | D | 98336 | |
| 90299 | D | 98337 | |
| 90305 | D | 98343 | |
| 90306 | D | 98344 |