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 (91667,91669,91670,91671,91672,91673,91674,91675,91676,91677,91699,91648,91658,91668,91772,91771,91770,83923,83930,83927,91765,83934,91766,83919,83937,91769,83936,91768,83935,91767,83918,83914,83917,83920,83922,83926,83928,83929,91836,83931,83932,83916,83925,83913,83921,83933,83915,83924,89118,89119,89120,89150,89151,89152,89154,89155,89156,89130,89131,89132,89134,89135,89136,89138,89139,89140,89142,89143,89144,89146,89147,89148,91785,91786,91773,91775,91781,91782,91774,91776,91778,91780,92526,91783,91784,91777,91779,92525,92532,92524,92527,92528,92539,92531,92538,92529)) 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 |
|---|---|---|---|
| 83913 | D | 91951 | |
| 83914 | D | 91952 | |
| 83915 | D | 91953 | |
| 83916 | D | 91954 | |
| 83917 | D | 91955 | |
| 83918 | D | 91956 | |
| 83919 | D | 91957 | |
| 83920 | D | 91958 | |
| 83921 | D | 91959 | |
| 83922 | D | 91960 | |
| 83923 | D | 91961 | |
| 83924 | D | 91962 | |
| 83925 | D | 91963 | |
| 83926 | D | 91964 | |
| 83927 | D | 91965 | |
| 83928 | D | 91966 | |
| 83929 | D | 91967 | |
| 83930 | D | 91968 | |
| 83931 | D | 91969 | |
| 83932 | D | 91970 | |
| 83933 | D | 91971 | |
| 83934 | D | 91972 | |
| 83935 | D | 91973 | |
| 83936 | D | 91974 | |
| 83937 | D | 91975 | |
| 89118 | D | 97156 | |
| 89119 | D | 97157 | |
| 89120 | D | 97158 | |
| 89130 | D | 97168 | |
| 89131 | D | 97169 | |
| 89132 | D | 97170 | |
| 89134 | D | 97172 | |
| 89135 | D | 97173 | |
| 89136 | D | 97174 | |
| 89138 | D | 97176 | |
| 89139 | D | 97177 | |
| 89140 | D | 97178 | |
| 89142 | D | 97180 | |
| 89143 | D | 97181 | |
| 89144 | D | 97182 | |
| 89146 | D | 97184 | |
| 89147 | D | 97185 | |
| 89148 | D | 97186 | |
| 89150 | D | 97188 | |
| 89151 | D | 97189 | |
| 89152 | D | 97190 | |
| 89154 | D | 97192 | |
| 89155 | D | 97193 | |
| 89156 | D | 97194 | |
| 91648 | D | 99721 | |
| 91658 | D | 99731 | |
| 91667 | D | 99740 | |
| 91668 | D | 99741 | |
| 91669 | D | 99742 | |
| 91670 | D | 99743 | |
| 91671 | D | 99744 | |
| 91672 | D | 99745 | |
| 91673 | D | 99746 | |
| 91674 | D | 99747 | |
| 91675 | D | 99748 | |
| 91676 | D | 99749 | |
| 91677 | D | 99750 | |
| 91699 | D | 99772 | |
| 91765 | D | 99838 | |
| 91766 | D | 99839 | |
| 91767 | D | 99840 | |
| 91768 | D | 99841 | |
| 91769 | D | 99842 | |
| 91770 | D | 99843 | |
| 91771 | D | 99844 | |
| 91772 | D | 99845 | |
| 91773 | D | 99846 | |
| 91774 | D | 99847 | |
| 91775 | D | 99848 | |
| 91776 | D | 99849 | |
| 91777 | D | 99850 | |
| 91778 | D | 99851 | |
| 91779 | D | 99852 | |
| 91780 | D | 99853 | |
| 91781 | D | 99854 | |
| 91782 | D | 99855 | |
| 91783 | D | 99856 | |
| 91784 | D | 99857 | |
| 91785 | D | 99858 | |
| 91786 | D | 99859 | |
| 91836 | D | 99914 | |
| 92524 | D | 100646 | |
| 92525 | D | 100647 | |
| 92526 | D | 100648 | |
| 92527 | D | 100649 | |
| 92528 | D | 100650 | |
| 92529 | D | 100651 | |
| 92531 | D | 100653 | |
| 92532 | D | 100654 | |
| 92538 | D | 100660 | |
| 92539 | D | 100661 |