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 (94891,94892,94894,94895,94898,94903,94904,94905,94908,94909,94910,94911,94912,94913,94914,94915,94918,94921,94922,94923,94924,94925,94926,94927,94928,94929,94930,94931,94932,94933,94934,94935,94936,94937,94938,94941,94943,94944,94947,96247,96248,96249,96252,96253,96254,96255,96256,96257,96258,96259,96262,96265,96266,96267,96268,96269,96270,96271,96272,96273,96274,96275,96276,96277,96278,96279,96280,96281,96282,96287,96288,96289,96292,96574,96575,96577,96578,96579,96580,96584,96585,96586,96587,96588,96589,96590,96591,96592,96593,96594,96595,96596,100547,100548,100549,100551)) 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 |
|---|---|---|---|
| 94891 | B | 103063 | |
| 94892 | B | 103064 | |
| 94894 | B | 103066 | |
| 94895 | B | 103067 | |
| 94898 | B | 103070 | |
| 94903 | B | 103075 | |
| 94904 | B | 103076 | |
| 94905 | B | 103077 | |
| 94908 | B | 103080 | |
| 94909 | B | 103081 | |
| 94910 | B | 103082 | |
| 94911 | B | 103083 | |
| 94912 | B | 103084 | |
| 94913 | B | 103085 | |
| 94914 | B | 103086 | |
| 94915 | B | 103087 | |
| 94918 | B | 103090 | |
| 94921 | B | 103093 | |
| 94922 | B | 103094 | |
| 94923 | B | 103095 | |
| 94924 | B | 103096 | |
| 94925 | B | 103097 | |
| 94926 | B | 103098 | |
| 94927 | B | 103099 | |
| 94928 | B | 103100 | |
| 94929 | B | 103101 | |
| 94930 | B | 103102 | |
| 94931 | B | 103103 | |
| 94932 | B | 103104 | |
| 94933 | B | 103105 | |
| 94934 | B | 103106 | |
| 94935 | B | 103107 | |
| 94936 | B | 103108 | |
| 94937 | B | 103109 | |
| 94938 | B | 103110 | |
| 94941 | B | 103113 | |
| 94943 | B | 103115 | |
| 94944 | B | 103116 | |
| 94947 | B | 103119 | |
| 96247 | B | 104419 | |
| 96248 | B | 104420 | |
| 96249 | B | 104421 | |
| 96252 | B | 104424 | |
| 96253 | B | 104425 | |
| 96254 | B | 104426 | |
| 96255 | B | 104427 | |
| 96256 | B | 104428 | |
| 96257 | B | 104429 | |
| 96258 | B | 104430 | |
| 96259 | B | 104431 | |
| 96262 | B | 104434 | |
| 96265 | B | 104437 | |
| 96266 | B | 104438 | |
| 96267 | B | 104439 | |
| 96268 | B | 104440 | |
| 96269 | B | 104441 | |
| 96270 | B | 104442 | |
| 96271 | B | 104443 | |
| 96272 | B | 104444 | |
| 96273 | B | 104445 | |
| 96274 | B | 104446 | |
| 96275 | B | 104447 | |
| 96276 | B | 104448 | |
| 96277 | B | 104449 | |
| 96278 | B | 104450 | |
| 96279 | B | 104451 | |
| 96280 | B | 104452 | |
| 96281 | B | 104453 | |
| 96282 | B | 104454 | |
| 96287 | B | 104459 | |
| 96288 | B | 104460 | |
| 96289 | B | 104461 | |
| 96292 | B | 104464 | |
| 96574 | B | 104755 | |
| 96575 | B | 104756 | |
| 96577 | B | 104758 | |
| 96578 | B | 104759 | |
| 96579 | B | 104760 | |
| 96580 | B | 104761 | |
| 96584 | B | 104765 | |
| 96585 | B | 104766 | |
| 96586 | B | 104767 | |
| 96587 | B | 104768 | |
| 96588 | B | 104769 | |
| 96589 | B | 104770 | |
| 96590 | B | 104771 | |
| 96591 | B | 104772 | |
| 96592 | B | 104773 | |
| 96593 | B | 104774 | |
| 96594 | B | 104775 | |
| 96595 | B | 104776 | |
| 96596 | B | 104777 | |
| 100547 | B | 108727 | |
| 100548 | B | 108728 | |
| 100549 | B | 108729 | |
| 100551 | B | 108731 |