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 (93782,93783,93784,93785,93786,94026,94027,94028,94029,94030,94031,94032,94033,94074,94075,94428,94452,94453,94454,94455,94456,94458,94459,94460,94461,94462,94709,94717,94718,94719,94720,94721,94722,94723,94724,94725,94726,94727,94728,94729,94730,94731,94732,94733,94734,94735,94736,94737,94738,94739,94740,94741,94742,94743,94744,94745,94746,94747,94748,94749,94750,94751,94752,94753,94754,94755,94756,94757,94758,94759,94760,94761,94762,94763,94764,94765,94816,94950,94951,95565,95566,95567,95568,95569,95570,95571,95572,95573,95574,95575,95576,95577,95578,95579,95580,95581)) 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 |
|---|---|---|---|
| 93782 | B | 101922 | |
| 93783 | B | 101923 | |
| 93784 | B | 101924 | |
| 93785 | B | 101925 | |
| 93786 | B | 101926 | |
| 94026 | B | 102166 | |
| 94027 | B | 102167 | |
| 94028 | B | 102168 | |
| 94029 | B | 102169 | |
| 94030 | B | 102170 | |
| 94031 | B | 102171 | |
| 94032 | B | 102172 | |
| 94033 | B | 102173 | |
| 94074 | B | 102214 | |
| 94075 | B | 102215 | |
| 94428 | B | 102573 | |
| 94452 | B | 102624 | |
| 94453 | B | 102625 | |
| 94454 | B | 102626 | |
| 94455 | B | 102627 | |
| 94456 | B | 102628 | |
| 94458 | B | 102630 | |
| 94459 | B | 102631 | |
| 94460 | B | 102632 | |
| 94461 | B | 102633 | |
| 94462 | B | 102634 | |
| 94709 | B | 102881 | |
| 94717 | B | 102889 | |
| 94718 | B | 102890 | |
| 94719 | B | 102891 | |
| 94720 | B | 102892 | |
| 94721 | B | 102893 | |
| 94722 | B | 102894 | |
| 94723 | B | 102895 | |
| 94724 | B | 102896 | |
| 94725 | B | 102897 | |
| 94726 | B | 102898 | |
| 94727 | B | 102899 | |
| 94728 | B | 102900 | |
| 94729 | B | 102901 | |
| 94730 | B | 102902 | |
| 94731 | B | 102903 | |
| 94732 | B | 102904 | |
| 94733 | B | 102905 | |
| 94734 | B | 102906 | |
| 94735 | B | 102907 | |
| 94736 | B | 102908 | |
| 94737 | B | 102909 | |
| 94738 | B | 102910 | |
| 94739 | B | 102911 | |
| 94740 | B | 102912 | |
| 94741 | B | 102913 | |
| 94742 | B | 102914 | |
| 94743 | B | 102915 | |
| 94744 | B | 102916 | |
| 94745 | B | 102917 | |
| 94746 | B | 102918 | |
| 94747 | B | 102919 | |
| 94748 | B | 102920 | |
| 94749 | B | 102921 | |
| 94750 | B | 102922 | |
| 94751 | B | 102923 | |
| 94752 | B | 102924 | |
| 94753 | B | 102925 | |
| 94754 | B | 102926 | |
| 94755 | B | 102927 | |
| 94756 | B | 102928 | |
| 94757 | B | 102929 | |
| 94758 | B | 102930 | |
| 94759 | B | 102931 | |
| 94760 | B | 102932 | |
| 94761 | B | 102933 | |
| 94762 | B | 102934 | |
| 94763 | B | 102935 | |
| 94764 | B | 102936 | |
| 94765 | B | 102937 | |
| 94816 | B | 102988 | |
| 94950 | B | 103122 | |
| 94951 | B | 103123 | |
| 95565 | B | 103737 | |
| 95566 | B | 103738 | |
| 95567 | B | 103739 | |
| 95568 | B | 103740 | |
| 95569 | B | 103741 | |
| 95570 | B | 103742 | |
| 95571 | B | 103743 | |
| 95572 | B | 103744 | |
| 95573 | B | 103745 | |
| 95574 | B | 103746 | |
| 95575 | B | 103747 | |
| 95576 | B | 103748 | |
| 95577 | B | 103749 | |
| 95578 | B | 103750 | |
| 95579 | B | 103751 | |
| 95580 | B | 103752 | |
| 95581 | B | 103753 |