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 (90714,90720,90713,90719,90728,90729,90717,90723,90725,90727,90712,90718,90586,90587,90730,90731,90724,90726,90716,90722,90592,90593,89243,89244,89253,89254,90588,90590,89245,89246,89247,89248,90589,90591,90715,90721,89249,89250,89251,89252,90048,90049,90050,90051,90052,90053,90018,90019,90020,90021,90032,90033,90034,90035,90036,90037,90042,90043,90044,90045,90046,90047,90058,90059,90014,90015,90016,90017,90026,90027,90028,90029,90030,90031,87836,93834,93835,93882,93883,93884,93885,95360,96122,96124,96125,96126,96127,96131,96155,96156,96195,96196,96197,96198,96199,96200)) 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 |
|---|---|---|---|
| 87836 | D | 95874 | |
| 89243 | D | 97281 | |
| 89244 | D | 97282 | |
| 89245 | D | 97283 | |
| 89246 | D | 97284 | |
| 89247 | D | 97285 | |
| 89248 | D | 97286 | |
| 89249 | D | 97287 | |
| 89250 | D | 97288 | |
| 89251 | D | 97289 | |
| 89252 | D | 97290 | |
| 89253 | D | 97291 | |
| 89254 | D | 97292 | |
| 90014 | D | 98052 | |
| 90015 | D | 98053 | |
| 90016 | D | 98054 | |
| 90017 | D | 98055 | |
| 90018 | D | 98056 | |
| 90019 | D | 98057 | |
| 90020 | D | 98058 | |
| 90021 | D | 98059 | |
| 90026 | D | 98064 | |
| 90027 | D | 98065 | |
| 90028 | D | 98066 | |
| 90029 | D | 98067 | |
| 90030 | D | 98068 | |
| 90031 | D | 98069 | |
| 90032 | D | 98070 | |
| 90033 | D | 98071 | |
| 90034 | D | 98072 | |
| 90035 | D | 98073 | |
| 90036 | D | 98074 | |
| 90037 | D | 98075 | |
| 90042 | D | 98080 | |
| 90043 | D | 98081 | |
| 90044 | D | 98082 | |
| 90045 | D | 98083 | |
| 90046 | D | 98084 | |
| 90047 | D | 98085 | |
| 90048 | D | 98086 | |
| 90049 | D | 98087 | |
| 90050 | D | 98088 | |
| 90051 | D | 98089 | |
| 90052 | D | 98090 | |
| 90053 | D | 98091 | |
| 90058 | D | 98096 | |
| 90059 | D | 98097 | |
| 90586 | D | 98638 | |
| 90587 | D | 98639 | |
| 90588 | D | 98640 | |
| 90589 | D | 98641 | |
| 90590 | D | 98642 | |
| 90591 | D | 98643 | |
| 90592 | D | 98644 | |
| 90593 | D | 98645 | |
| 90712 | D | 98764 | |
| 90713 | D | 98765 | |
| 90714 | D | 98766 | |
| 90715 | D | 98767 | |
| 90716 | D | 98768 | |
| 90717 | D | 98769 | |
| 90718 | D | 98770 | |
| 90719 | D | 98771 | |
| 90720 | D | 98772 | |
| 90721 | D | 98773 | |
| 90722 | D | 98774 | |
| 90723 | D | 98775 | |
| 90724 | D | 98776 | |
| 90725 | D | 98777 | |
| 90726 | D | 98778 | |
| 90727 | D | 98779 | |
| 90728 | D | 98780 | |
| 90729 | D | 98781 | |
| 90730 | D | 98782 | |
| 90731 | D | 98783 | |
| 93834 | B | 101974 | |
| 93835 | B | 101975 | |
| 93882 | B | 102022 | |
| 93883 | B | 102023 | |
| 93884 | B | 102024 | |
| 93885 | B | 102025 | |
| 95360 | B | 103532 | |
| 96122 | B | 104294 | |
| 96124 | B | 104296 | |
| 96125 | B | 104297 | |
| 96126 | B | 104298 | |
| 96127 | B | 104299 | |
| 96131 | B | 104303 | |
| 96155 | B | 104327 | |
| 96156 | B | 104328 | |
| 96195 | B | 104367 | |
| 96196 | B | 104368 | |
| 96197 | B | 104369 | |
| 96198 | B | 104370 | |
| 96199 | B | 104371 | |
| 96200 | B | 104372 |