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 (99699,99700,99701,99702,99703,99704,99705,99706,99707,99708,99709,99710,99711,99712,99713,99714,99715,99716,99717,99718,99719,99720,99721,99722,99723,99724,99725,99726,99727,99728,99729,99730,99731,99732,99733,99734,99735,99736,99737,99738,99739,99740,99741,99742,99743,99744,99745,99746,99747,99748,99749,99750,99751,99752,99753,99754,99755,99756,99757,99758,99759,99760,99761,99762,99763,99764,99765,99766,99767,99768,99769,99770,99771,99772,99773,99774,99775,99776,99777,99778,99779,99780,99781,99782,99783,99784,99785,99786,99787,99788,99789,99790,99791,99792,99793,99794)) 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 |
|---|---|---|---|
| 99699 | B | 107879 | |
| 99700 | B | 107880 | |
| 99701 | B | 107881 | |
| 99702 | B | 107882 | |
| 99703 | B | 107883 | |
| 99704 | B | 107884 | |
| 99705 | B | 107885 | |
| 99706 | B | 107886 | |
| 99707 | B | 107887 | |
| 99708 | B | 107888 | |
| 99709 | B | 107889 | |
| 99710 | B | 107890 | |
| 99711 | B | 107891 | |
| 99712 | B | 107892 | |
| 99713 | B | 107893 | |
| 99714 | B | 107894 | |
| 99715 | B | 107895 | |
| 99716 | B | 107896 | |
| 99717 | B | 107897 | |
| 99718 | B | 107898 | |
| 99719 | B | 107899 | |
| 99720 | B | 107900 | |
| 99721 | B | 107901 | |
| 99722 | B | 107902 | |
| 99723 | B | 107903 | |
| 99724 | B | 107904 | |
| 99725 | B | 107905 | |
| 99726 | B | 107906 | |
| 99727 | B | 107907 | |
| 99728 | B | 107908 | |
| 99729 | B | 107909 | |
| 99730 | B | 107910 | |
| 99731 | B | 107911 | |
| 99732 | B | 107912 | |
| 99733 | B | 107913 | |
| 99734 | B | 107914 | |
| 99735 | B | 107915 | |
| 99736 | B | 107916 | |
| 99737 | B | 107917 | |
| 99738 | B | 107918 | |
| 99739 | B | 107919 | |
| 99740 | B | 107920 | |
| 99741 | B | 107921 | |
| 99742 | B | 107922 | |
| 99743 | B | 107923 | |
| 99744 | B | 107924 | |
| 99745 | B | 107925 | |
| 99746 | B | 107926 | |
| 99747 | B | 107927 | |
| 99748 | B | 107928 | |
| 99749 | B | 107929 | |
| 99750 | B | 107930 | |
| 99751 | B | 107931 | |
| 99752 | B | 107932 | |
| 99753 | B | 107933 | |
| 99754 | B | 107934 | |
| 99755 | B | 107935 | |
| 99756 | B | 107936 | |
| 99757 | B | 107937 | |
| 99758 | B | 107938 | |
| 99759 | B | 107939 | |
| 99760 | B | 107940 | |
| 99761 | B | 107941 | |
| 99762 | B | 107942 | |
| 99763 | B | 107943 | |
| 99764 | B | 107944 | |
| 99765 | B | 107945 | |
| 99766 | B | 107946 | |
| 99767 | B | 107947 | |
| 99768 | B | 107948 | |
| 99769 | B | 107949 | |
| 99770 | B | 107950 | |
| 99771 | B | 107951 | |
| 99772 | B | 107952 | |
| 99773 | B | 107953 | |
| 99774 | B | 107954 | |
| 99775 | B | 107955 | |
| 99776 | B | 107956 | |
| 99777 | B | 107957 | |
| 99778 | B | 107958 | |
| 99779 | B | 107959 | |
| 99780 | B | 107960 | |
| 99781 | B | 107961 | |
| 99782 | B | 107962 | |
| 99783 | B | 107963 | |
| 99784 | B | 107964 | |
| 99785 | B | 107965 | |
| 99786 | B | 107966 | |
| 99787 | B | 107967 | |
| 99788 | B | 107968 | |
| 99789 | B | 107969 | |
| 99790 | B | 107970 | |
| 99791 | B | 107971 | |
| 99792 | B | 107972 | |
| 99793 | B | 107973 | |
| 99794 | B | 107974 |